Fout melding Spotweb

[pat30724]

Hallo,

Ik heb gister avond spotweb geinstalleerd op mijn DS214SE. Werkt aan het begin prima. Echter na het ophalen van de spots krijg ik bij het openen van spotweb de volgende foutmelding:

SpotWeb v0.67.28.31 on PHP v5.5.7 crashed object(SqlErrorException)#26 ( { ["message":protected]=> string(84) "HY000: 1021: Disk full (/tmp/#sql_25b4_1); waiting for someone to free some space..." ["string":"CustomException":private]=> NULL ["code":protected]=> int(-1) ["file":protected]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_pdo.php" ["line":protected]=> int(59) ["trace":"Exception":private]=> array(5) {

• => array(6) { ["file"]=> string(44) "/volume1/web/spotweb/lib/dbeng/dbeng_pdo.php" ["line"]=> int(146) ["function"]=> string(4) "exec" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(2) {
• => string(1576) "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, s.editstamp AS editstamp, s.editor AS editor, 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 = 3)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 3) OR (bl.ouruserid = -1)) AND (bl.idtype = 1)) LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 3) 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 26 OFFSET 0" [1]=> array(0) { } } } [1]=> array(6) { ["file"]=> string(51) "/volume1/web/spotweb/lib/dao/Base/Dao_Base_Spot.php" ["line"]=> int(123) ["function"]=> string(10) "arrayQuery" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(1) {
• => string(1576) "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, s.editstamp AS editstamp, s.editor AS editor, 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 = 3)) LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 3) OR (bl.ouruserid = -1)) AND (bl.idtype = 1)) LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 3) 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 26 OFFSET 0" } } [2]=> array(6) { ["file"]=> string(75) "/volume1/web/spotweb/lib/services/Providers/Services_Providers_SpotList.php" ["line"]=> int(23) ["function"]=> string( "getSpots" ["class"]=> string(13) "Dao_Base_Spot" ["type"]=> string(2) "->" ["args"]=> array(4) {
• => string(1) "3" [1]=> int(0) [2]=> int(25) [3]=> array(9) { ["filter"]=> string(0) "" ["categoryList"]=> array(0) { } ["unfiltered"]=> bool(false) ["strongNotList"]=> array(0) { } ["filterValueList"]=> array(0) { } ["additionalFields"]=> array(0) { } ["additionalTables"]=> array(0) { } ["additionalJoins"]=> array(0) { } ["sortFields"]=> array(1) {
• => array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } } } [3]=> array(6) { ["file"]=> string(48) "/volume1/web/spotweb/lib/page/SpotPage_index.php" ["line"]=> int(101) ["function"]=> string(13) "fetchSpotList" ["class"]=> string(27) "Services_Providers_SpotList" ["type"]=> string(2) "->" ["args"]=> array(4) {
• => string(1) "3" [1]=> int(0) [2]=> int(25) [3]=> array(9) { ["filter"]=> string(0) "" ["categoryList"]=> array(0) { } ["unfiltered"]=> bool(false) ["strongNotList"]=> array(0) { } ["filterValueList"]=> array(0) { } ["additionalFields"]=> array(0) { } ["additionalTables"]=> array(0) { } ["additionalJoins"]=> array(0) { } ["sortFields"]=> array(1) {
• => array(4) { ["field"]=> string(7) "s.stamp" ["direction"]=> string(4) "DESC" ["autoadded"]=> bool(true) ["friendlyname"]=> NULL } } } } } [4]=> array(6) { ["file"]=> string(30) "/volume1/web/spotweb/index.php" ["line"]=> int(381) ["function"]=> string(6) "render" ["class"]=> string(14) "SpotPage_index" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL ["string":"Exception":private]=> string(0) "" } HY000: 1021: Disk full (/tmp/#sql_25b4_1); waiting for someone to free some space...

En dit terwijl er nog 912GB ruimte vrij is op de hardeschijf waar Mysql op draait.

Ik maak gebruik van DSM5.0-4418 update 1

[RobertAthome]

Zelfde probleem hier. De tmp welke wordt gebruikt lijkt vol te zijn. Tmp op ds411j is maar 60 mb. Spotweb is nu down ook bij mij. Hopelijk heeft iemand een oplossing.

Sent from my Nokia Lumia using Tapatalk

[pat30724]

Heel raar is dit. Er zit op het moment iets van 700MB aan data in de database.

[basado]

Hetzelfde probleem hier! Het doet zich zowel voor zodra ik Spotweb handmatig of via een SPK installeer. Het probleem heb ik sinds DSM 5.0 waarbij MySql is veranderd naar MariDB. Heeft iemand inmiddels al een oplossing gevonden?