Skip site navigation (1) Skip section navigation (2)

backend closed the channel unexpectedly

From: Andreas Wernitznig <andreas(at)insilico(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: backend closed the channel unexpectedly
Date: 2001-09-07 23:14:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
This is the last part of a "vacuum verbose analyze;":

NOTICE:  --Relation pg_toast_17058--
NOTICE:  Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 9: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 113, MaxLen 2034; Re-using: Free/Avai
l. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE:  Index pg_toast_17058_idx: Pages 2; Tuples 9. CPU 0.00s/0.00u sec.
NOTICE:  Analyzing...
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

This usually happens after some millions of rows are inserted into the database.
What can I do to avoid this error?



pgsql-bugs by date

Next:From: Tom LaneDate: 2001-09-07 23:36:34
Subject: Re: backend closed the channel unexpectedly
Previous:From: Tom LaneDate: 2001-09-07 21:16:47
Subject: Re: Logging problems in PostgreSQL 7.2devel

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group