Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Ryan Senior commented on PDB-1031 Re: ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values We're targeting this as a bug fix, so it will be released in 2.3.x (maybe 2.3.1?). We would then hopefully make the next PE point release train. Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Rob Browning updated 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 Change By: Rob Browning Fix Version/s: PDB2.3.0 Fix Version/s: PDB2.3.x Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Kenneth Barber updated 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 Change By: Kenneth Barber Sprint: PuppetDB2014-12-17,PuppetDB2014-12-31 ,PuppetDB2015-02-11 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Kenneth Barber updated 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 Change By: Kenneth Barber Story Points: 5 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Ryan Senior updated 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 Change By: Ryan Senior Sprint: PuppetDB2014-12-17,PuppetDB2014-12-31 ,PuppetDB2015-01-28 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Kenneth Barber updated 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 Change By: Kenneth Barber Sprint: PuppetDB2014-12-17,PuppetDB2014-12-31,PuppetDB2015-01- 14 28 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Brian LaMetterey updated 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 Change By: Brian LaMetterey Sprint: PuppetDB2014-12-17,PuppetDB2014-12-31 ,PuppetDB2015-01-14 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Wyatt Alt commented on PDB-1031 Re: ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values Erik Lattimore Hey, I actually just started looking at this ticket. Like Ken mentioned above we had another user report essentially the same issue on the mailing list a few weeks ago, but with a different fact. Sounds like you did the same thing, but for posterity I ended up having him run these two queries to clear the issue: delete from fact_values where id not in (select distinct fact_value_id from facts); delete from fact_paths where id not in (select path_id from fact_values); We used those queries in the 2.2.0 release to garbage collect facts, but switched to garbage collection on fact updates for performance reasons. I think the issues you and Paul had indicate a bug, but I haven't been able to replicate it yet. I think it's just a strange coincidence that _timestamp is causing the issue. _timestamp would be present immediately after a migration from PDB 1.6.3, but would be deleted on the first fact update after the upgrade. It just happens that the update failed to run because the upgrade got your db into a bad state. In any case, thanks for the update and no need to close. Seems like a bug. Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Erik Lattimore commented on PDB-1031 Re: ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values Ok. We did have an odd install for a while. We were pinned to puppet 2.7 for quite a while as we converted our codebase to support puppet 3.x. During that time I believe we had a newer version of puppetdb installed but an older version of the terminus (or vice versa, I forget exactly) due to the dependencies and the nature of our apt:pin. This odd configuration might have been how we got into a state that you didn't expect. I also know that _timestamp had a few bugs relating to it in puppetdb ( PDB-337 ) so it might be hard to determine how we got into this bad state. Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Ryan Senior updated 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 Change By: Ryan Senior Sprint: PuppetDB2014-12-17 ,PuppetDB2014-12-31 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Kenneth Barber updated 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 Change By: Kenneth Barber Fix Version/s: PDB2.2.x 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Kenneth Barber updated 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 Change By: Kenneth Barber Sprint: PuppetDB2014-12-17 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Kenneth Barber commented on PDB-1031 Re: ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values Paul Seymour has also seen this here: https://groups.google.com/d/msgid/puppet-users/abee638f-5e75-410a-8fe2-7ff5acc8b7b2%40googlegroups.com?utm_medium=emailutm_source=footer 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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
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.
Jira (PDB-1031) ERROR: update or delete on table fact_paths violates foreign key constraint fact_values_path_id_fk on table fact_values
Title: Message Title Erik Lattimore updated 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 Change By: Erik Lattimore Higuys,eversinceanupgradetopuppet3.7(andacorrespondingupgradeofpuppetdbatthesametime)wehavebeengettingpostgreserrors.Weseemtoseethefollowingerroronthepuppetdbserveraftereveryinvocation:{noformat}Nov1711:01:52postgres[6379]:[1859-1]2014-11-1711:01:52ESTERROR:updateordeleteontablefact_pathsviolatesforeignkeyconstraintfact_values_path_id_fkontablefact_valuesNov1711:01:52postgres[6379]:[1859-2]2014-11-1711:01:52ESTDETAIL:Key(id)=(78)isstillreferencedfromtablefact_values.Nov1711:01:52postgres[6379]:[1859-3]2014-11-1711:01:52ESTSTATEMENT:COMMIT{noformat}It'salwaysthesamekeyID(78)thatitcomplainsabout.Wearerunningonpostgres9.1.Fromthefact_pathstable,theentrywithID78is:{noformat}id|value_type_id|depth|name|path+---+---++78|0|0|_timestamp|_timestamp{noformat}Ididn'tthink_timestampwassupposedtomakeitintopuppetdb?Thiscouldbearelicfromtheupgradethough. Inthefact_valuestable,thereare3entrieswhicharereferencingthe_timestampfact:{noformat}id|path_id|value_type_id|value_hash|value_integer|value_float|value_string|value_boolean|value_json-+-+---+--+---+-++---+2134865|78|0|226b3439f249f4fccfc7637e853c2b4a5e967160|||TueOct1413:48:04-04002014||2229630|78|0|14f01c68a6a7621cdcbc1bce80fb7e791b10a7df|||ThuOct1613:59:42-04002014||2172152|78|0|a4c93348ed4c2bb4fa6399512221512bf111f04b|||WedOct1508:38:29-04002014||{noformat} Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e)