Skip site navigation (1) Skip section navigation (2)

primary and hot standby database don' work now

From: leo xu <leoxu8703(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: primary and hot standby database don' work now
Date: 2012-07-22 06:00:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
hello everyone:
              my pg version is 9.1.2 running on red hat 5.4 x64
day,i found all database indexes can't work,reindex database,it can work,but
some table has primary key,found exists the same two records in table.
             primary database error:
                         semop(id=13762606) failed: Identifier
                        ERROR,XX000,"right sibling's left-link doesn't
match: block 6260 links to 6977 instead of expected 6398 in index
                 WARNING,01000,"relation ""tt_telhis_src"" page 2390 is
uninitialized --- 
              hot standby:
                     2012-07-19 21:15:10.827
CST,,,19617,,5008085e.4ca1,1,,2012-07-19 21:15:10
CST,,0,LOG,00000,"streaming replication successfully connected to
2012-07-19 21:18:36.133 CST,,,476,,4fde7dd3.1dc,22,,2012-06-18 09:01:07
CST,1/0,0,WARNING,01000,"specified item offset is too large",,,,,"xlog redo
insert: rel 17673/16386/16780; tid 409/151",,,,""
2012-07-19 21:18:36.133 CST,,,476,,4fde7dd3.1dc,23,,2012-06-18 09:01:07
CST,1/0,0,PANIC,XX000,"btree_insert_redo: failed to add item",,,,,"xlog redo
insert: rel 17673/16386/16780; tid 409/151",,,,""
2012-07-19 21:18:36.204 CST,,,474,,4fde7dd3.1da,4,,2012-06-18 09:01:07
CST,,0,LOG,00000,"startup process (PID 476) was terminated by signal 6:
2012-07-19 21:18:36.204 CST,,,474,,4fde7dd3.1da,5,,2012-06-18 09:01:07
CST,,0,LOG,00000,"terminating any other active server processes",,,,,,,,,"" 

View this message in context:
Sent from the PostgreSQL - bugs mailing list archive at


pgsql-bugs by date

Next:From: leo xuDate: 2012-07-23 00:40:57
Subject: Duplicate rows primary key bug
Previous:From: Craig RingerDate: 2012-07-21 07:58:26
Subject: Re: BUG #6746: feature request

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group