Caiguda de la base de dades del servidor

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… :cry:

Estaré (estiguem) atent a noves caigudes…

cc @xaloc

3 Likes

Hmmm…, intentaré investigar. No se si serà allò de que hi ha prou processos per la base de dades o què.

1 Like

Ui, aquest fil se m’havia escapat… Com ha acabat la cosa?

1 Like

De moment no ha tornat a passar… Així està la cosa…

2 Likes