strange error mysql error number: 2006

[Tom Dooley]

Hi, i get everyday mysql errors, this errormail is about 1 MB big an has to do with search i do not post the whole mail it´s too big but an snapshot :

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT searchid FROM search WHERE showposts='0' AND query=' 1=1 AND NOT (thread.forumid=\'56\' OR thread.forumid=\'63\' OR thread.forumid=\'38\' OR thread.forumid=\'72\' OR thread.forumid=\'73\' OR thread.forumid=\'16\' OR thread.forumid=\'57\' OR thread.forumid=\'50\' OR thread.forumid=\'61\' OR thread.forumid=\'45\' OR thread.forumid=\'60\' OR thread.forumid=\'58\' OR thread.forumid=\'65\' OR thread.forumid=\'64\')' AND postids='405,414,415,417,421,422,423,424,425,426,427,430,431,1168,1170,1502,1503,1504,1506 ,1507,1508,1509,1510,1511,1514,1515,1516,1519,1521,1523,1926,1927,1928,1930,1934,1935,1937 ,1939,1940,1941,1943,1944,1946,1947,1948,1949,1950,1951,1952,1954,1955,1956,1957,2311,2314 ,2315,2316,2666,2667,2668,2669,2670,2672,2783,2785,2787,2788,2789,2790,2792,2793,2794,2798 ,2799,2801,2802,2803,2804,2807,2808,2810,2811,2812,2813,2814,2816,2817,2818,2820,2821,2822 ,2823,2824,2825,2827,2828,2829,2830,2831,2832,2833,2834,2835,2838,2839,2840,2841,2842,2843 ,2844,2845,!
2848,2850,2851,2852,3180,3181,3182,3185,3186,3188,3189,3190,3192,3194,3681,3682,3685,3771, 3772,3773,3774,3775,3776,3777,3778,3779,3900,3903,3905,3906,3912,3916,3918,3919,3920,3921, 3923,3926,3930,3931,3932,3934,3935,3936,3937,3940,3942,3943,3946,3947,3949,3950,3951,4050, 4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4061,4063,4066,4067,4068,4069,4070,4071, 4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4089,4090, 4092,4093,4094,4095,4096,4097,4098,4099,4100,4101,4102,4103,4104,4107,4109,4113,4114,4115, 4116,4117,4118,4121,4122,4124,4125,4129,4131,4134,4136,4163,4164,4165,4166,4167,4168,4169, 4483,4484,4485,4487,4489,4490,4491,4493,4497,4500,4501,4504,4507,4508,4511,4514,4517,4518, 4520,4521,4522,4523,4524,4526,4527,4528,4530,4531,4532,4854,4856,4857,4858,4860,4861,4862, 4864,5023,5024,5025,5026,5027,5028,5029,5030,5032,5033,5036,5037,5039,5040,5041,5042,5043, 5046,5049,5050,5051,5052,5053,5054,5055,5056,5057,5058,5059,5060,5061,5062,5063,5064,5065, 5!
066,5069,5070,5071,5072,5073,5075,5076,5077,6505,6507,6509,6510,6511,6512,6514,6516,6520,6 521,6522,6523,6524,6525,6526,6528,6530,6531,6532,6533,6535,6536,6537,6539,6540,6608,6609,6 613,6614,6615,6616,6617,6618,6619,6622,6623,6626,6627,6629,6633,6634,6635,6636,6639,6640,6 813,6816,6817,6818,6819,6822,6826,6830,6831,6833,6839,6840,6842,7469,7470,7780,7782,7786,7 790,7791,7792,7793,7794,7795,7796,7798,7799,7800,7801,7802,7803,7806,7807,7811,8360,8363,8 366,8379,8387,8388,8389,9054,9058,9059,10811,10812,10813,10814,10815,10818,10819,10820,108 21,10822,10824,10825,10826,10827,10828,10832,10833,10834,10836,10837,10838,10839,10842,108 43,10846,10848,10849,10852,10853,11661,11664,11665,11667,11668,11670,11671,11672,11673,116 74,11675,11676,11679,11680,11681,11682,11683,11685,11686,11687,11688,11690,11691,11692,116 94,11697,11698,11700,11702,11703,11704,11705,11707,11709,11711,11712,11714,11716,11717,117 20,11722,11724,11725,11727,11728,11734,11735,11736,11737,11739,11740,11741,11743,11744,117 4!
many lines more like this than,
1142,651143,651144,651146,651147,651148,651151,' AND querystring='ich'
mysql error: MySQL server has gone away

mysql error number: 2006

Date: Wednesday 19th of December 2001 10:00:51 PM
Script: http://www.wbc-board.to/forum/forum/search.php
Referer: http://www.wbc-board.to/forum/search.php?s=


i´m on an dedicated dual PIII 1000 with 1 GB Ram, php 4.06 and newest mysql. I dead make an update of counters and everything but still get this error everyday twice or more. What is the Problem ?

[Steve Machol]

mysql error: MySQL server has gone away

As it says. Maybe your box is set up to automatically restart MySQL on a regular basis.

[Tom Dooley]

so what can i do that i do not get this errors in future ?

[George L]

Originally posted by Tom Dooley
so what can i do that i do not get this errors in future ?

you can try and look at your mysql.err error log in your mysql data directory for clues as to why mysql went down

[Tom Dooley]

i could not find a file with name mysql.err ?

[George L]

Originally posted by Tom Dooley
i could not find a file with name mysql.err ?

no it's not named mysql.err exactly it's located in your mysql data directory and named normally as

servername.err

where servername is the name of your server

[Tom Dooley]

This are the type of errors what i found:


011219 01:22:08 mysqld started
Can't initialize InnoDB as 'innodb_data_file_path' is not set
/usr/sbin/mysqld-max: ready for connections
011219 1:23:50 read_const: Got error 127 when reading table ./wbc/user
011219 1:23:58 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:04 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:08 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:08 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:12 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:15 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:21 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:33 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:35 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:38 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:41 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:42 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:43 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:44 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:47 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:50 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:56 read_const: Got error 127 when reading table ./wbc/user
011219 1:24:59 read_const: Got error 134 when reading table ./wbc/user
011219 1:24:59 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:05 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:08 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:10 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:15 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:21 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:22 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:28 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:29 read_const: Got error 127 when reading table ./wbc/user
011219 1:25:46 read_const: Got error 127 when reading table ./wbc/user


no i deleted all logfiles to get fresh ones and made an reboot, after reboot i get
011220 18:22:08 /usr/sbin/mysqld-max: Normal shutdown

011220 18:22:08 /usr/sbin/mysqld-max: Shutdown Complete

011220 18:22:08 mysqld ended

011220 18:23:45 mysqld started
Can't initialize InnoDB as 'innodb_data_file_path' is not set
/usr/sbin/mysqld-max: ready for connections
~
~

[George L]

3rd post in http://vbulletin.com/forum/showthrea...dbdatafilepath

[Aachi]

Invalid SQL:

                                        UPDATE xxxxxxxxsession
                                        SET lastactivity = 1292329008, location = '/admincp/options.php?do=options&dogroup=vietvbbtopstats&advanced=0', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
                                        WHERE sessionhash = '6ecf79ca742a586a5cb07e2f676d4a51';

[B][COLOR=red]MySQL Error   : MySQL server has gone away
Error Number  : 2006[/COLOR][/B]
Request Date  : Tuesday, December 14th 2010 @ 06:16:48 AM
Error Date    : Tuesday, December 14th 2010 @ 06:16:58 AM
IP Address    : 182.178.133.41
Username      : .BZU.
Classname     : vB_Database
MySQL Version :

on my site it is showing this error..

[Steve Machol]

This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

Also from the MySQL site:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html