View Issue Details

IDProjectCategoryView StatusLast Update
0000310Pgpool-IIBugpublic2017-07-19 17:03
Reportertuomas Assigned Tot-ishii  
PriorityhighSeverityblockReproducibilityrandom
Status closedResolutionopen 
Product Version3.6.4 
Summary0000310: INSERT ... ON CONFLICT ... DO UPDATE queries hang
DescriptionStill trying to figure out all the conditions, but since upgrading from 3.6.2 to 3.6.4 most if not all of our upsert queries just hang.
The load balancing is enabled and postgresql is 9.5.2 and streaming replication mode is used.

I'll update when I get more information.
TagsNo tags attached.

Activities

tuomas

2017-05-24 23:02

reporter   ~0001523

It seems to be a bit difficult to figure out what is happening. It seems to require some amount of load and it would seems that it does not happen with plain INSERTS.

t-ishii

2017-06-13 13:07

developer   ~0001540

Please let us know if you find a way to reproduce the problem. Thanks in advance.

t-ishii

2017-07-19 17:03

developer   ~0001594

No response over 1 month. Issue closed.

Issue History

Date Modified Username Field Change
2017-05-20 01:06 tuomas New Issue
2017-05-24 23:02 tuomas Note Added: 0001523
2017-06-13 13:07 t-ishii Note Added: 0001540
2017-06-13 13:07 t-ishii Assigned To => t-ishii
2017-06-13 13:07 t-ishii Status new => feedback
2017-07-19 17:03 t-ishii Note Added: 0001594
2017-07-19 17:03 t-ishii Status feedback => closed