Search Postgresql Archives

Re: postgres crash when select a record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



No, I didn't run the query when the DB is in recovering.

I did that after database system is ready


----- Original Message ----
From: Glyn Astill <glynastill@xxxxxxxxxxx>
To: mailtolouis2020-postgres@xxxxxxxxx; Postgres <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, May 14, 2008 6:07:23 PM
Subject: Re: [GENERAL] postgres crash when select a record

Looks loke you tried to run your query whilst postgres was recovering from an improper shutdown, try once again when the last thing in the log is

LOG:  database system is ready

----- Original Message ----
From: "mailtolouis2020-postgres@xxxxxxxxx" <mailtolouis2020-postgres@xxxxxxxxx>
To: Postgres <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, 14 May, 2008 5:07:03 PM
Subject: [GENERAL] postgres crash when select a record

Hello,
 
I wish some could help me on this.
 
I got a table which has 100500 records, when I try to query this particular record
 
select * from cs_sr_mthly_rtn where mthly_rtn_id = 61609;
Postgres crash, and show this errors:
 
server closed the connection unexpectedly
 This probably means the server terminated abnormally
 before or while processing the request.
 
And in the serverlog, it shows:
 
LOG:  server process (PID 395) was terminated by signal 11
LOG:  terminating any other active server processes
FATAL:  the database system is in recovery mode
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2008-05-14 12:52:15 BST
LOG:  checkpoint record is at 0/48DEC034
LOG:  redo record is at 0/48DEC034; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/705241; next OID: 49152
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 0/48DEC07C
LOG:  unexpected pageaddr 0/433AC000 in log file 0, segment 74, offset 3850240
LOG:  redo done at 0/4A3ABFC0
LOG:  database system is ready
 
Because of this, I'm not able to do pg_dump backup anymore.
 
Anyone can help me to solve this problem?
 
 
Thanks
louis


Sent from Yahoo! Mail.
A Smarter Email.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux