Tuxi (Backup) on Nostr: Hallo Profis, ich habe ein Problem mit meiner Instanz. In den Logs taucht folgender ...
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?
Published at
2025-03-14 16:19:32Event JSON
{
"id": "52d082b2259e47e692a976cbd6425a6984ee70d65824609176a08631c20f4cb5",
"pubkey": "d9d817b4103a4ab537d8bc35b40b2f19885704c09297709389c90ecb33556834",
"created_at": 1741969172,
"kind": 1,
"tags": [
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"p",
"08e210217b9bf22ce53ebf1e27b5ed8dc9db28dc1d82f1f4575eee7b3a76743a",
"wss://relay.mostr.pub"
],
[
"proxy",
"https://friendica.opensocial.space/objects/8ffdf77c-1867-d457-1480-594639187844",
"activitypub"
]
],
"content": "Hallo Profis, ich habe ein Problem mit meiner Instanz. In den Logs taucht folgender DB-Fehler auf:\nIndex for table 'post-user' is corrupt; try to repair it\n\nEin CHECK TABLE `post-user`; in der MariaDB Konsole zeigt folgendes:\nMariaDB [friendica]\u003e CHECK TABLE `post-user`;\n+---------------------+-------+----------+-----------------------------------------------------------+\n| Table | Op | Msg_type | Msg_text |\n+---------------------+-------+----------+-----------------------------------------------------------+\n| friendica.post-user | check | Warning | InnoDB: The B-tree of index PRIMARY is corrupted. |\n| friendica.post-user | check | Warning | InnoDB: Index uid_uri-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index uri-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index parent-uri-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index thr-parent-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index external-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index owner-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index author-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index causer-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index vid is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index contact-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index event-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index psid is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index author-id_uid is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index parent-uri-id_uid is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index uid_contactid is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index uid_unseen_contactid is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index uid_unseen is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index uid_hidden_uri-id is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index uid_wall_received is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index author-id_created is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index owner-id_created is marked as corrupted |\n| friendica.post-user | check | Warning | InnoDB: Index replies-id is marked as corrupted |\n| friendica.post-user | check | error | Corrupt |\n+---------------------+-------+----------+-----------------------------------------------------------+\n24 rows in set (57,683 sec)\n\nWenn ich REPAIR TABLE `post-user`; kommt folgende Ausgabe:\nMariaDB [friendica]\u003e REPAIR TABLE `post-user`;\n+---------------------+--------+----------+---------------------------------------------------------+\n| Table | Op | Msg_type | Msg_text |\n+---------------------+--------+----------+---------------------------------------------------------+\n| friendica.post-user | repair | note | The storage engine for the table doesn't support repair |\n+---------------------+--------+----------+---------------------------------------------------------+\n1 row in set (1 min 53,258 sec)\n\nIch habe keinen Plan mehr. Könnt ihr mich bitte Unterstützen?",
"sig": "68241a508c8fb7f8a62c466987e7dd4fe83f59f6e20c4a5433f0e2c379ab1c7a00441bccd613c1ab831b31a2ac5ccda7bb79947f7a3f0913210cad71efd063e8"
}