Теперь уже уперлись в лимиты MySQL
Смотреть надо wait_timeout и max_allowed_packet
Пишите провайдеру либо же посредством панели если конфиг MySQL доступен увеличивать лимиты
И после правок делать рестарт службы
Увеличил max_allowed_packet до 128Mб
теперь такая ошибка:
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:228
трассировка стека
DELETE FROM `xf_user_alert` WHERE alert_id IN
862415, 862423, 862425, 862434, 862435, 862445, 862448, 862450, 862452, 862454, 862457, 862458, 862459, 862460, 862461, 862463, 862464, 862465, 862466, 862467, 862468, 862469, 862471, 862472, 862473, 862474, 862475, 862476, 862477)
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(289): XF\Db\AbstractAdapter->query('DELETE FROM `x...', Array)
#4 src/XF/Repository/UserAlert.php(252): XF\Db\AbstractAdapter->delete('xf_user_alert', 'alert_id IN (14...')
#5 src/XF/Repository/UserAlert.php(628): XF\Repository\UserAlert->deleteAlertsInternal(Object(XF\Mvc\Entity\Finder))
#6 src/XF/Cron/CleanUp.php(134): XF\Repository\UserAlert->pruneUnviewedAlerts()
#7 [internal function]: XF\Cron\CleanUp::runHourlyCleanUp(Array)
#8 src/XF/Admin/Controller/CronEntry.php(112): call_user_func(Array, Array)
#9 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\CronEntry->actionRun(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:CronEntry', 'Run', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\CronEntry), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\CronEntry), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2326): XF\Mvc\Dispatcher->run()
#14 src/XF.php(488): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}
Содержимое запроса
array(4) {
["url"] => string(33) "/admin.php?cron/cleanUpHourly/run"
["referrer"] => string(37) "https://#####/admin.php?cron/"
["_GET"] => array(1) {
["cron/cleanUpHourly/run"] => string(0) ""
}
["_POST"] => array(1) {
["_xfToken"] => string(8) "********"
}
}
