Thread: backend closed the channel unexpectedly everytime!

backend closed the channel unexpectedly everytime!

From
"Vilson farias"
Date:
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.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179