after I switched from activerecord to datamapper I started to see this "MYSQL Server has gone away". so my workaround was http://pastie.org/295236 which worked and works just fine though I do not know the impact on transactions. (just saw that it works even though I leak connections !!)
then there was this fix with the reconnect feature of the mysql client, so I dropped my workaround and installed data_objects (0.9.11) . I did not see any of these exceptions anymore. but now I see (mysql_errno=2013, sql_state=HY000) Lost connection to MySQL server during queryQuery in the same irregular manner as the "MYSQL Server has gone away". I am on shared host (dreamhost) and can not change the server side configuration of MYSQL. when I had a look in the pool implementation of the connection, I really missed quite a few options I am used to see for these kind of connections pooling: * minimum/maximum pool size, * test query for testing the connection, * none-blocking connection retrieval (the blocking retrieval caused already deadlocks with me). so I patched it for myself and wanted to see if this helps to fix my problem. I uploaded it onto two low traffic production site to see if it has any effect. not sure yet if it solved the problem - too short of a time. I do not know how to reproduce the error BUT the frequency is NOT acceptable for production. if I can help somehow please let me know, any hints are welcome. if you want to see the pool patches I happy to contribute them. but if things remains like they are right now I go back to my above workaround (after fixing the conncetion leak ;-) with regards Kristian On Mar 9, 2:54 pm, codaniel <[email protected]> wrote: > Thats what I thought at first, so I bumped the max connections up to > 100, the most I ever have at one time is about 14 or so . . . > > On Mar 8, 1:01 pm, Dirkjan Bussink <[email protected]> wrote: > > > On 8 Mar 2009, at 20:19, codaniel wrote: > > > > Yeah it allows for reconnects. My wait timeout is pretty short > > > because I have a lot of applications that tie into this DB. I have > > > another app running on the same machine same stack and it never > > > disconnects. > > > Isn't the issue that the maximum number of connections is reached and > > that it therefore can't reconnect? Seems like that could be the cause > > for a database that is often connected to. > > > -- > > Regards, > > > Dirkjan Bussink --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
