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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs