Mix of explicit event definition IDs and CURRVAL results in unhappiness
Bug #957453 reported by
Dan Scott
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Evergreen |
Fix Released
|
Critical
|
Thomas Berezansky | ||
Bug Description
* Evergreen master
* PostgreSQL 9.1
I noticed when creating the database schema today that my PostgreSQL log contained the following:
ERROR: insert or update on table "event_params" violates foreign key constraint "event_
DETAIL: Key (event_def)=(100) is not present in table "event_definition".
STATEMENT: INSERT INTO action_
VALUES (currval(
This is because at line 7213 we use SETVAL to set the sequence value to 100.
But that breaks later, down on line 9212, when we use an explicit ID to create the event definition, but fall back to using CURRVAL on the sequence.
| Changed in evergreen: | |
| milestone: | none → 2.2.0beta1 |
Revision history for this message
| Dan Scott (denials) wrote | #1 |
| Changed in evergreen: | |
| importance: | Undecided → Critical |
| tags: | added: bitesize |
Revision history for this message
| Dan Scott (denials) wrote | #2 |
| Changed in evergreen: | |
| assignee: | nobody → Thomas Berezansky (tsbere) |
| Changed in evergreen: | |
| milestone: | 2.2.0beta1 → 2.2.0beta2 |
Revision history for this message
| Thomas Berezansky (tsbere) wrote | #3 |
| Changed in evergreen: | |
| milestone: | 2.2.0beta2 → 2.2.0beta1 |
| status: | New → Fix Committed |
| Changed in evergreen: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Marked as "Critical" because it should be a release blocker.