Re: Failing Mysql JDBC connections

2008-06-20 Thread Tobia Conforto
I wrote: As soon as this happens, all pages being worked on at the same time fail with such messages as: SQLTransformer.Query: Failed to execute query [...] com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed. For the record, this

Re: Failing Mysql JDBC connections

2008-06-20 Thread Andy Stevens
2008/6/20 Tobia Conforto [EMAIL PROTECTED]: For the record, this was caused by a deadlock problem, where many simultaneous requests would get a connection for their SQLTransformer, exhausting the connection pool, and then get stuck requesting more connections through an input module I wrote

Failing Mysql JDBC connections

2008-06-13 Thread Tobia Conforto
Hello I have a big problem right now: my Cocoon MySql connections have started to fail randomly, and when they do they bring down all pages currently being generated. My gut feeling is that it's a synchronization problem, some race condition in Cocoon or in the Mysql connector. This is