[pgpool-general: 8886] pgpool 4.4.2 error after upgrade
Maria Nieva
maria.nieva at points.com
Mon Jul 10 23:51:29 JST 2023
Hi,
I recently upgraded pgpool from 4.1.1 to 4.4.2. I saw in the pgpool logs
this error.
2023-07-08 00:39:20.825 [unknown] PROCESS: CHILD DB: pie2 USER: APPL:
[unknown] ERROR: invalid memory alloc request size 18446744073709551592
2023-07-08 00:39:20.825 [unknown] PROCESS: CHILD DB: pie2 USER: APPL:
[unknown] CONTEXT: while searching system catalog, When relcache is missed
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.
The postgres is in version 14.5. The db size is 1.4TB. The OS is Ubuntu
20. We installed pgpool from source.
wget https://www.pgpool.net/mediawiki/images/pgpool-II-4.4.2.tar.gz
tar -xvzf pgpool-II-4.4.2.tar.gz
cd pgpool-II-4.4.2/
./configure --prefix=/local/opt/points/pgpool4.4.2 --enable-sequence-lock
make ; make install
I have attached the pgpool logs for both versions.
I hope to get clarity on what caused the error and how to resolve this.
Maria Nieva Senior Database Administrator
T 416*.*596*.*6370
*Points *| More together.
Connect with us: Points <https://company.points.com/> | Twitter
<https://twitter.com/PointsLoyalty> | Instagram
<https://www.instagram.com/pointsloyalty/?hl=en> | LinkedIn
<https://www.linkedin.com/company/points/> | Careers
<https://company.points.com/careers/current-openings/>
TSX: PTS <https://web.tmxmoney.com/quote.php?qm_symbol=pts>; NASDAQ: PCOM
<https://www.nasdaq.com/symbol/pcom/>
111 Richmond St. W., Suite 700, Toronto, ON, M5H 2G4, Canada
[image: Points logo] [image: Great Place to Work: Best Workplaces
2015 Canada]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230710/6edc7bf5/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf.4.1.1
Type: application/octet-stream
Size: 43927 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230710/6edc7bf5/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf.4.4.2
Type: application/octet-stream
Size: 32637 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230710/6edc7bf5/attachment-0001.obj>
More information about the pgpool-general
mailing list