Hi,
Please try to adapt your MySQL server config following this:
http://msnoise.org/doc/master/installation.html#mysql-mariadb-configuration
note you'll have to restart the mysql server after the changes.
Cheers,
Thomas
Le 15/07/2019 à 20:32, gaelle vanessa Nana a écrit :
> 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@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(a)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@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(a)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(a)mailman-as.oma.be
>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>
> _______________________________________________
> MSNoise mailing list
> MSNoise(a)mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise
>
Hi everyone,
I want to work with sara plugin, after station table has been populated
and the archive scanned, I use the command "msnoise config --set
plugins=msnoise_sara" then Successfully updated parameter plugins =
msnoise_sara.
Afterwards I use the command "msnoise p sara install" and I face with
the Error "No such command "sara""
could you please help me
Thanks a lot
Navid
>From vanessa.gaelle3(a)gmail.com Mon Jul 15 18:32:37 2019
Return-Path: <vanessa.gaelle3(a)gmail.com>
X-Original-To: msnoise(a)mailman-as.oma.be
Delivered-To: msnoise(a)mailman-as.oma.be
Received: from mail-oi1-f174.google.com (mail-oi1-f174.google.com
[209.85.167.174])
by mailman-as.oma.be (Postfix) with ESMTP id 2398E2075B
for <msnoise(a)mailman-as.oma.be>; Mon, 15 Jul 2019 18:32:37 +0000 (UTC)
Received: by mail-oi1-f174.google.com with SMTP id s184so13433018oie.9
for <msnoise(a)mailman-as.oma.be>; Mon, 15 Jul 2019 11:32:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
h=mime-version:references:in-reply-to:from:date:message-id:subject:to;
bh=8FQlI/B22THz1BlxuVRG+2J33NYLtL+fFfOln5d+gTg=;
b=rdQJjPdyG2V0iwseZEDwm/R+/uhm3c6piUoUbWwl9wtnXWCkVsSXjt4X0d79wc7QZ5
H3wYCOo/bhJBagqoz0MitiaPwsVg9x4Py212TvLiXulFX2wqJ5+rxl9JlXj89o+qQ2/D
2u7UusYKOIp5jTvN4aT51yqYw9c1xN4qkvwlX5Ph9zCRn2r9PhTpOVJBOm4hmZggBmhX
5dsBallB4vJwQ21uEYGaCqCjeSMWNmgxs0NKLKqeUwNqp2qDqp//zNcz0Yv0Gp1F6+cC
XM7ZgpiNYvkRqJTseykUvDMvGfaPCn55PYfdviuc1dpb/r0SkKMuPo2VwMEcUXOkELLA
K1/A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20161025;
h=x-gm-message-state:mime-version:references:in-reply-to:from:date
:message-id:subject:to;
bh=8FQlI/B22THz1BlxuVRG+2J33NYLtL+fFfOln5d+gTg=;
b=oghE5kmS7XAaMs7Arz4LaN0uuJ1f+bnLaRu2ok9IuAaYk2mEgFME0eYQORC/h7ePOo
CWLayVKFgFaHzDfgupFEiPNOeN5QomZfnRemC9oJkqlHfgWieDw2lpT36g86+XbUVAbr
iXdrYi6HmP9rLNGtPk5WM+b7zFgz+2c0A3lFLPkZ07frCf/wGQG7RdCzjd2wdjWybG6u
S3fS8ch85NayEVv0IINBHrs9FADIBCZijtaScdQqfVWCnIdLCfMqu4lDwzTuN8qdNtN8
6/tdyzMwucKfQtn2wNu7CSx8hQyaqV8kOJ2DGCtg01kVu3QcSP4HZrpKgFYGyI0Ry4r2
501Q==
X-Gm-Message-State: APjAAAW0Eb+SEVW//I4DKSyMF448W3ULSstrwwZT8kB2CbeR8osT74gJ
/JGfRQab1Fz/eKMUa4BL4qyyuVDoEopKPj2+pTRPCbz6
X-Google-Smtp-Source: APXvYqyp24AjB8Nx92UQPmRtNnc1SX+RvtDptMYfdGLrWpaMxS9/8caetjMCFDIdHC/etcCqTMtmSu+wjFF5SD5O0/I=
X-Received: by 2002:aca:544b:: with SMTP id i72mr14663197oib.174.1563215555809;
Mon, 15 Jul 2019 11:32:35 -0700 (PDT)
MIME-Version: 1.0
References: <CAMKH5-=4HkuTgBU6SqH6A=BZuCCgJSLku4AnCa4i=og0DqO_qA(a)mail.gmail.com>
<778217f9-4cec-ce15-530f-5e318838c820(a)seismology.be>
In-Reply-To: <778217f9-4cec-ce15-530f-5e318838c820(a)seismology.be>
From: gaelle vanessa Nana <vanessa.gaelle3(a)gmail.com>
Date: Mon, 15 Jul 2019 19:32:15 +0100
Message-ID: <CAMKH5-=sG8+7SkKu2DCPd5gnwmFMUvXJf8YGZ+B3L+x_w6N8SA(a)mail.gmail.com>
To: Python Package for Monitoring Seismic Velocity Changes using Ambient
Seismic Noise <msnoise(a)mailman-as.oma.be>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Content-Filtered-By: Mailman/MimeDel 2.1.12
Subject: Re: [MSNoise] help
X-BeenThere: msnoise(a)mailman-as.oma.be
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: Python Package for Monitoring Seismic Velocity Changes using Ambient
Seismic Noise <msnoise.mailman-as.oma.be>
List-Unsubscribe: <http://mailman-as.oma.be/mailman/options/msnoise>,
<mailto:msnoise-request@mailman-as.oma.be?subject=unsubscribe>
List-Archive: <http://mailman-as.oma.be/pipermail/msnoise/>
List-Post: <mailto:msnoise@mailman-as.oma.be>
List-Help: <mailto:msnoise-request@mailman-as.oma.be?subject=help>
List-Subscribe: <http://mailman-as.oma.be/mailman/listinfo/msnoise>,
<mailto:msnoise-request@mailman-as.oma.be?subject=subscribe>
X-List-Received-Date: Mon, 15 Jul 2019 18:32:37 -0000
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@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/defa=
ult.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 =3D 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 =3D self._read_query_result(unbuffered=3Dunbuffered)
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 =3D 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=3Donly_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/msnois=
e.py",
line 717, in run
cli(obj=3D{})
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 =3D 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/msnois=
e.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 =3D updated_days_for_dates(db, start, end, pair.replace('_'=
,
'.'), jobtyp
e=3D'CC', interval=3Ddatetime.timedelta(days=3Dinterval),returndays=3DTrue)
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.p=
y",
li
ne 3168, in all
return list(self)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.p=
y",
li
ne 3324, in __iter__
return self._execute_and_instances(context)
File
"/home/vanessa/anaconda3/lib/python3.7/site-packages/sqlalchemy/orm/query.p=
y",
li
ne 3349, in _execute_and_instances
result =3D 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/element=
s.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=3Dexc_tb, cause=3Dcause)
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/defa=
ult.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 =3D 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 =3D self._read_query_result(unbuffered=3Dunbuffered)
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 =3D 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=3Donly_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 =3D %(pair_1)s AND jobs.day >=3D %(day_1)s AND jobs.day <=
=3D
%(day_2)s AND job
s.jobtype =3D %(jobtype_1)s AND jobs.lastmod >=3D %(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 =C3=A0 08:07, Thomas Lecocq <Thomas.Lecocq(a)seismology.=
be> a
=C3=A9crit :
> 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@NANA:~$ msnoise test
> > 2019-06-28 13:51:35 [DEBUG] CACHEDIR=3D/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(a)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(a)mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise
>
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@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!
Hello MSnoise Group,
I am trying to use windows version of msnoise with mysql but, I am having
problem during data import. Being a beginer at both python and mysql.
All steps are clear till creating empty database in mysql but, after that I
am facing problem even after reading documentation for several times. Even,
I tried reading codes of Data_structure, Scan_archive and even one extra
code given for custom data structure and station population but could not
get anything.
I can open the admin interface but there is no data to show. The sac file i
am trying to import is attached herewith.
May i get some demo for the steps involved during data loading and
populating the stations.
Thanking you
yours sincerely,
Shiv Mangal Gupta
IIT (ISM), Dhanbad , India
ᐧ
Hi, Thomas,
Recently, I used msnoise development version to process my data. I found the `stack` command will insert the MWCS jobs whose ‘day’ attribute were REF,
and when I completed the `compute_mwcs`, the flag of MWCS jobs with REF day were still T(Todo). Progress bar of MWCS jobs in dashboard was not 100%.
I checked the Job list and found all MWCS jobs have been done except the jobs with 'REF day'.
Then I looked the file s04stack.py, and found the REF MWCS jobs were inserted by:
```
322 update_job(db, "REF", ref_name.replace('_', '.'), 'MWCS', 'T’)
```
It seems these jobs were not used in MWCS step.
If you don't mind I asked, I'd like to understand the reason behind setting up such job.
When I want to compute MWCS repeatedly, after reset all mwcs jobs, should I mark the jobs with ‘REF day' as D(done) manually?
Looking forward your reply.
Thank you very very much!
weiyu
