PIWIK 1.6 > 1.7 Crash um Mitternacht


(cray) #1

Das Update ging problemlos, aber um Mitternacht kam es zum Crash. Hier die Fehlermeldung. Any ideas?

SQLSTATE[HY000]: General error: 144 Table ‘./dbxxx/pwk01_archive_blob_2012_02’ is marked as crashed and last (automatic?) repair failed

#0 /[…]/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /[…]/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /[…]/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT IGNORE??..’, Array)
#3 /[…]/core/Db/Adapter/Pdo/Mysql.php(211): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT IGNORE??..’, Array)
#4 /[…]/core/PluginsFunctions/Sql.php(45): Piwik_Db_Adapter_Pdo_Mysql->query(‘INSERT IGNORE??..’, Array)
#5 /[…]/core/PluginsFunctions/Sql.php(90): Piwik_Sql::query(‘INSERT IGNORE??..’, Array)
#6 /[…]/core/Piwik.php(2429): Piwik_Query()
#7 /[…]/core/Piwik.php(2405): Piwik::tableInsertBatchIterate(‘INSERT IGNORE??..’, Array)
#8 /[…]/core/ArchiveProcessing.php(776): Piwik::tableInsertBatch(‘pwk01_archive_b…’, Array, Array)
#9 /[…]/core/ArchiveProcessing.php(722): Piwik_ArchiveProcessing->insertBulkRecords(‘pwk01_archive_b…’, Array, Array)
#10 /[…]/plugins/Actions/Actions.php(585): Piwik_ArchiveProcessing->insertBlobRecord(Array)
#11 /[…]/plugins/Actions/Actions.php(550): Piwik_Actions->archiveDayRecordInDatabase(‘Actions_actions…’, Array)
#12 /[…]/libs/Event/Dispatcher.php(284): Piwik_Actions->archiveDay(Object(Piwik_ArchiveProcessing_Day))
#13 /[…]/core/PluginsManager.php(609): Event_Dispatcher->postNotification(Object(Piwik_Event_Notification))
#14 /[…]/core/ArchiveProcessing/Day.php(42): Piwik_PostEvent()
#15 /[…]/core/ArchiveProcessing.php(467): Piwik_ArchiveProcessing_Day->compute(Array, Array)
#16 /[…]/core/Archive/Single.php(224): Piwik_ArchiveProcessing->launchArchiving(Object(Piwik_Event_Notification), false, false)
#17 /[…]/core/Archive/Array/IndexedBySite.php(167): Piwik_Archive_Single->prepareArchive(‘ArchiveProcessi…’, Object(Piwik_ArchiveProcessing_Day))
#18 /[…]/core/Archive/Array/IndexedBySite.php(112): Piwik_Archive_Array_IndexedBySite->getArchiveIdsAfterLaunching()
#19 /[…]/core/Archive/Array/IndexedBySite.php(93): Piwik_Archive_Array_IndexedBySite->loadValuesFromDB()
#20 /[…]/core/Archive/Array/IndexedBySite.php(64): Piwik_Archive_Array_IndexedBySite->getValues()
#21 /[…]/plugins/MultiSites/API.php(113): Piwik_Archive_Array_IndexedBySite->getDataTableFromNumeric(Array)
#22 /[…]/plugins/MultiSites/Controller.php(58): Piwik_MultiSites_API->getAll(Array)
#23 /[…]/plugins/MultiSites/Controller.php(36): Piwik_MultiSites_Controller->getSitesInfo(Array)
#24 /[…]/core/FrontController.php(138): Piwik_MultiSites_Controller->index(Array)
#25 /[…]/index.php(53): Piwik_FrontController->dispatch(‘day’, ‘2012-02-17’, false)
#26 {main}


#2

Ich würde einfach nochmal eine Reparatur für die betroffende Tabelle anstoßen.


(Peterbo) #3

Das ist nicht direkt ein Piwik Problem. So etwas kann in stark arbeitenden Tabellen schon einmal passieren. Einfach reparieren und weitermachen. Falls das öfter vorkommt, sollte evtl. mal der MySQL-Server upgedatet werden.


(cray) #4

Es kam mir verdächtig vor, dass das ausgerechnet nach einem Piwik Update passiert. Aber- thanx - die Tabellen-Reparatur hat anscheinend geklappt.