We seem to have hit a bit of an issue with puppetdb garbage collection.
Initial symptoms were exceptions in the puppetdb logs :
Retrying after attempt 6, due to: org.postgresql.util.PSQLException: This
connection has been closed.
And on the postgres side :
LOG: incomplete message from client
Having turned up the logging on postgres, it appears that the query
DELETE FROM fact_paths fp
WHERE fp.id in ( $some_ids ) AND NOT EXISTS (SELECT 1 FROM facts
f
WHERE f.fact_path_id in ( $some_more_ids ) AND
f.fact_path_id = fp.id
AND f.factset_id <> $26355)
is the cuplrit. This query is absolutely massive, with over 26000 id's
specified as parameters - as soon as the query is executed, postgres
returns incomplete message from client and drops the connection.
puppetdb is 2.3.7-1puppetlabs1
postgres is 9.3
Does anyone have any clues what's going on here ?
Thanks
Matt
--
DataCentred Limited registered in England and Wales no. 05611763
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/5fe3bad3-71a7-4348-a9ff-24d8a0284a1c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
