{"issue":{"created_at":"2011-11-18T17:40:44Z","state":"open","updated_at":"2011-11-18T18:21:02Z","user":{"gravatar_id":"fbfea707778097187975540e56f15ab3","id":1204952,"url":"https://api.github.com/users/Starcreature","login":"Starcreature","avatar_url":"https://secure.gravatar.com/avatar/fbfea707778097187975540e56f15ab3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"comments":1,"body":"Nu de laatste update uitgevoerd. En krijg de foutmelding: MySQL server has gone away. zover ik kan zien gaat MySQL niet uit.\r\nDe site draait op een VM met Windows 2003, 4 cores, 2 GB geheugen.\r\nxamp 1.7.4. Een aantal instellingen heb ik (tijdelijk) aangepast om problemen te voorkomen welke ik in de issues lijst ben tegen gekomen. De aanpassingen zijn:\r\n \r\nmy.ini\r\n\r\ninnodb_lock_wait_timeout = 600\r\nmax_allowed_packet = 64M\r\n\r\nphp.ini\r\n\r\nmax_execution_time = 10800\r\n\r\nownsettings.php\r\n\r\nset_time_limit(10800);\r\n\r\nWat ik te zien krijg als ik upgrade-db.php uitvoer:\r\n\r\nUpdating schema..(mysql)\r\n        Validating spots(messageid)\r\n        Validating spots(poster)\r\n        Validating spots(title)\r\n        Validating spots(tag)\r\n        Validating spots(category)\r\n        Validating spots(subcata)\r\n        Validating spots(subcatb)\r\n        Validating spots(subcatc)\r\n        Validating spots(subcatd)\r\n        Validating spots(subcatz)\r\n        Validating spots(stamp)\r\n        Validating spots(reversestamp)\r\n        Validating spots(filesize)\r\n        Validating spots(moderated)\r\n        Validating spots(commentcount)\r\n        Validating spots(spotrating)\r\n        Validating spots(reportcount)\r\n        Validating spots(spotterid)\r\n        Validating spotsfull(messageid)\r\n        Validating spotsfull(verified)\r\n        Validating spotsfull(usersignature)\r\n        Validating spotsfull(userkey)\r\n        Validating spotsfull(xmlsignature)\r\n        Validating spotsfull(fullxml)\r\n        Validating nntp(server)\r\n        Validating nntp(maxarticleid)\r\n        Validating nntp(nowrunning)\r\n        Validating nntp(lastrun)\r\n        Validating nntp(serverdatelastrun)\r\n        Validating commentsxover(messageid)\r\n        Validating commentsxover(nntpref)\r\n        Validating commentsxover(spotrating)\r\n        Validating reportsxover(messageid)\r\n        Validating reportsxover(fromhdr)\r\n        Validating reportsxover(keyword)\r\n        Validating reportsxover(nntpref)\r\n        Validating spotstatelist(messageid)\r\n        Validating spotstatelist(ouruserid)\r\n        Validating spotstatelist(download)\r\n        Validating spotstatelist(watch)\r\n        Validating spotstatelist(seen)\r\n        Validating commentsfull(messageid)\r\n        Validating commentsfull(fromhdr)\r\n        Validating commentsfull(stamp)\r\n        Validating commentsfull(usersignature)\r\n        Validating commentsfull(userkey)\r\n        Validating commentsfull(spotterid)\r\n        Validating commentsfull(hashcash)\r\n        Validating commentsfull(body)\r\n        Validating commentsfull(verified)\r\n        Validating commentsfull(avatar)\r\n                Modifying column avatar (type) on commentsfull\r\n        Validating settings(name)\r\n        Validating settings(value)\r\n        Validating settings(serialized)\r\n        Validating commentsposted(ouruserid)\r\n        Validating commentsposted(messageid)\r\n        Validating commentsposted(inreplyto)\r\n        Validating commentsposted(randompart)\r\n        Validating commentsposted(rating)\r\n        Validating commentsposted(body)\r\n        Validating commentsposted(stamp)\r\n        Validating spotsposted(messageid)\r\n        Validating spotsposted(ouruserid)\r\n        Validating spotsposted(stamp)\r\n        Validating spotsposted(title)\r\n        Validating spotsposted(tag)\r\n        Validating spotsposted(category)\r\n        Validating spotsposted(subcats)\r\n        Validating spotsposted(filesize)\r\n        Validating spotsposted(fullxml)\r\n        Validating reportsposted(ouruserid)\r\n        Validating reportsposted(messageid)\r\n        Validating reportsposted(inreplyto)\r\n        Validating reportsposted(randompart)\r\n        Validating reportsposted(body)\r\n        Validating reportsposted(stamp)\r\n        Validating usersettings(userid)\r\n        Validating usersettings(privatekey)\r\n        Validating usersettings(publickey)\r\n        Validating usersettings(otherprefs)\r\n        Validating users(username)\r\n        Validating users(firstname)\r\n        Validating users(passhash)\r\n        Validating users(lastname)\r\n        Validating users(mail)\r\n        Validating users(apikey)\r\n        Validating users(lastlogin)\r\n        Validating users(lastvisit)\r\n        Validating users(lastread)\r\n        Validating users(lastapiusage)\r\n        Validating users(deleted)\r\n        Validating sessions(sessionid)\r\n        Validating sessions(userid)\r\n        Validating sessions(hitcount)\r\n        Validating sessions(lasthit)\r\n        Validating securitygroups(name)\r\n        Validating grouppermissions(groupid)\r\n        Validating grouppermissions(permissionid)\r\n        Validating grouppermissions(objectid)\r\n        Validating grouppermissions(deny)\r\n        Validating usergroups(userid)\r\n        Validating usergroups(groupid)\r\n        Validating usergroups(prio)\r\n        Validating notifications(userid)\r\n        Validating notifications(stamp)\r\n        Validating notifications(objectid)\r\n        Validating notifications(type)\r\n        Validating notifications(title)\r\n        Validating notifications(body)\r\n        Validating notifications(sent)\r\n        Validating filters(userid)\r\n        Validating filters(filtertype)\r\n        Validating filters(title)\r\n        Validating filters(icon)\r\n        Validating filters(torder)\r\n        Validating filters(tparent)\r\n        Validating filters(tree)\r\n        Validating filters(valuelist)\r\n        Validating filters(sorton)\r\n        Validating filters(sortorder)\r\n        Validating spotteridblacklist(spotterid)\r\n        Validating spotteridblacklist(ouruserid)\r\n        Validating spotteridblacklist(origin)\r\n        Validating cache(resourceid)\r\n                Adding column resourceid(VARCHAR(128)) to cache\r\n        Validating cache(cachetype)\r\n                Adding column cachetype(INTEGER) to cache\r\n        Validating cache(stamp)\r\n                Adding column stamp(INTEGER) to cache\r\n        Validating cache(metadata)\r\n                Adding column metadata(TEXT) to cache\r\n        Validating cache(serialized)\r\n                Adding column serialized(BOOLEAN) to cache\r\n        Validating cache(content)\r\n                Adding column content(MEDIUMBLOB) to cache\r\n        Validating permaudit(stamp)\r\n        Validating permaudit(userid)\r\n        Validating permaudit(permissionid)\r\n        Validating permaudit(objectid)\r\n        Validating permaudit(result)\r\n        Validating permaudit(ipaddr)\r\n\r\n\r\nConverting your cache data to another format\r\nPlease note - depending on the size of this cache it can take a huge amount of t\r\nime\r\n\r\n\r\nPHP Warning:  mysql_unbuffered_query(): MySQL server has gone away in E:\\SrvApps\r\n\\xampp\\htdocs\\Spotweb\\lib\\dbeng\\dbeng_mysql.php on line 100\r\n\r\nWarning: mysql_unbuffered_query(): MySQL server has gone away in E:\\SrvApps\\xamp\r\np\\htdocs\\Spotweb\\lib\\dbeng\\dbeng_mysql.php on line 100\r\nPHP Warning:  mysql_unbuffered_query(): Error reading result set's header in E:\\\r\nSrvApps\\xampp\\htdocs\\Spotweb\\lib\\dbeng\\dbeng_mysql.php on line 100\r\n\r\nWarning: mysql_unbuffered_query(): Error reading result set's header in E:\\SrvAp\r\nps\\xampp\\htdocs\\Spotweb\\lib\\dbeng\\dbeng_mysql.php on line 100\r\n\r\n\r\nSpotWeb crashed\r\n\r\nDatabase schema of settings upgrade mislukt:\r\n   Error executing query: MySQL server has gone away\r\n\r\n\r\n#0 E:\\SrvApps\\xampp\\htdocs\\Spotweb\\lib\\dbeng\\dbeng_abs.php(93): dbeng_mysql->r\r\nawExec('INSERT INTO cac...')\r\n#1 E:\\SrvApps\\xampp\\htdocs\\Spotweb\\lib\\dbeng\\dbeng_mysql.php(115): dbeng_abs->\r\nexec('INSERT INTO cac...', Array)\r\n#2 E:\\SrvApps\\xampp\\htdocs\\Spotweb\\lib\\dbstruct\\SpotStruct_abs.php(663): dbeng\r\n_mysql->modify('INSERT INTO cac...', Array)\r\n#3 E:\\SrvApps\\xampp\\htdocs\\Spotweb\\lib\\SpotUpgrader.php(53): SpotStruct_abs->u\r\npdateSchema()\r\n#4 E:\\SrvApps\\xampp\\htdocs\\Spotweb\\upgrade-db.php(22): SpotUpgrader->database(\r\n)\r\n#5 {main}\r\n\r\nHopelijk is hier een oplossing voor.","assignee":null,"id":2282576,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"number":1205,"labels":[],"title":"MySQL server has gone away","closed_at":null,"html_url":"https://github.com/spotweb/spotweb/issues/1205","milestone":null,"url":"https://api.github.com/repos/spotweb/spotweb/issues/1205"},"action":"created","comment":{"created_at":"2011-11-18T18:21:02Z","updated_at":"2011-11-18T18:21:02Z","user":{"gravatar_id":"e1366288552b5814ec9bd518535d7d4d","id":628200,"url":"https://api.github.com/users/spotweb","login":"spotweb","avatar_url":"https://secure.gravatar.com/avatar/e1366288552b5814ec9bd518535d7d4d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"Feitelijk betekent dit dat je MySQL crashde tijdens de update :( Kan je het gewoon nog eens proberen? :)","id":2792426,"url":"https://api.github.com/repos/spotweb/spotweb/issues/comments/2792426"}}