DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build



Hi dbi-users,

I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've tried all the hints suggested in both
the README and README.help.txt files with the same result. Any
suggestions?

Info below:

# uname -a
SunOS carnivore 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V240


# perl Makefile.PL -v
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on solaris
(sun4-solaris-thread-multi-64int)

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

Using Oracle in /opt/oracle
PATH=/opt/oracle/bin:/opt/oracle:/opt/VRTSperl/bin:.:opt/SUNWspro/bin:/o
pt/WS50/bin:/usr/openwin/bin:/sbi
n:/bin:/usr/sbin:/usr/dt/bin:/usr/local/bin:/usr/local/sbin:/usr/ucb:/us
r/ccs/bin:/etc:/opt/VRTSspcs/sal:
/opt/VRTSspcs/vxas/bin::/usr/local/bin:/opt/ansic/bin:/bin:/sbin:/usr/bi
n:/usr/sbin:/usr/dt/bin:/usr/ccs/
bin:/etc:/usr/local/bin:/usr/contrib/bin/X11:/opt/langtools/bin:/usr/ucb
:/usr/openwin/bin:/etc/opt/licens
es:.:/opt/proctool/bin:/usr/sbin:/opt/VRTSvmsa/bin:/opt/SUNWspro/bin:/us
r/local/samba/bin:/opt/oracle/bin
:/opt/oracle/bin
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /opt/oracle/rdbms/demo/demo_rdbms.mk
Using /opt/oracle/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib:/usr/lib:/usr/openwin/lib:/usr/lib:/usr/dt/lib:/usr/open
win/lib:.:/opt/proctool/lib:/usr/local/samba/lib:/opt/oracle/lib32:/usr/
local/lib:/compaq/wbem/lib:/opt/o
racle/lib32'
Reading /opt/oracle/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/rdbms/lib/env_rdbms.mk
Read a total of 2895 lines from /opt/oracle/rdbms/lib/env_rdbms.mk
(including inclusions)
Read a total of 3196 lines from /opt/oracle/rdbms/demo/demo_rdbms.mk
(including inclusions)
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
Deleted AR definition: AR=ar
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
Deleted CHMOD definition: CHMOD=chmod
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
Deleted LD definition: LD=ld
Deleted PERL definition: PERL=perl
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG)
$(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3)
Deleted AR definition: AR=/usr/ccs/bin/ar
Deleted AS definition: AS=/usr/ccs/bin/as
Deleted LD definition: LD=/usr/ccs/bin/ld
Deleted CPP definition: CPP=$(CC) -E $(ANSI)
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=$(NOKPIC_ASFLAGS) $(KPIC_OPTION)
Deleted CCFLAGS definition: CCFLAGS=$(NOKPIC_CCFLAGS) $(KPIC_OPTION)
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /opt/oracle/lib/sysliblist`
returned '-lkstat -lnsl -lsocket -lgen -ldl -lsched '

Attempting to discover Oracle OCI build rules
gcc -c DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/rdbms/demo/demo_rdbms.mk build
ECHODO=echo ECHO=echo GENCLNTSH='echo g
enclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
returned:
[true -xarch=v9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread]
reduced to:
[true -xarch=v9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread]
Oracle oci build command:
[true -xarch=v9 -L/opt/oracle/lib/ -L/opt/oracle/rdbms/lib/ -o
DBD_ORA_EXE DBD_ORA_OBJ.o -lclnts
h `cat /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4
-lkstat -lm -lthread -lpthread]

Found header files in /opt/oracle/rdbms/public.

Checking for functioning wait.ph


System: perl5.008008 sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210
Compiler: gcc -O -D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/inc
lude -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/ucb/ld
Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign
-xF $(XS) $(MR) -xildoff -errtags=y
es -v -xarch=v9 -xchip=ultra3 -W2,-AKNR_S -Wd,-xsafe=unboundsym
-Wc,-Qiselect-funcalign=32 -xcode=abs44 -
Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -D_REENTRANT
-DSS_64BIT_SERVER -DBIT64 -DMACH
INE64 -K PIC -I/opt/oracle/rdbms/demo -I/opt/oracle/rdbms/public
-I/opt/oracle/plsql/public -I/opt/oracle
/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD
-D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/opt/oracle/rdbms/lib/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = -xarch=v9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `cat /opt/
oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat -lm
-lthread -lpthread [from 'build' ru
le]

MakeMaker (v6.30)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce (dbi-users@xxxxxxxx)]
DEFINE => q[ -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"10.2.0.1\"]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/opt/oracle/rdbms/public -I/opt/oracle/rdbms/demo
-I/opt/oracle/rdbms/public -I/opt/oracle/p
lsql/public -I/opt/oracle/network/public
-I/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-multi-64
int/auto/DBI]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[xstmp.c Oracle.xsi dll.base dll.exp sqlnet.log
libOracle.def ora_explain mk.pm DBD_
ORA_OBJ.*] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest tardist],
COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f
Makefile.old distdir], SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[ -xarch=v9 -L/opt/oracle/lib/
-L/opt/oracle/rdbms/lib/ -lclntsh `c
at /opt/oracle/lib/sysliblist` -R/opt/oracle/lib -laio -lposix4 -lkstat
-lm -lthread -lpthread] }
Using PERL=/opt/VRTSperl/bin/perl
LD_RUN_PATH=/opt/oracle/lib32:/opt/oracle/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
_perl/5.8.8/sun4-solaris-thread-multi-64int/auto/DBI/
Writing Makefile for DBD::Oracle

*** If you have problems...
read all the log printed above, and the README and README.help.txt
files.
(Of course, you have read README by now anyway, haven't you?)



# perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris-thread-multi-64int
uname='sunos thor1 5.8 generic_117350-26 sun4u sparc
sunw,sun-fire-v210 '
config_args='-de -Dcc=gcc -Dmake=make -D prefix=/opt/VRTSperl -D
usethreads -D useithreads -D useperlio -D use64bitint'
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=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include'
ccversion='', gccversion='3.4.2', gccosandvers='solaris2.8'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lpthread -lc
perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_64_BIT_INT USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
Built under solaris
Compiled at Mar 8 2006 13:15:30
%ENV:
PERL_DL_DEBUG=""
@INC:
/opt/VRTSperl/lib/5.8.8/sun4-solaris-thread-multi-64int
/opt/VRTSperl/lib/5.8.8
/opt/VRTSperl/lib/site_perl/5.8.8/sun4-solaris-thread-multi-64int
/opt/VRTSperl/lib/site_perl/5.8.8
/opt/VRTSperl/lib/site_perl
.



# make test
make test
PERL_DL_NONLAZY=1 /opt/VRTSperl/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................dubious
Test returned status 0 (wstat 139, 0x8b)
t/10general.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/15nls.................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20select..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/21nchar...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_al32utf8......dubious
Test returned status 0 (wstat 139, 0x8b)
t/22nchar_utf8..........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_8bit........dubious
Test returned status 0 (wstat 139, 0x8b)
t/23wide_db_al32utf8....dubious
Test returned status 0 (wstat 139, 0x8b)
t/24implicit_utf8.......dubious
Test returned status 0 (wstat 139, 0x8b)
t/25plsql...............dubious
Test returned status 0 (wstat 139, 0x8b)
t/26exe_array...........dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-470
Failed 470/470 tests, 0.00% okay
t/31lob.................dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............dubious
Test returned status 0 (wstat 139, 0x8b)
t/50cursor..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/55nested..............dubious
Test returned status 0 (wstat 139, 0x8b)
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................dubious
Test returned status 0 (wstat 139, 0x8b)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------------------
-------
t/01base.t 0 139 ?? ?? % ??
t/10general.t 0 139 ?? ?? % ??
t/15nls.t 0 139 9 18 200.00% 1-9
t/20select.t 0 139 ?? ?? % ??
t/21nchar.t 0 139 ?? ?? % ??
t/22nchar_al32utf8.t 0 139 ?? ?? % ??
t/22nchar_utf8.t 0 139 ?? ?? % ??
t/23wide_db.t 0 139 ?? ?? % ??
t/23wide_db_8bit.t 0 139 ?? ?? % ??
t/23wide_db_al32utf8.t 0 139 ?? ?? % ??
t/24implicit_utf8.t 0 139 ?? ?? % ??
t/25plsql.t 0 139 ?? ?? % ??
t/26exe_array.t 0 139 14 26 185.71% 2-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 ?? ?? % ??
t/50cursor.t 0 139 ?? ?? % ??
t/55nested.t 0 139 ?? ?? % ??
t/70meta.t 0 139 ?? ?? % ??
1 test skipped.
Failed 19/20 test scripts, 5.00% okay. 501/502 subtests failed, 0.20%
okay.
*** Error code 255
make: Fatal error: Command failed for target `test_dynamic'


# pstack core
fefe5bb0 XS_DBD__Oracle__dr_init_oci (137188, 302ef4, 1ca928, 2,
140dc4, 322ac8) + 1cc
00092d80 Perl_pp_entersub (137188, 1ca92c, 80, 0, 1ca924, 0) + 5c0
0008a4dc Perl_runops_standard (137188, 800000, 0, 0, 12c, 14cd50) + 2c
0002a458 S_run_body (137188, 1, 137188, 0, 137188, 137cfc) + 13c
0002a0a0 perl_run (137188, 1, 3, ffbff8dc, 134c00, 2) + 8c
0002698c main (3, ffbff8dc, ffbff8ec, 137170, 0, 0) + b8
0002676c _start (0, 0, 0, 0, 0, 0) + 5c



Regards,
Aaron Saarela
Principle Software Engineer
Symantec Corporation
Email: aaron_saarela@xxxxxxxxxxxx

.



Relevant Pages