Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 90074 - mysql-python module does not properly close mod_python database connections
Summary: mysql-python module does not properly close mod_python database connections
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Development (show other bugs)
Hardware: x86 Linux
: High normal (vote)
Assignee: Python Gentoo Team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-22 14:23 UTC by Shiner_Man
Modified: 2005-05-07 05:24 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Shiner_Man 2005-04-22 14:23:33 UTC 
Using mysql-python 1.0.0 causes mod_python to never close connections to the mysql database.  Eventually, mysql crashes.  

mysql-python 1.2.0(which is masked) has seemed to resolve this issue.

Reproducible: Always
Steps to Reproduce:
1.run 'mysqladmin processlist' to view current mysql connections
2.refresh a mod_python page that connects to mysql using mysql-python 1.0.0
3.run 'mysqladmin processlist' again.  All connections remain open.

Actual Results:  
Eventually, mysql has too many open connections and crashes.

Expected Results:  
umm...not crashed.

This is a known issue with the MySQLdb python module:

http://www.modpython.org/FAQ/faqw.py?req=show&file=faq02.024.htp

I suggest mysql-python 1.2.0 be marked stable.
Comment 1 Bryan Østergaard (RETIRED) gentoo-dev 2005-05-07 05:24:05 UTC 
x86 stable bumped - thanks for your bugreport.