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
