DBD::Oracle-1.19 with HP-UX11.23 IA64 - Module-Tests fails

[MikelC]

Hello!
I'm just trying to build DBD::Oracle on a new Itanium-Machine with HP-UX11.23 IA64.
Compiling is OK, but 70% of the tests will fail and I get a core-file by running the tests.
Have already read all Readme's shipped with ;-), but nothing helped.

The /opt/perl_64/ was already (pre)installed and shipped already with DBI-1.59 (I get the machines already preinstalled from our competence center, but he has no know-how about compiling, perl, etc.). I don't know where it came from. Maybe installed with the Apache Webserver (2.0.58.01). I would like to use this one, if possible, rather than build a new one from source. All the stuff has to work under mod_perl with MQSeries and SAP::Rfc.

Is there still a problem with the threaded-build perl? It seems, that this perl is built with threads. But on the other side, there is a perl which comes with oracle ($ORACLE_HOME/perl), which seems also to be a 64bit-Perl with threads.

Hope there's anyone who can help me!

Thanx!

#####
Environment:
# uname -a
HP-UX B.11.23 U ia64 3461438580 unlimited-user license

# swlist
#
# Bundle(s):
#
B6447EB E.11.23.05 C++ SoftBench 6.X License, Server
[...]
hpuxwsApache B.2.0.58.01 HP-UX Apache-based Web Server
hpuxwsTomcat B.5.5.20.00 HP-UX Tomcat-based Servlet Engine
hpuxwsWebmin A.1.070.09 HP-UX Webmin-based Admin
hpuxwsXml A.2.03 HP-UX XML Web Server Tools
perl D.5.8.8.B 5.8.8 Perl Programming Language
[...]

# cc -V
cc: HP aC++/ANSI C B3910B A.06.05 [Jul 25 2005]

# perl -V
perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=hpux, osvers=11.22, archname=IA64.ARCHREV_0-thread-multi-LP64
uname='hp-ux bigsur03 b.11.22 u ia64 1800516905 unlimited-user license '
config_args='-ders -Dcc=cc -Dusethreads -Duseithreads -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= -Uloclibpth= -Duse64bitall -Dsh=/usr/bin/sh -Dd_attribut=undef -Dd_attribute_warn_unused_result=undef -Dd_u32align=define -Aprepend:libswanted=cl -Dvendorprefix=/opt/perl_64 -Doptimize=-fast +DSitanium2 +Ofltacc=strict -Accflags=+Z -Accflags=-DUSE_SITECUSTOMIZE -Duselargefiles -Accflags=-DNO_HASH_SEED -Dprefix=/opt/perl_64 -Dinc_version_list=5.8.7/$archname 5.8.7 5.8.6/$archname 5.8.6 5.8.4/$archname 5.8.4 5.8.3/$archname 5.8.3 5.8.2/$archname 5.8.2 5.8.1/$archname 5.8.1 5.8.0/$archname 5.8.0 -Dsed=/usr/bin/sed -Duseshrplib -Dconfig_heavy=Config_dynamic.pl -Dcf_by=ActiveState -Dcf_email=support@ActiveState.com'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=define uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags =' -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 ',
optimize='-fast +DSitanium2 +Ofltacc=strict',
cppflags='-D__STDC_EXT__ -D_HPUX_SOURCE -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DUSE_SITECUSTOMIZE -DNO_HASH_SEED'
ccversion='B3910B A.05.55', gccversion='', gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='/usr/bin/ld', ldflags =' -L/usr/lib/hpux64'
libpth=/usr/lib/hpux64 /lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lcl -lnsl -lnm -ldl -ldld -lm -lsec -lpthread -lc
perllibs=-lcl -lnsl -lnm -ldl -ldld -lm -lsec -lpthread -lc
libc=/usr/lib/hpux64/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/usr/lib/hpux64'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT
USE_ITHREADS USE_LARGE_FILES USE_PERLIO
USE_REENTRANT_API USE_SITECUSTOMIZE
Locally applied patches:
ActivePerl Build 817.1 [268662]
Iin_load_module moved for compatibility with build 806
POSIX: Support the long hostname version of uname()
Avoid signal flag SA_RESTART for older versions of HP-UX
PerlEx support in CGI::Carp
Less verbose ExtUtils::Install and Pod::Find
Patch for CAN-2005-0448 from Debian with modifications
Partly reverted 24733 to preserve binary compatibility
28671 Define PERL_NO_DEV_RANDOM on Windows
28376 Add error checks after execing PL_cshname or PL_sh_path
28305 Pod::Html should not convert "foo" into ``foo''
27736 Make perl_fini() run with Sun WorkShop compiler
27619 Bug in Term::ReadKey being triggered by a bug in Term::ReadLine
27549 Move DynaLoader.o into libperl.so
27528 win32_pclose() error exit doesn't unlock mutex
27527 win32_async_check() can loop indefinitely
27515 ignore directories when searching @INC
27359 Fix -d:Foo=bar syntax
27210 Fix quote typo in c2ph
27203 Allow compiling swigged C++ code
27200 Make stat() on Windows handle trailing slashes correctly
27194 Get perl_fini() running on HP-UX again
27133 Initialise lastparen in the regexp structure
27034 Avoid "Prototype mismatch" warnings with autouse
26970 Make Passive mode the default for Net::FTP
26921 Avoid getprotobyname/number calls in IO::Socket::INET
26897,26903 Make common IPPROTO_* constants always available
26670 Make '-s' on the shebang line parse -foo=bar switches
26379 Fix alarm() for Windows 2003
26087 Storable 0.1 compatibility
25861 IO::File performace issue
25084 long groups entry could cause memory exhaustion
24699 ICMP_UNREACHABLE handling in Net::Ping
Built under hpux
Compiled at Sep 19 2006 13:50:51
@INC:
/opt/perl_64/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64
/opt/perl_64/lib/5.8.8
/opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64
/opt/perl_64/lib/site_perl/5.8.8
/opt/perl_64/lib/site_perl
/opt/perl_64/lib/vendor_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64
/opt/perl_64/lib/vendor_perl/5.8.8
/opt/perl_64/lib/vendor_perl
.

# set | grep -i ora
LD_LIBRARY_PATH=/oracle/product/102/lib:/usr/lib/hpux64:/usr/ccs/lib
ORACLE_HOME=/oracle/product/102
ORACLE_SID=
ORACLE_USERID=
PATH=[...]:/oracle/product/102/bin:[...]
SHLIB_PATH=/oracle/product/102/lib:/usr/lib/hpux64:/usr/ccs/lib

### Making DBD::Oracle
# perl Makefile.PL -l
Using DBI 1.59 (for perl 5.008008 on IA64.ARCHREV_0-thread-multi-LP64) installed in /opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on hpux (IA64.ARCHREV_0-thread-multi-LP64)

Remember to actually *READ* the README file! Especially if you have any problems.

Using Oracle in /oracle/product/102
DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR)
Oracle version 10.2.0.3 (10.2)
Found direct-link candidates: libclntsh.sl libclntsh.so
Oracle sysliblist: -l:librt.so -l:libnss_dns.so.1 -l:libdld.so -lm -lpthread -lunwind -lnsl
Found header files in /oracle/product/102/rdbms/public.
Your LD_LIBRARY_PATH/SHLIB_PATH env var is set to '/oracle/product/102/lib:/usr/lib/hpux64:/usr/ccs/lib:/oracle/product/102/lib:/usr/lib/hpux64:/usr/ccs/lib'
WARNING: If you have trouble, see README.hpux.txt...
you may have to build your own perl, or go hunting for libraries

Checking for functioning wait.ph


System: perl5.008008 hp-ux bigsur03 b.11.22 u ia64 1800516905 unlimited-user license
Compiler: cc -fast +DSitanium2 +Ofltacc=strict -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -l:librt.so -l:libnss_dns.so.1 -l:libdld.so -lm -lpthread -lunwind -lnsl
Linking with -lclntsh.

Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -l:librt.so
Note (probably harmless): No library found for -l:libnss_dns.so.1
Note (probably harmless): No library found for -l:libdld.so
LD_RUN_PATH=/oracle/product/102/lib:/usr/lib/hpux64
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.59 (for perl 5.008008 on IA64.ARCHREV_0-thread-multi-LP64) installed in /opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/
Writing Makefile for DBD::Oracle
[...]

# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /opt/perl_64/lib/5.8.8/ExtUtils/xsubpp -typemap /opt/perl_64/lib/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/oracle/product/102/rdbms/public -I/opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +DSitanium2 +Ofltacc=strict -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_64/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" Oracle.c
cc -c -I/oracle/product/102/rdbms/public -I/opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +DSitanium2 +Ofltacc=strict -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_64/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" dbdimp.c
"dbdimp.c", line 82: warning #2236-D: controlling expression is constant
&& OCIErrorGet_log_stat(errhp, recno, (text*)NULL, &eg_errcode, errbuf,
^

cc -c -I/oracle/product/102/rdbms/public -I/opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +DSitanium2 +Ofltacc=strict -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_64/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" oci8.c
"oci8.c", line 132: warning #2236-D: controlling expression is constant
&& OCIErrorGet_log_stat(errhp, recno, (text*)NULL, &eg_errcode, errbuf,
^

Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
/usr/bin/ld +b "/oracle/product/102/lib:/usr/lib/hpux64" -b +vnocompatwarnings -L/usr/lib/hpux64 Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
-L/oracle/product/102/lib -lclntsh -lm -lpthread -lunwind -lnsl \

chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man3/DBD::Oraperl.3

--> hey, this looks good!!! but...

# make test
/usr/bin/perl /opt/perl_64/lib/5.8.8/ExtUtils/xsubpp -typemap /opt/perl_64/lib/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/oracle/product/102/rdbms/public -I/opt/perl_64/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +DSitanium2 +Ofltacc=strict -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_64/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.3\" Oracle.c
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
/usr/bin/ld +b "/oracle/product/102/lib:/usr/lib/hpux64" -b +vnocompatwarnings -L/usr/lib/hpux64 Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
-L/oracle/product/102/lib -lclntsh -lm -lpthread -lunwind -lnsl \

chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 6-33
Failed 28/33 tests, 15.15% okay
t/15nls.................ok
t/20select..............dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 2-36
Failed 35/36 tests, 2.78% okay
[...]
t/25plsql...............dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 13-82
Failed 70/82 tests, 14.63% okay
t/26exe_array...........ok 1/14DBD::Oracle::st execute_array failed: ORA-00932: inconsistent datatypes: expected %s got %s (DBD ERROR: OCIBindByName) [err was 932 now 1008]
ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (?,?,?)"] at t/26exe_array.t line 62.
t/26exe_array...........dubious
Test returned status 0 (wstat 138, 0x8a)
DIED. FAILED tests 3-14
Failed 12/14 tests, 14.29% okay
[...]
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
t/10general.t 0 139 33 56 169.70% 6-33
t/20select.t 0 139 36 70 194.44% 2-36
t/21nchar.t 0 139 ?? ?? % ??
t/22nchar_al32utf8.t 0 139 ?? ?? % ??
t/22nchar_utf8.t 0 139 ?? ?? % ??
t/24implicit_utf8.t 0 139 74 148 200.00% 1-74
t/25plsql.t 0 139 82 140 170.73% 13-82
t/26exe_array.t 0 138 14 24 171.43% 3-14
t/30long.t 0 139 470 940 200.00% 1-470
t/31lob.t 0 139 9 18 200.00% 1-9
t/40ph_type.t 0 139 19 34 178.95% 3-19
t/50cursor.t 0 138 1002 2002 199.80% 2-1002
t/70meta.t 0 139 13 26 200.00% 1-13
4 tests skipped.
Failed 13/20 test scripts, 35.00% okay. 1729/1782 subtests failed, 2.97% okay.
*** Error exit code 255
[...]