1040 error, too many connections?
I'm running a series of queries from a Python program using the MySQLdb module. The program opens a connection and then procedes to make two queries and then close the connection. It does this for each file provided as an argument to the program so there can be quite a few such cycles. I'm getting an 1040 error of 'Too many connections'. I can't figure out how this program would ever have more than one connection open at a time. Could anyone explain what I'm doing wrong? I've tried forcing the connection closed at the end of each cycle but that doesn't seem to help. Thanks. -- Peace, Love, Linux Michael [EMAIL PROTECTED] http://kavlon.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1040 error, too many connections?
What happens if you keep the original connection open and ALWAYS query with that connection -M - Original Message - From: Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 27, 2003 6:41 AM Subject: 1040 error, too many connections? I'm running a series of queries from a Python program using the MySQLdb module. The program opens a connection and then procedes to make two queries and then close the connection. It does this for each file provided as an argument to the program so there can be quite a few such cycles. I'm getting an 1040 error of 'Too many connections'. I can't figure out how this program would ever have more than one connection open at a time. Could anyone explain what I'm doing wrong? I've tried forcing the connection closed at the end of each cycle but that doesn't seem to help. Thanks. -- Peace, Love, Linux Michael [EMAIL PROTECTED] http://kavlon.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1040 error, too many connections?
Hi Michael, How many client connections does mysql SHOW PROCESSLIST show you ? Best regards Nils Valentin Tokyo/Japan 2003 7 27 22:41Michael : I'm running a series of queries from a Python program using the MySQLdb module. The program opens a connection and then procedes to make two queries and then close the connection. It does this for each file provided as an argument to the program so there can be quite a few such cycles. I'm getting an 1040 error of 'Too many connections'. I can't figure out how this program would ever have more than one connection open at a time. Could anyone explain what I'm doing wrong? I've tried forcing the connection closed at the end of each cycle but that doesn't seem to help. Thanks. -- Peace, Love, Linux Michael [EMAIL PROTECTED] http://kavlon.org -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]