Postgres Pro
Downloads
Home   >   mailing lists

Thread: regressions tests on freebsd/alpha: failure

regressions tests on freebsd/alpha: failure

From
"Christopher Kings-Lynne"
Date:
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

bash-2.03$

Re: regressions tests on freebsd/alpha: failure

From
"Christopher Kings-Lynne"
Date:
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
>
> bash-2.03$
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Re: regressions tests on freebsd/alpha: failure

From
Tom Lane
Date:
"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

Re: regressions tests on freebsd/alpha: failure

From
"Christopher Kings-Lynne"
Date:
> 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

Re: regressions tests on freebsd/alpha: failure

From
"Christopher Kings-Lynne"
Date:
> > 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