| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | kyle(dot)kinnear(at)welchallyn(dot)com |
| Subject: | BUG #15117: Duplicate Primary Key |
| Date: | 2018-03-16 20:49:29 |
| Message-ID: | 152123336924.1215.1160410866220981019@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15117
Logged by: Kyle Kinnear
Email address: kyle(dot)kinnear(at)welchallyn(dot)com
PostgreSQL version: 9.6.6
Operating system: Windows 10 Enterprise - 14393.2035
Description:
Hello,
While running some performance simulations on a test application server
overnight, I came back to some odd errors. I was then able to trace it back
to the primary index of this table being duplicated.
Here is the information for the table, done from an export:
reco_id modality user_id file_name update_ts groups_fk
9 4 1 UserPreferences.xml 2018-02-14 21:35:33.122 7
10 4 1 UserPreferences.xml 2018-02-14 21:35:34.903 8
6 0 3 ExMgrUserPreferences.xml 2018-02-08 20:40:59.869 -1
5 255 3 CFDL.XML 2018-02-08 20:41:01.619 -1
3 4 1 UserPreferences.xml 2018-03-09 21:13:54.36817 1
12 0 4 ExMgrUserPreferences.xml 2018-02-14 22:23:10.212115 -1
11 255 4 CFDL.XML 2018-02-14 22:23:11.965623 -1
13 4 4 UserPreferences.xml 2018-02-14 22:23:11.965623 7
16 4 5 UserPreferences.xml 2018-02-14 22:24:43.012535 8
15 0 5 ExMgrUserPreferences.xml 2018-02-14 22:24:41.304534 -1
14 255 5 CFDL.XML 2018-02-14 22:24:43.012535 -1
1 255 1 CFDL.XML 2018-03-09 21:13:54.36817 -1
2 0 1 ExMgrUserPreferences.xml 2018-03-16 14:58:44.621422 -1
2 0 1 ExMgrUserPreferences.xml 2018-03-16 14:58:44.621422 -1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2018-03-16 22:37:04 | Re: BUG #15116: pg_recvlogical always fails |
| Previous Message | Joseph B | 2018-03-16 20:30:53 | Re: BUG #15036: Un-killable queries Hanging in BgWorkerShutdown |