multiple SQL errors (gone away) after upgrade

[ctrenks]

Database error in vBulletin 3.8.6:

Invalid SQL:

		SELECT value, varname, datatype, optioncode
		FROM vb_setting
		WHERE varname IN ('vbet_provider_availability_Apertium')
		ORDER BY varname;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, December 5th 2011 @ 12:07:39 PM
Error Date    : Monday, December 5th 2011 @ 12:12:40 PM
Script        : http://www.allfreechips.com/es/afc_contests/dice.html
Referrer      : 
IP Address    : 66.249.68.97
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Invalid SQL:
INSERT IGNORE INTO vb_vbenterprisetranslator_cache_short_es (originaltext, translated, serie) VALUES ('$10 Free No Deposit With...', '$10 Libre Ningún Depósito Con...',1.32310820698E+13),('$15 Free + 300% 1st time...', '$15 Libre + 300% 1.º tiempo...',1.32310820698E+13),('2,000 Free Credits –...', '2,000 Créditos Libres \\u0096...',1.32310820698E+13),('Get $15 Free No Deposit...', 'Conseguir $15 Libre Ningún Depósito...',1.32310820698E+13),('579', '579',1.32310820698E+13),('118', '118',1.32310820698E+13),('101,167', '101,167',1.32310820698E+13),('6,247', '6,247',1.32310820698E+13),('22,782', '22,782',1.32310820698E+13),('S', 'S',1.32310820698E+13),('M', 'M',1.32310820698E+13),('T', 'T',1.32310820698E+13),('W', 'W',1.32310820698E+13),('T', 'T',1.32310820698E+13),('F', 'F',1.32310820698E+13),('S', 'S',1.32310820698E+13),('28', '28',1.32310820698E+13),('29', '29',1.32310820698E+13),('30', '30',1.32310820698E+13),('10', '10',1.32310820698E+13),('11', '11',1.32310820698E+13),('12', '12',1.32310820698E+13),('13', '13',1.32310820698E+13),('14', '14',1.32310820698E+13),('15', '15',1.32310820698E+13),('16', '16',1.32310820698E+13),('19', '19',1.32310820698E+13),('20', '20',1.32310820698E+13),('21', '21',1.32310820698E+13),('28', '28',1.32310820698E+13),('29', '29',1.32310820698E+13),('30', '30',1.32310820698E+13),('Online Users: 176', 'Usuarios on-line: 176',1.32310820698E+13),('5 members and 171 guests', '5 miembros y 171 huéspedes',1.32310820698E+13),('shirlsplay', 'shirlsplay',1.32310820698E+13),('Search Forums', 'Foros de búsqueda',1.32310820698E+13),('Advanced Search', 'Búsqueda avanzada',1.32310820698E+13),('» Stats', '» Stats',1.32310820698E+13),('Members: 14,617', 'Miembros: 14,617',1.32310820698E+13),('Threads: 4,757', 'Hilos: 4,757',1.32310820698E+13),('Posts: 20,751', 'Correos: 20,751',1.32310820698E+13),('Top Poster:', 'Cartel superior:',1.32310820698E+13),('ovelhinha', 'ovelhinha',1.32310820698E+13),('Powered by vBadvanced CMPS v3.2.1', 'Powered Por vBadvanced CMPS v3.2.1',1.32310820698E+13),('06:03 PM', '06:03 PM',1.32310820698E+13);

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, December 5th 2011 @ 12:03:26 PM
Error Date    : Monday, December 5th 2011 @ 12:08:09 PM
Script        : http://www.allfreechips.com/es/afc_contests/scratchcards.html
Referrer      : 
IP Address    : 66.249.68.97
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[r.dziadusz]

Hi I will try to reproduce this error in our test forum
In the meantime please read this post

[r.dziadusz]

I didn't notice any higly increased number of mysql, server has gone away errors.
Pleas read post i linked you in my previoust post ant let mi know if there is still a lot of new mysql: server has gone away errors

[ctrenks]

I have set max_allowed_packet to 3megs and also tripled the wait value. Restarted MySQL and withing a minute got a lot of errors still such as

Database error in vBulletin 3.8.6:

Invalid SQL:

		SELECT value, varname, datatype, optioncode
		FROM vb_setting
		WHERE varname IN ('vbet_provider_availability_Apertium')
		ORDER BY varname;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Sunday, December 18th 2011 @ 10:44:26 AM
Error Date    : Sunday, December 18th 2011 @ 10:52:01 AM
Script        : http://www.allfreechips.com/es/
Referrer      : 
IP Address    : 157.55.39.228
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Thanks!

Chris

[ctrenks]

These errors may be from me actually restarting SQL looking at the times,, ill check back later today..

[ctrenks]

OK, looks like all my errors have since stopped! woo I was getting pounded there for a while. Thanks again.

[r.dziadusz]

Hi much in meantime we found reasons why these errors apears, sometimes - it do not depand on us - Apertium server has some internal issue, we will prevent this kind of "timeouts" errors in our next release.