View Issue Details

IDProjectCategoryView StatusLast Update
0000111Pgpool-IIBugpublic2015-06-29 18:25
ReporterswAssigned ToMuhammad Usama 
PrioritynormalSeverityminorReproducibilityhave not tried
Status feedbackResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0000111: Significant increase of load average after upgrade to PSQL 9.3 and Pgpool 3.3.3
DescriptionSince I have upgraded my DB cluster to Postgresl 9.3 and Pgpool 3.3.3, load average on active Pgpool node increased from previously 3 to constantly 50 and more with peaks up to 120.

Resource usage is more or less the same as before (CPU 8 cores at 0000005:0000020%, 4 of 16 GB memory used). Kernel version did not change (Ubuntu Precise 3.2.0-58-generic), when I performed the upgrade.

This issue might be related to "[pgpool-general: 1528] Mysterious Load Spikes" but happens with load average being constantly higher than 50.

Looks like most of the processes are idle but are constantly pushed to the run queue which increases the load average and causes context switches.
Additional Information$ vmstat 1 10
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
 r b swpd free buff cache si so bi bo in cs us sy id wa
 2 0 0 6559324 292784 4912628 0 0 0 1244 1 0 3 9 88 0
 1 0 0 6542988 292784 4913896 0 0 0 12888 74483 139684 6 29 64 1
 2 0 0 6541620 292784 4915196 0 0 0 5960 74076 149707 5 31 64 0
 4 0 0 6539524 292784 4917224 0 0 0 15084 99863 174457 7 30 62 1
 0 0 0 6536372 292784 4918596 0 0 0 14380 67959 132991 6 27 66 1
265 1 0 6544508 292784 4919988 0 0 0 10308 55465 101475 6 24 70 1
 1 0 0 6549936 292784 4922012 0 0 0 14072 68786 126349 5 23 71 1
 0 0 0 6554144 292784 4923308 0 0 0 8020 76164 136969 6 29 64 1
 0 0 0 6540876 292784 4924792 0 0 0 6432 49840 102974 4 26 70 0
 1 1 0 6537632 292784 4926804 0 0 0 21868 98727 181727 9 24 66 1
TagsNo tags attached.

Activities

Muhammad Usama

2014-08-22 00:52

developer   ~0000469

I have been trying to replicate this issue and still has no luck. For further analysis on this issue can you please share the PostgreSQL, pgpool log and pgpool-II configuration you are using when this situation arrives.

Issue History

Date Modified Username Field Change
2014-08-14 23:27 sw New Issue
2014-08-22 00:52 Muhammad Usama Note Added: 0000469
2014-11-06 08:13 t-ishii Assigned To => Muhammad Usama
2014-11-06 08:13 t-ishii Status new => assigned
2015-06-29 18:25 Muhammad Usama Status assigned => feedback