Truncated exception message impossible to determine cause

Pydio 8
, ,
1

Pydio core 8.2.5, Ubuntu 20.04

Logs filled with :slight_smile:

#0 /var/www/pydio-core-8.0.1/core/src/lib/dibi/libs/DibiConnection.php(324): DibiMySqliDriver->query(‘INSERT INTO aj...') #1 /var/www/pydio-core-8.0.1/core/src/lib/dibi/libs/DibiConnection.php(246): DibiConnection->nativeQuery('INSERT INTO aj…’) #2 /var/www/pydio-core-8.0.1/core/src/lib/dibi/libs/Dibi.php(183): DibiConnection->query(Array) #3 /var/www/pydio-core-8.0.1/plugins/meta.syncable/ChangesTracker.php(573): dibi::query(Array, Array) #4 /var/www/pydio-core-8.0.1/plugins/meta.syncable/ChangesTracker.php(681): Pydio\Access\Meta\Sync\ChangesTracker->updateNodesIndex(NULL, Object(Pydio\Access\Core\Model\AJXP_Node), false) #5 [internal function]: Pydio\Access\Meta\Sync\ChangesTracker->indexNode(Object(Pydio\Access\Core\Model\AJXP_Node)) #6 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(363): call_user_func_array(Array, Array) #7 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(468): Pydio\Core\Controller\Controller::applyCallback(Object(Pydio\Core\Model\Context), Array, Array, false) #8 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(182): Pydio\Core\Controller\Controller::applyHook(‘node.index’, Array) #9 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(178): Pydio\Access\Indexer\Core\CoreIndexer->recursiveIndexation(Object(Pydio\Core\Model\Context), Object(Pydio\Access\Core\Model\AJXP_Node), 5) #10 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(178): Pydio\Access\Indexer\Core\CoreIndexer->recursiveIndexation(Object(Pydio\Core\Model\Context), Object(Pydio\Access\Core\Model\AJXP_Node), 4) #11 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(178): Pydio\Access\Indexer\Core\CoreIndexer->recursiveIndexation(Object(Pydio\Core\Model\Context), Object(Pydio\Access\Core\Model\AJXP_Node), 3) #12 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(178): Pydio\Access\Indexer\Core\CoreIndexer->recursiveIndexation(Object(Pydio\Core\Model\Context), Object(Pydio\Access\Core\Model\AJXP_Node), 2) #13 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(178): Pydio\Access\Indexer\Core\CoreIndexer->recursiveIndexation(Object(Pydio\Core\Model\Context), Object(Pydio\Access\Core\Model\AJXP_Node), 1) #14 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(115): Pydio\Access\Indexer\Core\CoreIndexer->recursiveIndexation(Object(Pydio\Core\Model\Context), Object(Pydio\Access\Core\Model\AJXP_Node)) #15 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(392): Pydio\Access\Indexer\Core\CoreIndexer->applyAction(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #16 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(259): Pydio\Core\Controller\Controller::handleRequest(Object(DOMElement), Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #17 /var/www/pydio-core-8.0.1/plugins/core.tasks/src/TaskService.php(113): Pydio\Core\Controller\Controller::run(Object(Zend\Diactoros\ServerRequest)) #18 /var/www/pydio-core-8.0.1/plugins/core.index/CoreIndexer.php(92): Pydio\Tasks\TaskService->enqueueTask(Object(Pydio\Tasks\Task), Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #19 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(392): Pydio\Access\Indexer\Core\CoreIndexer->applyAction(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #20 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(259): Pydio\Core\Controller\Controller::handleRequest(Object(DOMElement), Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #21 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Controller/Controller.php(141): Pydio\Core\Controller\Controller::run(Object(Zend\Diactoros\ServerRequest), Object(DOMElement)) #22 [internal function]: Pydio\Core\Controller\Controller::registryActionMiddleware(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #23 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #24 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(145): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #25 [internal function]: Pydio\Core\Http\Server->Pydio\Core\Http{closure}(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #26 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(162): call_user_func_array(Object(Closure), Array) #27 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Middleware/SessionRepositoryMiddleware.php(114): Pydio\Core\Http\Server::callNextMiddleWare(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #28 [internal function]: Pydio\Core\Http\Middleware\SessionRepositoryMiddleware::handleRequest(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #29 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #30 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(145): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #31 [internal function]: Pydio\Core\Http\Server->Pydio\Core\Http{closure}(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #32 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(162): call_user_func_array(Object(Closure), Array) #33 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Middleware/WorkspaceAuthMiddleware.php(107): Pydio\Core\Http\Server::callNextMiddleWare(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #34 [internal function]: Pydio\Core\Http\Middleware\WorkspaceAuthMiddleware::handleRequest(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #35 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #36 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(145): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #37 [internal function]: Pydio\Core\Http\Server->Pydio\Core\Http{closure}(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #38 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(162): call_user_func_array(Object(Closure), Array) #39 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Middleware/AuthMiddleware.php(96): Pydio\Core\Http\Server::callNextMiddleWare(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #40 [internal function]: Pydio\Core\Http\Middleware\AuthMiddleware::handleRequest(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #41 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #42 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(145): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #43 [internal function]: Pydio\Core\Http\Server->Pydio\Core\Http{closure}(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #44 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(162): call_user_func_array(Object(Closure), Array) #45 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Middleware/SecureTokenMiddleware.php(73): Pydio\Core\Http\Server::callNextMiddleWare(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #46 [internal function]: Pydio\Core\Http\Middleware\SecureTokenMiddleware::handleRequest(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #47 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #48 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(145): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #49 [internal function]: Pydio\Core\Http\Server->Pydio\Core\Http{closure}(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #50 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(162): call_user_func_array(Object(Closure), Array) #51 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Middleware/SessionMiddleware.php(86): Pydio\Core\Http\Server::callNextMiddleWare(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #52 [internal function]: Pydio\Core\Http\Middleware\SessionMiddleware::handleRequest(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #53 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #54 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(145): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #55 [internal function]: Pydio\Core\Http\Server->Pydio\Core\Http{closure}(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #56 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(162): call_user_func_array(Object(Closure), Array) #57 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Middleware/SapiMiddleware.php(75): Pydio\Core\Http\Server::callNextMiddleWare(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #58 [internal function]: Pydio\Core\Http\Middleware\SapiMiddleware->handleRequest(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response), Object(Closure)) #59 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(146): call_user_func_array(Array, Array) #60 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Server.php(198): Pydio\Core\Http\Server->nextCallable(Object(Zend\Diactoros\ServerRequest), Object(Zend\Diactoros\Response)) #61 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/Base.php(74): Pydio\Core\Http\Server->listen() #62 [internal function]: Pydio\Core\Http\Base::handleRoute(’’, ‘/’, Array) #63 /var/www/pydio-core-8.0.1/core/src/pydio/Core/Http/TopLevelRouter.php(139): call_user_func(Array, ‘’, ‘/’, Array) #64 /var/www/pydio-core-8.0.1/index.php(29): Pydio\Core\Http\TopLevelRouter->route() #65 {main}

But the truncated SQL output makes it impossible to see what’s gone wrong

These are always followed by:
Incorrect string value: ‘\xA9 July…’ for column ‘node_path’ at row 1

2

Hi,
Do you use pydio sync client? If no, you can disable syncable of workspaces.

3

Hi @c12simple, I’m not sure. This was set up by my predecessor and I’m still learning my way around. What is the sync client and how does it work?

4

@c12simple we are using synchable and the database tables exists and are being populated. It would be more helpful if we could see the SQL INSERT that’s causing the error. I assume there’s a missing column in a database table somewhere, probably caused by an update at some point.

Blockquote

5

It looks like inserting into ajxp_index barfs on some node_paths, e.g. ‘\x82dical…’ - Unicode � which is a single close quote? Maybe unescaped?

6

Hi,
What is the charset, collation of your DB ?

7

Hi @c12simple, the collation is utf8mb4_0900_ai_ci