Hello
I’m trying to install MSNoise, but keep getting unintelligible (to me) errors when running
msnoise test:
*****
Traceback (most recent call last):
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1276, in _execute_context
self.dialect.do_execute(
File
"/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line
593, in do_execute
cursor.execute(statement, parameters)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line
148, in execute
result = self._query(query)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line
310, in _query
conn.query(q)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
775, in _read_query_result
result.read()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
1156, in read
first_packet = self.connection._read_packet()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
725, in _read_packet
packet.raise_for_error()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/protocol.py", line
221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/err.py", line 143, in
raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, "Table 'msnoise.config' doesn't
exist")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/anaconda3/bin/msnoise", line 5, in <module>
from msnoise.scripts.msnoise import run
File "/opt/anaconda3/lib/python3.8/site-packages/msnoise/scripts/msnoise.py",
line 1183, in <module>
plugins = get_config(db, "plugins")
File "/opt/anaconda3/lib/python3.8/site-packages/msnoise/api.py", line 215, in
get_config
config = session.query(table).filter(table.name == name).first()
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py",
line 3429, in first
ret = list(self[0:1])
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py",
line 3203, in __getitem__
return list(res)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py",
line 3535, in __iter__
return self._execute_and_instances(context)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py",
line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1011, in execute
return meth(self, multiparams, params)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/sql/elements.py",
line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1316, in _execute_context
self._handle_dbapi_exception(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1510, in _handle_dbapi_exception
util.raise_(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1276, in _execute_context
self.dialect.do_execute(
File
"/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line
593, in do_execute
cursor.execute(statement, parameters)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line
148, in execute
result = self._query(query)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line
310, in _query
conn.query(q)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
775, in _read_query_result
result.read()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
1156, in read
first_packet = self.connection._read_packet()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line
725, in _read_packet
packet.raise_for_error()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/protocol.py", line
221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/err.py", line 143, in
raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table
'msnoise.config' doesn't exist")
[SQL: SELECT config.name AS config_name, config.value AS config_value
FROM config
WHERE config.name = %(name_1)s
LIMIT %(param_1)s]
[parameters: {'name_1': 'plugins', 'param_1': 1}]
(Background on this error at:
http://sqlalche.me/e/13/f405)
*****
I’ve got all the required Python packages, MySQLServer and Workbench versions 8.0.18
(compatible with my macOS Mojave 10.14.6). Local database and user are set-up.
Any ideas?
Thanks,
Dave
David Healy [he/him]
School of Geosciences
Meston Walk
University of Aberdeen
Aberdeen AB24 3UE
My working day may not be your working day. Please do not feel obliged to reply to this
e-mail outside of your normal working hours.
Publications:
https://scholar.google.com/citations?hl=en&user=ug9DnVoAAAAJ
Software:
http://www.fracturedrockphysics.com/software.html
Home page:
http://www.fracturedrockphysics.com/index.html
The University of Aberdeen is a charity registered in Scotland, No SC013683.
Tha Oilthigh Obar Dheathain na charthannas clàraichte ann an Alba, Àir. SC013683.