Jira (PDB-1031) ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values"

[Erik Lattimore (JIRA)]

Title: Message Title

Erik Lattimore created an issue   PuppetDB / PDB-1031 ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values" Issue Type: Bug Affects Versions: 2.2.2 Assignee: Unassigned Created: 2014/11/17 10:04 AM Priority: Normal Reporter: Erik Lattimore Hi guys, ever since an upgrade to puppet 3.7 (and a corresponding upgrade of puppetdb at the same time) we have been getting postgres errors. We seem to see the following error on the puppetdb server after every invocation: Nov 17 11:01:52 postgres[6379]: [1859-1] 2014-11-17 11:01:52 EST ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values" Nov 17 11:01:52 postgres[6379]: [1859-2] 2014-11-17 11:01:52 EST DETAIL: Key (id)=(78) is still referenced from table "fact_values". Nov 17 11:01:52 postgres[6379]: [1859-3] 2014-11-17 11:01:52 EST STATEMENT: COMMIT It's always the same key ID (78) that it complains about. We are running on postgres 9.1. From the fact_paths table, the entry with ID 78 is: id | value_type_id | depth | name | path ----+---------------+-------+------------+------------ 78 | 0 | 0 | _timestamp | _timestamp I didn't think _timestamp was supposed to make it into puppetdb? This could be a relic from the upgrade though. Add Comment   This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.