spotweb/spotweb — Issue #1205: MySQL server has gone away
Author: Starcreature
Created: 2011-11-18 17:40:44+00:00
State: open

Nu de laatste update uitgevoerd. En krijg de foutmelding: MySQL server has gone away. zover ik kan zien gaat MySQL niet uit.
De site draait op een VM met Windows 2003, 4 cores, 2 GB geheugen.
xamp 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:

my.ini

innodb_lock_wait_timeout = 600
max_allowed_packet = 64M

php.ini

max_execution_time = 10800

ownsettings.php

set_time_limit(10800);

Wat ik te zien krijg als ik upgrade-db.php uitvoer:

Updating schema..(mysql)
Validating spots(messageid)
Validating spots(poster)
Validating spots(title)
Validating spots(tag)
Validating spots(category)
Validating spots(subcata)
Validating spots(subcatb)
Validating spots(subcatc)
Validating spots(subcatd)
Validating spots(subcatz)
Validating spots(stamp)
Validating spots(reversestamp)
Validating spots(filesize)
Validating spots(moderated)
Validating spots(commentcount)
Validating spots(spotrating)
Validating spots(reportcount)
Validating spots(spotterid)
Validating spotsfull(messageid)
Validating spotsfull(verified)
Validating spotsfull(usersignature)
Validating spotsfull(userkey)
Validating spotsfull(xmlsignature)
Validating spotsfull(fullxml)
Validating nntp(server)
Validating nntp(maxarticleid)
Validating nntp(nowrunning)
Validating nntp(lastrun)
Validating nntp(serverdatelastrun)
Validating commentsxover(messageid)
Validating commentsxover(nntpref)
Validating commentsxover(spotrating)
Validating reportsxover(messageid)
Validating reportsxover(fromhdr)
Validating reportsxover(keyword)
Validating reportsxover(nntpref)
Validating spotstatelist(messageid)
Validating spotstatelist(ouruserid)
Validating spotstatelist(download)
Validating spotstatelist(watch)
Validating spotstatelist(seen)
Validating commentsfull(messageid)
Validating commentsfull(fromhdr)
Validating commentsfull(stamp)
Validating commentsfull(usersignature)
Validating commentsfull(userkey)
Validating commentsfull(spotterid)
Validating commentsfull(hashcash)
Validating commentsfull(body)
Validating commentsfull(verified)
Validating commentsfull(avatar)
Modifying column avatar (type) on commentsfull
Validating settings(name)
Validating settings(value)
Validating settings(serialized)
Validating commentsposted(ouruserid)
Validating commentsposted(messageid)
Validating commentsposted(inreplyto)
Validating commentsposted(randompart)
Validating commentsposted(rating)
Validating commentsposted(body)
Validating commentsposted(stamp)
Validating spotsposted(messageid)
Validating spotsposted(ouruserid)
Validating spotsposted(stamp)
Validating spotsposted(title)
Validating spotsposted(tag)
Validating spotsposted(category)
Validating spotsposted(subcats)
Validating spotsposted(filesize)
Validating spotsposted(fullxml)
Validating reportsposted(ouruserid)
Validating reportsposted(messageid)
Validating reportsposted(inreplyto)
Validating reportsposted(randompart)
Validating reportsposted(body)
Validating reportsposted(stamp)
Validating usersettings(userid)
Validating usersettings(privatekey)
Validating usersettings(publickey)
Validating usersettings(otherprefs)
Validating users(username)
Validating users(firstname)
Validating users(passhash)
Validating users(lastname)
Validating users(mail)
Validating users(apikey)
Validating users(lastlogin)
Validating users(lastvisit)
Validating users(lastread)
Validating users(lastapiusage)
Validating users(deleted)
Validating sessions(sessionid)
Validating sessions(userid)
Validating sessions(hitcount)
Validating sessions(lasthit)
Validating securitygroups(name)
Validating grouppermissions(groupid)
Validating grouppermissions(permissionid)
Validating grouppermissions(objectid)
Validating grouppermissions(deny)
Validating usergroups(userid)
Validating usergroups(groupid)
Validating usergroups(prio)
Validating notifications(userid)
Validating notifications(stamp)
Validating notifications(objectid)
Validating notifications(type)
Validating notifications(title)
Validating notifications(body)
Validating notifications(sent)
Validating filters(userid)
Validating filters(filtertype)
Validating filters(title)
Validating filters(icon)
Validating filters(torder)
Validating filters(tparent)
Validating filters(tree)
Validating filters(valuelist)
Validating filters(sorton)
Validating filters(sortorder)
Validating spotteridblacklist(spotterid)
Validating spotteridblacklist(ouruserid)
Validating spotteridblacklist(origin)
Validating cache(resourceid)
Adding column resourceid(VARCHAR(128)) to cache
Validating cache(cachetype)
Adding column cachetype(INTEGER) to cache
Validating cache(stamp)
Adding column stamp(INTEGER) to cache
Validating cache(metadata)
Adding column metadata(TEXT) to cache
Validating cache(serialized)
Adding column serialized(BOOLEAN) to cache
Validating cache(content)
Adding column content(MEDIUMBLOB) to cache
Validating permaudit(stamp)
Validating permaudit(userid)
Validating permaudit(permissionid)
Validating permaudit(objectid)
Validating permaudit(result)
Validating permaudit(ipaddr)

Converting your cache data to another format
Please note - depending on the size of this cache it can take a huge amount of t
ime

PHP Warning: mysql_unbuffered_query(): MySQL server has gone away in E:\SrvApps
\xampp\htdocs\Spotweb\lib\dbeng\dbeng_mysql.php on line 100

Warning: mysql_unbuffered_query(): MySQL server has gone away in E:\SrvApps\xamp
p\htdocs\Spotweb\lib\dbeng\dbeng_mysql.php on line 100
PHP Warning: mysql_unbuffered_query(): Error reading result set's header in E:\
SrvApps\xampp\htdocs\Spotweb\lib\dbeng\dbeng_mysql.php on line 100

Warning: mysql_unbuffered_query(): Error reading result set's header in E:\SrvAp
ps\xampp\htdocs\Spotweb\lib\dbeng\dbeng_mysql.php on line 100

SpotWeb crashed

Database schema of settings upgrade mislukt:
Error executing query: MySQL server has gone away

#0 E:\SrvApps\xampp\htdocs\Spotweb\lib\dbeng\dbeng_abs.php(93): dbeng_mysql->r
awExec('INSERT INTO cac...')
#1 E:\SrvApps\xampp\htdocs\Spotweb\lib\dbeng\dbeng_mysql.php(115): dbeng_abs->
exec('INSERT INTO cac...', Array)
#2 E:\SrvApps\xampp\htdocs\Spotweb\lib\dbstruct\SpotStruct_abs.php(663): dbeng
_mysql->modify('INSERT INTO cac...', Array)
#3 E:\SrvApps\xampp\htdocs\Spotweb\lib\SpotUpgrader.php(53): SpotStruct_abs->u
pdateSchema()
#4 E:\SrvApps\xampp\htdocs\Spotweb\upgrade-db.php(22): SpotUpgrader->database(
)
#5 {main}

Hopelijk is hier een oplossing voor.