Обсуждение: psql hanging

Поиск
Список
Период
Сортировка

psql hanging

От
"David J. Trombley"
Дата:


    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

От
Tom Lane
Дата:
"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