<div dir="ltr"><div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">Hello,</div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">We recently upgraded pgpool from 4.1.1 to 4.4.6.  We noticed that we are getting this </span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">2025-02-08 01:39:33.724 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % WARNING:  failed to lock semaphore<br>2025-02-08 01:39:33.725 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % DETAIL:  Invalid argument<br>2025-02-08 01:39:33.725 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % LOCATION:  pool_sema.c:129<br>2025-02-08 01:39:33.725 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % WARNING:  failed to unlock semaphore<br>2025-02-08 01:39:33.725 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % DETAIL:  Invalid argument<br>2025-02-08 01:39:33.725 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % LOCATION:  pool_sema.c:202<br>2025-02-08 01:39:33.763 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % WARNING:  failed to lock semaphore<br>2025-02-08 01:39:33.763 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % DETAIL:  Invalid argument<br>2025-02-08 01:39:33.763 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % LOCATION:  pool_sema.c:129<br>2025-02-08 01:39:33.764 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % WARNING:  failed to unlock semaphore<br>2025-02-08 01:39:33.764 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % DETAIL:  Invalid argument<br>2025-02-08 01:39:33.764 PROCESS: WORKER DB: [No Connection] USER: [No Connection] APPL: sr_check_worker % LOCATION:  pool_sema.c:202</span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">This doesn't show much</span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">ipcs -s<br><br>------ Semaphore Arrays --------<br>key        semid      owner      perms      nsems</span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">This is in our <b>pgpool.conf </b></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">backend_clustering_mode = 'streaming_replication'<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">num_init_children = 250<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">min_spare_children = 25<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">max_spare_children = 50<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">max_pool = 2<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">child_life_time = 300<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">child_max_connections = 2<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">connection_life_time = 300<br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">client_idle_limit = 300<br></span></div><div><br></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">Can you please help us understand why we see the warning?  What is it?  How do we resolve this?     </span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></span></div><div><span class="gmail_default" style="font-family:"comic sans ms",sans-serif">Thank you very much.  Any help would be appreciated</span></div><br clear="all"></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><p style="color:rgb(51,51,51);font-size:11pt;margin:12pt 0px 0px"><span style="font-weight:bold">Maria Nieva</span><span style="font-weight:bold"></span><b>   </b><span style="color:rgb(2,123,182)">Senior Database Administrator</span></p><p style="color:rgb(51,51,51);font-size:12pt;margin:3pt 0px 0px">T <span style="color:rgb(2,123,182)">416<b>.</b>596<b>.</b>6370</span><span style="color:rgb(2,123,182)"></span></p><p style="font-size:12pt;margin:1pt 0px 8pt;color:rgb(2,123,182)"><b>Points  </b>|  More together.</p><p style="color:rgb(51,51,51);margin:0px;font-size:8pt"><span style="color:rgb(162,171,184)">Connect with us:</span> <a href="https://company.points.com/" style="color:rgb(2,123,182)" target="_blank">Points</a> | <a href="https://twitter.com/PointsLoyalty" style="color:rgb(2,123,182)" target="_blank">Twitter</a> | <a href="https://www.instagram.com/pointsloyalty/?hl=en" style="color:rgb(2,123,182)" target="_blank">Instagram</a> | <a href="https://www.linkedin.com/company/points/" style="color:rgb(2,123,182)" target="_blank">LinkedIn</a> | <a href="https://company.points.com/careers/current-openings/" style="color:rgb(2,123,182)" target="_blank">Careers</a></p><p style="margin:0px;font-size:8pt;color:rgb(162,171,184)">TSX: <a href="https://web.tmxmoney.com/quote.php?qm_symbol=pts" style="color:rgb(162,171,184)" target="_blank">PTS</a>; NASDAQ: <a href="https://www.nasdaq.com/symbol/pcom/" style="color:rgb(162,171,184)" target="_blank">PCOM</a></p><p style="margin:0px;font-size:8pt;color:rgb(162,171,184)"><span>111 Richmond St. W., Suite 700, Toronto, ON, M5H 2G4, Canada</span></p><img width="150" height="100" src="https://www.points.com/imgs/Points_Logo_Website.png" alt="Points logo" style="color:rgb(51,51,51);font-size:13.3333px;margin-top:10px"><span style="color:rgb(51,51,51);font-size:13.3333px">        </span><span style="color:rgb(51,51,51);font-size:13.3333px"><img width="59" height="100" src="https://s3.amazonaws.com/points.com-marketing-images/Points_Social/GPTW_2022.png" alt="Great Place to Work: Best Workplaces 2015 Canada" style="margin-top:10px"></span><br></div></div></div><input name="virtru-metadata" type="hidden" value="{"email-policy":{"disableCopyPaste":false,"disablePrint":false,"disableForwarding":false,"enableNoauth":false,"expandedWatermarking":false,"expires":false,"sms":false,"expirationNum":1,"expirationUnit":"days","isManaged":false,"persistentProtection":false},"attachments":{},"compose-id":"1","compose-window":{"secure":false}}"></div>