crash during autovacuum

From: wambacher(at)posteo(dot)de
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: crash during autovacuum
Date: 2018-12-28 10:13:12
Message-ID: 22fb8ec4-67d8-314a-98db-91e2709106db@posteo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

this morning my database crashed, because of a problem during autovacuum.

this is the second time during the last 2 month and i can't find out why.

logfile:

2018-12-28 10:52:22 CET [23757-59] LOG:  Serverprozess (PID 14149) wurde
von Signal 6 beendet: Aborted
2018-12-28 10:52:22 CET [23757-60] DETAIL:  Der fehlgeschlagene Prozess
führte aus: autovacuum: VACUUM ANALYZE public.planet_osm_ways
2018-12-28 10:52:22 CET [23757-61] LOG:  aktive Serverprozesse werden
abgebrochen
2018-12-28 10:52:23 CET [26335-1] postgres(at)planet3 FATAL:  das
Datenbanksystem ist im Wiederherstellungsmodus
2018-12-28 10:52:23 CET [23757-62] LOG:  alle Serverprozesse beendet;
initialisiere neu
2018-12-28 10:52:25 CET [26402-1] postgres(at)planet3 FATAL:  das
Datenbanksystem ist im Wiederherstellungsmodus
2018-12-28 10:52:25 CET [26401-1] LOG:  Datenbanksystem wurde
unterbrochen; letzte bekannte Aktion am 2018-12-28 10:50:10 CET

that's all i get :(

it is a really big table (552.669.751 records, 228 GB data + indices)
and the last two autovacuum analyze did well. running for a really long
time (> 2 days) but without any (known) problems.

any idea what's going on and what i can do?

Regards
walter

--
My projects:

Admin Boundaries of the World <https://wambachers-osm.website/boundaries>
Missing Boundaries
<https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries>
Emergency Map <https://wambachers-osm.website/emergency>
Postal Code Map (Germany only) <https://wambachers-osm.website/plz>
Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>
Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundaries>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-12-28 11:07:16 Re: crash during autovacuum
Previous Message arvind chikne 2018-12-26 07:42:00 Re: PgpoolII auto fail-over