Unable to execute query ....MySQL server has gone away

[cybra]

My timeout has been increased to 30 minutes, and I still get the same error. Database has gone away.

[vshare2]

Hi,

Open a support ticket at

BuyScripts Helpdesk

with your vshare admin and FTP login details.

Thanks,

Buyscripts Team

[bplex]

My timeout has been increased to 30 minutes, and I still get the same error. Database has gone away.

How big are the videos that you are uploading? When vShare starts the conversion process, it establishes a connection to mySQL. When the process finishes, it attempts to update mySQL with the information for the videos. If the time between the start and finish is greater than 30 minutes, then you would still get the Database has gone away error. With a timeout of 30 minutes, it sounds as though either what you are uploading and converting is very big, or your server is taking an unusually long time to convert.

[cybra]

The biggest file was about 15 minutes long. But it times out on videos as short as 7 minutes. The entire process goes for about 4-5 minutes before it times out. The average 4-5 minutes videos convert fine with no problem.

My host ensured me that they increased it but I have now way of knowing for sure. I am just taking their word for it.

(from my server)
Hello,

we have increased the timeout limit to 1800 now. Please check and let us know if you need any other assistance.

Thanks!

[bplex]

Ask them which timeout limit they actually changed and if they restarted mySQL after the change. By default, BTW, the limit is set to 8 hours. They are telling you that it is set to 30 minutes, but if it is timing out before 30 minutes, it is obviously not set to 30 minutes.

[cybra]

I asked them to increase the MySQL server timeout and I actually restarted the server myself. So you said by default the limit is set to 8 hours. That would mean they actually would have decreased the limit to 30 minutes? Should I ask them then to set the limit to 8 hours?

[bplex]

Are you on a dedicated server (or virtual server)? If so, you can actually check the my.cnf file yourself (usually /etc/my.cnf) and see what they set the wait_timeout limit to. By default, it's 8 hours. However, setting it that high hurts performance which is why most host set it to something much lower than that (usually 5-10 minutes).

[cybra]

Im on a vps right now. Can it bee seen from WHMpanel? I can't find it from /etc/my.cnf