Thread: AW: v7.0.3 *pre-release* ...

AW: v7.0.3 *pre-release* ...

From
Zeugswetter Andreas SB
Date:
> AIX 4.3.2, xlc 3.6.6.
> 
>   Same regression test failures as 7.0.2.
>   The nasty failures are triggers, misc, and plgpgsql which
>   consistently give "pqReadData() -- backend closed the channel
>   unexpectedly." at the same point.  Also the sanity_check hangs
>   during a VACUUM.  Killing the backend was the only way to continue.

This should not be so. Your setup should definitely work without 
regression failures. There is something wrong with your dynamic loading
of shared libs. Can you give more details, e.g. did you add optimization
which does not work yet ?

Andreas


AW: v7.0.3 *pre-release* ...

From
Pete Forman
Date:
Zeugswetter Andreas SB writes:> > > AIX 4.3.2, xlc 3.6.6.> > > >   Same regression test failures as 7.0.2.> >   The
nastyfailures are triggers, misc, and plgpgsql which> >   consistently give "pqReadData() -- backend closed the
channel>>   unexpectedly." at the same point.  Also the sanity_check hangs> >   during a VACUUM.  Killing the backend
wasthe only way to continue.> > This should not be so. Your setup should definitely work without> regression failures.
Thereis something wrong with your dynamic> loading of shared libs. Can you give more details, e.g. did you add>
optimizationwhich does not work yet ?
 

No extra flags were added by me.  The only build warnings were
duplicate symbol errors.  (There were a couple of warnings about
0.0/0.0 used to represent a NaN.)  Here are a couple of extracts from
my build log.
 xlc -I../include -I../backend -qmaxmem=16384 -qhalt=w -qsrcmsg   -qlanglvl=extended -qlonglong -o postgres
access/SUBSYS.o  bootstrap/SUBSYS.o catalog/SUBSYS.o commands/SUBSYS.o   executor/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o
main/SUBSYS.o  parser/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o port/SUBSYS.o   postmaster/SUBSYS.o regex/SUBSYS.o
rewrite/SUBSYS.o  storage/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o ../utils/version.o   -lPW -lcrypt -lld -lnsl -ldl -lm
-lcursesMaking postgres.imp ../backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/bin >   postgres.imp xlc
-Wl,-bE:../backend/postgres.imp-o postgres access/SUBSYS.o   bootstrap/SUBSYS.o catalog/SUBSYS.o commands/SUBSYS.o
executor/SUBSYS.olib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o   parser/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o
port/SUBSYS.o  postmaster/SUBSYS.o regex/SUBSYS.o rewrite/SUBSYS.o   storage/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o
../utils/version.o  -lPW -lcrypt -lld -lnsl -ldl -lm -lcurses
 

 xlc -I../../include -I../../backend -qmaxmem=16384 -qhalt=w   -qsrcmsg -qlanglvl=extended -qlonglong -DFRONTEND -c
pqsignal.c-o   pqsignal.o ar crs libpq.a fe-auth.o fe-connect.o fe-exec.o fe-misc.o   fe-print.o fe-lobj.o
pqexpbuffer.odllist.o pqsignal.o touch libpq.a ../../backend/port/aix/mkldexport.sh libpq.a /usr/local/pgsql/lib   >
libpq.expld -H512 -bM:SRE -bI:../../backend/postgres.imp -bE:libpq.exp -o   libpq.so libpq.a -lPW -lcrypt -lld -lnsl
-ldl-lm -lcurses -lcrypt   -lc ld: 0711-224 WARNING: Duplicate symbol: .crypt ld: 0711-224 WARNING: Duplicate symbol:
cryptld: 0711-224 WARNING: Duplicate symbol: .strlen ld: 0711-224 WARNING: Duplicate symbol: strlen ld: 0711-224
WARNING:Duplicate symbol: .PQuntrace ld: 0711-224 WARNING: Duplicate symbol: .PQtrace ld: 0711-224 WARNING: Duplicate
symbol:.setsockopt ld: 0711-224 WARNING: Duplicate symbol: setsockopt   [and others]
 

-- 
Pete Forman                 -./\.- Disclaimer: This post is originated
Western Geophysical           -./\.-  by myself and does not represent
pete.forman@westgeo.com         -./\.-  the opinion of Baker Hughes or
http://www.crosswinds.net/~petef  -./\.-  its divisions.