Re: plperl db crash - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: plperl db crash
Date
Msg-id 3F7DCA2D.5090207@e-trolley.de
Whole thread Raw
In response to Re: plperl db crash  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-novice
Oliver Elphick wrote:
> I'm just uploading 7.3.4-6 to unstable.
>
> I've tested this function with that release and your problem does not
> occur on my system, but I'm not aware of having done anything to affect
> it.
>

Here's the strace output:

---------------------------------------8<---------------------------------
)    = 1 (in [4], left {288, 80000})
--- SIGCHLD (Child exited) @ 0 (0) ---
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS],
NULL, 8) = 0
waitpid(-1, [WIFSIGNALED(s) && WTERMSIG(s) == SIGSEGV && WCOREDUMP(s)],
WNOHANG) = 6147
time(NULL)                              = 1065208172
socket(PF_UNIX, SOCK_DGRAM, 0)          = 8
fcntl64(8, F_SETFD, FD_CLOEXEC)         = 0
connect(8, {sa_family=AF_UNIX, path="/dev/log"}, 16) = 0
time([1065208172])                      = 1065208172
getpid()                                = 6136
rt_sigaction(SIGPIPE, {0x40334540, [], SA_RESTORER, 0x40289578},
{SIG_IGN}, 8) = 0
send(8, "<134>Oct  3 21:09:32 postgres[61"..., 100, 0) = 100
rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
time(NULL)                              = 1065208172
time([1065208172])                      = 1065208172
getpid()                                = 6136
rt_sigaction(SIGPIPE, {0x40334540, [], SA_RESTORER, 0x40289578},
{SIG_IGN}, 8) = 0
send(8, "<134>Oct  3 21:09:32 postgres[61"..., 92, 0) = 92
rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
send(5, "\2\0\0\0\30\0\0\0\0\0\0\0\3\30\0\0\0\0\0\0\0\0\0\0", 24, 0) = 24
waitpid(-1, 0xbffff39c, WNOHANG)        = 0
time(NULL)                              = 1065208172
time([1065208172])                      = 1065208172
getpid()                                = 6136
rt_sigaction(SIGPIPE, {0x40334540, [], SA_RESTORER, 0x40289578},
{SIG_IGN}, 8) = 0
send(8, "<134>Oct  3 21:09:32 postgres[61"..., 123, 0) = 123
rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
semctl(983040, 0, IPC_RMID, 0xbffff2dc) = 0
semctl(1015809, 0, IPC_RMID, 0xbffff2dc) = 0
semctl(1048578, 0, IPC_RMID, 0xbffff2dc) = 0
semctl(1081347, 0, IPC_RMID, 0xbffff2dc) = 0
semctl(1114116, 0, IPC_RMID, 0xbffff2dc) = 0
shmdt(0x4040a000)                       = 0
shmctl(3768320, IPC_RMID, 0)            = 0
shmget(5432001, 9732096, IPC_CREAT|IPC_EXCL|0600) = 3801111
shmat(3801111, 0, 0)                    = 0x4040a000
open("/var/lib/postgres/data/postmaster.pid", O_RDWR|O_LARGEFILE) = 9
read(9, "6136\n/var/lib/postgres/data\n  54"..., 8092) = 48
_llseek(9, 0, [0], SEEK_SET)            = 0
write(9, "6136\n/var/lib/postgres/data\n  54"..., 48) = 48
close(9)                                = 0
getpid()                                = 6136
open("/var/lib/postgres/data/global/pg_control", O_RDWR|O_LARGEFILE) = 9
read(9, "\23\240^\34?\350\375<H\0\0\0M\372\356\v\4\0\0\0`\311}?"...,
360) = 360
close(9)                                = 0
semget(5432001, 17, IPC_CREAT|IPC_EXCL|0600) = 1146880
semctl(1146880, 16, SETVAL, 0xbffff23c) = 0
semop(1146880, 0xbffff2a4, 1)           = 0
semctl(1146880, 0, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 1, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 2, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 3, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 4, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 5, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 6, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 7, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 8, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 9, SETVAL, 0xbffff26c)  = 0
semctl(1146880, 10, SETVAL, 0xbffff26c) = 0
semctl(1146880, 11, SETVAL, 0xbffff26c) = 0
semctl(1146880, 12, SETVAL, 0xbffff26c) = 0
semctl(1146880, 13, SETVAL, 0xbffff26c) = 0
semctl(1146880, 14, SETVAL, 0xbffff26c) = 0
semctl(1146880, 15, SETVAL, 0xbffff26c) = 0
semget(5432002, 17, IPC_CREAT|IPC_EXCL|0600) = 1179649
semctl(1179649, 16, SETVAL, 0xbffff23c) = 0
semop(1179649, 0xbffff2a4, 1)           = 0
semctl(1179649, 0, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 1, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 2, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 3, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 4, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 5, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 6, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 7, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 8, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 9, SETVAL, 0xbffff26c)  = 0
semctl(1179649, 10, SETVAL, 0xbffff26c) = 0
semctl(1179649, 11, SETVAL, 0xbffff26c) = 0
semctl(1179649, 12, SETVAL, 0xbffff26c) = 0
semctl(1179649, 13, SETVAL, 0xbffff26c) = 0
semctl(1179649, 14, SETVAL, 0xbffff26c) = 0
semctl(1179649, 15, SETVAL, 0xbffff26c) = 0
semget(5432003, 17, IPC_CREAT|IPC_EXCL|0600) = 1212418
semctl(1212418, 16, SETVAL, 0xbffff23c) = 0
semop(1212418, 0xbffff2a4, 1)           = 0
semctl(1212418, 0, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 1, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 2, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 3, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 4, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 5, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 6, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 7, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 8, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 9, SETVAL, 0xbffff26c)  = 0
semctl(1212418, 10, SETVAL, 0xbffff26c) = 0
semctl(1212418, 11, SETVAL, 0xbffff26c) = 0
semctl(1212418, 12, SETVAL, 0xbffff26c) = 0
semctl(1212418, 13, SETVAL, 0xbffff26c) = 0
semctl(1212418, 14, SETVAL, 0xbffff26c) = 0
semctl(1212418, 15, SETVAL, 0xbffff26c) = 0
semget(5432004, 17, IPC_CREAT|IPC_EXCL|0600) = 1245187
semctl(1245187, 16, SETVAL, 0xbffff23c) = 0
semop(1245187, 0xbffff2a4, 1)           = 0
semctl(1245187, 0, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 1, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 2, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 3, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 4, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 5, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 6, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 7, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 8, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 9, SETVAL, 0xbffff26c)  = 0
semctl(1245187, 10, SETVAL, 0xbffff26c) = 0
semctl(1245187, 11, SETVAL, 0xbffff26c) = 0
semctl(1245187, 12, SETVAL, 0xbffff26c) = 0
semctl(1245187, 13, SETVAL, 0xbffff26c) = 0
semctl(1245187, 14, SETVAL, 0xbffff26c) = 0
semctl(1245187, 15, SETVAL, 0xbffff26c) = 0
semget(5432005, 17, IPC_CREAT|IPC_EXCL|0600) = 1277956
semctl(1277956, 16, SETVAL, 0xbffff23c) = 0
semop(1277956, 0xbffff2a4, 1)           = 0
semctl(1277956, 0, SETVAL, 0xbffff26c)  = 0
brk(0)                                  = 0x827d000
brk(0x829e000)                          = 0x829e000
fork()                                  = 6148
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
sigreturn()                             = ? (mask now [])
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS],
NULL, 8) = 0
accept(4, {sa_family=AF_UNIX, path=@}, [2]) = 9
getsockname(9, {sa_family=AF_UNIX,
path="/var/run/postgresql/.s.PGSQL.5432"}, [36]) = 0
fork()                                  = 6149
close(9)                                = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS],
NULL, 8) = 0
waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], WNOHANG) = 6149
send(5, "\2\0\0\0\30\0\0\0\0\0\0\0\5\30\0\0\0\0\0\0\0\0\0\0", 24, 0) = 24
waitpid(-1, 0xbffff39c, WNOHANG)        = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
sigreturn()                             = ? (mask now [])
select(5, [3 4], [], NULL, {60, 0} <unfinished ...>

---------------------------------8<-------------------------------------


--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: cancel request in progress
Next
From: "Menke, Kurt"
Date:
Subject: importing data automatically