Thread: make check-world problem

make check-world problem

From
Vladimir Koković
Date:
Hi,

PostgreSQL build failed with current GIT source.

tail make-out-dev.log
gcc -Wall -Wmissing-prototypes -Wpointer-arith  
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute  
-Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard  
-g3 -gdwarf-2 isolation_main.o pg_regress.o -L../../../src/port  
-L../../../src/common -Wl,--as-needed  
-Wl,-rpath,'/home/src/postgresql-devel/dev-install/lib',--enable-new-dtags   
-lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz  
-lreadline -lrt -lcrypt -ldl -lm  -o pg_isolation_regress
PATH="/home/src/postgresql-devel/dev-build/tmp_install/home/src/postgresql-devel/dev-install/bin:$PATH"  
LD_LIBRARY_PATH="/home/src/postgresql-devel/dev-build/tmp_install/home/src/postgresql-devel/dev-install/lib"  
./pg_isolation_regress --temp-instance=./tmp_check  
--inputdir=/home/src/postgresql-devel/postgresql-git/postgresql/src/test/isolation  
--bindir=   
--schedule=/home/src/postgresql-devel/postgresql-git/postgresql/src/test/isolation/isolation_schedule
============== creating temporary instance            ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 57832 with PID 15786
============== creating database "isolationtest"      ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries        ==============
test simple-write-skew        ... ok
test receipt-report           ... ok
test temporal-range-integrity ... ok
test project-manager          ... ok
test classroom-scheduling     ... ok
test total-cash               ... ok
test referential-integrity    ... ok
test ri-trigger               ... ok
test partial-index            ... ok
test two-ids                  ... ok
test multiple-row-versions    ... ok
test index-only-scan          ... ok
test fk-contention            ... ok
test fk-deadlock              ... ok
test fk-deadlock2             ... ok
test eval-plan-qual           ... ok
test lock-update-delete       ... ok
test lock-update-traversal    ... ok
test insert-conflict-do-nothing ... ok
test insert-conflict-do-update ... ok
test insert-conflict-do-update-2 ... ok
test insert-conflict-do-update-3 ... ok
test delete-abort-savept      ... ok
test delete-abort-savept-2    ... ok
test aborted-keyrevoke        ... ok
test multixact-no-deadlock    ... ok
test multixact-no-forget      ... ok
test propagate-lock-delete    ... ok
test tuplelock-conflict       ... ok
test nowait                   ... ok
test nowait-2                 ... ok
test nowait-3                 ... ok
test nowait-4                 ... ok
test nowait-5                 ... ok
test skip-locked              ... ok
test skip-locked-2            ... ok
test skip-locked-3            ... ok
test skip-locked-4            ... ok
test brin-1                   ... FAILED (test process exited with exit  
code 1)
test drop-index-concurrently-1 ... ok
test alter-table-1            ... ok
test alter-table-2            ... ok
test alter-table-3            ... ok
test create-trigger           ... ok
test timeouts                 ... ok
============== shutting down postmaster               ==============

======================= 1 of 45 tests failed.
=======================

The differences that caused some tests to fail can be viewed in the
file  
"/home/src/postgresql-devel/dev-build/src/test/isolation/regression.diffs".   
A copy of the test summary that you see
above is saved in the file  
"/home/src/postgresql-devel/dev-build/src/test/isolation/regression.out".

Makefile:58: recipe for target 'check' failed
make[2]: *** [check] Error 1
make[2]: Leaving directory  
'/home/src/postgresql-devel/dev-build/src/test/isolation'
Makefile:28: recipe for target 'check-isolation-recurse' failed
make[1]: *** [check-isolation-recurse] Error 2
make[1]: Leaving directory '/home/src/postgresql-devel/dev-build/src/test'
GNUmakefile:69: recipe for target 'check-world-src/test-recurse' failed
make: *** [check-world-src/test-recurse] Error 2



cat  
/home/src/postgresql-devel/dev-build/src/test/isolation/results/brin-1.out
Parsed test spec with 2 sessions

starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
setup failed: ERROR:  could not open extension control file  

"/home/src/postgresql-devel/dev-build/tmp_install/home/src/postgresql-devel/dev-install/share/extension/pageinspect.control":

 
No such file or directory


My build environment:
---------------------
dev-build.sh:
#!/bin/bash

set -v
set -e

POSTGRESQL=/home/src/postgresql-devel
BUILD=dev-build

cd $POSTGRESQL
rm -rf $BUILD
mkdir $BUILD
chown postgres:postgres $BUILD
cd $POSTGRESQL/$BUILD
su -c "$POSTGRESQL/dev-build-postgres.sh" postgres

kdiff3 /home/src/pgadmin3-git/pgadmin3/pgadmin/pg_scanners/pg95/scan.l  
$POSTGRESQL/postgresql-git/postgresql/src/backend/parser/scan.l &
kdiff3  
/home/src/pgadmin3-git/pgadmin3/pgadmin/pg_scanners/pg95/src/backend/parser/95/parser/gram.h  
$POSTGRESQL/dev-install/include/server/parser/gram.h &

exit 0


----------------------
dev-build-postgres.sh:
#!/bin/bash

set -v
set -e

POSTGRESQL=/home/src/postgresql-devel
BUILD=dev-build

cd $POSTGRESQL/$BUILD

export CFLAGS="-g3 -gdwarf-2"

$POSTGRESQL/postgresql-git/postgresql/configure  
"--srcdir=$POSTGRESQL/postgresql-git/postgresql" '--enable-cassert' \
'--enable-nls' '--enable-integer-datetimes' '--with-perl' '--with-python'  
'--with-tcl' '--with-openssl' \
'--enable-thread-safety' '--with-ldap' '--with-gssapi' '--with-pam'  
'--with-libxml' '--with-libxslt' \
"--prefix=$POSTGRESQL/dev-install" > configure-out-dev.log 2>&1

make check-world > make-out-dev.log 2>&1

make install-world > make-install-out-dev.log 2>&1

exit 0

-------------------------------

Best regards
Vladimir Kokovic DP senior



Re: make check-world problem

From
Michael Paquier
Date:
On Sun, Aug 9, 2015 at 5:00 PM, Vladimir Koković
<vladimir.kokovic@a-asoft.com> wrote:
> starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
> setup failed: ERROR:  could not open extension control file
>
"/home/src/postgresql-devel/dev-build/tmp_install/home/src/postgresql-devel/dev-install/share/extension/pageinspect.control":

Yes, this is a known issue that has been caused by the recent commit
2834855c which has added a dependency to the contrib module
pageinspect in the isolation test you are seeing failing. I would
imagine that a fix is in the works as well, which is going to remove
this dependency to pageinspect.
--
Michael