[BUGS] primary and hot standby database don' work now
hello everyone: my pg version is 9.1.2 running on red hat 5.4 x64 servers.one 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 removed",," ... ERROR,XX000,"right sibling's left-link doesn't match: block 6260 links to 6977 instead of expected 6398 in index ""tt_wait_artifident_ck_20120716_pk""",," ... 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,0,"streaming replication successfully connected to primary","" 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,0,"startup process (PID 476) was terminated by signal 6: Aborted","" 2012-07-19 21:18:36.204 CST,,,474,,4fde7dd3.1da,5,,2012-06-18 09:01:07 CST,,0,LOG,0,"terminating any other active server processes","" -- View this message in context: http://postgresql.1045698.n5.nabble.com/primary-and-hot-standby-database-don-work-now-tp5717562.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #6748: sequence value may be conflict in some cases
The following bug has been logged on the website: Bug reference: 6748 Logged by: Xiangming Mei Email address: meixiangm...@huawei.com PostgreSQL version: 9.1.4 Operating system: SUSE 11 X64 Description: Reproduce steps: 1. create a table using serial such as: CREATE TABLE tbl_aaa ( sno serial NOT NULL, //自增序列，等同于sequence userid int NOT NULL, CONSTRAINT tbl_aaa_pkey PRIMARY KEY (sno) ); 2. insert a tuple: INSERT INTO tbl_aaa values (DEFAULT, 1); 3. postgersql instance crashed, may be power lost or killed by someone: 4. restart the instance then insert another tuple into tbl_aaa, you will get a error message: INSERT INTO tbl_aaa values (DEFAULT, 2); ERROR: SQLSTATE 23505: duplicate key value violates unique constraint "tbl_aaa_pkey" LOCATION: _bt_check_unique, nbtinsert.c:300 I think this is because there is no logit when 'is_called' become from 'f' to 't'. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Duplicate rows primary key bug
version - PostgreSQL 9.1.2 on red hat 5.4 x64, compiled by GCC 4.1 There are several tables have two same rows with the same primary key. This shouldn't happen. Has this been reported as a bug in this version? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Duplicate-rows-primary-key-bug-tp5717581.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Duplicate rows primary key bug
Hello 2012/7/23 leo xu : > version > - > PostgreSQL 9.1.2 on red hat 5.4 x64, compiled by GCC 4.1 > > > There are several tables have two same rows with the same primary key. This > shouldn't happen. Has this been reported as a bug in this version? > you index is broken - the source of this issue should be in hw or in sw. Can you repeat a operations that breaks your indexes? Regards Pavel Stehule > > > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Duplicate-rows-primary-key-bug-tp5717581.html > Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
