<div dir="ltr"><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Hi, </div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">I recently upgraded pgpool from 4.1.1 to 4.4.2.  I saw in the pgpool logs this error.</div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><span style="font-family:Arial,Helvetica,sans-serif">2023-07-08 00:39:20.825 [unknown] PROCESS: CHILD DB: pie2 USER:  APPL: [unknown] ERROR:  invalid memory alloc request size 18446744073709551592</span></div>2023-07-08 00:39:20.825 [unknown] PROCESS: CHILD DB: pie2 USER:  APPL: [unknown] CONTEXT:  while searching system catalog, When relcache is missed<div><br></div><div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">When I google the error, it seems related to postgres.  However, when I look into the postgres logs, I do not see the error.  Also the logs in 4.1.1 do not have the same error.  I am unsure why I'm getting the error in 4.4.2.</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">The postgres is in version 14.5.  The db size is 1.4TB.  The OS is Ubuntu 20.  We installed pgpool from source.  </div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">wget <a href="https://www.pgpool.net/mediawiki/images/pgpool-II-4.4.2.tar.gz">https://www.pgpool.net/mediawiki/images/pgpool-II-4.4.2.tar.gz</a><br>tar -xvzf pgpool-II-4.4.2.tar.gz<br>cd pgpool-II-4.4.2/<br>./configure --prefix=/local/opt/points/pgpool4.4.2 --enable-sequence-lock<br>make ; make install<br></div><br></div><div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">I have attached the pgpool logs for both versions.  </div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">I hope to get clarity on what caused the error and how to resolve this.  </div><br><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":{"state":"closed","expirationUnit":"days","disableCopyPaste":false,"disablePrint":false,"disableForwarding":false,"enableNoauth":false,"persistentProtection":false,"expandedWatermarking":false,"expires":false,"isManaged":false,"sms":false},"attachments":{},"compose-id":"1","compose-window":{"secure":false}}"></div></div>