Spotweb Crashed steeds

[RobbieT]

Sinds kort heb ik een DS211+. Hier wil ik graag spotweb opdraaien in combinatie met NZBGet.
Ik krijg alles wel draaiend, maar spotweb lijkt steeds te crashen.

Als ik spotweb wil openen dan duurt het even en dan krijg ik een grote lap tekst in beeld met iets in de trant van spotweb crashed, try to repair it. (Lijkt iets van een MySql probleem).

Hetgeen wat dan helpt is in phpadmin bij de spotweb database mijn gebruikersnaam te verwijderen en vervolgens de spotweb install opnieuw te doorlopen.

Kan iemand mij vertellen hoe dit komt en hoe ik het kan oplossen?

[RobbieT]

Dit is een deel van de code die in beeld komt als spotweb is gecrashed.

Code: [Selecteer]

SpotWeb v0.58.25.29 on PHP v5.3.21 crashed object(SqlErrorException)#31 (8) { ["message":protected]=> string(69) "Incorrect key file for table '/tmp/#sql_1526_0.MYI'; try to repair it" ["string":"CustomException":private]=> NULL ["code":protected]=> int(126) ["file":protected]=> string(46) "/volume1/web/spotweb/lib/dbeng/dbeng_mysql.php" ["line":protected]=> int(50) ["string":"Exception":private]=> string(0) "" ["trace":"Exception":private]=> array(7) { [0]=> array(6) { ["file"]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_abs.php" ["line"]=> int(93) ["function"]=> string(7) "rawExec" ["class"]=> string(11) "dbeng_mysql" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1507) "SELECT s.id AS id, s.messageid AS messageid, s.category AS category, s.poster AS poster, l.download as downloadstamp, l.watch as watchstamp, l.seen AS seenstamp, s.subcata AS subcata, s.subcatb AS subcatb, s.subcatc AS subcatc, s.subcatd AS subcatd, s.subcatz AS subcatz, s.title AS title, s.tag AS tag, s.stamp AS stamp, s.moderated AS moderated, s.filesize AS filesize, s.spotrating AS rating, s.commentcount AS commentcount, s.reportcount AS reportcount, s.spotterid AS spotterid, f.verified AS verified, COALESCE(bl.idtype, wl.idtype, gwl.idtype) AS idtype FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 6)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 6) OR (bl.ouruserid = -1)) AND (bl.idtype = 1)) LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 6)) AND (wl.idtype = 2)) LEFT JOIN spotteridblacklist as gwl on ((gwl.spotterid = s.spotterid) AND ((gwl.ouruserid = -1)) AND (gwl.idtype = 2)) WHERE (bl.spotterid IS NULL) ORDER BY s.reversestamp ASC LIMIT 101 OFFSET 0" } } [1]=> array(6) { ["file"]=> string(46) "/volume1/web/spotweb/lib/dbeng/dbeng_mysql.php" ["line"]=> int(88) ["function"]=> string(4) "exec" ["class"]=> string(9) "dbeng_abs" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(1507) "SELECT s.id AS id, s.messageid AS messageid, s.category AS category, s.poster AS poster, l.download as downloadstamp, l.watch as watchstamp, l.seen AS seenstamp, s.subcata AS subcata, s.subcatb AS subcatb, s.subcatc AS subcatc, s.subcatd AS subcatd, s.subcatz AS subcatz, s.title AS title, s.tag AS tag, s.stamp AS stamp, s.moderated AS moderated, s.filesize AS filesize, s.spotrating AS rating, s.commentcount AS commentcount, s.reportcount AS reportcount, s.spotterid AS spotterid, f.verified AS verified, COALESCE(bl.idtype, wl.idtype, gwl.idtype) AS idtype FROM spots AS s LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 6)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 6) OR (bl.ouruserid = -1)) AND (bl.idtype = 1)) LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 6)) AND (wl.idtype = 2)) LEFT JOIN spotteridblacklist as gwl on ((gwl.spotterid = s.spotterid) AND ((gwl.ouruserid = -1)) AND (gwl.idtype = 2)) WHERE (bl.spotterid IS NULL) ORDER BY s.reversestamp ASC LIMIT 101 OFFSET 0" [1]=> array(0) { } } } [2]=> array(6) { ["file"]=> string(51) "/volume1/web/spotweb/lib/dao/Base/Dao_Base_Spot.php" ["line"]=> int(122) ["function"]=> string(10) "arrayQuery" ["class"]=> string(11) "dbeng_mysql" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1507) "SELECT s.id AS id, s.messageid AS messageid, s.category AS category, s.poster AS poster, l.download as downloadstamp, l.watch as watchstamp, l.seen AS seenstamp, s.subcata AS subcata, s.subcatb AS subcatb, s.subcatc AS subcatc, s.subcatd AS subcatd, s.subcatz AS subcatz, s.title AS title, s.tag AS tag, s.stamp AS stamp, s.moderated AS moderated, s.filesize AS filesize, s.spotrating AS rating, s.commentcount

[SynoBart]

Hoi!

Ik heb hetzelfde probleem, heb je het opgelost gekregen?

Ik heb dit al geprobeerd via SSH:
/usr/syno/mysql/bin/mysqlcheck -u root -p --auto-repair --check --optimize spotweb

Resultaat:
spotweb.cache
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK
spotweb.commentsfull
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK
spotweb.commentsposted
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK

(maar de andere tabellen doet hij blijkbaar niet?)
Vlak na het commando was het probleem nog steeds hetzelfde 

Heb je tips?

bedankt hé,
Bart

[Birdy]

Kijk ff hier

https://github.com/spotweb/spotweb/issues/1710

Het lijkt erop dus, misschien helpt die fix ook wel bij jou.

[SynoBart]

Update:
Na wat langer wachten is het commando vermoedelijk toch volledig gelukt op alle tabellen.
Ik had de SSH sessie al gesloten, maar dit loopt verder op de achtergrond.

Alles terug OK nu.
Het commando van hierboven werkt dus wel, maar het duurt even.

Toch bedankt voor detip hoor :-)