Обсуждение: is there any backend (server) timeout undocumented?

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

is there any backend (server) timeout undocumented?

От
NunoACHenriques
Дата:
    Hi!

    I have sended the message below to pgadmin-support (by mistake I
think) and to pgsql-hackers but receive no answers... I hope you can help me
on this...

    Is there any server timeout that is undocumented?

    I've issued a query like the one below and the server timed out after
120min (+/-). The query "construct_warehouse()" can last well above the
120min because it fills a table with millions of tuples... I really believe
in PostgreSQL! :-)

----------------------------------------------------------------------------
spid=> vacuum full analyze ; select construct_warehouse() ; vacuum analyze ;
NOTICE:  Skipping "pg_group" --- only table or database owner can VACUUM it
NOTICE:  Skipping "pg_database" --- only table or database owner can VACUUM it
NOTICE:  Skipping "pg_shadow" --- only table or database owner can VACUUM it
VACUUM
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
You are currently not connected to a database.
!> \q
----------------------------------------------------------------------------

    I've searched the archives for some documented timeout but nothing...

    I've searched the postgresql.conf file and nothing...

    Can anyone help me? Thanks in advance!

    Note: the first time I noticed a time out was using a JDBC driver and
then I've tested in the pgsql console to confirm it.

    Please reply to: nach@fct.unl.pt. I'm not a member of this list.

--
     o__        Bem haja,
    _.>/ _            NunoACHenriques
   (_) \(_)            ~~~~~~~~~~~~~~~
                http://students.fct.unl.pt/users/nuno/

Re: is there any backend (server) timeout undocumented?

От
Martijn van Oosterhout
Дата:
On Sat, May 25, 2002 at 07:39:02PM +0100, NunoACHenriques wrote:
>     Hi!
>
>     I have sended the message below to pgadmin-support (by mistake I
> think) and to pgsql-hackers but receive no answers... I hope you can help me
> on this...
>
>     Is there any server timeout that is undocumented?
>
>     I've issued a query like the one below and the server timed out after
> 120min (+/-). The query "construct_warehouse()" can last well above the
> 120min because it fills a table with millions of tuples... I really believe
> in PostgreSQL! :-)

Sounds to me like you're running out of memory. What version of postgres are
you using? What does ps aux show while the query is running.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America