Hola!
Aquesta nit el servidor ha caigut a les 3 AM (horari BCN) i l’he tornat a aixecar. El que havia caigut era la base de dades amb aquest error:
/var/log/postgresql/postgresql-14-main.log
2024-11-19 02:21:11.268 UTC [1129105] akkoma@akkoma ERROR: duplicate key value violates unique constraint "users_nickname_index"
2024-11-19 02:21:11.268 UTC [1129105] akkoma@akkoma DETAIL: Key (nickname)=(privacy@lemmy.ml) already exists.
2024-11-19 02:21:11.268 UTC [1129105] akkoma@akkoma STATEMENT: UPDATE "users" SET "name" = $1, "background" = $2, "nickname" = $3, "pinned_objects" = $4, "bio" = $5, "follower_address" = $6, "last_refreshed_at" = $7, "updated_at" = $8 WHERE "id" = $9
2024-11-19 02:21:13.286 UTC [1128021] akkoma@akkoma ERROR: duplicate key value violates unique constraint "users_nickname_index"
2024-11-19 02:21:13.286 UTC [1128021] akkoma@akkoma DETAIL: Key (nickname)=(privacy@lemmy.ml) already exists.
2024-11-19 02:21:13.286 UTC [1128021] akkoma@akkoma STATEMENT: UPDATE "users" SET "name" = $1, "background" = $2, "nickname" = $3, "pinned_objects" = $4, "bio" = $5, "follower_address" = $6, "last_refreshed_at" = $7, "updated_at" = $8 WHERE "id" = $9
2024-11-19 02:21:14.312 UTC [1128021] akkoma@akkoma ERROR: duplicate key value violates unique constraint "users_nickname_index"
2024-11-19 02:21:14.312 UTC [1128021] akkoma@akkoma DETAIL: Key (nickname)=(privacy@lemmy.ml) already exists.
2024-11-19 02:21:14.312 UTC [1128021] akkoma@akkoma STATEMENT: UPDATE "users" SET "name" = $1, "background" = $2, "nickname" = $3, "pinned_objects" = $4, "bio" = $5, "follower_address" = $6, "last_refreshed_at" = $7, "updated_at" = $8 WHERE "id" = $9
2024-11-19 02:25:41.051 UTC [850] LOG: server process (PID 1125619) was terminated by signal 9: Killed
2024-11-19 02:25:41.051 UTC [850] DETAIL: Failed process was running: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at" FROM "activities" AS a0 WHERE (coalesce((a0."data")->'object'->>'id', (a0."data")->>'object') = $1) AND ((a0."data")->>'type' = $2)
2024-11-19 02:25:41.051 UTC [850] LOG: terminating any other active server processes
2024-11-19 02:25:41.097 UTC [1130931] [unknown]@[unknown] LOG: PID 1130904 in cancel request did not match any process
2024-11-19 02:25:41.098 UTC [1130932] akkoma@akkoma FATAL: the database system is in recovery mode
2024-11-19 02:25:41.113 UTC [1130930] [unknown]@[unknown] LOG: PID 1125619 in cancel request did not match any process
2024-11-19 02:25:41.149 UTC [1130933] akkoma@akkoma FATAL: the database system is in recovery mode
2024-11-19 02:25:41.149 UTC [1130934] akkoma@akkoma FATAL: the database system is in recovery mode
2024-11-19 02:25:41.190 UTC [850] LOG: all server processes terminated; reinitializing
2024-11-19 02:25:41.325 UTC [850] LOG: received fast shutdown request
2024-11-19 02:25:41.326 UTC [1130937] LOG: database system was interrupted; last known up at 2024-11-19 02:22:15 UTC
2024-11-19 02:25:41.330 UTC [1130938] [unknown]@[unknown] LOG: PID 1129882 in cancel request did not match any process
2024-11-19 02:25:41.348 UTC [1130939] akkoma@akkoma FATAL: the database system is shutting down
2024-11-19 02:25:41.435 UTC [1130937] LOG: database system was not properly shut down; automatic recovery in progress
2024-11-19 02:25:41.443 UTC [1130937] LOG: redo starts at 23D/AAB1C4C0
2024-11-19 02:25:41.445 UTC [850] LOG: abnormal database system shutdown
2024-11-19 02:25:41.451 UTC [850] LOG: database system is shut down
Estic tenint una mica de dejà vu amb pleroma… 
Estaré (estiguem) atent a noves caigudes…
cc @xaloc