Re: PostgreSQL 8.2 : regression failures on IA-64

Thank you very much : it works !!!!
-bash-3.00$ gmake check 2>&1 |tee traces_check8.2.0_gcc_121206_v2.log
... ... ...
test create_function_1 ... ok
triggers ... ok
... ... ...
=======================
All 103 tests passed.
=======================

The problems were those you found :
- I replaced AS '@abs_spidir@/refint(at)DLSUFFIX@' by AS
'@abs_spidir@/autoinc(at)DLSUFFIX@'
- I added ' at lines 58, 63, 68

By doing this, the regression tests are OK !
Regards,
Alexandra

Tatsuhito Kasahara wrote:

> Hi!
>
> I think this was caused by a description mistake of
> "postgresql-test.patch".
>
> >
> '/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regres/../../../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/regres/../../../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/regres/../../../contrib/spi/refint.so
>
> Single quotes (') of end of line is insufficient.
>
>
> > CREATE FUNCTION autoinc ()
> > RETURNS trigger
> > ! AS
> >
> '/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regres/../../../contrib/spi/refint.so
>
> We have to use "autoinc.so". (not "refint.so")
>
> # And You had better fix
> "/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regress/"
> and
>
> "/SLONY_PGS/PostgreSQL_8.2.0/BUILD/postgresql-8.2.0/src/test/regres/../../../contrib/spi/"
>
> in "/usr/lib/pgsql/test/regress/".
>
> best regards.
>
> DANTE Alexandra wrote:
>
>> Hello List,
>>
>> I have already posted an e-mail on the general mailing list but on
>> the advice of Devrim Gunduz ;-) , I try on this mailing list.
>> I try to generate the RPM from the src.rpm downloaded on the
>> postgresql.org web site. I work on an IA-64 server with Red Hat
>> Enterprise Linux 4 AS update 2.
>> As root, the first command I launched was :
>> [root(at)bt1 SOURCES]# rpm -i postgresql-8.2.0-2PGDG.src.rpm
>> [root(at)bt1 SOURCES]# ls -ltr ../SPECS
>> total 28
>> -rw-r--r-- 1 root root 24840 Dec 5 06:04 postgresql-8.2.spec
>> [root(at)bt1 SOURCES]# ls -ltr
>> total 24176
>> -rw-r--r-- 1 root root 12459207 Dec 2 20:25 postgresql-8.2.0.tar.bz2
>> -rw-r--r-- 1 root root 897 Dec 2 20:28 pg_config.h
>> -rw-r--r-- 1 root root 1539 Dec 2 20:28 Makefile.regress
>> -rwxr-xr-x 1 root root 56 Dec 2 20:28 filter-requires-perl-Pg.sh
>> -rw-r--r-- 1 root root 1631 Dec 2 20:28 postgresql-logging.patch
>> -rw-r--r-- 1 root root 7529 Dec 2 20:28 postgresql.init
>> -rw-r--r-- 1 root root 85 Dec 2 20:28 postgresql-bashprofile
>> -rw-r--r-- 1 root root 1757 Dec 2 20:28 rpm-pgsql.patch
>> -rw-r--r-- 1 root root 15598 Dec 2 20:28 README.rpm-dist
>> -rw-r--r-- 1 root root 2563 Dec 2 20:28 postgresql-test.patch
>> -rw-r--r-- 1 root root 919 Dec 2 20:28
>> postgresql-perl-rpath.patch
>> -rw-r--r-- 1 root root 141 Dec 2 20:28 postgresql.pam
>> -rw-r--r-- 1 root root 12198114 Dec 6 17:18
>> postgresql-8.2.0-2PGDG.src.rpm
>>
>> Then from the SPECS directory, with the spec file that you can find
>> attached, I launched as root :
>> rpmbuild -ba postgresql-8.2.spec
>>
>> Then, as root, I changed the access to these directories :
>> root# chmod -R a+w src/test/regress
>> root# chmod -R a+w contrib/spi
>>
>> And as postgres, I launched the regression tests.
>> root# su - postgres
>> -bash-3.00$ gmake check
>> The tests for create_function_1 and triggers fail...
>> 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...
>>
>>
>> You can find attach the files "regression.diff" and "regression.out"
>> 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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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/regres/../../../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
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>
>