CMS Widget/CMS Crashed Randomly - Had to clear CMS Cache?

محروم.كوم · #1 02-02-2010, 07:00 AM

Wow I don't know WTF happened but if this is going to be a semi-regular issue that we experience with vB4 this is not going to be fun having vb4.

I was getting an error about Widget cache keys and it would timeout my MySQL server. The database error messages that I was getting e-mailed to me were 1mb in size and crashes Thunderbird if I try to open it. If I try to open it in webmail, it completely effs my browser's output to:

Quote:
Database error in vBulletin 4.0.1:

Invalid SQL:

REPLACE INTO cache
SET cacheid = 'widget.beb52656a86384c715e10a2176e71dcd',
expires = 1265079118,
created = 1265078818,
locktime = 0,
data = "O\"vB_Search_Results\"{s:23:\"\0vB_Se arch _Results\0user\";O\"vB_Legacy_CurrentUser\" {s\"\0*\0attachments\";N;s:16:\"\0*\0hidden_fo rums\";N;s:22:\"\0*\0unsearchable_forums\";N;s \"\0*\0registry\";O\"vB_Registry\":103:{s:9 :\" datastore\";O\"vB_Datastore\"{s\"defaul titems\";a{i:0;s:7:\"options\";i:1;s\"bitfi elds\";i:2;s:15:\"attachmentcache\";i:3;s\"for umcache\";i:4;s\"usergroupcache\";i:5;s\"s tylecache\";i:6;s\"languagecache\";i:7;s\"p roducts\";i:8;s\"pluginlist\";i:9;s\"cron\" ;i:10;s\"profilefield\";i:11;s\"loadcache\" ;i:12;s\"noticecache\";}s\"registry\";R:6;s \"dbobject\";O\"vB_Database\":18:{s\"fun ctions\";a{s:7:\"connect\";s\"mysql_connec t\";s\"pconnect\";s\"mysql_pconnect\";s:9 :\ "select_db\";s:15:\"mysql_select_db\";s\"qu ery\ ";s\"mysql_query\";s:16:\"query_unbuffered \";s :22:\"mysql_unbuffered_query\";s\"fetch_row\";s :15:\"mysql_fetch_row\";s\"fetch_array\";s \"mysql_fetch_array\";s\"fetch_field\";s:17 :\" mysql_fetch_field\";s\"free_result\";s\"my sql_free_result\";s\"data_seek\";s:15:\"mysql_d ata_seek\";s\"error\";s\"mysql_error\";s \"errno\";s\"mysql_errno\";s\"affected_ row s\";s:19:\"mysql_affected_rows\";s\"num_rows\ "; s\"mysql_num_rows\";s\"num_fields\";s:16:\ "mysql_num_fields\";s\"field_name\";s:16:\ "mys ql_field_name\";s\"insert_id\";s:15:\"mysql_ins ert_id\";s\"escape_string\";s:19:\"mysql_escap e_string\";s:18:\"real_escape_string\";s\"mysq l_real_escape_string\";s\"close\";s\"mysql_ close\";s:15:\"client_encoding\";s\"mysql_clie nt_encoding\";}s\"registry\";R:6;s\"fetchty pes\";a{i:2;i:2;i:1;i:1;i:0;i:3;}s:7:\"appname\ ";s\"vBulletin\";s\"appshortname\";s \"vB ulletin\";s\"database\";s\"mifbody_vbulleti n\";s\"connection_master\";i:0;s:16:\"connec ti on_slave\";R:52;s\"connection_recent\";R:52;s: 11:\"multiserver\";b:0;s:15:\"shutdownqueries\";a: 1:{s\"lastvisit\";s:85:\"\n UPDATE user\n SET lastactivity = 1265078818\n WHERE userid = 193\n \";}s\"sql\";s:0:\"\";s\"reporterror\";b :1; s\"error\";s:0:\"\";s\"errno\";i:0;s\"max packet\";i:0;s\"locked\";b:0;s\"querycount\ ";i:67;}s\"prefix\";N;s:15:\"checked_option s\"; b:1;}s\"input\";O:16:\"vB_Input_Cleaner\"{s \"shortvars\";a{s\"f\";s:7:\"forumid\";s \"t\";s\"threadid\";s\"p\";s\"postid\" ;s\"u\";s\"userid\";s\"a\";s\"announc ementid\";s\"c\";s\"calendarid\";s\"e\"; s:7:\"eventid\";s\"q\";s\"query\";s\"pp\" ;s:7:\"perpage\";s\"page\";s\"pagenumber\"; s\"sort\";s\"sortfield\";s\"order\";s\ "sortorder\";}s:18:\"superglobal_lookup\";a:7: {s:1 :\"g\";s\"_GET\";s\"p\";s\"_POST\";s \" r\";s\"_REQUEST\";s\"c\";s:7:\"_COOKIE\";s :1 :\"s\";s:7:\"_SERVER\";s\"e\";s\"_ENV\";s: 1: \"f\";s\"_FILES\";}s\"scriptpath\";s:0:\ "\" ;s\"reloadurl\";s:0:\"\";s:7:\"wolpath\";s:0:\" \";s\"url\";s:0:\"\";s\"ipaddress\";s:0:\ "\" ;s\"alt_ip\";s:0:\"\";s\"registry\";r:6;s:12 :\"cleaned_vars\";a:19:{s:18:\"vbulletin_collaps e\ ";i:7;s:18:\"mifbody_referrerid\";i:3;s\"m ifbo dy_userid\";i:3;s:16:\"mifbody_password\";i:7;s:17 :\"mifbody_lastvisit\";i:3;s\"mifbody_lastac ti vity\";i:3;s\"mifbody_threadedmode\";i:9;s:19: \"mifbody_sessionhash\";i:9;s:19:\"mifbody_user sty leid\";i:3;s:18:\"mifbody_languageid\";i:3;s\"s \";i:9;s:7:\"styleid\";i:2;s\"langid\";i:2;s :10 :\"referrerid\";i:3;s\"a\";i:7;s\"nojs\";i :1 ;s\"ajax\";i:1;s\"pagenumber\";i:3;s:16:\"m ifbody_cms_rate\";i:7;}s\"friendly_uri\";s:0:\ "\";}s\"db\";R:22;s\"userinfo\";a:198:{s \ "userid\";s\"193\";s\"temp\";N;s\"fie ld2\ ";s\"Macomb Twp, MI\";s\"field3\";s:34:\"Camaros, Firebirds, computers, etc\";s\"field4\";s\"Service Desk Analyst\";s\"field5\";s\"48042\";s\"field 7\";s\"Brian Meissen\";s\"field8\";s:37:\"1994 Camaro "Red Alert" LT1\";s:7:\"field66\";s:7:\"meissen\";s:7:\"field6 7\";s\"38501391\";s:7:\"field68\";s:7:\"mifbo dy \";s:7:\"field69\";s:0:\"\";s\"subfolders\" ;N; s\"pmfolders\";s\"a{i:1;s\"Save\";}\" ;s\"buddylist\";s:163:\"254 305 386 395 453 470 757 789 806 954 981 1366 1515 1619 1653 1743 1749 1771 1855 1889 1895 1918 1990 1993 2053 2127 2135 2189

(I had to delete it because it was just all gibberish and was past the size limit)

WTF???

Thankfully clearing CMS cache fixed it but this is completely unacceptable. What causes this? __DEFINE_LIKE_SHARE__