Re: is there any backend timeout undocumented?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: NunoACHenriques <nach(at)fct(dot)unl(dot)pt>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: is there any backend timeout undocumented?
Date: 2002-05-27 21:18:42
Message-ID: 27440.1022534322@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

NunoACHenriques <nach(at)fct(dot)unl(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2002-05-27 21:19:35 Re: Interval oddities
Previous Message Bruce Momjian 2002-05-27 21:17:58 Re: WAL FILES