I think, the main problem is that, postgres reads wrong xlog-s file.
I lunched strace to postgres process, and then i grep the log:
# cat /tmp/strace-log | fgrep xlog
5546 stat("pg_xlog", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
5546 stat("pg_xlog/archive_status", {st_mode=S_IFDIR|0700, s
On 2.12.2011 09:16, Oleg Serov wrote:
> Hello!
>
> i've don't try to do reindex. There was enough space.
Not sure whether you tried to reindex or not. And what do you mean by
'there was enough space'? For example with ext2 (and ext3/ext4) it was
rather simple to exhaust inodes long before the dev
On 12/02/2011 09:08 AM, Oleg Serov wrote:
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 toa
Hello!
i've don't try to do reindex. There was enough space.
And i have a full data-directory backup, when i've stop server, before
start.
2011/12/2 Venkat Balaji
>
> 2011/12/2 Oleg Serov
>
>> And, i'm an idiot.
>>
>> My DB version:
>> PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by
2011/12/2 Oleg Serov
> 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
>
>> Hello, i have a problem.
>>
>> I've got a production server, working fine. Then i've
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
> Hello, i have a problem.
>
> I've got a production server, working fine. Then i've got strange error:
> > ERROR: right sibl
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 back