Lost connection to MySQL server during query

[fmichael]

My script is on the lotus server, and according to the Service announcements this should be back up and running normally after some recent changes. However, I now get an "Lost connection to MySQL server during query". I haven't had this error before, and it seems to have been on and off today. At one point today my account was temporarily suspended for something with excessive resource use, but it is not suspended anymore, and I again get the error "Lost connection to MySQL server during query".

My script is already using 'localhost', as recommended in the Service announcements. What can be done to solve this?
Thanks in advance.

 

[Gouri]

Hi fmichael,

When I visited your site I saw first table showing the balances table then When it tries for the purchases table it is getting the error "Lost connection to MySQL server during query"

I think you have to separate the fetching of these two details. Check when the first table completed, Whether the connection is still live or not.

 

[fmichael]

Hi fmichael,

When I visited your site I saw first table showing the balances table then When it tries for the purchases table it is getting the error "Lost connection to MySQL server during query"

I think you have to separate the fetching of these two details. Check when the first table completed, Whether the connection is still live or not.

I'm sorry, but I don't understand what it is you suggest I should do. And in any case, it should not be necessary for me to change anything in the script; it has worked fine for years, and now it doesn't after something was changed with the server.

It works again now, but as I said the error has been on and off since sometime between Friday 5th of February 2010 and Monday 9th of February. Has something been corrected in the server so the error does not suddenly come up again later today?

Thanks in advance.
Edit:
The error is back again...
In the Service thread, it now says that:

Transfers \ Update Part31 hour ago Absolut, Stoli, Lotus, Boru, and Cossacks should all be running as normal. If you see anything wrong please open a ticket.

Well, my script is on Lotus, and it definitely doesn't run as normal.

 

[Gouri]

Again I am telling you that you need to review the code then only you can narrow down the problem and then easily find the solution for the problem.

 

[fmichael]

Again I am telling you that you need to review the code then only you can narrow down the problem and then easily find the solution for the problem.

I think this reply could win a prize for "Least Helpful Answer Ever"

Well, I've already tried, and if it was easy, I would not have started a thread. Anyway, as I said the code has worked fine for years. Now you made a change to the server, and it stopped working. How I am supposed to narrow down the problem, when the problem seems to be due to changes on the server? My code has not been changed; it's the server that's changed.

 

[Gouri]

Escalated to Admins to check serverside.