Skip to main content


@Tobias @Hypolite Petovan @Michael Vogel

Sorry for the direct mention, but I'm having trouble with Friendica groups. I can't see any posts except my own from a few months ago. I can still get feeds of people in my network timeline. I also left and then tried to re-add the Friendica Admins group, admins@forum.friendi.ca, but I can't seem to re-add it.

Was wondering if it was a weird database issue or if my nginx config is doing something weird again. I was having issues with redis recently so not sure if that's an issue. Thanks for any tips you have.
According to https://friendica.jb-net.us/friendica you are on the latest version with all database updates done. When you think that something is weird then have a look for PHP errors (error logging has to be enabled for both the web process and the cli in their respective php.ini) as well as for entries with "DB Error" in your friendica log file.
Looks like I'm seeing quite a few database errors in the Friendica log. Have a bunch of entries that look like below.

2021-02-26T02:27:18Z index [ERROR]: DB Error {"code":1205,"error":"Lock wait timeout exceeded; try restarting transaction","callstack":"DBA::update, DFRN::import, dfrn_dispatch_public, dfrn_notify_post, LegacyModule::runModuleFunction, LegacyModule::post, call_user_func, Module::run","params":"UPDATE `contact` SET `forum` = 0, `prv` = 0 WHERE ((`forum` OR `prv`) AND `uid` = 0 AND `nurl` = 'http:\/\/libranet.de\/profile\/ncnews')"} - {"file":"Database.php","line":765,"function":"e","uid":"7a1b0c","process_id":44180}
2021-02-26T02:27:18Z index [ERROR]: DB Error {"code":1205,"error":"Lock wait timeout exceeded; try restarting transaction","callstack":"DBA::update, DFRN::import, dfrn_dispatch_public, dfrn_notify_post, LegacyModule::runModuleFunction, LegacyModule::post, call_user_func, Module::run","params":"UPDATE `contact` SET `forum` = 0, `prv` = 0 WHERE ((`forum` OR `prv`) AND `uid` = 0 AND `nurl` = 'http:\/\/libranet.de\/profile\/ncnews')"} - {"file":"Database.php","line":765,"function":"e","uid":"505a0d","process_id":48254}
2021-02-26T02:27:18Z index [ERROR]: DB Error {"code":1205,"error":"Lock wait timeout exceeded; try restarting transaction","callstack":"Item::insert, Diaspora::receiveStatusMessage, Diaspora::dispatch, Diaspora::dispatchPublic, Diaspora::storeByGuid, Diaspora::parentItem, Diaspora::receiveComment, Diaspora::dispatch","params":"INSERT IGNORE INTO `post-user` (`uri-id`, `parent-uri-id`, `thr-parent-id`, `created`, `edited`, `received`, `gravity`, `network`, `owner-id`, `author-id`, `post-type`, `vid`, `private`, `global`, `visible`, `deleted`, `uid`, `protocol`, `contact-id`, `wall`, `origin`, `psid`, `unseen`) VALUES (1025328, 1025328, 1025328, '2021-02-26 00:12:53', '2021-02-26 00:12:53', '2021-02-26 02:24:45', 0, 'dspr', 18161, 18161, 75, 8, 0, 1, 1, 0, 0, 2, 18161, 0, 0, 0, 0)"} - {"file":"Database.php","line":765,"function":"e","uid":"dd9a1e","process_id":44179}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:11Z worker [ERROR]: DB Error {"code":1064,"error":"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1","callstack":"DBA::delete, CleanItemUri::execute, Worker::execFunction, Worker::execute, Worker::processQueue","params":"DELETE FROM `item-uri` WHERE `id` IN ();"} - {"file":"Database.php","line":765,"function":"e","uid":"10c5c7","process_id":188432}
2021-02-26T02:50:17Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::detect, GServer::check","worker_id":"a29cbce","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"75c79a","process_id":188447}
2021-02-26T02:50:42Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::check, UpdateGServer::execute","worker_id":"ab6113d","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"1916d7","process_id":188397}
2021-02-26T02:50:51Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::check, UpdateGServer::execute","worker_id":"5dcae53","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"943808","process_id":188456}
2021-02-26T03:00:15Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::check, UpdateGServer::execute","worker_id":"70834c7","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"9a3379","process_id":230133}
2021-02-26T03:00:17Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::detect, GServer::check","worker_id":"587dbb9","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"192c63","process_id":230164}
2021-02-26T03:03:27Z index [ERROR]: DB Error {"code":1146,"error":"Table 'friendica.post-user-view' doesn't exist","callstack":"Post::selectForUser, ping_init, LegacyModule::runModuleFunction, LegacyModule::init, call_user_func, Module::run, App::runFrontend","params":"SELECT `wall`, `uid`, `uri-id` FROM `post-user-view` WHERE (`unseen` AND `uid` = 1 AND NOT `origin` AND (`vid` != 6 OR `vid` IS NULL) AND `visible` AND NOT `deleted` AND NOT `author-blocked` AND NOT `owner-blocked` AND (NOT `causer-blocked` OR `causer-id` = 0) AND NOT `contact-blocked` AND ((NOT `contact-readonly` AND NOT `contact-pending` AND (`contact-rel` IN (2, 3))) OR `self` OR `gravity` != 0 OR `contact-uid` = 0) AND NOT EXISTS (SELECT `uri-id` FROM `post-user` WHERE `hidden` AND `uri-id` = `post-user-view`.`uri-id` AND `uid` = 1) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = 1 AND `cid` = `author-id` AND `blocked`) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = 1 AND `cid` = `owner-id` AND `blocked`) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = 1 AND `cid` = `author-id` AND `ignored` AND `gravity` = 0) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = 1 AND `cid` = `owner-id` AND `ignored` AND `gravity` = 0))"} - {"file":"Database.php","line":662,"function":"p","uid":"4d516e","process_id":60441}
2021-02-26T03:37:19Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"e8a074","process_id":44179}
2021-02-26T03:43:06Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"e72127","process_id":44177}
2021-02-26T05:00:12Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::detect, GServer::check","worker_id":"1e2fd59","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"d9696a","process_id":711964}
2021-02-26T05:38:22Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"30b481","process_id":60804}
2021-02-26T08:30:33Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"89d717","process_id":44179}
2021-02-26T10:01:04Z worker [ERROR]: compacting error {"worker_id":"42e4571","worker_cmd":"AddContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"17173b","process_id":1886915}
2021-02-26T12:16:02Z worker [ERROR]: compacting error {"worker_id":"915a6c1","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6bc168","process_id":2407022}
2021-02-26T12:37:48Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"f4a726","process_id":57909}
2021-02-26T12:40:08Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::check, UpdateGServer::execute","worker_id":"1eac2a3","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"2d7b64","process_id":2526008}
2021-02-26T12:40:15Z worker [ERROR]: compacting error {"worker_id":"5e9af68","worker_cmd":"UpdateGServer"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"545ebe","process_id":2525969}
2021-02-26T13:00:13Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::check, UpdateGServer::execute","worker_id":"16c3959","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"db3502","process_id":2604676}
2021-02-26T17:01:25Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::detect, GServer::check","worker_id":"d38a63c","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"b22d76","process_id":3540859}
2021-02-26T17:46:11Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"1f0121","process_id":2786368}
2021-02-26T18:29:57Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"96b00f","process_id":2872591}
2021-02-26T22:40:05Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::check, UpdateGServer::execute","worker_id":"431a151","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"ea6abe","process_id":640015}
2021-02-26T22:40:08Z worker [ERROR]: Error(s) while parsing XML string. {"callstack":"GServer::validHostMeta, GServer::detect, GServer::detect, GServer::check","worker_id":"d0175ae","worker_cmd":"UpdateGServer"} - {"file":"XML.php","line":450,"function":"parseString","uid":"249faa","process_id":640051}
2021-02-27T02:35:53Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"35c9e6","process_id":3747428}
2021-02-27T05:51:03Z worker [ERROR]: compacting error {"worker_id":"dd9bfcb","worker_cmd":"AddContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"3576e8","process_id":2258000}
2021-02-27T06:01:05Z worker [ERROR]: compacting error {"worker_id":"c0f7caa","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"c097e4","process_id":2295529}
2021-02-27T06:01:05Z worker [ERROR]: compacting error {"worker_id":"5e9f4e5","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"d712dc","process_id":2295532}
2021-02-27T06:21:05Z worker [ERROR]: compacting error {"worker_id":"1ed47d4","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"9f81a9","process_id":2366210}
2021-02-27T06:21:06Z worker [ERROR]: compacting error {"worker_id":"534ef99","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6e08c5","process_id":2366292}
2021-02-27T06:21:07Z worker [ERROR]: compacting error {"worker_id":"9467e40","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6499e9","process_id":2366312}
2021-02-27T06:21:07Z worker [ERROR]: compacting error {"worker_id":"7837486","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"b5c3ac","process_id":2366191}
2021-02-27T06:21:07Z worker [ERROR]: compacting error {"worker_id":"1d02271","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"bfb27c","process_id":2366309}
2021-02-27T06:21:11Z worker [ERROR]: compacting error {"worker_id":"51ce795","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"fc0a0c","process_id":2366388}
2021-02-27T06:21:11Z worker [ERROR]: compacting error {"worker_id":"27dd8b4","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"491764","process_id":2366213}
2021-02-27T06:21:11Z worker [ERROR]: compacting error {"worker_id":"6385c5b","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a350d3","process_id":2366208}
2021-02-27T06:21:11Z worker [ERROR]: compacting error {"worker_id":"545c40a","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"e12759","process_id":2366450}
2021-02-27T06:21:12Z worker [ERROR]: compacting error {"worker_id":"1215948","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"72cef6","process_id":2366302}
2021-02-27T06:21:23Z worker [ERROR]: compacting error {"worker_id":"f8d1ef6","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"94d533","process_id":2366284}
2021-02-27T06:21:32Z worker [ERROR]: compacting error {"worker_id":"19cefba","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"420469","process_id":2366189}
2021-02-27T06:21:32Z worker [ERROR]: compacting error {"worker_id":"3e4afdb","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"e499dc","process_id":2366186}
2021-02-27T06:22:09Z worker [ERROR]: compacting error {"worker_id":"1ed47d4","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"9f81a9","process_id":2366210}
2021-02-27T06:22:10Z worker [ERROR]: compacting error {"worker_id":"9467e40","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6499e9","process_id":2366312}
2021-02-27T06:22:11Z worker [ERROR]: compacting error {"worker_id":"7837486","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"b5c3ac","process_id":2366191}
2021-02-27T06:22:15Z worker [ERROR]: compacting error {"worker_id":"51ce795","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"fc0a0c","process_id":2366388}
2021-02-27T06:22:16Z worker [ERROR]: compacting error {"worker_id":"27dd8b4","worker_cmd":"AddContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"491764","process_id":2366213}
2021-02-27T06:22:19Z worker [ERROR]: compacting error {"worker_id":"1d02271","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"bfb27c","process_id":2366309}
2021-02-27T06:22:21Z worker [ERROR]: compacting error {"worker_id":"b52053c","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a9d5b1","process_id":2366221}
2021-02-27T06:22:35Z worker [ERROR]: compacting error {"worker_id":"19cefba","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"420469","process_id":2366189}
2021-02-27T06:22:37Z worker [ERROR]: compacting error {"worker_id":"534ef99","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6e08c5","process_id":2366292}
2021-02-27T06:22:38Z worker [ERROR]: compacting error {"worker_id":"545c40a","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"e12759","process_id":2366450}
2021-02-27T06:22:46Z worker [ERROR]: compacting error {"worker_id":"6385c5b","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a350d3","process_id":2366208}
2021-02-27T06:22:59Z worker [ERROR]: compacting error {"worker_id":"f8d1ef6","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"94d533","process_id":2366284}
2021-02-27T06:23:13Z worker [ERROR]: compacting error {"worker_id":"9467e40","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6499e9","process_id":2366312}
2021-02-27T06:31:19Z worker [ERROR]: compacting error {"worker_id":"0fa1188","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"1e4206","process_id":2405838}
2021-02-27T06:31:19Z worker [ERROR]: compacting error {"worker_id":"61d5998","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a655f0","process_id":2405836}
2021-02-27T06:31:22Z worker [ERROR]: compacting error {"worker_id":"e15fac5","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"807520","process_id":2405816}
2021-02-27T07:25:44Z worker [ERROR]: compacting error {"worker_id":"9c78129","worker_cmd":"ContactDiscovery"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"bd47b6","process_id":2596873}
2021-02-27T09:41:04Z worker [ERROR]: compacting error {"worker_id":"725e8db","worker_cmd":"AddContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"3a4a74","process_id":3122045}
2021-02-27T09:41:04Z worker [ERROR]: compacting error {"worker_id":"8fc5453","worker_cmd":"AddContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"59d749","process_id":3121962}
2021-02-27T12:00:09Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"cd2078","process_id":2421028}
2021-02-27T12:02:49Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a26814","process_id":2421186}
2021-02-27T12:08:16Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"214c84","process_id":2225492}
2021-02-27T12:22:10Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"6d470b","process_id":2421028}
2021-02-27T12:32:51Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"8852b2","process_id":2277294}
2021-02-27T12:34:21Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"17773d","process_id":2421186}
2021-02-27T12:34:23Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"275c6f","process_id":2421171}
2021-02-27T12:34:38Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"803022","process_id":2399839}
2021-02-27T12:39:19Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"2ef4a9","process_id":2387945}
2021-02-27T12:52:42Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a9cc6a","process_id":2400272}
2021-02-27T13:01:04Z worker [ERROR]: compacting error {"worker_id":"ef61193","worker_cmd":"UpdateContact"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"39facd","process_id":3881507}
2021-02-27T13:12:31Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"3cefe3","process_id":2225492}
2021-02-27T13:25:43Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"93c80c","process_id":2421038}
2021-02-27T13:31:33Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"7c0c60","process_id":2225492}
2021-02-27T13:42:25Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"73a538","process_id":2399839}
2021-02-27T13:56:07Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"c8a1cd","process_id":1066270}
2021-02-27T13:56:56Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"d16b48","process_id":2421038}
2021-02-27T14:11:24Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"73d4f0","process_id":2421171}
2021-02-27T14:32:06Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"fd0b90","process_id":2421171}
2021-02-27T14:51:59Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"aec819","process_id":1066270}
2021-02-27T15:02:40Z worker [ERROR]: compacting error {"worker_id":"fd195b9","worker_cmd":"ContactDiscovery"} - {"file":"JsonLD.php","line":153,"function":"compact","uid":"0ae4f2","process_id":139384}
2021-02-27T15:03:25Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"d54b43","process_id":2399839}
2021-02-27T15:19:12Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a028f1","process_id":1063751}
2021-02-27T15:20:12Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a028f1","process_id":1063751}
2021-02-27T15:21:13Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"a028f1","process_id":1063751}
2021-02-27T15:22:53Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"98f2ce","process_id":2399839}
2021-02-27T15:25:04Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"3b1940","process_id":1066270}
2021-02-27T15:26:05Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"3b1940","process_id":1066270}
2021-02-27T15:27:05Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"3b1940","process_id":1066270}
2021-02-27T15:31:03Z index [ERROR]: compacting error [] - {"file":"JsonLD.php","line":153,"function":"compact","uid":"b641db","process_id":2225492}
Most of these errors don't matter. Also most of them don't contain "DB Error", but only "error" in it :-) The lock timeout can happen during clean up processes, but is some background thing. And the syntax error is already fixed with the latest commits.
I guess I should also mention that I think a new update of MariaDB was pushed to my server. Could the update have caused an issue?
Okay, thanks! I'll dig around some more.
The biggest question here is: how do you try to follow a forum contact and what exactly is happening.
This is really strange. I re-followed the admins last night, but just checked again and I can see the latest post from Tio. So I guess it just took a while? I unfortunately can't see any previous post, but maybe that will populate over time. I'll wait a day or two and see if that works.
You don't see any previous posts. But you can always go to the forum page, take a message link and paste it into your search to import it.
Okay. That's good to know if I need any other posts from the past! Maybe it was hung on on using a different protocol (I've followed the forum.friendi.ca groups ever since I started up my node. It seems like at least un-following and then re-adding the group restored communication.