Re: DBD::Oracle-1.26 fails test t/31lob.t on Oracle 11gR2 Ubuntu 10.04

  On 10/19/2010 10:34 AM, CAMPBELL, ED (ATTBST) wrote:

No I do not think you buggered anything up.

Might be a permissions error or alike or a change in Oracle 11gR2 sounds 
very new.

if you can do a

  prove (t/31lob.t)  on it so we can get the deatils of that test that 
will help narrow it down

cheers
John Scoles
> When I do make test on DBD::Oracle-1.26 with Oracle 11gR2 on Ubuntu
> 10:04 x64 it fails t/31lob.t test 9.  Is this a known problem or am I
> doing something wrong.
>
> My perl info:
> $ perl -V
> Summary of my perl5 (revision 5 version 10 subversion 1) configuration:
>
>    Platform:
>      osname=linux, osvers=2.6.24-27-server,
> archname=x86_64-linux-gnu-thread-muli
>      uname='linux crested 2.6.24-27-server #1 smp fri mar 12 01:23:09 utc
> 2010 x'
>      config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
> -Dcccdlflags=-'
>      hint=recommended, useposix=true, d_sigaction=define
>      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_REENTRANT -D_GNU_SOURCE -DDEBIAN
> -fno-strict-aliasing,
>      optimize='-O2 -g',
>      cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing
> -pipe -f'
>      ccversion='', gccversion='4.4.3', gccosandvers=''
>      intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
>      d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
>      ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksiz8
>      alignbytes=8, prototype=define
>    Linker and Libraries:
>      ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
>      libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
>      libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
>      perllibs=-ldl -lm -lpthread -lc -lcrypt
>      libc=/lib/libc-2.11.1.so, so=so, useshrplib=true,
> libperl=libperl.so.5.10.1
>      gnulibc_version='2.11.1'
>    Dynamic Linking:
>      dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
>      cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib
> -fstack-prot'
>
>
> Characteristics of this binary (from libperl):
>    Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
>                          PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
> USE_64_BIT_ALL
>                          USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
>                          USE_PERLIO USE_REENTRANT_API
>    Built under linux
>    Compiled at Apr 23 2010 08:21:31
>    @INC:
>      /etc/perl
>      /usr/local/lib/perl/5.10.1
>      /usr/local/share/perl/5.10.1
>      /usr/lib/perl5
>      /usr/share/perl5
>      /usr/lib/perl/5.10
>      /usr/share/perl/5.10
>      /usr/local/lib/site_perl
>      .
>
> My DBI info:
> perl -MDBI -e 'print "$DBI::VERSION\n"'
> 1.609
>
> The output of the 'make test':
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0,t
> # Test loading DBI, DBD::Oracle and version
> t/01base.t .............. ok
> t/10general.t ........... ok
> t/12impdata.t ........... ok
> t/14threads.t ........... ok
> t/15nls.t ............... ok
> t/20select.t ............ ok
> t/21nchar.t ............. ok
> t/22nchar_al32utf8.t .... ok
> t/22nchar_utf8.t ........ ok
> t/23wide_db.t ........... skipped: Database character set is not Unicode
> t/23wide_db_8bit.t ...... skipped: Database character set is not Unicode
> t/23wide_db_al32utf8.t .. skipped: Database character set is not Unicode
> t/24implicit_utf8.t ..... ok
> t/25plsql.t ............. ok
> t/26exe_array.t ......... ok
> t/28array_bind.t ........ ok
> t/30long.t .............. ok
> t t/31lob.t line 126.
> :
>
> t/31lob.t ...............
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 4/12 subtests
> t/31lob_extended.t ...... ok
> t/32xmltype.t ........... ok
> t/34pres_lobs.t ......... ok
>   Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with
> Oracle.
>   Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
>   Your system doesn't. If that seems odd, let us know.
> t/40ph_type.t ........... ok
> Can't determine open_cursors from v$parameter, so using default
> t/50cursor.t ............ ok
> t/51scroll.t ............ ok
> t/55nested.t ............ ok
> t/56embbeded.t .......... ok
> t/58object.t ............ ok
> t/60reauth.t ............ skipped: ORACLE_USERID_2 not unique.
> t/70meta.t .............. ok
> t/80ora_charset.t ....... ok
>
>
> Test Summary Report
> -------------------
> t/31lob.t             (Wstat: 256 Tests: 9 Failed: 1)
>    Failed test:  9
>    Non-zero exit status: 1
>    Parse errors: Bad plan.  You planned 12 tests but ran 9.
> Files=30, Tests=1166, 26 wallclock secs ( 0.46 usr  0.15 sys + 11.99
> cusr  1.72)
> Result: FAIL
> Failed 1/30 test programs. 1/1166 subtests failed.
> make: *** [test_dynamic] Error 255
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
>
> $ perl -V
> Summary of my perl5 (revision 5 version 10 subversion 1) configuration:
>
>    Platform:
>      osname=linux, osvers=2.6.24-27-server,
> archname=x86_64-linux-gnu-thread-muli
>      uname='linux crested 2.6.24-27-server #1 smp fri mar 12 01:23:09 utc
> 2010 x'
>      config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
> -Dcccdlflags=-'
>      hint=recommended, useposix=true, d_sigaction=define
>      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_REENTRANT -D_GNU_SOURCE -DDEBIAN
> -fno-strict-aliasing,
>      optimize='-O2 -g',
>      cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing
> -pipe -f'
>      ccversion='', gccversion='4.4.3', gccosandvers=''
>      intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
>      d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
>      ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksiz8
>      alignbytes=8, prototype=define
>    Linker and Libraries:
>      ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
>      libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
>      libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
>      perllibs=-ldl -lm -lpthread -lc -lcrypt
>      libc=/lib/libc-2.11.1.so, so=so, useshrplib=true,
> libperl=libperl.so.5.10.1
>      gnulibc_version='2.11.1'
>    Dynamic Linking:
>      dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
>      cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib
> -fstack-prot'
>
>
> Characteristics of this binary (from libperl):
>    Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
>                          PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
> USE_64_BIT_ALL
>                          USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
>                          USE_PERLIO USE_REENTRANT_API
>    Built under linux
>    Compiled at Apr 23 2010 08:21:31
>    @INC:
>      /etc/perl
>      /usr/local/lib/perl/5.10.1
>      /usr/local/share/perl/5.10.1
>      /usr/lib/perl5
>      /usr/share/perl5
>      /usr/lib/perl/5.10
>      /usr/share/perl/5.10
>      /usr/local/lib/site_perl
>      .
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
> $ perl -MDBI -e 'print "$DBI::VERSION\n"'
> 1.609
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
> $ cat test.out
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0,t
> # Test loading DBI, DBD::Oracle and version
> t/01base.t .............. ok
> t/10general.t ........... ok
> t/12impdata.t ........... ok
> t/14threads.t ........... ok
> t/15nls.t ............... ok
> t/20select.t ............ ok
> t/21nchar.t ............. ok
> t/22nchar_al32utf8.t .... ok
> t/22nchar_utf8.t ........ ok
> t/23wide_db.t ........... skipped: Database character set is not Unicode
> t/23wide_db_8bit.t ...... skipped: Database character set is not Unicode
> t/23wide_db_al32utf8.t .. skipped: Database character set is not Unicode
> t/24implicit_utf8.t ..... ok
> t/25plsql.t ............. ok
> t/26exe_array.t ......... ok
> t/28array_bind.t ........ ok
> t/30long.t .............. ok
> DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an
> unsupporte.
>
> t/31lob.t ...............
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 4/12 subtests
> t/31lob_extended.t ...... ok
> t/32xmltype.t ........... ok
> t/34pres_lobs.t ......... ok
>   Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with
> Oracle.
>   Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
>   Your system doesn't. If that seems odd, let us know.
> t/40ph_type.t ........... ok
> Can't determine open_cursors from v$parameter, so using default
> t/50cursor.t ............ ok
> t/51scroll.t ............ ok
> t/55nested.t ............ ok
> t/56embbeded.t .......... ok
> t/58object.t ............ ok
> t/60reauth.t ............ skipped: ORACLE_USERID_2 not unique.
> t/70meta.t .............. ok
> t/80ora_charset.t ....... ok
>
> Test Summary Report
> -------------------
> t/31lob.t             (Wstat: 256 Tests: 9 Failed: 1)
>    Failed test:  9
>    Non-zero exit status: 1
>    Parse errors: Bad plan.  You planned 12 tests but ran 9.
> Files=30, Tests=1166, 26 wallclock secs ( 0.46 usr  0.15 sys + 11.99
> cusr  1.72)
> Result: FAIL
> Failed 1/30 test programs. 1/1166 subtests failed.
> make: *** [test_dynamic] Error 255
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
> $
>
>
> I will appreciate any help or information about this error.
>
> Thanks
>