Tuxi (Backup) (nprofile…ktgr) This happened to me on my instance and I tried everything to fix the corrupted indexes, using expert advice, and couldn't fix it. I finally restored from a backup, which took 12 hours. It happened to me because I made a change to Friendica and restarted it while everything was still running. I know this is not helping you in your current situation, but I want to understand what may have caused this to happen to you and to help other Admins.
Do you have a theory as to what brought this about?
Whenever I am making any changes to Friendica now, I take MariaDB and Apache2 down, and I make a complete backup of the database disk to another disk (sudo cp -rp /mnt/friendica_db_volume_nyc1_01/mariadb /mnt/friendica_backups/) because I never ever want to go through this again. I also take a disk snapshot on Digital Ocean of the external DB drive as well, and have the regular backup available. Total paranoia now.
Good luck. Keep us posted on how you overcome this and what you learn.
Jerry on Friendica /
npub1w9…q80dz
2025-03-14 18:57:33
in reply to nevent1q…keeg
Author Public Key
npub1w99kwr8nzh6k302q96kxl53cgj0whd5m54z6v20cjdfxtp4hzr6qaq80dzPublished at
2025-03-14 18:57:33Event JSON
{
"id": "ac7a611da98df6835215704371d7346f3260b6418bd728af43f9961c26164ee9",
"pubkey": "714b670cf315f568bd402eac6fd238449eebb69ba545a629f893526586b710f4",
"created_at": 1741978653,
"kind": 1,
"tags": [
[
"p",
"d9d817b4103a4ab537d8bc35b40b2f19885704c09297709389c90ecb33556834",
"wss://relay.mostr.pub"
],
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"e",
"52d082b2259e47e692a976cbd6425a6984ee70d65824609176a08631c20f4cb5",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://my-place.social/objects/e599373b-9367-d47c-1d18-259129772424",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqm8vp0dqs8f9t2d7chs6mgze0rxy9wpxqj2thpyufey8vkv64dq6q4dktgr This happened to me on my instance and I tried everything to fix the corrupted indexes, using expert advice, and couldn't fix it. I finally restored from a backup, which took 12 hours. It happened to me because I made a change to Friendica and restarted it while everything was still running. I know this is not helping you in your current situation, but I want to understand what may have caused this to happen to you and to help other Admins.\n\nDo you have a theory as to what brought this about?\n\nWhenever I am making any changes to Friendica now, I take MariaDB and Apache2 down, and I make a complete backup of the database disk to another disk (sudo cp -rp /mnt/friendica_db_volume_nyc1_01/mariadb /mnt/friendica_backups/) because I never ever want to go through this again. I also take a disk snapshot on Digital Ocean of the external DB drive as well, and have the regular backup available. Total paranoia now.\n\nGood luck. Keep us posted on how you overcome this and what you learn.",
"sig": "40101a74f8ae2e887d3f05776b6c38dde9ad5cffc6ada0d9689843ff543de576e5f03bab9d84b1315f0b019502a9c7d1546ddcbcf03edb0384fd1219ce8d4120"
}