[MSNoise] Error after install

Wed Oct 6 12:40:23 UTC 2021

Hey Dave,

it seems there are lots of issues with some recent codebase changes in 
dependencies, leading to crazy errors in the test suite.

You should go ahead and try making a small project folder, and running 
the workflow,

Let me know how it goes,

Thomas

Le 06/10/2021 à 14:32, Healy, David a écrit :
> 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.
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise
>