XF 2.1 Have error when cleanUpDaily

[John rus]

How fix error when clean Up Daily from ACP ?

• XF\Db\Exception: MySQL query error [1615]: Prepared statement needs to be re-prepared
• src/XF/Db/AbstractStatement.php:228
• Сгенерировано пользователем: Неизвестная учетная запись
• 11 Янв 2020 в 13:20

Трассировка стека
SELECT xf_thread., xf_user_User_1., xf_forum_Forum_2., xf_node_Node_3., xf_permission_cache_content_Permissions_4.*
FROM xf_thread
LEFT JOIN xf_user AS xf_user_User_1 ON (xf_user_User_1.user_id = xf_thread.user_id)
LEFT JOIN xf_forum AS xf_forum_Forum_2 ON (xf_forum_Forum_2.node_id = xf_thread.node_id)
LEFT JOIN xf_node AS xf_node_Node_3 ON (xf_node_Node_3.node_id = xf_forum_Forum_2.node_id)
LEFT JOIN xf_permission_cache_content AS xf_permission_cache_content_Permissions_4 ON (xf_permission_cache_content_Permissions_4.content_type = 'node' AND xf_permission_cache_content_Permissions_4.content_id = xf_node_Node_3.node_id AND xf_permission_cache_content_Permissions_4.permission_combination_id = '1')
WHERE (xf_thread.thread_id = '125861')


LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1615, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1615, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Mvc/Entity/Finder.php(1261): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#4 src/XF/Mvc/Entity/Manager.php(149): XF\Mvc\Entity\Finder->fetchOne()
#5 src/XF/Pub/Controller/Thread.php(1372): XF\Mvc\Entity\Manager->find('XF:Thread', '125861', Array)
#6 src/XF/Pub/Controller/Thread.php(12): XF\Pub\Controller\Thread->assertViewableThread('125861', Array)
#7 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(261): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(KL\AutoMergeDoublePost\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(KL\AutoMergeDoublePost\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#12 src/XF.php(391): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}
Содержимое запроса
array(4) {
["url"] => string(22) "/forum/threads/125861/"
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[John rus]

and often error in forum

An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in src/XF/Db/AbstractStatement.php on line 228

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
XF\Db\AbstractAdapter->fetchOne() in src/XF/Job/Manager.php at line 396
XF\Job\Manager->getFirstAutomaticTime() in src/XF/Job/Manager.php at line 405
XF\Job\Manager->updateNextRunTime() in src/XF/App.php at line 1399
XF\App->XF\{closure}() in src/XF/App.php at line 1654
XF\App->XF\{closure}() in src/XF/Container.php at line 28
XF\Container->offsetGet() in src/XF/App.php at line 2220
XF\App->offsetGet() in src/XF/App.php at line 1849
XF\App->getGlobalTemplateData() in src/XF/App.php at line 1800
XF\App->preRender() in src/XF/Admin/App.php at line 98
XF\Admin\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
XF\App->run() in src/XF.php at line 391
XF::runApp() in admin.php at line 13

 

[John rus]

i solved the problem myself

 

[teletubbi]

Might be a good idea to write down how you solve it.
Maybe someone else with the same problem can use your solution.

 

[John rus]

Empty table xf_image_proxy and delete all files from directory image_cache
Cleaning these cache images files from remote storage caused heavy load server and have errors 504 Gateway Time-out and other errors - https://xenforo.com/community/threads/error-cron-cleanuphourly.174826/

Sorry for my bad English