dbi:mysql mysql has gone away
Paul Vudmaska <[email protected]>
| Newsgroups | gmane.comp.apache.mod-ruby,gmane.comp.lang.ruby.general |
|---|---|
| Message-ID | <[email protected]> |
I've been using Ruby/mod_ruby now for...about 5 months and truly like it - developing about 1/2 dozen sites for a customer, utilizing the same common code for things like content and user mgt. Adding another site is quite simple. Its great and the customer is happy. I'm using dbi: mysql ruby - and i use it a lot - say 6,8 or 10 lookups(session mgt, site vars, etc) Of course I plan to cache these at some time. However, still, and for some time, i've intermittantly been getting this /'Mysql has gone away'/* *error - about 1 in 30 or 40 pages. Gone away without so much as a post card! Upon refresh it is gone and generally, I can catch the error, only hobbling the page somewhat. I've checked mysql to see if I'm hanging connections - i'm not. In fact, code is set up in such a way that that would be difficult. I'm not 'finishing' recordsets - i'm exclusively using select_one,or select_all (which does this automatically i understand) - and they are typically in closures anyhow. The only non-typical thing i'm doing is sharing the code between sites - would this affect a threadding problem or something - do mod_ruby and dbi:ruby get along?? My host says 'mysql is not stable' - running 3.23. They suggest postegre. My needs are not sophisticated. My needs are more in terms of speed. It has come to be a neat system - you should see the customers eyes when I create a whole new site by simply draggin a file into a directory! http://suite.integrated-internet.com I simply can not chase this down. Anyone suggest any paths to explore that might help find this? Thanks,Paul