Re: Update pg_stat_monitor failed

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: BUBACZ Martin <martin(dot)bubacz(at)axa(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Update pg_stat_monitor failed
Date: 2026-11-05 16:14:48
Message-ID: c814f502-b77f-4623-91e9-cce14cda9174@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/5/26 8:03 AM, Adrian Klaver wrote:
> On 11/5/26 2:53 AM, BUBACZ Martin wrote:
>> Hi,
>>
>> I’m fairly new to postgresql and this is maybe a stupid question
>> (sorry beforehand): I'm trying to install
>> pg_stat_monitor_16-2.4.0-1PGDG.rhel9.8.x86_64 on rhel 9.8 and
>> postgresql 16.9.3 and I receive the message below when updating
>> existing version with "alter extension pg_stat_monitor update".
>>
>> ERROR:  could not load library "/usr/pgsql-16/lib/
>> pg_stat_monitor.so": / usr/pgsql-16/lib/pg_stat_monitor.so: undefined
>> symbol: palloc0_mul
>>
>> yum info pg_stat_monitor_16-2.4.0-1PGDG.rhel9.8.x86_64
>>
>> Last metadata expiration check: 2:21:52 ago on Thu 05 Nov 2026
>> 08:41:50 AM CET.
>>
>
>>
>> This version is running fine:
>> pg_stat_monitor_16-2.2.0-1PGDG.rhel9.x86_64.rpm
>>
>> Can someone advice?
>
> Since the problem occurred with the pg_stat_monitor version change I
> would suggest filing an issue here:
>
> https://github.com/percona/pg_stat_monitor/issues

Especially given the below.

2.4.0
Release highlights

"This release is focused on the stability and reliability of
pg_stat_monitor. Large parts of the internals were reworked to remove
long-standing sources of crashes, memory leaks and incorrect statistics,
and the test suite was extended with test cases backported from
pg_stat_statements so that the behavior of both extensions can be
compared directly."

Add to that Ron's observation of the Postgres version being well back
from current and I think there is good case to be made for a bad
interaction between new code and old code.

>
>>
>> Thank you.
>>
>> Regards,
>>
>> martin
>>
>> **
>>
>> *Martin BUBACZ**
>> *Database Administrator (Oracle)

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2026-11-06 07:18:54 Re: Update pg_stat_monitor failed
Previous Message Adrian Klaver 2026-11-05 16:03:48 Re: Update pg_stat_monitor failed