Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Austin Blatt created an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Issue Type: Bug Assignee: Unassigned Created: 2020/03/18 2:22 PM Priority: Normal Reporter: Austin Blatt When PuppetDB has to create a new partition the creation and insertion happen in different transactions and some of the constraints can deadlock with the insertion < 2020-03-18 10:01:23.195 PDT > ERROR: deadlock detected at character 13 < 2020-03-18 10:01:23.195 PDT > DETAIL: Process 71527 waits for RowExclusiveLock on relation 17910 of database 16387; blocked by process 71529. Process 71529 waits for ShareRowExclusiveLock on relation 17910 of database 16387; blocked by process 71527. Process 71527: INSERT INTO reports_20200318Z ( status_id, environment_id, catalog_uuid, receive_time, hash, transaction_uuid, puppet_version, noop, logs, report_format, start_time, producer_timestamp, cached_catalog_status, end_time, producer_id, configuration_version, code_id, noop_pending, certname, metrics, job_id ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21 )
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Nick Burgan updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Nick Burgan Story Points: 3 Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.20770.1585159800045%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Nick Burgan updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Nick Burgan Fix Version/s: PDB 6.10.0 Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.20771.1585159800099%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Austin Blatt assigned an issue to Austin Blatt PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Austin Blatt Assignee: Austin Blatt Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.22684.1585327680571%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Nick Burgan updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Nick Burgan Sprint: HA Team 2020-04-08 , HA Team 2020-04-22 (SS 4/15) Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.33949.1586370240219%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Nick Burgan updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Nick Burgan Story Points: 3 2 Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.33959.1586370480360%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Austin Boyd updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Austin Boyd Labels: jira_escalated Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.17848.1597759260091%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Austin Boyd updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Austin Boyd Zendesk Ticket Count: 1 Zendesk Ticket IDs: 39812 Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.17850.1597759500095%40Atlassian.JIRA.
Jira (PDB-4675) Deadlock when creating/inserting into a new report partition
Title: Message Title Austin Boyd updated an issue PuppetDB / PDB-4675 Deadlock when creating/inserting into a new report partition Change By: Austin Boyd Zendesk Ticket Count: 1 2 Zendesk Ticket IDs: 39812 ,39963 Add Comment This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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 puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.350469.1584566547000.37963.1600334940037%40Atlassian.JIRA.