MSNoise

msnoise@lists.observatory.be

349 discussions

by lakromah60

I fully understand Aurélien.Thank you so much for your asstistance. Kind regards Linda Akromah Sent from my Samsung Galaxy smartphone. -------- Original message --------From: Aurélien Mordret <mordret(a)mit.edu> Date: 2018/09/07 11:21 (GMT+02:00) To: Python Package for Monitoring Seismic Velocity Changes using Ambient Seismic Noise <msnoise(a)mailman-as.oma.be> Subject: Re: [MSNoise] Fwd: msnoise admin error I'm afraid that's beyond my IT capabilities... I never had such error on my laptop or personal computer... I would say that it's not an msnoise problem, but more an environment problem. You should contact your computer administrator, he may be able to solve this problem more easily than us on this mailing list... Sorry I can't be more helpful for now. Le jeu. 6 sept. 2018 20:30, Linda Akromah <lakromah60(a)gmail.com> a écrit : > I tried sqlite and it is less complicated but now I get the following > message after running msnoise admin > > "Do not use a development server in a production environment" > > I tried export flask_app=flaskr to change the environment but that didn't > work. > > Would it be that bad to go ahead and use the development server in a > production environment anyway? Please davise > > Kind regards > Linda Akromah > > On Thu, 06 Sep 2018, 11:44 Linda Akromah <lakromah60(a)gmail.com> wrote: > > > Thank you Aurélien. Will do that > > > > Regards > > Linda Akromah > > > > On Thu, 06 Sep 2018, 11:18 Aurélien Mordret <mordret(a)mit.edu> wrote: > > > >> Dear Linda, > >> > >> I suggest you to chose the SQlite option instead of MySQL which is a bit > >> more tricky to handle when you just start. > >> > >> Type msnoise install > >> > >> then 1 for the choice, then Enter directly to give the default name to > the > >> database. > >> > >> You should be good to go after that with msnoise admin. > >> > >> http://msnoise.org/doc/workflow/001_msnoise_admin.html > >> > >> Best, > >> > >> Aurelien > >> > >> > >> Le jeu. 6 sept. 2018 à 10:35, Linda Akromah <lakromah60(a)gmail.com> a > >> écrit : > >> > >> > Thank you > >> > > >> > In the installer I think there is something I am not filling in > >> correctly. > >> > > >> > I chose mysql > >> > > >> > Hostname:I entered the port number > >> > Database:localhost > >> > Username: msnoise (which created in priveleges) > >> > Password:msnoise password > >> > > >> > > >> > In mysql "connect to database"tab > >> > Hostname:localhost Port:3306 > >> > Username:root > >> > Password:root password > >> > > >> > What am I doing wrong > >> > > >> > Regards > >> > Linda Akromah > >> > > >> > > >> > On Thu, 06 Sep 2018, 09:56 Thomas Lecocq <thomas.lecocq(a)seismology.be > > > >> > wrote: > >> > > >> > > Hi > >> > > > >> > > 1. Create a new folder and cd to it > >> > > 2. msnoise install > >> > > 3. msnoise admin > >> > > > >> > > Should work > >> > > > >> > > Thomas > >> > > _______________________________________________ > >> > > 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 > >> > > >> -- > >> ========================== > >> > >> Postdoctoral associate > >> Department of Earth, Atmospheric and Planetary Sciences > >> Massachusetts Institute of Technology > >> 54-526 > >> Cambridge, MA 02139-4307 > >> phone: 617-253-5051 > >> e-mail: mordret(a)mit.edu > >> web: http://web.mit.edu/mordret/www > >> _______________________________________________ > >> 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 > -- ========================== Postdoctoral associate Department of Earth, Atmospheric and Planetary Sciences Massachusetts Institute of Technology 54-526 Cambridge, MA 02139-4307 phone: 617-253-5051 e-mail: mordret(a)mit.edu web: http://web.mit.edu/mordret/www _______________________________________________ MSNoise mailing list MSNoise(a)mailman-as.oma.be http://mailman-as.oma.be/mailman/listinfo/msnoise

6 years, 7 months

TR: Some questions about MsNoise Win

by Guénolé Mainsant O'Rhand

Guénolé Mainsant O'Rhand a partagé un fichier OneDrive avec vous. Pour l’afficher, cliquez sur le lien ci-dessous. <https://1drv.ms/u/s!AqvuPyASMKXzgdsAG0YtqUkEn6FyDQ> [https://r1.res.office365.com/owa/prem/images/dc-png_20.png]<https://1drv.ms/u/s!AqvuPyASMKXzgdsAG0YtqUkEn6FyDQ> MsNoiseConfigError.png<https://1drv.ms/u/s!AqvuPyASMKXzgdsAG0YtqUkEn6FyDQ> I've forgotten the attachment file. Regards, Guénolé MAINSANT ________________________________ De : Guénolé Mainsant O'Rhand <guenole.mainsant(a)outlook.fr> Envoyé : mardi 21 août 2018 01:50 À : msnoise(a)mailman-as.oma.be Objet : Some questions about MsNoise Win Hello, My name is Guénolé MAINSANT, former PhD student at ISTerre and post doc at LPG in Nantes. I've tried to use Win MsNoise version with MySQL but i have some problems about that: * Can MsNoise read .sac formats ? * Is this a problem if my files are defined in hours and not in days? like this : DF01.FDF.BHE.2016.270.20.sac * How can I configure MsNoise. With linux I remember to write msnoise config to open a configuration table. Is not there the same thing with Windows or similar using MySql? By writing msnoise config I get: see Attachment Thank you in advance for you help ! Best regards, Guénolé MAINSANT

6 years, 8 months

msnoise admin error

by Linda Akromah

Good day I installed msnoise in my new laptop and all is going well so far but the command "msnoise admin gives the following error: in read_database_inifile f = open(inifile, 'rb') FileNotFoundError: [Errno 2] No such file or directory: '/home/linda/db.ini' Some assistance please Kind regards Linda Akromah

6 years, 8 months

Changing startdate/enddate and ref_begin/ref_end

by Sigríður Kristjánsdóttir

Hello everyone, I am trying to run MSNOISE for new startdate/enddate and ref_begin/ref_end. First I changed the relevant parameters in the configuration. Then I ran msnoise scan_archive. When I plot the data_availibilty the data shows up on the plot. Next I ran msnoise new_jobs msnoise reset CC --all msnoise -t 10 compute_cc but when I plot the ccf vs time graphs I only get correlograms for the old time period :( Any ideas what I am missing? Sissa Sigríður Kristjánsdóttir Jarðeðlisfræðingur / Geophysicist Sími / Tel: +354 528 1608 Grensásvegur 9, 108 Reykjavík - www.isor.is<http://www.isor.is/> ___________________________________ [isor-1945-2015]

6 years, 8 months

Empty plots

by Linda Akromah

Good morning I am in the trial stages of MSNoise and have only one day data for 10 stations. we tried to do the following "msnoise plot interferogram MS_ST2 MS_ST6 -m2" for two days. The problem is the plot is empty. Where will we find the output tables shown on pages 25 and 28 of the MS noise Documentation for version 1.5 After following the lazy mode option, this is what was done: msnoise new_jobs msnoise compute_cc msnoise stack -r -m -1 2 msnoisecompute_mwcs msnoise compute_dtt Please check if any steps have been omitted. Kind regards Linda Akromah

6 years, 8 months

Re: [MSNoise] msnoise scan archive

by Thomas Lecocq

Hi Linda, Please write the mailing list and not me directly as other users could help you for sure. What is the output of "msnoise info" ? Thomas On 27/08/2018 13:18, Linda Akromah wrote: > Good morning Thomas > > What could be the error when populate and msnoise scan archive are > done but no data is showing in the database and no error message either. > > Kind regards > Linda -- 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

6 years, 8 months

Fwd: MSNOISEOUT

by Linda Akromah

Good morning What could be the error when populate and msnoise scan archive are done but no data is showing in the database and no error message either. Attached is the output of msnoise info. Kind regards

6 years, 8 months

No filters defined

by Linda Akromah

An error of "no filters defined" was the result of running "msnoise compute_cc" How can this be rectified? Kind regards Linda

6 years, 8 months

Re: [MSNoise] (no subject)

by Thomas Lecocq

Dear Linda, You have to understand that this mailing list is meant for msnoise users and I cannot imagine what's under the hood of your calculations. So, my best advice for now: just try using msnoise and check if your results are similar... Regards, Thomas Le 17/08/2018 à 08:43, Linda Akromah a écrit : > I am not using MS-Noise at the moment.I have a python code I developed > and it has worked well before for a different set of data though. > Which parameters should I consider changing? > > Kind regards > Linda Akromah

6 years, 8 months

Re: [MSNoise] MSNoise Digest, Vol 49, Issue 6

by Yawar Hussain

Thanks! The problem is solved. Regards, Yawar Hussain Ph.D. Student, Geotechnical Engineering Dpt. Civil and Environmental Engg. University of Brasilia, Brazil. On Sat, Aug 18, 2018 at 4:22 PM <msnoise-request(a)mailman-as.oma.be> wrote: > Send MSNoise mailing list submissions to > msnoise(a)mailman-as.oma.be > > To subscribe or unsubscribe via the World Wide Web, visit > http://mailman-as.oma.be/mailman/listinfo/msnoise > or, via email, send a message with subject or body 'help' to > msnoise-request(a)mailman-as.oma.be > > You can reach the person managing the list at > msnoise-owner(a)mailman-as.oma.be > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of MSNoise digest..." > > > Today's Topics: > > 1. MSNoise stack (Yawar Hussain) > 2. Re: MSNoise stack (Yawar Hussain) > 3. Re: MSNoise stack (Thomas Lecocq) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 18 Aug 2018 09:55:12 -0300 > From: Yawar Hussain <yawar.pgn(a)gmail.com> > To: msnoise(a)mailman-as.oma.be > Subject: [MSNoise] MSNoise stack > Message-ID: > < > CAP7arHRVjawZnP_a-iBU8Wkwx6FbWXQSSFPsNE01Aqc78fQt1Q(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hello, > > I have problem with stacking: > > yawar@yawar-Vostro-5470:~/anaconda3/bin$ msnoise stack -r > Lets STACK ! > 2018-08-18 09:52:14 [DEBUG] Starting the ref stack > [] > 2018-08-18 09:52:14 [DEBUG] Processing LS_DF01:LS_DF02-ZZ-1 > Traceback (most recent call last): > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > line 1139, in _execute_context > context) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", > line 450, in do_execute > cursor.execute(statement, parameters) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > line 166, in execute > result = self._query(query) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > line 322, in _query > conn.query(q) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 835, in query > self._affected_rows = self._read_query_result(unbuffered=unbuffered) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 1019, in _read_query_result > result.read() > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 1302, in read > first_packet = self.connection._read_packet() > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 981, in _read_packet > packet.check_error() > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 393, in check_error > err.raise_mysql_exception(self._data) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/err.py", > line 107, in raise_mysql_exception > raise errorclass(errno, errval) > pymysql.err.InternalError: (1055, "Expression #1 of SELECT list is not in > GROUP BY clause and contains nonaggregated column 'msnoise.jobs.ref' which > is not functionally dependent 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/yawar/anaconda3/bin/msnoise", line 11, in <module> > sys.exit(run()) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/scripts/msnoise.py", > line 614, in run > cli(obj={}) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > line 716, in __call__ > return self.main(*args, **kwargs) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > line 696, in main > rv = self.invoke(ctx) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > line 1060, in invoke > return _process_result(sub_ctx.command.invoke(sub_ctx)) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > line 889, in invoke > return ctx.invoke(self.callback, **ctx.params) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > line 534, in invoke > return callback(*args, **kwargs) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/scripts/msnoise.py", > line 301, in stack > main('ref', interval) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/s04stack.py", > line 203, in main > updated_days = updated_days_for_dates(db, start, end, pair.replace('_', > '.'), jobtype='CC', > interval=datetime.timedelta(days=interval),returndays=True) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/api.py", > line 1189, in updated_days_for_dates > days = session.query(Job).filter(Job.pair == pair).filter(Job.day >= > date1).filter(Job.day <= date2).filter(Job.jobtype == > jobtype).filter(Job.lastmod >= > lastmod).group_by(Job.day).order_by(Job.day).all() > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > line 2613, in all > return list(self) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > line 2761, in __iter__ > return self._execute_and_instances(context) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > line 2776, in _execute_and_instances > result = conn.execute(querycontext.statement, self._params) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > line 914, in execute > return meth(self, multiparams, params) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", > line 323, in _execute_on_connection > return connection._execute_clauseelement(self, multiparams, params) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > line 1010, in _execute_clauseelement > compiled_sql, distilled_params > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > line 1146, in _execute_context > context) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > line 1341, in _handle_dbapi_exception > exc_info > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/util/compat.py", > line 202, in raise_from_cause > reraise(type(exception), exception, tb=exc_tb, cause=cause) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/util/compat.py", > line 185, in reraise > raise value.with_traceback(tb) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > line 1139, in _execute_context > context) > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", > line 450, in do_execute > cursor.execute(statement, parameters) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > line 166, in execute > result = self._query(query) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > line 322, in _query > conn.query(q) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 835, in query > self._affected_rows = self._read_query_result(unbuffered=unbuffered) > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 1019, in _read_query_result > result.read() > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 1302, in read > first_packet = self.connection._read_packet() > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 981, in _read_packet > packet.check_error() > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > line 393, in check_error > err.raise_mysql_exception(self._data) > File "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/err.py", > line 107, in raise_mysql_exception > raise errorclass(errno, errval) > sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1055, > "Expression #1 of SELECT list is not in GROUP BY clause and contains > nonaggregated column 'msnoise.jobs.ref' which is not functionally dependent > on columns in GROUP BY clause; this is incompatible with > sql_mode=only_full_group_by") [SQL: 'SELECT jobs.ref AS jobs_ref, jobs.day > AS jobs_day, jobs.pair AS jobs_pair, jobs.jobtype AS jobs_jobtype, > jobs.flag AS jobs_flag, jobs.lastmod AS jobs_lastmod \nFROM jobs \nWHERE > jobs.pair = %(pair_1)s AND jobs.day >= %(day_1)s AND jobs.day <= %(day_2)s > AND jobs.jobtype = %(jobtype_1)s AND jobs.lastmod >= %(lastmod_1)s GROUP BY > jobs.day ORDER BY jobs.day'] [parameters: {'lastmod_1': > datetime.datetime(2018, 8, 17, 9, 52, 14, 839671), 'jobtype_1': 'CC', > 'day_2': datetime.date(2017, 12, 13), 'day_1': datetime.date(2017, 12, 9), > 'pair_1': 'LS.DF01:LS.DF02'}] > > > > > Regards, > Yawar Hussain > Ph.D. Student, Geotechnical Engineering > Dpt. Civil and Environmental Engg. > University of Brasilia, Brazil. > > > ------------------------------ > > Message: 2 > Date: Sat, 18 Aug 2018 10:01:01 -0300 > From: Yawar Hussain <yawar.pgn(a)gmail.com> > To: msnoise(a)mailman-as.oma.be > Subject: Re: [MSNoise] MSNoise stack > Message-ID: > <CAP7arHSFQndNYOUjAKwscc8gRpTfhkH8io= > eURG3yUBMkg5_5g(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > The stacking on msnoise example data is perfectly alright. > > > Regards, > Yawar Hussain > Ph.D. Student, Geotechnical Engineering > Dpt. Civil and Environmental Engg. > University of Brasilia, Brazil. > > > On Sat, Aug 18, 2018 at 9:55 AM Yawar Hussain <yawar.pgn(a)gmail.com> wrote: > > > Hello, > > > > I have problem with stacking: > > > > yawar@yawar-Vostro-5470:~/anaconda3/bin$ msnoise stack -r > > Lets STACK ! > > 2018-08-18 09:52:14 [DEBUG] Starting the ref stack > > [] > > 2018-08-18 09:52:14 [DEBUG] Processing LS_DF01:LS_DF02-ZZ-1 > > Traceback (most recent call last): > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > > line 1139, in _execute_context > > context) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", > > line 450, in do_execute > > cursor.execute(statement, parameters) > > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > > line 166, in execute > > result = self._query(query) > > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > > line 322, in _query > > conn.query(q) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 835, in query > > self._affected_rows = self._read_query_result(unbuffered=unbuffered) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 1019, in _read_query_result > > result.read() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 1302, in read > > first_packet = self.connection._read_packet() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 981, in _read_packet > > packet.check_error() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 393, in check_error > > err.raise_mysql_exception(self._data) > > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/err.py", > > line 107, in raise_mysql_exception > > raise errorclass(errno, errval) > > pymysql.err.InternalError: (1055, "Expression #1 of SELECT list is not in > > GROUP BY clause and contains nonaggregated column 'msnoise.jobs.ref' > which > > is not functionally dependent 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/yawar/anaconda3/bin/msnoise", line 11, in <module> > > sys.exit(run()) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/scripts/msnoise.py", > > line 614, in run > > cli(obj={}) > > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > > line 716, in __call__ > > return self.main(*args, **kwargs) > > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > > line 696, in main > > rv = self.invoke(ctx) > > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > > line 1060, in invoke > > return _process_result(sub_ctx.command.invoke(sub_ctx)) > > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > > line 889, in invoke > > return ctx.invoke(self.callback, **ctx.params) > > File "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > > line 534, in invoke > > return callback(*args, **kwargs) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/scripts/msnoise.py", > > line 301, in stack > > main('ref', interval) > > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/s04stack.py", > > line 203, in main > > updated_days = updated_days_for_dates(db, start, end, > > pair.replace('_', '.'), jobtype='CC', > > interval=datetime.timedelta(days=interval),returndays=True) > > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/api.py", > > line 1189, in updated_days_for_dates > > days = session.query(Job).filter(Job.pair == pair).filter(Job.day >= > > date1).filter(Job.day <= date2).filter(Job.jobtype == > > jobtype).filter(Job.lastmod >= > > lastmod).group_by(Job.day).order_by(Job.day).all() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > > line 2613, in all > > return list(self) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > > line 2761, in __iter__ > > return self._execute_and_instances(context) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > > line 2776, in _execute_and_instances > > result = conn.execute(querycontext.statement, self._params) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > > line 914, in execute > > return meth(self, multiparams, params) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", > > line 323, in _execute_on_connection > > return connection._execute_clauseelement(self, multiparams, params) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > > line 1010, in _execute_clauseelement > > compiled_sql, distilled_params > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > > line 1146, in _execute_context > > context) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > > line 1341, in _handle_dbapi_exception > > exc_info > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/util/compat.py", > > line 202, in raise_from_cause > > reraise(type(exception), exception, tb=exc_tb, cause=cause) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/util/compat.py", > > line 185, in reraise > > raise value.with_traceback(tb) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > > line 1139, in _execute_context > > context) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", > > line 450, in do_execute > > cursor.execute(statement, parameters) > > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > > line 166, in execute > > result = self._query(query) > > File > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > > line 322, in _query > > conn.query(q) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 835, in query > > self._affected_rows = self._read_query_result(unbuffered=unbuffered) > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 1019, in _read_query_result > > result.read() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 1302, in read > > first_packet = self.connection._read_packet() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 981, in _read_packet > > packet.check_error() > > File > > > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > > line 393, in check_error > > err.raise_mysql_exception(self._data) > > File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/err.py", > > line 107, in raise_mysql_exception > > raise errorclass(errno, errval) > > sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1055, > > "Expression #1 of SELECT list is not in GROUP BY clause and contains > > nonaggregated column 'msnoise.jobs.ref' which is not functionally > dependent > > on columns in GROUP BY clause; this is incompatible with > > sql_mode=only_full_group_by") [SQL: 'SELECT jobs.ref AS jobs_ref, > jobs.day > > AS jobs_day, jobs.pair AS jobs_pair, jobs.jobtype AS jobs_jobtype, > > jobs.flag AS jobs_flag, jobs.lastmod AS jobs_lastmod \nFROM jobs \nWHERE > > jobs.pair = %(pair_1)s AND jobs.day >= %(day_1)s AND jobs.day <= > %(day_2)s > > AND jobs.jobtype = %(jobtype_1)s AND jobs.lastmod >= %(lastmod_1)s GROUP > BY > > jobs.day ORDER BY jobs.day'] [parameters: {'lastmod_1': > > datetime.datetime(2018, 8, 17, 9, 52, 14, 839671), 'jobtype_1': 'CC', > > 'day_2': datetime.date(2017, 12, 13), 'day_1': datetime.date(2017, 12, > 9), > > 'pair_1': 'LS.DF01:LS.DF02'}] > > > > > > > > > > Regards, > > Yawar Hussain > > Ph.D. Student, Geotechnical Engineering > > Dpt. Civil and Environmental Engg. > > University of Brasilia, Brazil. > > > > > ------------------------------ > > Message: 3 > Date: Sat, 18 Aug 2018 21:22:21 +0200 > From: Thomas Lecocq <Thomas.Lecocq(a)seismology.be> > To: msnoise(a)mailman-as.oma.be > Subject: Re: [MSNoise] MSNoise stack > Message-ID: <0f6f23ea-65b4-5fa8-2d04-b8c8965cbeaa(a)seismology.be> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Yawar, > > You have to configure your MySQL (my.cnf or elsewhere) to use the > "traditional group by mode", see: > > https://github.com/ROBelgium/MSNoise/issues/72 > > Cheers, > > Thomas > > > Le 18/08/2018 ? 15:01, Yawar Hussain a ?crit?: > > The stacking on msnoise example data is perfectly alright. > > > > > > Regards, > > Yawar Hussain > > Ph.D. Student, Geotechnical Engineering > > Dpt. Civil and Environmental Engg. > > University of Brasilia, Brazil. > > > > > > On Sat, Aug 18, 2018 at 9:55 AM Yawar Hussain <yawar.pgn(a)gmail.com> > wrote: > > > >> Hello, > >> > >> I have problem with stacking: > >> > >> yawar@yawar-Vostro-5470:~/anaconda3/bin$ msnoise stack -r > >> Lets STACK ! > >> 2018-08-18 09:52:14 [DEBUG] Starting the ref stack > >> [] > >> 2018-08-18 09:52:14 [DEBUG] Processing LS_DF01:LS_DF02-ZZ-1 > >> Traceback (most recent call last): > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > >> line 1139, in _execute_context > >> context) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", > >> line 450, in do_execute > >> cursor.execute(statement, parameters) > >> File > >> "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > >> line 166, in execute > >> result = self._query(query) > >> File > >> "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > >> line 322, in _query > >> conn.query(q) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 835, in query > >> self._affected_rows = > self._read_query_result(unbuffered=unbuffered) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 1019, in _read_query_result > >> result.read() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 1302, in read > >> first_packet = self.connection._read_packet() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 981, in _read_packet > >> packet.check_error() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 393, in check_error > >> err.raise_mysql_exception(self._data) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/err.py", > >> line 107, in raise_mysql_exception > >> raise errorclass(errno, errval) > >> pymysql.err.InternalError: (1055, "Expression #1 of SELECT list is not > in > >> GROUP BY clause and contains nonaggregated column 'msnoise.jobs.ref' > which > >> is not functionally dependent 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/yawar/anaconda3/bin/msnoise", line 11, in <module> > >> sys.exit(run()) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/scripts/msnoise.py", > >> line 614, in run > >> cli(obj={}) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > >> line 716, in __call__ > >> return self.main(*args, **kwargs) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > >> line 696, in main > >> rv = self.invoke(ctx) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > >> line 1060, in invoke > >> return _process_result(sub_ctx.command.invoke(sub_ctx)) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > >> line 889, in invoke > >> return ctx.invoke(self.callback, **ctx.params) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/click/core.py", > >> line 534, in invoke > >> return callback(*args, **kwargs) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/scripts/msnoise.py", > >> line 301, in stack > >> main('ref', interval) > >> File > >> "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/s04stack.py", > >> line 203, in main > >> updated_days = updated_days_for_dates(db, start, end, > >> pair.replace('_', '.'), jobtype='CC', > >> interval=datetime.timedelta(days=interval),returndays=True) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/msnoise/api.py", > >> line 1189, in updated_days_for_dates > >> days = session.query(Job).filter(Job.pair == pair).filter(Job.day > >= > >> date1).filter(Job.day <= date2).filter(Job.jobtype == > >> jobtype).filter(Job.lastmod >= > >> lastmod).group_by(Job.day).order_by(Job.day).all() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > >> line 2613, in all > >> return list(self) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > >> line 2761, in __iter__ > >> return self._execute_and_instances(context) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/orm/query.py", > >> line 2776, in _execute_and_instances > >> result = conn.execute(querycontext.statement, self._params) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > >> line 914, in execute > >> return meth(self, multiparams, params) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", > >> line 323, in _execute_on_connection > >> return connection._execute_clauseelement(self, multiparams, params) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > >> line 1010, in _execute_clauseelement > >> compiled_sql, distilled_params > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > >> line 1146, in _execute_context > >> context) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > >> line 1341, in _handle_dbapi_exception > >> exc_info > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/util/compat.py", > >> line 202, in raise_from_cause > >> reraise(type(exception), exception, tb=exc_tb, cause=cause) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/util/compat.py", > >> line 185, in reraise > >> raise value.with_traceback(tb) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", > >> line 1139, in _execute_context > >> context) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", > >> line 450, in do_execute > >> cursor.execute(statement, parameters) > >> File > >> "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > >> line 166, in execute > >> result = self._query(query) > >> File > >> "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/cursors.py", > >> line 322, in _query > >> conn.query(q) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 835, in query > >> self._affected_rows = > self._read_query_result(unbuffered=unbuffered) > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 1019, in _read_query_result > >> result.read() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 1302, in read > >> first_packet = self.connection._read_packet() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 981, in _read_packet > >> packet.check_error() > >> File > >> > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/connections.py", > >> line 393, in check_error > >> err.raise_mysql_exception(self._data) > >> File > "/home/yawar/anaconda3/lib/python3.5/site-packages/pymysql/err.py", > >> line 107, in raise_mysql_exception > >> raise errorclass(errno, errval) > >> sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1055, > >> "Expression #1 of SELECT list is not in GROUP BY clause and contains > >> nonaggregated column 'msnoise.jobs.ref' which is not functionally > dependent > >> on columns in GROUP BY clause; this is incompatible with > >> sql_mode=only_full_group_by") [SQL: 'SELECT jobs.ref AS jobs_ref, > jobs.day > >> AS jobs_day, jobs.pair AS jobs_pair, jobs.jobtype AS jobs_jobtype, > >> jobs.flag AS jobs_flag, jobs.lastmod AS jobs_lastmod \nFROM jobs \nWHERE > >> jobs.pair = %(pair_1)s AND jobs.day >= %(day_1)s AND jobs.day <= > %(day_2)s > >> AND jobs.jobtype = %(jobtype_1)s AND jobs.lastmod >= %(lastmod_1)s > GROUP BY > >> jobs.day ORDER BY jobs.day'] [parameters: {'lastmod_1': > >> datetime.datetime(2018, 8, 17, 9, 52, 14, 839671), 'jobtype_1': 'CC', > >> 'day_2': datetime.date(2017, 12, 13), 'day_1': datetime.date(2017, 12, > 9), > >> 'pair_1': 'LS.DF01:LS.DF02'}] > >> > >> > >> > >> > >> Regards, > >> Yawar Hussain > >> Ph.D. Student, Geotechnical Engineering > >> Dpt. Civil and Environmental Engg. > >> University of Brasilia, Brazil. > >> > > _______________________________________________ > > 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 > > > End of MSNoise Digest, Vol 49, Issue 6 > ************************************** >

6 years, 8 months

← Newer
1
...
8
9
10
11
12
13
14
...
35
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

MSNoise