Manually deleting that row (id=22128) in fact_values might also do the trick if it's only one affected node/value, but wouldn't tell much about how you got to this state so could be leaving something broken. It would be interesting to get the discarded tarball in any case.
On Fri, Nov 21, 2014 at 8:57 AM, Wyatt Alt <wy...@puppetlabs.com> wrote: > Paul, > > Thanks for that. It looks like 22128 has not been cleaned up properly for > some reason, and it's likely being skipped over in the gc process because > the facts cleanup identifies values to delete from that column in the facts > table. > > Are there failed commands in your /var/lib/puppetdb/mq/discarded directory > you can tie this to? I'd like to take a look at that if you can send me a > tarball. > > This issue would likely disappear if you dropped and recreated the > puppetdb database and allowed the nodes to repopulate it, but that could > take some maneuvering depending on your situation/data needs. > > Wyatt > > > On 11/20/14 12:29 AM, Paul Seymour wrote: > > > > On Wednesday, 19 November 2014 17:56:23 UTC, Wyatt Alt wrote: >> >> Hey Paul, >> >> That's some kind of DB corruption. Shouldn't be happening. Do you have >> any sense of when this started or whether it was tied to a recent >> upgrade? Is there a stacktrace in your logs that you could gist? Does it >> happen on every agent run or only occasionally? Is it always the same >> path_id like in the other ticket? >> >> Also would you mind reporting the output of this? >> >> select * from facts where fact_value_id in (50319,22128); >> >> > Thanks Wyatt, > > I cannot be sure if this is tied to an upgrade specifically but I just > happened to be keeping an eye > on the logs a little more lately (working on an ELK thing to monitoring > them). > > A stack trace is available at > https://gist.github.com/PsychoSid/b1a479d7d6fec7477263 > > The output from the select is:- > $ psql > psql (9.3.5) > Type "help" for help. > > postgres=# \c puppetdb > You are now connected to database "puppetdb" as user "postgres". > puppetdb=# select * from facts where fact_value_id in (50319,22128); > factset_id | fact_value_id > ------------+--------------- > 22 | 50319 > (1 row) > > Hope this helps. > > Cheers > Paul > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/7baf1653-d0b4-4fcf-8bcb-039b43af99a5%40googlegroups.com > <https://groups.google.com/d/msgid/puppet-users/7baf1653-d0b4-4fcf-8bcb-039b43af99a5%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAJDiH3EtXEdC-5MvuC-aOZxAYAvk9ja3ZOShtd6p5J6nPKoT_w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
