| From: | meixiangming(at)huawei(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #6748: sequence value may be conflict in some cases |
| Date: | 2012-07-23 01:51:56 |
| Message-ID: | E1St7oS-0004Rg-Oc@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
The following bug has been logged on the website:
Bug reference: 6748
Logged by: Xiangming Mei
Email address: meixiangming(at)huawei(dot)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'.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2012-07-23 06:33:18 | Re: Duplicate rows primary key bug |
| Previous Message | leo xu | 2012-07-23 00:40:57 | Duplicate rows primary key bug |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit kapila | 2012-07-23 03:48:45 | FW: Patch for option in pg_resetxlog for restore from WAL files |
| Previous Message | Noah Misch | 2012-07-22 23:50:03 | Re: Restrict ALTER FUNCTION CALLED ON NULL INPUT (was Re: Not quite a security hole: CREATE LANGUAGE for non-superusers) |