From: | Oleg Serov <serovov(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgresql + corrupted disk = data loss. (Need help for database recover) |
Date: | 2011-12-02 01:08:10 |
Message-ID: | CAMkKa8AuJZ95Pe-_tiXV-eKK82_m4Fub680OQHax2_wYC-78Gg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello, i have a problem.
I've got a production server, working fine. Then i've got strange error:
> ERROR: right sibling's left-link doesn't match: block 147 links to 407
instead of expected 146 in index "order_status_key"'
And decidet to backup all server. So i shut-down VPS with server and backup
all data.
Then, after i booted it - and then - i've got Data loss.
I've lost data, that have been written to DB around 10-100 hours (different
tables, have different last updated value).
Then i've analyzed log, and found this:
7 days ago appears this errors:
db= LOG: could not rename temporary statistics file
"pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat":
db= WARNING: pgstat wait timeout
ERROR: missing chunk number 0 for toast value 2550017 in pg_toast_17076
5 days ago:
a lot of: ERROR: xlog flush request F/DC1A22D8 is not satisfied ---
flushed only to F/526512E0
83238 db= WARNING: could not write block 54 of base/16384/2619
83239 db= CONTEXT: writing block 54 of relation base/16384/2619
And today:
18 db= LOG: could not open file "pg_xlog/000000010000000F00000052"
(log file 15, segment 82):
19 db= ERROR: xlog flush request F/DC1A22D8 is not satisfied ---
flushed only to F/52FDF0E0
There is any ability to recover fresh data from database?
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Serov | 2011-12-02 01:10:15 | Re: Postgresql + corrupted disk = data loss. (Need help for database recover) |
Previous Message | Marcin Mańk | 2011-12-02 00:50:01 | Re: Query Optimizer makes a poor choice |