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

Поиск
Список
Период
Сортировка
От jothiprasath21@gmail.com
Тема [BUGS] BUG #14736: Crash on postgresql server by autovacuum worker process
Дата
Msg-id 20170707055626.9033.31948@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14736: Crash on postgresql server by autovacuum worker process  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14736
Logged by:          JOE
Email address:      jothiprasath21@gmail.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
optimizedout>
 
#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



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: [BUGS] BUG #14733: unexpected query result
Следующее
От: "K S, Sandhya (Nokia - IN/Bangalore)"
Дата:
Сообщение: [BUGS] Re: [HACKERS] Postgres process invoking exit resulting in sh-QUITcore