Bug #46012 for DBD-Oracle: Dubious test results on RHEL

Tue May 12 19:25:46 2009 dhorne [...] cpan.org - Ticket created

Subject:

Dubious test results on RHEL

Hi The following tests are failing with DBD::Oracel 1.23: t/31lob.t ............... 1/9 DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0x1781f538)] at t/31lob.t line 108. t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100) Failed 4/9 subtests t/31lob_extended.t ...... ok t/32xmltype.t ........... ok t/34pres_lobs.t ......... ok t/40ph_type.t ........... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version. 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. Oracle 11.1.0.7.0 # perl -V Summary of my perl5 (revision 5 version 10 subversion 0) configuration: Platform: osname=linux, osvers=2.6.18-53.el5, archname=x86_64-linux uname='linux wlglnxdw1.<domain hidden> 2.6.18-53.el5 #1 smp wed oct 10 16:34:19 edt 2007 x86_64 x86_64 x86_64 gnulinux ' config_args='-de' hint=recommended, useposix=true, d_sigaction=define useithreads=undef, usemultiplicity=undef useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm', optimize='-O2', cppflags='-fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm' ccversion='', gccversion='4.1.2 20070626 (Red Hat 4.1.2-14)', 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', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64 /usr/local/lib64 libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc libc=/lib/libc-2.5.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.5' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES USE_PERLIO Built under linux Compiled at Apr 14 2009 12:35:23 @INC: /usr/local/lib/perl5/5.10.0/x86_64-linux /usr/local/lib/perl5/5.10.0 /usr/local/lib/perl5/site_perl/5.10.0/x86_64-linux /usr/local/lib/perl5/site_perl/5.10.0

Wed May 13 07:47:57 2009 champoux [...] pythian.com - Taken

Wed May 13 07:53:12 2009 champoux [...] pythian.com - Correspondence added

An Oracle 24813 error happens when an attempt was made to send a LOB across the network, but either the server does not support the LOB sent by the client, or the client does not support the LOB sent by the server. This error usually occurs when the client and server are running different versions of Oracle. So I may not be a DBD::Oracle error. Can you tell me which Oracle server and client you are using. As well there was a patch just applied to trunk http://svn.perl.org/modules/dbd-oracle/trunk that was around this area so you might want to donwload and try the 'Trunk' version of dbd::Oracle

Wed May 13 07:53:13 2009 The RT System itself - Status changed from 'new' to 'open'

Mon Jul 06 00:58:30 2009 dhorne [...] cpan.org - Correspondence added

On Wed May 13 07:53:12 2009, PYTHIAN wrote: Show quoted text

> An Oracle 24813 error happens when an attempt was made to send a LOB > across the network, but either the server does not support the LOB sent > by the client, or the client does not support the LOB sent by the > server. This error usually occurs when the client and server are > running different versions of Oracle.

We're running Oracle 11.1.0.7.0, and we're running teh tests locally, so the client and server are part of the same installation. This is running on Redhat Enterprise Linux 5.3 Show quoted text

> > So I may not be a DBD::Oracle error. > > Can you tell me which Oracle server and client you are using. > > As well there was a patch just applied to trunk > > http://svn.perl.org/modules/dbd-oracle/trunk > > that was around this area so you might want to donwload and try > the 'Trunk' version of dbd::Oracle

Alas, running the version from trunk didn't help

Mon Nov 26 15:13:30 2012 champoux [...] pythian.com - Correspondence added

Could you try again with the latest DBD::Oracle? (v1.52)

Sun Dec 02 16:36:29 2012 dhorne [...] cpan.org - Correspondence added

On Mon Nov 26 15:13:30 2012, PYTHIAN wrote: Show quoted text

> Could you try again with the latest DBD::Oracle? (v1.52)

Unfortunately, I'm no longer working at a site that has Oracle 11.1. Running again with DBD::Oracle 1.52 and Oracle 11.2, I encounter the errors in RT #69350: prove -Ilib -v t/31lob.t 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 ok 9 - returned length via PL/SQL # TODO problem reported w/ lobs and Oracle 11.2.*, see RT#69350 Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x001D477B8], [0], [0], [0], [], [], [] ""Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x001D477B8], [0], [0], [0], [], [], [] |V|V|V|V�� Dubious, test returned 1 (wstat 256, 0x100) Failed 3/12 subtests (1 TODO test unexpectedly succeeded) Test Summary Report ------------------- t/31lob.t (Wstat: 256 Tests: 9 Failed: 0) TODO passed: 9 Non-zero exit status: 1 Parse errors: Bad plan. You planned 12 tests but ran 9. Files=1, Tests=9, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.06 cusr 0.02 csys = 0.10 CPU) Result: FAIL

Sun Dec 02 16:56:18 2012 dhorne [...] cpan.org - Correspondence added

On Sun Dec 02 16:36:29 2012, DHORNE wrote: Show quoted text

> On Mon Nov 26 15:13:30 2012, PYTHIAN wrote:

> > Could you try again with the latest DBD::Oracle? (v1.52)

> > Unfortunately, I'm no longer working at a site that has Oracle 11.1. > Running again with DBD::Oracle 1.52 and Oracle 11.2, I encounter the > errors in RT #69350: > > prove -Ilib -v t/31lob.t > 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 > ok 9 - returned length via PL/SQL # TODO problem reported w/ lobs and > Oracle 11.2.*, see RT#69350 > Errors in file : > OCI-21500: internal error code, arguments: [kghufree_06], [0x001D477B8], > [0], [0], [0], [], [], [] > ""Errors in file : > OCI-21500: internal error code, arguments: [kghufree_06], [0x001D477B8], > [0], [0], [0], [], [], [] > |V|V|V|V�� > Dubious, test returned 1 (wstat 256, 0x100) > Failed 3/12 subtests > (1 TODO test unexpectedly succeeded) > > Test Summary Report > ------------------- > t/31lob.t (Wstat: 256 Tests: 9 Failed: 0) > TODO passed: 9 > Non-zero exit status: 1 > Parse errors: Bad plan. You planned 12 tests but ran 9. > Files=1, Tests=9, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.06 cusr > 0.02 csys = 0.10 CPU) > Result: FAIL

I forgot to point out that in this case the Oracle client and server libraries are on different servers

Fri May 03 16:48:07 2013 champoux [...] pythian.com - Correspondence added

The sequel to those adventures are being tracked in RT #69350

Fri May 03 16:48:08 2013 champoux [...] pythian.com - Status changed from 'open' to 'resolved'

Bug #46012 for DBD-Oracle: Dubious test results on RHEL

Preferred bug tracker