On 28/03/2014, at 10:10 PM, Juan Antonio Ibáñez <[email protected]> wrote:
> Hello, > > I am trying to migrate my Turbogears app from MySQL 5.5 to Percona 5.6. It > works ok under paste serve script but fails under Apache + mod_wsgi: > > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py', line 2184 in one > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py', line 2227 in > __iter__ > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py', line 2240 in > _execute_and_instances > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py', line 2231 in > _connection_from_session > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/session.py', line 730 in > connection > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/session.py', line 734 in > _connection_for_bind > File 'build/bdist.linux-x86_64/egg/sqlalchemy/orm/session.py', line 267 in > _connection_for_bind > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py', line 2490 in > contextual_connect > File 'build/bdist.linux-x86_64/egg/sqlalchemy/pool.py', line 224 in connect > File 'build/bdist.linux-x86_64/egg/sqlalchemy/pool.py', line 387 in __init__ > File 'build/bdist.linux-x86_64/egg/sqlalchemy/pool.py', line 741 in _do_get > File 'build/bdist.linux-x86_64/egg/sqlalchemy/pool.py', line 188 in > _create_connection > File 'build/bdist.linux-x86_64/egg/sqlalchemy/pool.py', line 273 in __init__ > File 'build/bdist.linux-x86_64/egg/sqlalchemy/event.py', line 282 in exec_once > File 'build/bdist.linux-x86_64/egg/sqlalchemy/event.py', line 291 in __call__ > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/strategies.py', line 167 > in first_connect > File 'build/bdist.linux-x86_64/egg/sqlalchemy/dialects/mysql/base.py', line > 1999 in initialize > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py', line 176 in > initialize > File 'build/bdist.linux-x86_64/egg/sqlalchemy/dialects/mysql/base.py', line > 1964 in _get_default_schema_name > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py', line 1449 in > execute > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py', line 1628 in > _execute_text > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py', line 1698 in > _execute_context > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py', line 1691 in > _execute_context > File 'build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py', line 331 in > do_execute > File 'build/bdist.linux-x86_64/egg/MySQLdb/cursors.py', line 201 in execute > File 'build/bdist.linux-x86_64/egg/MySQLdb/connections.py', line 36 in > defaulterrorhandler > InterfaceError: (InterfaceError) (0, '') 'SELECT DATABASE()' () > > What could be the difference when running under mod_wsgi? > I use mod_wsgi 3.2 version, SQLalchemy 0.7.8 and both tested mysql.python > 1.2.4 and 1.2.5 Don't really know. If you Google that error message you will find some suggesting it is because the database server software was upgraded but the database client code, MySQLdb module in this case, wasn't recompiled against the upgraded database client libraries. The result is a mismatch in the ABI and so it fails. So make sure you have reinstall MySQLdb module in the Python installation that mod_wsgi is using. Graham -- You received this message because you are subscribed to the Google Groups "modwsgi" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/modwsgi. For more options, visit https://groups.google.com/d/optout.
