Re: is there any backend timeout undocumented? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: is there any backend timeout undocumented?
Date
Msg-id 27440.1022534322@sss.pgh.pa.us
Whole thread Raw
In response to is there any backend timeout undocumented?  (NunoACHenriques <nach@fct.unl.pt>)
List pgsql-hackers
NunoACHenriques <nach@fct.unl.pt> writes:
>     Is there any server timeout that is undocumented?

No.

> 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.

This looks like a crash to me, not a timeout.  Can you provide us with a
stack backtrace?  Also, you'd better explain what construct_warehouse()
is doing.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Marcia Abade
Date:
Subject: NO CREATE TABLE
Next
From: Tom Lane
Date:
Subject: Re: strange update problem with 7.2.1