regressions tests on freebsd/alpha: failure

If I createlang manually:

bash-2.03$ createlang plpgsql template1
ERROR: Load of file /home/chriskl/local/lib/postgresql/plpgsql.so failed:
dlopen '/home/chriskl/local/lib/postgresql/plpgsql.so' failed.
(/home/chriskl/local/lib/postgresql/plpgsql.so: Undefined symbol
"MakeExprContext")
createlang: language installation failed: ERROR: Load of file
/home/chriskl/local/lib/postgresql/plpgsql.so failed: dlopen
'/home/chriskl/local/lib/postgresql/plpgsql.so' failed.
(/home/chriskl/local/lib/postgresql/plpgsql.so: Undefined symbol
"MakeExprContext")

Chris

----- Original Message -----
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Hackers" <pgsql-hackers@postgresql.org>
Sent: Monday, July 07, 2003 1:14 PM
Subject: [HACKERS] regressions tests on freebsd/alpha: failure

I finally got Bison 1.875 installed on the alpha here, and tried running
regression tests:

============== removing existing temp installation ==============
============== creating temporary installation ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 65432 with pid 2974
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== dropping regression test user accounts ==============
============== installing PL/pgSQL ==============
createlang: language installation failed: ERROR: stat failed on file

'/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl

/local/lib/postgresql/plpgsql': No such file or directory
pg_regress: createlang failed
gmake[2]: Leaving directory `/home/chriskl/pgsql-temp/src/test/regress'
gmake[1]: Leaving directory `/home/chriskl/pgsql-temp/src/test'
bash-2.03$

============================================================

bash-2.03$ more ./src/test/regress/log/initdb.log
Running with noclean mode on. Mistakes will not be cleaned up.
The files belonging to this database system will be owned by user

"chriskl".

This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/base... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/global... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/pg_xlog... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/pg_clog... ok
creating template1 database in
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl/

local/bin/postmaster -D
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data
or

/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl/

local/bin/pg_ctl -D
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data -l logfile

start

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:

If I createlang manually:
bash-2.03$ createlang plpgsql template1
ERROR: Load of file /home/chriskl/local/lib/postgresql/plpgsql.so failed:
dlopen '/home/chriskl/local/lib/postgresql/plpgsql.so' failed.
(/home/chriskl/local/lib/postgresql/plpgsql.so: Undefined symbol
"MakeExprContext")

Sounds to me like an obsolete version of plpgsql.so. Perhaps your
install failed to overwrite the previous version for some reason?

regards, tom lane

Sounds to me like an obsolete version of plpgsql.so. Perhaps your
install failed to overwrite the previous version for some reason?

Doh! Just realised I had commented out the building of plpgsql since I had
some non-compilable changes in there :(

Chris

Sounds to me like an obsolete version of plpgsql.so. Perhaps your
install failed to overwrite the previous version for some reason?

Doh! Just realised I had commented out the building of plpgsql since I

had

some non-compilable changes in there :(

And in that case I can confirm that 7.4CVS passes all regression tests on
FreeBSD/Alpha.

Chris