autonomous.zone on Nostr: Having some really frustrating problems with our postgres database for this mastodon ...
Having some really frustrating problems with our postgres database for this mastodon instance. When running out database dump (backup) scripts we hit a fatal error relating to missing or corrupted toast values:
`Dumping the contents of table "status_edits" failed: ... ERROR: missing chunk number 0 for toast value 123456 in pg_toast_123456`
This happened before and I manually nulled out those values, but suddenly this week again a corruption. What should I check first?
#postgres #mastodon
Published at
2026-08-16 08:24:09 UTCEvent JSON
{
"id": "998fda4d78cdf138a275aadfb3c29b89b94502d2ce63ff0856256eb13f28bdfa",
"pubkey": "57cbb9cbe54a3e43e568a03d992ced9065c21ce2aa4b3f6239a6c1358a6e9ca5",
"created_at": 1786868649,
"kind": 1,
"tags": [
[
"t",
"postgres"
],
[
"t",
"mastodon"
],
[
"proxy",
"https://autonomous.zone/@twilight/117104223802214620",
"web"
],
[
"proxy",
"https://autonomous.zone/users/twilight/statuses/117104223802214620",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://autonomous.zone/users/twilight/statuses/117104223802214620",
"pink.momostr"
],
[
"-"
]
],
"content": "Having some really frustrating problems with our postgres database for this mastodon instance. When running out database dump (backup) scripts we hit a fatal error relating to missing or corrupted toast values:\n\n`Dumping the contents of table \"status_edits\" failed: ... ERROR: missing chunk number 0 for toast value 123456 in pg_toast_123456`\n\nThis happened before and I manually nulled out those values, but suddenly this week again a corruption. What should I check first?\n\n#postgres #mastodon",
"sig": "121a0ee7cb89abd86fd3b1e84dcf5f0c336d75e749947ccd850ad536139fa9608cb58d37fceef07634375331ecaf021e3651ccc9baab4064708186f3b607e4c4"
}
