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