BUG #14736: Crash on postgresql server by autovacuum worker process

From: jothiprasath21(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: jothiprasath21(at)gmail(dot)com
Subject: BUG #14736: Crash on postgresql server by autovacuum worker process
Date: 2017-07-07 05:56:26
Message-ID: 20170707055626.9033.31948@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14736
Logged by: JOE
Email address: jothiprasath21(at)gmail(dot)com
PostgreSQL version: 9.3.14
Operating system: CentOS release 6.7 (Final)
Description:

I got the following stack trace after the crash and i'm not sure what were
the queries executing at the point of time.
This got failed in XLogFileInit () and it is running fine on a restart.

Core was generated by `postgres: autovacuum worker process icon
'.
Program terminated with signal 6, Aborted.
#0 0x00007fdda6972625 in raise (sig=<value optimized out>) at
../nptl/sysdeps/unix/sysv/linux/raise.c:64
64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
Missing separate debuginfos, use: debuginfo-install
postgresql93-server-9.3.14-1PGDG.rhel6.x86_64
(gdb) bt full
#0 0x00007fdda6972625 in raise (sig=<value optimized out>) at
../nptl/sysdeps/unix/sysv/linux/raise.c:64
resultvar = 0
pid = <value optimized out>
selftid = <value optimized out>
#1 0x00007fdda6973e05 in abort () at abort.c:92
save_stage = 2
act = {__sigaction_handler = {sa_handler = 0x7fff6fe91f80,
sa_sigaction = 0x7fff6fe91f80}, sa_mask = {__val = {12037408, 0, 7663537,
140735070937200, 8898152,
140589959244632, 140589986960592, 140735070937312, 4294967295,
140735070937312, 1, 11638160, 0, 0, 0, 0}}, sa_flags = -1474629440,
sa_restorer = 0x1}
sigs = {__val = {32, 0 <repeats 15 times>}}
#2 0x0000000000731859 in errfinish ()
No symbol table info available.
#3 0x00000000004b7e93 in XLogFileInit ()
No symbol table info available.
#4 0x00000000004b813d in ?? ()
No symbol table info available.
#5 0x00000000004b9987 in XLogFlush ()
No symbol table info available.
#6 0x00000000004aa3e8 in ?? ()
No symbol table info available.
#7 0x00000000004aa66d in ?? ()
No symbol table info available.
#8 0x00000000004ab975 in CommitTransactionCommand ()
No symbol table info available.
#9 0x000000000057da0a in vacuum ()
No symbol table info available.
#10 0x0000000000610175 in ?? ()
No symbol table info available.
#11 0x0000000000610616 in ?? ()
No symbol table info available.
#12 0x00000000006106e6 in StartAutoVacWorker ()
No symbol table info available.
#13 0x000000000061af52 in ?? ()
No symbol table info available.
#14 <signal handler called>
No symbol table info available.
#15 0x00007fdda6a21393 in __select_nocancel () at
../sysdeps/unix/syscall-template.S:82
No locals.
#16 0x000000000061c380 in PostmasterMain ()
No symbol table info available.
#17 0x00000000005b8428 in main ()

Thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message K S, Sandhya (Nokia - IN/Bangalore) 2017-07-07 07:10:08 Re: Postgres process invoking exit resulting in sh-QUIT core
Previous Message Dilip Kumar 2017-07-07 04:22:54 Re: BUG #14733: unexpected query result