1С (CommerceML) ошибки логирования. Есть решение
Сервер забивается логами на ГБ свободного места, затем вход в админку невозможен, если значение перевалит 8 ГБ логов.
В чем проблема с плагином и как поправить?
wa-log/shop/plugins/cml1c/error.log
2019-04-29 17:31:27 23.105.233.236 Error during import product with Ид 4627076043753:Database error. See log for details. 2019-04-29 17:31:27 23.105.233.236 Error during import offer process: Database error. See log for details. TRACE: #0 /wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 /wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 /wa-system/database/waModel.class.php(141): waModel->describe() #3 /wa-system/database/waModel.class.php(97): waModel->getFields() #4 /wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('28234') #8 /wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('28234') #9 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 /wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 /wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 /wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 /wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 /wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 /wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 /wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 /wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 /wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 /wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 /index.php(7): waSystem->dispatch() #24 {main} 2019-04-29 17:31:27 23.105.233.236 Error during import product with Ид JCNP-002:Database error. See log for details. 2019-04-29 17:31:27 23.105.233.236 Error during import offer process: Database error. See log for details. TRACE: #0 /wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 /wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 /wa-system/database/waModel.class.php(141): waModel->describe() #3 /wa-system/database/waModel.class.php(97): waModel->getFields() #4 /wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('42286') #8 /wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('42286') #9 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 /wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 /wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 /wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 /wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 /wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 /wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 /wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 /wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 /wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 /wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 /index.php(7): waSystem->dispatch() #24 {main} 2019-04-29 17:31:27 23.105.233.236 Error during import product with Ид SDS-DUNI-001:Database error. See log for details. 2019-04-29 17:31:27 23.105.233.236 Error during import offer process: Database error. See log for details. TRACE: #0 /wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 /wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 /wa-system/database/waModel.class.php(141): waModel->describe() #3 /wa-system/database/waModel.class.php(97): waModel->getFields() #4 /wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 /wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('42893') #8 /wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('42893') #9 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 /wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 /wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 /wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 /wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 /wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 /wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 /wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 /wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 /wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 /wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 /wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 /index.php(7): waSystem->dispatch()
wa-log/db.log
2019-04-29 17:31:27 23.105.233.236 Table './webdev/shop_search_index' is marked as crashed and last (automatic?) repair failed ## wa-system/database/waDbMysqliAdapter.class.php(345) #0 wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 wa-system/database/waModel.class.php(141): waModel->describe() #3 wa-system/database/waModel.class.php(97): waModel->getFields() #4 wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('28234') #8 wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('28234') #9 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 index.php(7): waSystem->dispatch() #24 {main} 2019-04-29 17:31:27 23.105.233.236 Table './webdev/shop_search_index' is marked as crashed and last (automatic?) repair failed ## wa-system/database/waDbMysqliAdapter.class.php(345) #0 wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 wa-system/database/waModel.class.php(141): waModel->describe() #3 wa-system/database/waModel.class.php(97): waModel->getFields() #4 wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('42286') #8 wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('42286') #9 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 index.php(7): waSystem->dispatch() #24 {main} 2019-04-29 17:31:27 23.105.233.236 Table './webdev/shop_search_index' is marked as crashed and last (automatic?) repair failed ## wa-system/database/waDbMysqliAdapter.class.php(345) #0 wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 wa-system/database/waModel.class.php(141): waModel->describe() #3 wa-system/database/waModel.class.php(97): waModel->getFields() #4 wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('42893') #8 wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('42893') #9 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 index.php(7): waSystem->dispatch() #24 {main} 2019-04-29 17:31:27 23.105.233.236 Table './webdev/shop_search_index' is marked as crashed and last (automatic?) repair failed ## wa-system/database/waDbMysqliAdapter.class.php(345) #0 wa-system/database/waDbMysqliAdapter.class.php(168): waDbMysqliAdapter->exception() #1 wa-system/database/waModel.class.php(185): waDbMysqliAdapter->schema('shop_search_ind...', false) #2 wa-system/database/waModel.class.php(141): waModel->describe() #3 wa-system/database/waModel.class.php(97): waModel->getFields() #4 wa-system/database/waModel.class.php(77): waModel->getMetadata() #5 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(44): waModel->__construct() #6 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(62): shopIndexSearch->getIndexModel() #7 wa-apps/shop/lib/classes/search/shopIndexSearch.class.php(35): shopIndexSearch->indexProduct('41501') #8 wa-apps/shop/lib/classes/shopProduct.class.php(569): shopIndexSearch->onUpdate('41501') #9 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(5333): shopProduct->save() #10 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(4209): shopCml1cPluginBackendRunController->stepImportOffer(Array, Array, Array) #11 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(1166): shopCml1cPluginBackendRunController->stepImport(Array, Array, Array) #12 wa-system/controller/waLongActionController.class.php(318): shopCml1cPluginBackendRunController->step() #13 wa-apps/shop/plugins/cml1c/lib/actions/backend/shopCml1cPluginBackendRun.controller.php(129): waLongActionController->execute() #14 wa-system/controller/waController.class.php(21): shopCml1cPluginBackendRunController->execute() #15 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(315): waController->run() #16 wa-apps/shop/plugins/cml1c/lib/actions/frontend/shopCml1cPluginFrontend.controller.php(90): shopCml1cPluginFrontendController->importCatalog('offers.xml') #17 wa-system/controller/waController.class.php(21): shopCml1cPluginFrontendController->execute() #18 wa-system/controller/waFrontController.class.php(254): waController->run(NULL) #19 wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(shopCml1cPluginFrontendController), NULL) #20 wa-system/controller/waFrontController.class.php(83): waFrontController->execute('cml1c', 'frontend', NULL) #21 wa-system/waSystem.class.php(761): waFrontController->dispatch() #22 wa-system/waSystem.class.php(503): waSystem->dispatchFrontend('cml1c/7f3c931f-...') #23 index.php(7): waSystem->dispatch() #24 {main}
2 комментария
Следует починить таблицу, которая сломалась и автоматически не смогла починиться:
Table './webdev/shop_search_index' is marked as crashed and last (automatic?) repair failed
mysqlrepair --auto-repair --all-databases --user=root --password
зашел с этой командой и пока логи не копятся, как раньше