Hangs on Semop

Поиск
Список
Период
Сортировка
Искать
От
Gary Mensenares
Тема
Hangs on Semop
Дата
Msg-id
000001c45442$a4040c80$c41ba7cb@jugster2
Список
Дерево обсуждения
Hangs on Semop "Gary Mensenares" <jug@callworx.com>
Re: Hangs on Semop Tom Lane <tgl@sss.pgh.pa.us>
Hello all!
 
I was just wondering if anyone else here has ever experienced Postgres
hanging on an INSERT or DELETE command?
 
Here is my setup:
DB:       Postgres 7.3.4
OS:      Fedora Core 1
Kernel:  2.4.22
 
The behavior is quite erratic. Using the exact same test script,
sometimes it runs and sometimes it hangs so it is rather difficult to
recreate the condition. We did an strace on postgres and got this:
 
postgres 14648  0.0  0.7 12524 4012 pts/2    S    03:30   0:00 postgres:
jug ubp [local] DELETE waiting
 
#strace -p 14648
Process 14648 attached - interrupt to quit
semop(851970, 0xbfe2bce0, 1
 
Nothing extraordinary shows up on the postgres logs itself.
 
Thanks for whatever help you can extend!
В списке pgsql-bugs по дате отправления
От: Jim Helm
Дата:
От: Tom Lane
Дата:
Сообщение: Re: Hangs on Semop
FAQ