backend closed the channel unexpectedly everytime!

From: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: backend closed the channel unexpectedly everytime!
Date: 2003-03-28 19:22:51
Message-ID: 004501c2f55f$700c55b0$98a0a8c0@dgtac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

It's the first time I face this situation, but my database can't let me
connect anyway. How can I proceed to recover information stored there? Its a
very important database and I need to recover information at any cost. I'm
still on PostgreSQL 7.1.2 with RedHat 6.2. It's an embeded system so I can't
upgrade to a newer PostgreSQL release at this time.

There wasn't reboots or system hangups when problem ocurred for the first
time.

Here is some information about connection attempts.

$ pg_ctl start
postmaster successfully started
$ DEBUG: database system was shut down at 2003-03-28 15:25:38 BRT
DEBUG: CheckPoint record at (7, 479465352)
DEBUG: Redo record at (7, 479465352); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 9026840; NextOid: 5484180
DEBUG: database system is in production state

$
$ psql template1
Server process (pid 30916) exited with status 11 at Fri Mar 28 15:25:59 2003
Terminating any active server processes...
Server processes were terminated at Fri Mar 28 15:25:59 2003
Reinitializing shared memory and semaphores
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
connection to server was lost
$ DEBUG: database system was interrupted at 2003-03-28 15:25:48 BRT
DEBUG: CheckPoint record at (7, 479465352)
DEBUG: Redo record at (7, 479465352); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 9026840; NextOid: 5484180
DEBUG: database system was not properly shut down; automatic recovery in
progress...
DEBUG: ReadRecord: record with zero len at (7, 479465416)
DEBUG: redo is not required
DEBUG: database system is in production state
Server process (pid 31844) exited with status 11 at Fri Mar 28 15:26:04 2003
Terminating any active server processes...
Server processes were terminated at Fri Mar 28 15:26:04 2003
Reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2003-03-28 15:26:01 BRT
DEBUG: CheckPoint record at (7, 479465416)
DEBUG: Redo record at (7, 479465416); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 9026840; NextOid: 5484180
DEBUG: database system was not properly shut down; automatic recovery in
progress...
DEBUG: ReadRecord: record with zero len at (7, 479465480)
DEBUG: redo is not required
$ DEBUG: database system is in production state
$

$ pg_ctl stop
Smart Shutdown request at Fri Mar 28 15:39:13 2003
DEBUG: shutting down
waiting for postmaster to shut down.....DEBUG: database system is shut down
done
postmaster successfully shut down

Best regards,

----------------------------------------------------------------------------
----
José Vilson de Mello de Farias
Software Engineer

Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson(dot)farias(at)digitro(dot)com(dot)br
Tel.: +55 48 281 7158
ICQ 11866179

Browse pgsql-admin by date

  From Date Subject
Next Message Tamir Halperin 2003-03-29 08:18:47 Hope it's ok to post a pgAdmin request for help in this list...
Previous Message A.M. 2003-03-28 17:07:54 Realistic upper bounds on table size