Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Crash when MySQL is not accessed for some time. #12

Open
dotancohen opened this issue Dec 8, 2013 · 2 comments
Open

Crash when MySQL is not accessed for some time. #12

dotancohen opened this issue Dec 8, 2013 · 2 comments
Labels

Comments

@dotancohen
Copy link
Owner

I left squeal open all morning. When I came back I tried to view a table and it crashed:

   Showing table phone_list
   ------------------------

   Describe table
   --------------
Traceback (most recent call last):
  File "./squeal.py", line 336, in <module>
    main()
  File "./squeal.py", line 120, in main
    show_table_details(conn, cursor, prompt, menu_tables[operation-1])
  File "./squeal.py", line 251, in show_table_details
    output_table_from_sql(conn, cursor, sql)
  File "./squeal.py", line 294, in output_table_from_sql
    cursor.execute(sql, data)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')
@dotancohen
Copy link
Owner Author

Another one, from the current version of the script:

   Describe table
   --------------
Traceback (most recent call last):
  File "./squeal.py", line 378, in <module>
    main()
  File "./squeal.py", line 139, in main
    show_table_details(conn, cursor, prompt, menu_tables[operation-1], records_to_show)
  File "./squeal.py", line 288, in show_table_details
    output_table_from_sql(conn, cursor, sql)
  File "./squeal.py", line 332, in output_table_from_sql
    cursor.execute(sql, data)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')

@dotancohen
Copy link
Owner Author

May be related to #23.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant