PostgreSQL 8.2 on IA-64 : 2 regression tests FAILED

From: DANTE Alexandra <Alexandra(dot)Dante(at)bull(dot)net>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 8.2 on IA-64 : 2 regression tests FAILED
Date: 2006-12-07 14:47:42
Message-ID: 4578298E.2000206@bull.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello List,

I work on an IA-64 server with Red Hat Enterprise Linux 4 AS, and as the
8.2 release is now available, I try to generate RPM for IA-64.
To do that, I downloaded the "postgresql-8.2.0-2PGDG.src.rpm", extracted
the ".spec" file and these files :
-bash-3.00$ cd SOURCES/
-bash-3.00$ ls -ltr
total 24176
-rw-r--r-- 1 postgres postgres 12459207 Dec 2 20:25
postgresql-8.2.0.tar.bz2
-rw-r--r-- 1 postgres postgres 897 Dec 2 20:28 pg_config.h
-rw-r--r-- 1 postgres postgres 1539 Dec 2 20:28 Makefile.regress
-rwxr-xr-x 1 postgres postgres 56 Dec 2 20:28
filter-requires-perl-Pg.sh
-rw-r--r-- 1 postgres postgres 1631 Dec 2 20:28
postgresql-logging.patch
-rw-r--r-- 1 postgres postgres 7529 Dec 2 20:28 postgresql.init
-rw-r--r-- 1 postgres postgres 85 Dec 2 20:28 postgresql-bashprofile
-rw-r--r-- 1 postgres postgres 1757 Dec 2 20:28 rpm-pgsql.patch
-rw-r--r-- 1 postgres postgres 15598 Dec 2 20:28 README.rpm-dist
-rw-r--r-- 1 postgres postgres 2563 Dec 2 20:28 postgresql-test.patch
-rw-r--r-- 1 postgres postgres 919 Dec 2 20:28
postgresql-perl-rpath.patch
-rw-r--r-- 1 postgres postgres 141 Dec 2 20:28 postgresql.pam
-rw-r--r-- 1 postgres postgres 12198114 Dec 6 17:18
postgresql-8.2.0-2PGDG.src.rpm

Then, as the "postgres" user, I launched the command : rpmbuild -ba
postgresql-8.2.spec
By doing this, all the RPM had been created on /RPMS/ia64.

Now, I try to launch the regression tests and 2 of them failed :
test create_function_1 ... FAILED
... ... ...
triggers ... FAILED

I see at http://archives.postgresql.org/pgsql-ports/2006-11/msg00011.php
that this problem already appear on 64 bits but I am note sure that it
is the same problem...

In the file "regression.diff", my first problem seems to be linked with
the function "autoinc()" :
*** ./expected/create_function_1.out Thu Dec 7 14:37:28 2006
--- ./results/create_function_1.out Thu Dec 7 14:41:21 2006
***************
*** 25,40 ****
NOTICE: argument type city_budget is only a shell
CREATE FUNCTION check_primary_key ()
RETURNS trigger
! AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so
LANGUAGE C;
CREATE FUNCTION check_foreign_key ()
RETURNS trigger
! AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so
LANGUAGE C;
CREATE FUNCTION autoinc ()
RETURNS trigger
! AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so
LANGUAGE C;
CREATE FUNCTION funny_dup17 ()
RETURNS trigger
AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/regress.so'
--- 25,41 ----
NOTICE: argument type city_budget is only a shell
CREATE FUNCTION check_primary_key ()
RETURNS trigger
! AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so'
LANGUAGE C;
CREATE FUNCTION check_foreign_key ()
RETURNS trigger
! AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so'
LANGUAGE C;
CREATE FUNCTION autoinc ()
RETURNS trigger
! AS
'/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so'
LANGUAGE C;
*+ ERROR: could not find function "autoinc" in file
"/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/../../../contrib/spi/refint.so"*

I checked the file "contrib/spi/refint.c" : it does not contain a
function called autoinc...

The two others errors reported in "regression.diff" are :
delete from tttest where price_id = 2;
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 3 | 3 | 30 | 999999
! 2 | 2 | 20 | 40
(3 rows)

-- what do we see ?
--- 150,175 ----
for each row
execute procedure
autoinc (price_on, ttdummy_seq);
*+ ERROR: function autoinc() does not exist*
insert into tttest values (1, 1, null);
insert into tttest values (2, 2, null);
insert into tttest values (3, 3, 0);
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 2 | 2 | | 999999
! 3 | 3 | 0 | 999999
(3 rows)

delete from tttest where price_id = 2;
*+ ERROR: ttdummy (tttest): price_on must be NOT NULL*
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 2 | 2 | | 999999
! 3 | 3 | 0 | 999999
(3 rows)

-- what do we see ?

Any suggestion would be appreciated...

Thank you for your help.
Regards,
Alexandra

Browse pgsql-general by date

  From Date Subject
Next Message andy rost 2006-12-07 14:49:45 SET statement_timeout
Previous Message Bill Moran 2006-12-07 14:26:14 Re: VACUUM and transactions in different databases