MOD_WSGI + pymssql Access SQL Server block

by pymssql Path SQL Server moment, directly Python does not issue the execution. by Mod_wsgi and Apache when deployed. All requests are found hang and then the database queries.

Through Google to find the answer, thank Google, specific description of the narrative see: Https://code.google.com/p/modwsgi/wiki/ApplicationIssues#Python_Simplified_GIL_State_API

Briefly, Mod_wsgi creates a sub interpreter for each virtual host and app mount point. There is a famous Gil in Python, when visiting Gil state via C extension, there is only the first sub interpreter capable of working properly, assuming that using a possibly sub interpreter can lead to deadlocks or crash, Since pymssql is a C extension so there will be this problem, the solution is. To add a configuration entry:

Wsgiapplicationgroup%{global}

Force the app to use the first sub interpreter, which makes the Gil work properly. After the change, mod_wsgi everything OK.

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

MOD_WSGI + pymssql Access SQL Server block