Re: postgres crash when select a record

LinkBack

Thread Tools

Display Modes

#1 (permalink)

05-16-2008, 01:41 PM

mailtolouis2020-postgres@yahoo.com

Posts: n/a

Re: postgres crash when select a record

Hello,
Yes, I deleted that record, and now my backup is working fine! Thanks
But why this problem came out? Is there anyway to trace it down and*how it happen? Or is it a bug of postgres?
Regards
Louis

----- Original Message ----
From: Pavel Stehule <pavel.stehule@gmail.com>
To: mailtolouis2020-postgres@yahoo.com
Cc: Postgres <pgsql-general@postgresql.org>
Sent: Wednesday, May 14, 2008 6:13:05 PM
Subject: Re: [GENERAL] postgres crash when select a record

Hello

Delete this broken row

Regards
Pavel Stehule

2008/5/14* <mailtolouis2020-postgres@yahoo.com>:
> 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 inlog 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 thisproblem?
>
>
> Thanks
> louis

« Re: postgres crash when select a record | PG -v- MySQL »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 10:14 PM.

SEO

Re: postgres crash when select a record