> Urscheler, Roger (COM Chantry CA) wrote:
>> I have a multi-threaded application with a threadpool where each thread
>> has its own connection (and query and row objects). I did set the
>> 'reconnect' and 'multi statement' options. Once a while (about every 50
>> or 100 queries) the connection to mysql is disconnected, the exception is
>> "Lost connection to MySQL server during query". The 'reconnect' option
>> reconnects automatically again, but still this query failed.
I had the same problem some time ago (im using a simalar
multithreding-connection system. My problem was: I had a query which
returned many rows, but didnt used (a failure) all of them. then i tried to
reuse the query and result object i got that error. if u use the same query
(of course in the same thread) many times, do a query.reset() and
res.purge() before reusing them, even if it works most times without them.
this solved my problem.