PDA

View Full Version : multiple SQL errors (gone away) after upgrade



ctrenks
05-12-11, 19:19
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
06-12-11, 19:54
Hi I will try to reproduce this error in our test forum
In the meantime please read this post (http://www.vbenterprisetranslator.com/forum/troubleshooting/6-faq-2.html#post3106)

r.dziadusz
07-12-11, 19:17
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
18-12-11, 17:59
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
18-12-11, 18:01
These errors may be from me actually restarting SQL looking at the times,, ill check back later today..

ctrenks
18-12-11, 18:50
OK, looks like all my errors have since stopped! woo I was getting pounded there for a while. Thanks again.

r.dziadusz
18-12-11, 20:48
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.

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Thanks to vBET 4.10.1 you can enjoy automatic translations