SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:36 AM
| ||||
| ||||
 mysql server has gone away If I fire a lot of querries, I get an error "mysql server has gone away/lost connection with the server" . I tried to use "mysql_ping()" to reconnect, but tht also fails... So shud i call real_connect again? I mean will it be gud practice tht way? I looked for such an error to have occured. I found mainly 2 reasons: 1-time out : this isn't possible as hundreds of queries r being fired in a few secs 2-a wrong query- i checked for the querry n it looked fine to me..... Also i noticed that the querry tht actually gives this error is in fact executed n logged in the database even though it returns an error!!! But thereafter, no query even gets logged and all return the same error. do u knw any othr circumstances in which such an error occurs? n whts the best poss soln here- to do a reconnect???? -- Bye for now, Nishant God Gave Me Nothing I Wanted, He Gave Me Everything I Needed !      |
|
02-28-2008, 05:36 AM
| ||||
| ||||
| Re: mysql server has gone away > If I fire a lot of querries, I get an error "mysql server has gone > away/lost > connection with the server" . I've seen this error for the second reason you've mentioned, wrong queries. You'll need to show us the query so we can see any possible issues. |
Linear Mode
