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

  On 19/10/2010 18:17, CAMPBELL, ED (ATTBST) wrote:
> I'm not sure exactly how to run the "prove" command.  When I try it as
> "prove t/31lob.t" it gives:
>
> Can't locate DBD/Oracle.pm in @INC (@INC contains: /etc/perl
> /usr/local/lib/per.
> BEGIN failed--compilation aborted at t/31lob.t line 5.
> # Looks like your test exited with 2 before it could output anything.
> t/31lob.t ..
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 12/12 subtests
>
You need prove -vb t/32lob.t if you run it from the untarred DBD::Oracle 
distribution else you are attempting to run it using the installed 
DBD::Oracle which clearly you do not have.

I think it adds -Iblib/lib and -Iblib/arch to the Perl command line.

I think unrelated but "/usr/local/lib/per" in INC looks strange.

Martin

> Test Summary Report
> -------------------
> t/31lob.t (Wstat: 512 Tests: 0 Failed: 0)
>    Non-zero exit status: 2
>    Parse errors: Bad plan.  You planned 12 tests but ran 0.
> Files=1, Tests=0,  0 wallclock secs ( 0.06 usr  0.01 sys +  0.04 cusr
> 0.01 csy)
> Result: FAIL
>
> I assume I'm not running this correctly.  It appears to be looking for
> an installed version of DBD which I haven't done at the point.  I just
> attempting to install DBD and haven't actually done the "make install".
>
> Instead I ran the "make test TEST_VERBOSE=1", not all results shown,
> just for t/31lob.t.  Hope this will shed some light.
>
> . . . .
> ok 479
> ok
> ? ); END;" with ParamValues: :p1=undef,
> :p2=OCILobLocatorPtr=SCALAR(0x1e8a0d8)].
>
> #   Failed test 'returned length via PL/SQL'
> #   at t/31lob.t line 143.
> #          got: undef
> #     expected: '40000'
> t/31lob.t ...............
> 1..12
> ok 1 - returned valid locator
> ok 2 - inserted into BLOB successfully
> ok 3 - got back what we put in
> ok 4 - returned valid locator
> ok 5 - returned valid locator
> ok 6 - returned initialized locator
> ok 7 - returned length
> ok 8 - returned written value
> not ok 9 - returned length via PL/SQL
> Errors in file :
> OCI-21500: internal error code, arguments: [kghufree_06], [0x001C2A838],
> [0], []
> ????????????????Errors in file :
> OCI-21500: internal error code, arguments: [kghufree_06], [0x001C2A838],
> [0], []
> ????????????????????????????????
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 4/12 subtests
> # create table dbd_ora__drop_me ( idx integer, x clob,  dt date )
> # procedure p_DBD_Oracle_drop_me dropped
> # table dbd_ora__drop_me dropped
> t/31lob_extended.t ......
> 1..31
> . . . .
>
> -----Original Message-----
> From: John Scoles [mailto:[email protected]]
> Sent: Tuesday, October 19, 2010 12:03 PM
> To: CAMPBELL, ED (ATTBST)
> Cc: [email protected]
> Subject: 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
>>