(OperationalError) (2006, 'MySQL server has gone away')

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Running on  MySQL server 
2. Went to bed, woke up and found the error and pyrit closed
3.

What is the expected output? What do you see instead?

root@Osiris:~# pyrit batch
Pyrit 0.4.1-dev (svn r297) (C) 2008-2011 Lukas Lueg http://pyrit.googlecode.com
This code is distributed under the GNU General Public License v3+

Connecting to storage at 'mysql://192.168.5.1/pyrit'...  connected.
Working on ESSID 'KTA3'
Traceback (most recent call last): (3.7%); 15224 PMKs per second.
  File "/usr/local/bin/pyrit", line 6, in <module>
    pyrit_cli.Pyrit_CLI().initFromArgv()
  File "/usr/local/lib/python2.6/dist-packages/pyrit_cli.py", line 115, in initFromArgv
    func(self, **options)
  File "/usr/local/lib/python2.6/dist-packages/pyrit_cli.py", line 803, in batchprocess
    for results in dbiterator:
  File "/usr/local/lib/python2.6/dist-packages/cpyrit/cpyrit.py", line 787, in next
    solvedResults
  File "/usr/local/lib/python2.6/dist-packages/cpyrit/storage.py", line 1065, in __setitem__
    essid_obj = q.filter(ESSID_DBObject.essid == essid).one()
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/orm/query.py", line 1646, in one
    ret = list(self)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/orm/query.py", line 1689, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/orm/query.py", line 1694, in _execute_and_instances
    mapper=self._mapper_zero_or_none())
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/orm/session.py", line 720, in execute
    clause, params or {})
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", line 1191, in execute
    params)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", line 1302, in __execute_context
    context.parameters[0], context=context)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
    context)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
    context)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/default.py", line 299, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (2006, 'MySQL server has 
gone away') 'SELECT essids.essid_id AS essids_essid_id, essids.essid AS 
essids_essid, essids.uid AS essids_uid \nFROM essids \nWHERE essids.essid = %s' 
('KTA3',)

What version of the product are you using? On what operating system?

Pyrit 0.4.1-dev (svn r297)
Ubuntu Desktop 10.10 x86/32
2.6.32-28-generic #55-Ubuntu SMP Mon Jan 10 21:21:01 UTC 2011 i686 GNU/Linux

Please provide any additional information below.
I have set max packet size to 32mb in mysql
I am unsure if this is really an issue with pyrit, or just an issue with sql 
configuration. But I woke up and found it, so I figured I would share. If I 
find anything I will post here for all to see.

Original issue reported on code.google.com by mrfantas...@aol.com on 24 Feb 2011 at 3:18

[GoogleCodeExporter]

This only occured once and I am uncertain the cause, I have been generating 
tables for over a week now and the issue has not re-occurred, as I stated, this 
may have been an issue with my configuration. Consider this a resolved issue, 
Unless further issues arrise, I will consider this a non issue. Thank you!

Original comment by mrfantas...@aol.com on 5 Mar 2011 at 6:11

[GoogleCodeExporter]

Original comment by lukas.l...@gmail.com on 8 Mar 2011 at 4:01

• Changed state: Invalid