Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 46012
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: champoux [...] pythian.com
Requestors: dhorne [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 1.23
Fixed in: (no value)



Subject: Dubious test results on RHEL
Download (untitled) / with headers
text/plain 2.8k
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
Download (untitled) / with headers
text/plain 611b
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
Download (untitled) / with headers
text/plain 918b
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
Could you try again with the latest DBD::Oracle? (v1.52)
Download (untitled) / with headers
text/plain 1.3k
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
Download (untitled) / with headers
text/plain 1.5k
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
The sequel to those adventures are being tracked in RT #69350


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.