ludovic.mercier at gmail
Jul 9, 2009, 12:09 AM
Post #1 of 1
(143 views)
Permalink
|
|
trac crash with mysql error
|
|
Hi,
I use trac from several month and i have a chronic problem.
After a mysql timeout and if i am logged trac crash with the mysql
error : "MySQL server has gone away".
It is look like to the bug : #3645 http://trac.edgewall.org/ticket/3645
So i have updated my trac version :
this is my system information :
Trac: 0.11.4Trac: 0.11.4
Python: 2.4.3 (#1, May 24 2008, 13:47:28) [GCC 4.1.2 20070626 (Red
Hat 4.1.2-14)]
setuptools: 0.6c5
MySQL: server: "5.0.45-log", client: "5.0.45", thread-safe: 1
MySQLdb: 1.2.2
Genshi: 0.5.1
mod_python: 3.2.8
Pygments: 0.11.1
Subversion: 1.4.2 (r22196)
jQuery: 1.2.6
Python: 2.4.3 (#1, May 24 2008, 13:47:28) [GCC 4.1.2 20070626 (Red
Hat 4.1.2-14)]
setuptools: 0.6c5
MySQL: server: "5.0.45-log", client: "5.0.45", thread-safe: 1
MySQLdb: 1.2.2
Genshi: 0.5.1
mod_python: 3.2.8
Pygments: 0.11.1
Subversion: 1.4.2 (r22196)
jQuery: 1.2.6
But in my apache server i have php installed. So i have re-build php
with a patch to link in libmysqlclient_r.so.
-bash-3.1$ ldd /usr/lib/php/modules/*.so | grep mysql
/usr/lib/php/modules/mysqli.so:
libmysqlclient_r.so.15 => /usr/lib/mysql/libmysqlclient_r.so.
15 (0x00672000)
/usr/lib/php/modules/mysql.so:
libmysqlclient_r.so.15 => /usr/lib/mysql/libmysqlclient_r.so.
15 (0x003ee000)
/usr/lib/php/modules/pdo_mysql.so:
libmysqlclient_r.so.15 => /usr/lib/mysql/libmysqlclient_r.so.
15 (0x00a8d000)
And my sqldb link also on /usr/lib/mysql/libmysqlclient_r.so.15
I have any solution for this problem.... someone have any idea ??
thanks for your help.
############# The crash message ################
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/api.py", line 367, in send_error
'text/html')
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/chrome.py", line 708, in render_template
data = self.populate_data(req, data)
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/chrome.py", line 618, in populate_data
d['chrome'].update(req.chrome)
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/api.py", line 194, in __getattr__
value = self.callbacks[name](self)
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/chrome.py", line 476, in prepare_request
for category, name, text in contributor.get_navigation_items(req):
File "/usr/lib/python2.4/site-packages/Bitten-0.6dev_r641-py2.4.egg/
bitten/web_ui.py", line 89, in get_navigation_items
if 'BUILD_VIEW' in req.perm:
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/api.py", line 194, in __getattr__
value = self.callbacks[name](self)
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/main.py", line 264, in _get_perm
return PermissionCache(self.env, self.authenticate(req))
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/main.py", line 133, in authenticate
authname = authenticator.authenticate(req)
File "build/bdist.linux-i686/egg/acct_mgr/web_ui.py", line 408, in
wrap
File "build/bdist.linux-i686/egg/acct_mgr/web_ui.py", line 419, in
authenticate
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/auth.py", line 70, in authenticate
authname = self._get_name_for_cookie(req, req.incookie
['trac_auth'])
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/
web/auth.py", line 189, in _get_name_for_cookie
(cookie.value, req.remote_addr))
File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/
util.py", line 50, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in
execute
File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35,
in defaulterrorhandler
OperationalError: (2006, 'MySQL server has gone away')
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
|
