psql hanging

Started by Dave Trombleyover 23 years ago2 messagesgeneral
Jump to latest
#1Dave Trombley
dtrom@bumba.net

I'm running 7.2.2 on x86 linux, and trying to execute a very large
(200Mb or so) sql script by cat'ing it to psql.

After about 2000 lines, psql hangs.

An strace yields the following output after the process is in the
hung state:

rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigaction(SIGINT, {0x804d528, [], SA_RESTART|0x4000000},
{0x804d528, [], SA_RESTART|0x4000000}, 8) = 0

over and over again.

After I kill the process, the server doesn't need to be restarted
for a new psql instance to function; it seems just this
conenction/process is messed up.

Any ideas?

-dj

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dave Trombley (#1)
Re: psql hanging

"David J. Trombley" <dtrom@bumba.net> writes:

I'm running 7.2.2 on x86 linux, and trying to execute a very large
(200Mb or so) sql script by cat'ing it to psql.
After about 2000 lines, psql hangs.
An strace yields the following output after the process is in the
hung state:
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigaction(SIGINT, {0x804d528, [], SA_RESTART|0x4000000},
{0x804d528, [], SA_RESTART|0x4000000}, 8) = 0
over and over again.

Can't guess much from that. Could you attach to the hung process with
gdb and get a stack trace?

regards, tom lane