integer out of range errors for fact_values
Bug #924105 reported by
James Troup
This bug affects 5 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
puppet (Ubuntu) |
Confirmed
|
High
|
Unassigned |
Bug Description
Our puppet infrastructure recently ground to a halt as all nodes
errored out while trying to compile their catalogs with errors like
this:
| err: INSERT INTO "fact_values" ("created_at", "updated_at", "value", "fact_name_id", "host_id") VALUES('2012-01-31 05:00:47.693719', '2012-01-31 05:00:47.693719', E'Tue Jan 31 05:00:47 +0000 2012', 29, 88) RETURNING "id"
| err: Could not retrieve catalog from remote server: Error 400 on SERVER: PGError: ERROR: integer out of range
We ended up working around this by shutting everything down and
running the following as postgres:
| ALTER SEQUENCE fact_values_id_seq RESTART; UPDATE fact_values SET id = DEFAULT;
To post a comment you must log in.
This is filed upstream as http:// projects. puppetlabs. com/issues/ 9225 -
I filed this bug in the hope of adding a bug watch but didn't realise
Launchpad didn't support 'watching' Redmine yet.