Re: 1040 error, too many connections?

2003-07-27 Thread Martin Gainty
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?

2003-07-27 Thread Nils Valentin
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]