Re: crash during autovacuum

Hi Walter,

It is very hard to say, but I fear that there may be a disk level issue
(corruption) and this table might be getting participating in the
autovacuum process initial for these 2 crashes.

To reconfirm maybe you can verify by taking a logical dump for this
particular table or whole database once if there any disk level or block
level corruption, and it may be causing that test to be avoided from the
fearing out during the tuning operation.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Fri, Dec 28, 2018 at 3:43 PM <wambacher(at)posteo(dot)de> wrote:

> 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>
>