vB crashes MySQL on one really* really long query.

محروم.كوم · #1 09-27-2009, 08:10 PM

Hi all. I've seen this a few times. I get a MySQL error on the following query:

Code:
Invalid SQL:

REPLACE INTO search
(userid* titleonly* ipaddress* personal* query* searchuser* forumchoice* prefixchoice* sortby* sortorder* searchtime* showposts* orderedids* dateline* searchterms* displayterms* searchhash* completed)
VALUES
(0*
0*
'75.36.203.166'*
0*
'oil cooler 911'*
''*
'257*8*223'*
''*
'rank'*
'DESC'*
49.94111* 1*
'2597545*2597470*2597565*2597589*2597601*2597592*2 597465*2597442*2597307*2597303*2597322*2597329*259 7429*2597607*2597631*2597840*2597814*3671638*25978 61*2597881*2597806*2597768*2597720*2597677*2597751 *2597764*2597766*2597273*2597272*2597068*2597045*2 597069*2597086*2597095*2597032*2597030*2597001*259 6988*2597024*2597025*2597034*2597104*2597137*25972 45*2597240*2597254*2597260*2597262*2597233*2597172 *2597141*2597138*2597150*2597159*2597163*2597904*2 597910*2598599*2598585*2688679*2954387*2598697*259 8545*2598493*2598411*2598369*2598420*2598423*25984 62*2598723*2598773*2598947*2598943*2598967*2598972 *2598993*2598913*2598907*2598810*2598805*2598843*2 598889*2598898*2598349*2598337*2598091*

[this section is about 15*000 lines long]

1254023413*
'a:25:{s\"query\";s\"oil cooler 911\";s\"searchuser\";s:0:\"\";s\"exactname \";i:1;s\"starteronly\";i:0;s\"tag\";s:0:\" \";s\"forumchoice\";a{i:0;s\"257\";i:1;s \"8\";}s\"prefixchoice\";a:0:{}s\"child forums\";i:1;s\"titleonly\";i:0;s\"showposts \";i:1;s\"searchdate\";s\"0\";s\"before after\";s\"after\";s\"sortby\";s\"rank\"; s\"sortorder\";s\"descending\";s\"replyl ess\";i:0;s\"replylimit\";i:0;s\"searchthr eadid\";i:0;s\"saveprefs\";i:0;s\"quicksear ch\";i:0;s\"searchtype\";i:1;s:7:\"exclude\";s :0:\"\";s:7:\"nocache\";i:0;s\"ajax\";i:0;s \"humanverify\";a{s\"input\";s\"hG2E9p\"; s\"hash\";s:32:\"b269e7908dbe1b84b57eb614ae635a 57\";}s\"userid\";i:0;}'*
'a{s\"words\";a{i:0;s:34:\"oil</u> OR cooler OR <u>911\";}s\"highlight\";a{i:0;s\"oil\";i :1;s\"cooler\";i:2;s\"911\";}s\"common\"; a:0:{}s\"users\";a:0:{}s\"forums\";a{i:25 7;i:257;i:8;i:8;}s\"prefixes\";a:0:{}s\"tag\ ";s:0:\"\";s:7:\"options\";a{s\"starteronly \";i:0;s\"childforums\";i:1;s\"action\";s:7 :\"process\";}}'*

'e2de7f5182ceb313b62a13dfdd036879'*
1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday* September 26th 2009 @ 08:49:23 PM
Error Date : Saturday* September 26th 2009 @ 08:50:13 PM
Script : http://forums.pelicanparts.com/search.php?do=process
Referrer : http://forums.pelicanparts.com/search.php?do=process
IP Address : 75.36.203.166
Username : Unregistered
Classname : vB_Database
MySQL Version :
I realize that I have a pretty big forum* and this is probably too big of a query to run on the server. So* what can be done to minimize / prevent this error? I got three of them today.

Thanks in advance*

Wayne __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
mysql query	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-11-2010 09:30 PM
vB crashes MySQL on one really* really long query.	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	09-27-2009 07:50 PM
Query took long time? What is the cause?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-13-2009 11:10 PM
Mysql Server crashes all couple of minutes.	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-07-2009 09:30 AM
Need MySQL Query help	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-08-2009 01:00 PM