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

  On 10/19/2010 2:33 PM, CAMPBELL, ED (ATTBST) wrote:

Ok I have seen this one before

Me thinks this is on the oracle side of things

I would just go ahead and install

The fail here will not effect you much as it is a rather obscure blob 
thing dealing with  the test of an insert empty blob returning blob to a 
var. it returns 0 for the lenght but it actully enters the data.

Might be a switch in the OCI client or an error on the DB??

I am working in it for the next release.

You might want to raise it with you Oracle rep and report it as a bug as 
it works for all version before 11

cheers
John Scoles


> Thanks, I've been fortunate enough in my dealings with DBD or DBI that I
> haven't had to run prove at this point..
>
> The output from "prove -vb t/31lob.t" follows:
> DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an
> unsupporte.
>
> #   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], [0x0023CBDC8],
> [0], []
> )Or?)Or?Errors in file :
>
> OCI-21500: internal error code, arguments: [kghufree_06], [0x0023CBDC8],
> [0], []
> ----????????????????
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 4/12 subtests
>
> 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=1, Tests=9,  0 wallclock secs ( 0.05 usr  0.01 sys +  0.23 cusr
> 0.06 csy)
> Result: FAIL
>
> It appears to be the same as output from "make test TEST_VERBOSE=1".
>
>
> -----Original Message-----
> From: Martin J. Evans [mailto:[email protected]]
> Sent: Tuesday, October 19, 2010 2:23 PM
> To: [email protected]
> Subject: 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
>>>