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);
Wyatt
On 11/19/14 12:15 AM, Paul Seymour wrote:
Hello,
Getting a couple of errors thrown with PuppetDB
2014-11-19 08:03:49,120 ERROR [c.p.p.command]
[22329b48-7c20-4ec4-beb2-15cd02e11bff] [replace facts] Retrying after
attempt 8, due to: org.postgresql.util.PSQLException: ERROR: update or
delete on table "fact_paths" violates foreign key constraint
"fact_values_path_id_fk" on table "fact_values"
Detail: Key (id)=(512) is still referenced from table "fact_values".
org.postgresql.util.PSQLException: ERROR: update or delete on table
"fact_paths" violates foreign key constraint "fact_values_path_id_fk"
on table "fact_values"
Detail: Key (id)=(512) is still referenced from table "fact_values".
Which is similar to PDB-1031 albeit with a different fact (ours is a
custom one not _timestamp).
puppetdb=# select * from fact_paths where id = 512;
id | value_type_id | depth | name |
path
-----+---------------+-------+----------------------------------------+----------------------------------------
512 | 0 | 0 | XXXXXX_ethernet_eth0_intralink_unit_id
| XXXXXX_ethernet_eth0_intralink_unit_id
(1 row)
puppetdb=# select * from fact_values where path_id = 512;
id | path_id | value_type_id | value_hash |
value_integer | value_float | value_string | value_boolean | value_json
-------+---------+---------------+------------------------------------------+---------------+-------------+--------------+---------------+------------
50319 | 512 | 0 |
80e54cb487aed67b98d7dc92feaac988bf95bcc7 | | |
107827 | |
22128 | 512 | 0 |
47e3876c8d334accbeb827775e728643581bbb83 | | |
107292 | |
Is it just noise or something to be concerned about ? This is with
v2.2.1 and PostGres 9.3.5
Thanks
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
<mailto:puppet-users+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/08bf4cb9-6c80-489d-a0ef-26627f395f5e%40googlegroups.com
<https://groups.google.com/d/msgid/puppet-users/08bf4cb9-6c80-489d-a0ef-26627f395f5e%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/546CD9C0.2050308%40puppetlabs.com.
For more options, visit https://groups.google.com/d/optout.
