Обсуждение: BUG #9296: Symbol resolution issue: undefined symbol: CheckFunctionValidatorAccess

The following bug has been logged on the website:

Bug reference:      9296
Logged by:          Remi Gacogne
Email address:      rgacogne-bugs@nuagelabs.fr
PostgreSQL version: 9.3.3
Operating system:   Linux x86_64
Description:

Hi,

I just built a Postgresql 9.3.3 and I have an issue at runtime with a
program linked against libpq.so that works like a charm with 9.3.2. It seems
like a recently introduced symbol (CheckFunctionValidatorAccess) isn't
exported.

The exact runtime error is :

could not load library "/usr/lib/postgresql/plpgsql.so":
/usr/lib/postgresql/plpgsql.so: undefined symbol:
CheckFunctionValidatorAccess

The function is indeed used:

$ objdump -RtD /usr/lib/postgresql/plpgsql.so |grep InputFunctionCall
0000000000000000         *UND*  0000000000000000
InputFunctionCall
00000000000071d0 <InputFunctionCall@plt>:
   1288b:       e8 40 49 ff ff          callq  71d0 <InputFunctionCall@plt>
   128ab:       e8 20 49 ff ff          callq  71d0 <InputFunctionCall@plt>
                        225ea0: R_X86_64_JUMP_SLOT      InputFunctionCall

But I an not able to find the symbol anywhere. Am I missing something?

Thank you,

Remi Gacogne

rgacogne-bugs@nuagelabs.fr writes:
> I just built a Postgresql 9.3.3 and I have an issue at runtime with a
> program linked against libpq.so that works like a charm with 9.3.2. It seems
> like a recently introduced symbol (CheckFunctionValidatorAccess) isn't
> exported.

You apparently are not running a 9.3.3 server, because that symbol should
be exported by the core server executable.  Maybe you installed 9.3.3 but
forgot to restart the server?

            regards, tom lane

>>> I just built a Postgresql 9.3.3 and I have an issue at runtime with a
>>> program linked against libpq.so that works like a charm with 9.3.2. It
>>> seems
>>> like a recently introduced symbol (CheckFunctionValidatorAccess) isn't
>>> exported.
>>
>> You apparently are not running a 9.3.3 server, because that symbol should
>> be exported by the core server executable.  Maybe you installed 9.3.3 but
>> forgot to restart the server?
>
> Sorry, I forgot to specify that my program is a client, using the libpq API
> to interact with a PG server. So yes, I did restart the executable.

Thinking about it twice, you may be right. The server is not on the same
host but may have been upgraded at the same time, and while I get the
error message on the client side, it may just be because the client
displays an error message sent by the server. I will check as soon as
possible, and if that's the case I am very sorry about the noise.

Thank you!

Hi Tom,

On Thu, 20 Feb 2014, Tom Lane wrote:

> rgacogne-bugs@nuagelabs.fr writes:
>> I just built a Postgresql 9.3.3 and I have an issue at runtime with a
>> program linked against libpq.so that works like a charm with 9.3.2. It seems
>> like a recently introduced symbol (CheckFunctionValidatorAccess) isn't
>> exported.
>
> You apparently are not running a 9.3.3 server, because that symbol should
> be exported by the core server executable.  Maybe you installed 9.3.3 but
> forgot to restart the server?

Sorry, I forgot to specify that my program is a client, using
the libpq API to interact with a PG server. So yes, I did restart the
executable.

Best regards,

Remi Gacogne