Re: crash during autovacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux