[Bug 924105] [NEW] integer out of range errors for fact_values

[James Troup]

Public bug reported:

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;

** Affects: puppet (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to puppet in Ubuntu.
https://bugs.launchpad.net/bugs/924105

Title:
  integer out of range errors for fact_values

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/puppet/+bug/924105/+subscriptions