And, i'm an idiot. My DB version: PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit
2011/12/2 Oleg Serov <sero...@gmail.com> > 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! > > > -- С уважением Олег
