Als Antwort auf Gerhard Hallstein

@Gerhard Hallstein forum.friendi.ca/display/8ffdf…


!Friendica Support
Hallo Profis, ich habe ein Problem mit meiner Instanz. In den Logs taucht folgender DB-Fehler auf:
Index for table 'post-user' is corrupt; try to repair it

Ein CHECK TABLE `post-user`; in der MariaDB Konsole zeigt folgendes:

MariaDB [friendica]> CHECK TABLE `post-user`;
+---------------------+-------+----------+-----------------------------------------------------------+
| Table               | Op    | Msg_type | Msg_text                                                  |
+---------------------+-------+----------+-----------------------------------------------------------+
| friendica.post-user | check | Warning  | InnoDB: The B-tree of index PRIMARY is corrupted.         |
| friendica.post-user | check | Warning  | InnoDB: Index uid_uri-id is marked as corrupted           |
| friendica.post-user | check | Warning  | InnoDB: Index uri-id is marked as corrupted               |
| friendica.post-user | check | Warning  | InnoDB: Index parent-uri-id is marked as corrupted        |
| friendica.post-user | check | Warning  | InnoDB: Index thr-parent-id is marked as corrupted        |
| friendica.post-user | check | Warning  | InnoDB: Index external-id is marked as corrupted          |
| friendica.post-user | check | Warning  | InnoDB: Index owner-id is marked as corrupted             |
| friendica.post-user | check | Warning  | InnoDB: Index author-id is marked as corrupted            |
| friendica.post-user | check | Warning  | InnoDB: Index causer-id is marked as corrupted            |
| friendica.post-user | check | Warning  | InnoDB: Index vid is marked as corrupted                  |
| friendica.post-user | check | Warning  | InnoDB: Index contact-id is marked as corrupted           |
| friendica.post-user | check | Warning  | InnoDB: Index event-id is marked as corrupted             |
| friendica.post-user | check | Warning  | InnoDB: Index psid is marked as corrupted                 |
| friendica.post-user | check | Warning  | InnoDB: Index author-id_uid is marked as corrupted        |
| friendica.post-user | check | Warning  | InnoDB: Index parent-uri-id_uid is marked as corrupted    |
| friendica.post-user | check | Warning  | InnoDB: Index uid_contactid is marked as corrupted        |
| friendica.post-user | check | Warning  | InnoDB: Index uid_unseen_contactid is marked as corrupted |
| friendica.post-user | check | Warning  | InnoDB: Index uid_unseen is marked as corrupted           |
| friendica.post-user | check | Warning  | InnoDB: Index uid_hidden_uri-id is marked as corrupted    |
| friendica.post-user | check | Warning  | InnoDB: Index uid_wall_received is marked as corrupted    |
| friendica.post-user | check | Warning  | InnoDB: Index author-id_created is marked as corrupted    |
| friendica.post-user | check | Warning  | InnoDB: Index owner-id_created is marked as corrupted     |
| friendica.post-user | check | Warning  | InnoDB: Index replies-id is marked as corrupted           |
| friendica.post-user | check | error    | Corrupt                                                   |
+---------------------+-------+----------+-----------------------------------------------------------+
24 rows in set (57,683 sec)

Wenn ich REPAIR TABLE `post-user`; kommt folgende Ausgabe:

MariaDB [friendica]> REPAIR TABLE `post-user`;
+---------------------+--------+----------+---------------------------------------------------------+
| Table               | Op     | Msg_type | Msg_text                                                |
+---------------------+--------+----------+---------------------------------------------------------+
| friendica.post-user | repair | note     | The storage engine for the table doesn't support repair |
+---------------------+--------+----------+---------------------------------------------------------+
1 row in set (1 min 53,258 sec)

Ich habe keinen Plan mehr. Könnt ihr mich bitte Unterstützen?


Hello @Libranet Support @Friendica Support !

I've just realised something, which I assume is down to imperfect federation between Friendica and Mastodon: When I reply to someone on Mastodon, it automatically includes a mention of them @name.whatever - but I don't see that mention. If it's a nested comment, multiple mentions might be included. I only realised this when someone asked to stop mentioning them in a thread, and didn't realise I had.

Is this intentional? Is there a way to not mention someone in a comment on their post (or a reply to a comment)? Thanks.

Hello @Friendica Support ,
it looks like my instance dica.interfel.de crashed some days ago.

Calling the Website gives an "Error 503 - Service Unavailable" and the uberspace-supervisord.log warns

2025-03-07 09:30:36,455 WARN No file matches via include "/home/snila/etc/services.d/*.ini


everytime, the worker.php is called.

I switched to maintenance mode until I have an idea of what this is about and where to start to take care of it.

The last five signs of life showed this Friendica-log entry

2025-03-07T01:30:25Z worker [ERROR]: Uncaught exception in worker method execution {"class":"RuntimeException","message":"Unable to write to stream","code":0,"file":"/var/www/virtual/snila/html/vendor/guzzlehttp/psr7/src/Stream.php:260","trace":"#0 /var/www/virtual/snila/html/vendor/guzzlehttp/psr7/src/StreamDecoratorTrait.php(144): GuzzleHttp\\Psr7\\Stream->write('<!DOCTYPE html>...')\n#1 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php(414): GuzzleHttp\\Psr7\\LazyOpenStream->write('<!DOCTYPE html>...')\n#2 [internal function]: GuzzleHttp\\Handler\\CurlFactory::GuzzleHttp\\Handler\\{closure}(Object(CurlHandle), '<!DOCTYPE html>...')\n#3 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php(44): curl_exec(Object(CurlHandle))\n#4 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(28): GuzzleHttp\\Handler\\CurlHandler->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#5 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(48): GuzzleHttp\\Handler\\Proxy::GuzzleHttp\\Handler\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#6 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php(35): GuzzleHttp\\Handler\\Proxy::GuzzleHttp\\Handler\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#7 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Middleware.php(31): GuzzleHttp\\PrepareBodyMiddleware->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#8 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php(71): GuzzleHttp\\Middleware::GuzzleHttp\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#9 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php(107): GuzzleHttp\\RedirectMiddleware->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#10 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php(73): GuzzleHttp\\RedirectMiddleware->checkRedirect(Object(GuzzleHttp\\Psr7\\Request), Array, Object(GuzzleHttp\\Psr7\\Response))\n#11 /var/www/virtual/snila/html/vendor/guzzlehttp/promises/src/FulfilledPromise.php(48): GuzzleHttp\\RedirectMiddleware->GuzzleHttp\\{closure}(Object(GuzzleHttp\\Psr7\\Response))\n#12 /var/www/virtual/snila/html/vendor/guzzlehttp/promises/src/TaskQueue.php(52): GuzzleHttp\\Promise\\Fu2025-03-07T06:45:16Z worker [ERROR]: Uncaught exception in worker method execution {"class":"RuntimeException","message":"Unable to write to stream","code":0,"file":"/var/www/virtual/snila/html/vendor/guzzlehttp/psr7/src/Stream.php:260","trace":"#0 /var/www/virtual/snila/html/vendor/guzzlehttp/psr7/src/StreamDecoratorTrait.php(144): GuzzleHttp\\Psr7\\Stream->write('{\"links\":[{\"rel...')\n#1 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php(414): GuzzleHttp\\Psr7\\LazyOpenStream->write('{\"links\":[{\"rel...')\n#2 [internal function]: GuzzleHttp\\Handler\\CurlFactory::GuzzleHttp\\Handler\\{closure}(Object(CurlHandle), '{\"links\":[{\"rel...')\n#3 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php(44): curl_exec(Object(CurlHandle))\n#4 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(28): GuzzleHttp\\Handler\\CurlHandler->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#5 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(48): GuzzleHttp\\Handler\\Proxy::GuzzleHttp\\Handler\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#6 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php(35): GuzzleHttp\\Handler\\Proxy::GuzzleHttp\\Handler\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#7 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Middleware.php(31): GuzzleHttp\\PrepareBodyMiddleware->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#8 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php(71): GuzzleHttp\\Middleware::GuzzleHttp\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#9 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Middleware.php(63): GuzzleHttp\\RedirectMiddleware->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#10 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/HandlerStack.php(75): GuzzleHttp\\Middleware::GuzzleHttp\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#11 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(333): GuzzleHttp\\HandlerStack->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#12 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(169): GuzzleHttp\\Client->transfer(Object(GuzzleHttp\\Psr7\\Request), Array)\n#13 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(189): GuzzleHttp\\Client->requestAsync('get', Object(GuzzleHttp\\Psr7\\Uri), Array)\n#14 /var/www/virtual/snila/html/src/Network/HTTPClient/Client/HttpClient.php(167): GuzzleHttp\\Client->request('get', 'https://social....', Array)\n#15 /var/www/virtual/snila/html/src/Network/HTTPClient/Client/HttpClient.php(203): Friendica\\Network\\HTTPClient\\Client\\HttpClient->request('get', 'https://social....', Array)\n#16 /var/www/virtual/snila/html/src/Model/GServer.php(603): Friendica\\Network\\HTTPClient\\Client\\HttpClient->get('https://social....', 'application/jso...', Array)\n#17 /var/www/virtual/snila/html/src/Model/GServer.php(362): Friendica\\Model\\GServer::detect('https://social....', '', false)\n#18 /var/www/virtual/snila/html/src/Worker/UpdateGServer.php(64): Friendica\\Model\\GServer::check('https://social....', '', true, false)\n#19 [internal function]: Friendica\\Worker\\UpdateGServer::execute('https://social....', false)\n#20 /var/www/virtual/snila/html/src/Core/Worker.php(560): call_user_func_array('Friendica\\\\Worke...', Array)\n#21 /var/www/virtual/snila/html/src/Core/Worker.php(374): Friendica\\Core\\Worker::execFunction(Array, 'UpdateGServer', Array, true)\n#22 /var/www/virtual/snila/html/src/Core/Worker.php(109): Friendica\\Core\\Worker::execute(Array)\n#23 /var/www/virtual/snila/html/bin/worker.php(75): Friendica\\Core\\Worker::processQueue(true, Object(Friendica\\Core\\Worker\\Entity\\Process))\n#24 {main}","previous":null,"worker_id":"78f079e","worker_cmd":"UpdateGServer"} - {"file":"Worker.php","line":562,"function":"execFunction","request-id":"67ca95ee4cf10","stack":"Worker::execFunction (374), Worker::execute (109), Worker::processQueue (75)","uid":"715ae3","process_id":20006}


followed by three lines of this

2025-03-07T09:30:25Z worker [ERROR]: Uncaught exception in worker method execution {"class":"Error","message":"Class \"GuzzleHttp\\Promise\\RejectedPromise\" not found","code":0,"file":"/var/www/virtual/snila/html/vendor/guzzlehttp/promises/src/Create.php:45","trace":"#0 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(335): GuzzleHttp\\Promise\\Create::rejectionFor(Object(RuntimeException))\n#1 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(169): GuzzleHttp\\Client->transfer(Object(GuzzleHttp\\Psr7\\Request), Array)\n#2 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(189): GuzzleHttp\\Client->requestAsync('get', Object(GuzzleHttp\\Psr7\\Uri), Array)\n#3 /var/www/virtual/snila/html/src/Network/HTTPClient/Client/HttpClient.php(167): GuzzleHttp\\Client->request('get', 'https://m.abunc...', Array)\n#4 /var/www/virtual/snila/html/src/Network/HTTPClient/Client/HttpClient.php(203): Friendica\\Network\\HTTPClient\\Client\\HttpClient->request('get', 'https://m.abunc...', Array)\n#5 /var/www/virtual/snila/html/src/Model/GServer.php(1860): Friendica\\Network\\HTTPClient\\Client\\HttpClient->get('https://m.abunc...', 'application/jso...', Array)\n#6 /var/www/virtual/snila/html/src/Model/GServer.php(773): Friendica\\Model\\GServer::checkMastodonDirectory('https://m.abunc...', Array)\n#7 /var/www/virtual/snila/html/src/Model/GServer.php(362): Friendica\\Model\\GServer::detect('https://m.abunc...', '', false)\n#8 /var/www/virtual/snila/html/src/Worker/UpdateGServer.php(64): Friendica\\Model\\GServer::check('https://m.abunc...', '', true, false)\n#9 [internal function]: Friendica\\Worker\\UpdateGServer::execute('https://m.abunc...', false)\n#10 /var/www/virtual/snila/html/src/Core/Worker.php(560): call_user_func_array('Friendica\\\\Worke...', Array)\n#11 /var/www/virtual/snila/html/src/Core/Worker.php(374): Friendica\\Core\\Worker::execFunction(Array, 'UpdateGServer', Array, true)\n#12 /var/www/virtual/snila/html/src/Core/Worker.php(109): Friendica\\Core\\Worker::execute(Array)\n#13 /var/www/virtual/snila/html/bin/worker.php(75): Friendica\\Core\\Worker::processQueue(false, Object(Friendica\\Core\\Worker\\Entity\\Process))\n#14 {main}","previous":null,"worker_id":"210fa80","worker_cmd":"UpdateGServer"} - {"file":"Worker.php","line":562,"function":"execFunction","request-id":"67cabca020cbe","stack":"Worker::execFunction (374), Worker::execute (109), Worker::processQueue (75)","uid":"157f2d","process_id":25969}


and finally this

2025-03-07T09:30:26Z worker [ERROR]: Uncaught exception in worker method execution {"class":"Error","message":"Class \"GuzzleHttp\\Exception\\RequestException\" not found","code":0,"file":"/var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php:211","trace":"#0 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php(158): GuzzleHttp\\Handler\\CurlFactory::createRejection(Object(GuzzleHttp\\Handler\\EasyHandle), Array)\n#1 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php(110): GuzzleHttp\\Handler\\CurlFactory::finishError(Object(GuzzleHttp\\Handler\\CurlHandler), Object(GuzzleHttp\\Handler\\EasyHandle), Object(GuzzleHttp\\Handler\\CurlFactory))\n#2 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php(47): GuzzleHttp\\Handler\\CurlFactory::finish(Object(GuzzleHttp\\Handler\\CurlHandler), Object(GuzzleHttp\\Handler\\EasyHandle), Object(GuzzleHttp\\Handler\\CurlFactory))\n#3 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(28): GuzzleHttp\\Handler\\CurlHandler->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#4 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php(48): GuzzleHttp\\Handler\\Proxy::GuzzleHttp\\Handler\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#5 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php(35): GuzzleHttp\\Handler\\Proxy::GuzzleHttp\\Handler\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#6 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Middleware.php(31): GuzzleHttp\\PrepareBodyMiddleware->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#7 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php(71): GuzzleHttp\\Middleware::GuzzleHttp\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#8 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Middleware.php(63): GuzzleHttp\\RedirectMiddleware->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#9 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/HandlerStack.php(75): GuzzleHttp\\Middleware::GuzzleHttp\\{closure}(Object(GuzzleHttp\\Psr7\\Request), Array)\n#10 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(333): GuzzleHttp\\HandlerStack->__invoke(Object(GuzzleHttp\\Psr7\\Request), Array)\n#11 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(169): GuzzleHttp\\Client->transfer(Object(GuzzleHttp\\Psr7\\Request), Array)\n#12 /var/www/virtual/snila/html/vendor/guzzlehttp/guzzle/src/Client.php(189): GuzzleHttp\\Client->requestAsync('head', Object(GuzzleHttp\\Psr7\\Uri), Array)\n#13 /var/www/virtual/snila/html/src/Network/HTTPClient/Client/HttpClient.php(167): GuzzleHttp\\Client->request('head', 'https://mastodo...', Array)\n#14 /var/www/virtual/snila/html/src/Network/HTTPClient/Client/HttpClient.php(192): Friendica\\Network\\HTTPClient\\Client\\HttpClient->request('head', 'https://mastodo...', Array)\n#15 /var/www/virtual/snila/html/src/Util/Network.php(72): Friendica\\Network\\HTTPClient\\Client\\HttpClient->head('https://mastodo...', Array)\n#16 /var/www/virtual/snila/html/src/Model/GServer.php(557): Friendica\\Util\\Network::isUrlValid('https://mastodo...')\n#17 /var/www/virtual/snila/html/src/Model/GServer.php(362): Friendica\\Model\\GServer::detect('https://mastodo...', '', false)\n#18 /var/www/virtual/snila/html/src/Worker/UpdateGServer.php(64): Friendica\\Model\\GServer::check('https://mastodo...', '', true, false)\n#19 [internal function]: Friendica\\Worker\\UpdateGServer::execute('https://mastodo...', false)\n#20 /var/www/virtual/snila/html/src/Core/Worker.php(560): call_user_func_array('Friendica\\\\Worke...', Array)\n#21 /var/www/virtual/snila/html/src/Core/Worker.php(374): Friendica\\Core\\Worker::execFunction(Array, 'UpdateGServer', Array, true)\n#22 /var/www/virtual/snila/html/src/Core/Worker.php(109): Friendica\\Core\\Worker::execute(Array)\n#23 /var/www/virtual/snila/html/bin/worker.php(75): Friendica\\Core\\Worker::processQueue(false, Object(Friendica\\Core\\Worker\\Entity\\Process))\n#24 {main}","previous":null,"worker_id":"1bca238","worker_cmd":"UpdateGServer"} - {"file":"Worker.php","line":562,"function":"execFunction","request-id":"67cabca020cbe","stack":"Worker::execFunction (374), Worker::execute (109), Worker::processQueue (75)","uid":"157f2d","process_id":25969}


Before these last five log-entries, there are lots of log-entries of this type

2025-03-06T18:31:19Z app [ERROR]: DB Error {"code":1062,"error":"Duplicate entry 'fedibikes_de-a.gup.pe/u/fedibikes_de' for key 'type_name_url'","params":"UPDATE `tag` SET `name` = 'fedibikes_de' WHERE (`url` = 'https://a.gup.pe/u/fedibikes_de' AND `type` = 1)"} - {"file":"Database.php","line":782,"function":"e","request-id":"67c9e9f6ca796","stack":"Database::e (1361), Database::update (404), DBA::update (114), Tag::store (261), Tag::storeByHash (315), Tag::storeFromArray (296), Tag::storeFromBody (1010), Processor::storeFromBody (958), Processor::processContent (485), Processor::createItem (785), Receiver::routeActivities (750), Receiver::processActivity (1790), Processor::processActivity (1691), Processor::fetchMissingActivity (822), Receiver::routeActivities (750)","uid":"a7cfed","process_id":16879}


(I once tried to follow the fedibikes-group, but i stopped that more than a year ago and i am not following any a.gup.pe-account nowadays.)

Als Antwort auf Michael 🇺🇦

Hi @Michael 🇺🇦 ,
thank you for your quick view at my log-excerpts.
So i will give Uberspace-support a try.

Anyway during the last weeks i noticed lots of reports related to high load and database-problems.
From time to time i had to call dica.interfel.de twice to get an answer. These days libranet.de always needs two or three calls to get any result.