Actions
Bug #4995
openMean Stack filter crash - "Got a packet bigger than 'max_allowed_packet' bytes"
Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
05/31/2017
Due date:
% Done:
0%
Estimated time:
Affected Version:
Appion/Leginon 3.2
Show in known bugs:
No
Workaround:
Description
Log from Priyamvada's 17may30c session:
... reading particle 88338 from stack start.hed into memory ... reading particle 88355 from stack start.hed into memory ... reading particle 88389 from stack start.hed into memory ... reading particle 90302 from stack start.hed into memory ... reading particle 92166 from stack start.hed into memory ... reading particle 92704 from stack start.hed into memory ... reading particle 93887 from stack start.hed into memory ... finished reading 282 particles of boxsize 160 x 160 from file ... finished readParticlesFromFile() in 11.81 sec ... writing stack to disk from memory: /gpfs/appion/pacharya/17may30c/stacks/meanfilt836_2/bad.hed ... wrote 282 particles to header file ... finished in 479.03 msec ... finished appendParticlesToFile() in 479.26 msec ... ProcessStack2: finished processing stack in 12.29 sec got old stackdata in 1.68 msec ... created new stackdata in 10.05 msec ... Getting list of particles to include ... Completed in 243.71 msec ... Retrieving original stack information ... Completed in 163.37 msec ... Assembling database insertion command ... Inserting particle information into database appending 94787 particles to file before flip 1.59927 0.622391 after flip 0.622391 1.59927 appending 282 particles to file before flip -0.402555 -1.25287 after flip -1.25287 -0.402555 Long MySQL query of 10962851 characters connecting Traceback (most recent call last): File "/opt/myamisnap/bin/stackFilter.py", line 102, in subStack.start() File "/opt/myamisnap/bin/stackFilter.py", line 91, in start apStack.commitSubStack(self.params, newname, oldstackparts=stackparts) File "/opt/myamisnap/lib/appionlib/apStack.py", line 557, in commitSubStack sinedon.directq.complexMysqlQuery('appiondata',sqlcmd) File "/opt/myamisnap/lib/sinedon/directq.py", line 26, in complexMysqlQuery results = cur.selectall(query) File "/opt/myamisnap/lib/sinedon/sqldb.py", line 42, in selectall self.c.execute(strSQL, param) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1153, "Got a packet bigger than 'max_allowed_packet' bytes"
Actions