From: wambacher@posteo.de
To: pgsql-admin@lists.postgresql.org
Subject: crash during autovacuum
Date: Fri, 28 Dec 2018 11:13:12 +0100
Message-ID: <22fb8ec4-67d8-314a-98db-91e2709106db@posteo.de> (raw)
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@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@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-boun...;
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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wambacher@posteo.de, pgsql-admin@lists.postgresql.org
Subject: Re: crash during autovacuum
In-Reply-To: <22fb8ec4-67d8-314a-98db-91e2709106db@posteo.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox