19 Oct
2018
19 Oct
'18
6:53 p.m.
Hi Thomas, I actually think this was related to the PR I submitted the
other day. Since I have a mix of stations (some 3-comp some only Z), when
mwcs_compute tried to calculate RR for a station-pair that only had ZZ, and
it couldnt find the reference function it crashed/hanged. Then after a
while hanging it threw the SQL error.
On Thu, Oct 18, 2018 at 11:15 PM Thomas Lecocq <Thomas.Lecocq(a)seismology.be>
wrote:
Hi Ashton
it seems your MWCS computation took a looooooong time and the MySQL
connection was killed during that time. Can you confirm ?
Thomas
Le 18/10/2018 à 18:54, Flinders, Ashton a écrit :
--
Ashton F. Flinders, Ph.D
U.S. Geological Survey
345 Middlefield Road
Menlo Park, CA 94025
(650) 329-5050
I get a strange crash part way through my MWCS
step (see below), and
compute_MWCS is not finishing. E.g. I have 5 frequency bands, but for
bands
2-4 only 1 of 10 station pair MWCS's get
calculated, even though all the
data is there in the stacks. I have tried rerunning comute_mwcs by
changing
the flag back to 'T' for the station
pairs where mwcs did not get
calculated, but it still crashes. This crash is repeatable.
Any thoughts?
(p.s. I also initially tried remaking the stacks, but it crashed at the
same point. The data looks good in the stacks)
-ashton
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File
"/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py",
line 1139, in _execute_context
context)
File
"/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
cursor.execute(statement, parameters)
File
"/home/ashton/anaconda3/envs/msnoise/lib/python3.5/site-packages/pymysql/cursors.py",
line 165, in execute
result = self._query(query)
File
"/home/ashton/anaconda3/envs/msnoise/lib/python3.5/site-packages/pymysql/cursors.py",
line 321, in _query
conn.query(q)
File
"/home/ashton/anaconda3/envs/msnoise/lib/python3.5/site-packages/pymysql/connections.py",
line 859, in query
self._execute_command(COMMAND.COM_QUERY, sql)
File
"/home/ashton/anaconda3/envs/msnoise/lib/python3.5/site-packages/pymysql/connections.py",
line 1096, in _execute_command
self._write_bytes(packet)
File
"/home/ashton/anaconda3/envs/msnoise/lib/python3.5/site-packages/pymysql/connections.py",
line 1048, in _write_bytes
"MySQL server has gone away (%r)" % (e,))
pymysql.err.OperationalError: (2006, "MySQL server has gone away
(BrokenPipeError(32, 'Broken pipe'))")
The above exception was the direct cause of the following exception:
_______________________________________________
MSNoise mailing list
MSNoise(a)mailman-as.oma.be
http://mailman-as.oma.be/mailman/listinfo/msnoise