Project

General

Profile

Actions

Bug #4995

open

Mean Stack filter crash - "Got a packet bigger than 'max_allowed_packet' bytes"

Added by Carl Negro over 7 years ago. Updated over 7 years ago.

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

Also available in: Atom PDF