undefined symbol: SPI_plan_get_cached_plan

Roger Niederland <roger@niederland.com> writes:

I am getting the following error when trying to execute a plpgsql funtion:

PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan

This is on a SL6.3 system running postgres 9.2.2

SPI_plan_get_cached_plan was added to the backend in 9.2.3. It looks
like you're trying to use a 9.2.3 plpgsql.so with a 9.2.2 (or older)
server.

After restarting the postgres service, the error went away.

So you had upgraded, but not actually restarted the server ...
just for future reference, SLES apparently doesn't do a service
restart automatically during package upgrade.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Hi,

On Mon, 2013-02-11 at 09:47 -0500, Tom Lane wrote:

After restarting the postgres service, the error went away.

So you had upgraded, but not actually restarted the server ...
just for future reference, SLES apparently doesn't do a service
restart automatically during package upgrade.

I think Roger is referring to Scientific Linux with SL, and my packages.
I don't see any reason why package updates don't restart themselves,
unless they are installed without running post scripts...

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

On 2/11/2013 6:47 AM, Tom Lane wrote:

Roger Niederland <roger@niederland.com> writes:

I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL6.3 system running postgres 9.2.2

SPI_plan_get_cached_plan was added to the backend in 9.2.3. It looks
like you're trying to use a 9.2.3 plpgsql.so with a 9.2.2 (or older)
server.

After restarting the postgres service, the error went away.

So you had upgraded, but not actually restarted the server ...
just for future reference, SLES apparently doesn't do a service
restart automatically during package upgrade.

regards, tom lane

The system was running Postgres 9.2.2 on Scientific Linux 6.3. Postgres
was not
upgraded, Last night I simply restarted the Postgres 9.2.2 service to
eliminate the undefined symbol issue.

This morning I upgraded the Postgres to 9.2.3, have not had this issue
reoccur.

Roger

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

2013/2/11 Roger Niederland <roger@niederland.com>:

On 2/11/2013 6:47 AM, Tom Lane wrote:

Roger Niederland <roger@niederland.com> writes:

I am getting the following error when trying to execute a plpgsql
funtion:
PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL6.3 system running postgres 9.2.2

SPI_plan_get_cached_plan was added to the backend in 9.2.3. It looks
like you're trying to use a 9.2.3 plpgsql.so with a 9.2.2 (or older)
server.

After restarting the postgres service, the error went away.

So you had upgraded, but not actually restarted the server ...
just for future reference, SLES apparently doesn't do a service
restart automatically during package upgrade.

regards, tom lane

The system was running Postgres 9.2.2 on Scientific Linux 6.3. Postgres was
not
upgraded, Last night I simply restarted the Postgres 9.2.2 service to
eliminate the undefined symbol issue.

This morning I upgraded the Postgres to 9.2.3, have not had this issue
reoccur.

yes, it is expected - files was updated, but only using PL/pgSQL needs restart

Regards

Pavel

Roger

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general