[MSNoise] help
gaelle vanessa Nana
vanessa.gaelle3 at gmail.com
Mon Jul 15 18:32:15 UTC 2019
Hello group,
i have Problem with the STACK.
I did the CC, but when i start the STACK processus, some PB appear, i don't
know what to do exactly.
You can see below the error who appear on the terminal, after running the
STACK.
thank you for your help
base) vanessa at NANA:~/noise1$ msnoise stack -r -m -i 10
Lets STACK !
2019-07-15 19:23:45 [DEBUG] Starting the ref stack
[]
2019-07-15 19:23:45 [DEBUG] Processing XB_CM01:XB_CM02-ZZ-1
Traceback (most recent call last):
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1244, in _execute_context
cursor, statement, parameters, context
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/default.py
", line 550, in do_execute
cursor.execute(statement, parameters)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py",
line 17
0, in execute
result = self._query(query)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py",
line 32
8, in _query
conn.query(q)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 732, in _read_query_result
result.read()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 1075, in read
first_packet = self.connection._read_packet()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 684, in _read_packet
packet.check_error()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/protocol.py",
line 2
20, in check_error
err.raise_mysql_exception(self._data)
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/err.py",
line 109, i
n raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1055, "Expression #1 of SELECT list is not in
GROUP BY claus
e and contains nonaggregated column 'msnoise.jobs.ref' which is not
functionally depende
nt on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by"
)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/vanessa/anaconda3/bin/msnoise", line 10, in <module>
sys.exit(run())
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/scripts/msnoise.py",
line 717, in run
cli(obj={})
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py",
line 764, in
__call__
return self.main(*args, **kwargs)
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py",
line 717, in
main
rv = self.invoke(ctx)
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py",
line 1137, i
n invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py",
line 956, in
invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/click/core.py",
line 555, in
invoke
return callback(*args, **kwargs)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/scripts/msnoise.py",
line 375, in stack
main('ref', interval)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/s04stack.py",
line 1
97, in main
updated_days = updated_days_for_dates(db, start, end, pair.replace('_',
'.'), jobtyp
e='CC', interval=datetime.timedelta(days=interval),returndays=True)
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/msnoise/api.py",
line 1255,
in updated_days_for_dates
group_by(Job.day).order_by(Job.day).all()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.py",
li
ne 3168, in all
return list(self)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.py",
li
ne 3324, in __iter__
return self._execute_and_instances(context)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.py",
li
ne 3349, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 988, in execute
return meth(self, multiparams, params)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/sql/elements.py",
line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1107, in _execute_clauseelement
distilled_params,
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1248, in _execute_context
e, statement, parameters, cursor, context
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/util/compat.py",
line 399, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/util/compat.py",
line 153, in reraise
raise value.with_traceback(tb)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1244, in _execute_context
cursor, statement, parameters, context
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/engine/default.py
", line 550, in do_execute
cursor.execute(statement, parameters)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py",
line 17
0, in execute
result = self._query(query)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py",
line 32
8, in _query
conn.query(q)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 732, in _read_query_result
result.read()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 1075, in read
first_packet = self.connection._read_packet()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/connections.py",
lin
e 684, in _read_packet
packet.check_error()
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/protocol.py",
line 2
20, in check_error
err.raise_mysql_exception(self._data)
File "/home/vanessa/anaconda3/lib/python3.7/site-packages/pymysql/err.py",
line 109, i
n raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1055,
"Expression #1 of SELEC
T list is not in GROUP BY clause and contains nonaggregated column
'msnoise.jobs.ref' wh
ich is not functionally dependent on columns in GROUP BY clause; this is
incompatible wi
th sql_mode=only_full_group_by")
[SQL: SELECT jobs.ref AS jobs_ref, jobs.day AS jobs_day, jobs.pair AS
jobs_pair, jobs.jo
btype AS jobs_jobtype, jobs.flag AS jobs_flag, jobs.lastmod AS jobs_lastmod
FROM jobs
WHERE jobs.pair = %(pair_1)s AND jobs.day >= %(day_1)s AND jobs.day <=
%(day_2)s AND job
s.jobtype = %(jobtype_1)s AND jobs.lastmod >= %(lastmod_1)s GROUP BY
jobs.day ORDER BY j
obs.day]
[parameters: {'pair_1': 'XB.CM01:XB.CM02', 'day_1': datetime.date(2006, 1,
1), 'day_2':
datetime.date(2007, 1, 1), 'jobtype_1': 'CC', 'lastmod_1':
datetime.datetime(2019, 7, 5,
19, 23, 45, 798518)}]
(Background on this error at: http://sqlalche.me/e/2j85)
Le mer. 3 juil. 2019 à 08:07, Thomas Lecocq <Thomas.Lecocq at seismology.be> a
écrit :
> Hi,
>
> Could you try using an empty folder, as stated in the doc and here: "
>
> Directory is not empty, can't run tests here!"
>
> ?
>
> Thomas
>
> On 28/06/2019 15:01, gaelle vanessa Nana wrote:
> > hello MSnoise group
> > i have a problem,after installing Msnoise, i tried to run MSNOISE TEST
> but
> > there is some problem.
> > I tried to install pyqt, pyside but no success.
> > Please, if someone have an idea to solve this problem.
> >
> > cheers
> >
> > (base) vanessa at NANA:~$ msnoise test
> > 2019-06-28 13:51:35 [DEBUG] CACHEDIR=/home/vanessa/.cache/matplotlib
> > 2019-06-28 13:51:35 [DEBUG] Using fontManager instance from
> > /home/vanessa/.cache/matplotlib/fontlist-v310.json
> > 2019-06-28 13:51:36 [DEBUG] Loaded backend qt5agg version unknown.
> > 2019-06-28 13:51:36 [DEBUG] Loaded backend qt5agg version unknown.
> > 2019-06-28 13:51:36 [DEBUG] Loaded backend Qt5Agg version unknown.
> > 2019-06-28 13:51:36 [DEBUG] Loaded backend agg version unknown.
> > 2019-06-28 13:51:36 [DEBUG] Loaded backend agg version unknown.
> > Directory is not empty, can't run tests here!
> >
> > _______________________________________________
> > MSNoise mailing list
> > MSNoise at mailman-as.oma.be
> > http://mailman-as.oma.be/mailman/listinfo/msnoise
>
> --
> Dr. Thomas Lecocq
> Geologist - Seismologist
>
> Seismology - Gravimetry
> Royal Observatory of Belgium
>
> *
> * * * * *
> * * * *
> ---------
> http://www.seismology.be
> http://msnoise.org
> http://twitter.com/#!/Seismologie_be
> https://www.facebook.com/seismologie.be
>
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise
>
More information about the MSNoise
mailing list