Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql hanging

psql hanging

From
"David J. Trombley"
Date:


    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

Re: psql hanging

From
Tom Lane
Date:
"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