Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: PDB 2.2.2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Template:

      Description

      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 "could not serialize access due to concurrent update" errors are somewhat expected, but they may be being exacerbated by the slow gc because they are incredibly frequent in the logs. The error that says "there is already a transaction in progress" may be caused by nested transactions; I think Ken Barber believes that this should not happen using jdbc.

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

        Attachments

          Issue Links

            Activity

              jsd-sla-details-panel

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  wyatt Wyatt Alt
                • Votes:
                  2 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: