Jira (PDB-1205) facts gc is too slow

Wyatt Alt (JIRA) Fri, 30 Jan 2015 13:06:05 -0800

Title: Message Title

Wyatt Alt created an issue

PDB-1205

Issue Type:	Bug
Affects Versions:	PDB 2.2.2
Assignee:	Unassigned
Created:	2015/01/30 1:04 PM
Priority:	Normal
Reporter:	Wyatt Alt

We have multiple customers experiencing issues with slow facts garbage collection (see PE-7392 and PDB-1124). From a user's logs,

< 2015-01-05 12:41:51.008 CET >STATEMENT: COMMIT

< 2015-01-05 12:41:51.009 CET >WARNING:  there is already a transaction in progress

< 2015-01-05 12:41:51.016 CET >WARNING:  there is already a transaction in progress

< 2015-01-05 12:41:51.075 CET >WARNING:  there is already a transaction in progress

< 2015-01-05 12:41:51.196 CET >LOG:  duration: 13591.153 ms  execute S_20: DELETE FROM fact_paths fp

                                        WHERE fp.id in ( SELECT fp.id

                                                         FROM fact_paths fp

                                                              inner join fact_values fv on fp.id = fv.path_id

                                                              inner join facts f on fv.id = f.fact_value_id

                                                         WHERE fp.id in ( select fv.path_id from fact_values fv where fv.id in ($1,$2,$3,$4) )

                                                         GROUP BY fp.id

                                                         HAVING COUNT(fv.id) = 1)

< 2015-01-05 12:41:51.196 CET >DETAIL:  parameters: $1 = '34861202', $2 = '34861204', $3 = '34861203', $4 = '34861205'

< 2015-01-05 12:41:51.234 CET >ERROR:  could not serialize access due to concurrent update

The customer is using a replicated postgres setup with separate read/write dbs so the serialization failures are somewhat expected, but they may be being exacerbated by the slow gc because they are incredibly frequent in the logs.

This may be tied to known issues with fact_values (PDB-1031)

Add Comment

This message was sent by Atlassian JIRA

--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.

Jira (PDB-1205) facts gc is too slow

Reply via email to