Bug #69305 for DBD-Oracle: 31lob.t test crashes Oracle (and other issues)

Wed Jul 06 03:11:57 2011 bohica [...] ntlworld.com - Ticket created

Reported on behalf of abraxxa on the #dbix-class irc channel. abraxxa ran the test for DBD::Oracle 1.29_1 against Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production on AIX from instant client 11.2.0.2.0 x64 on ubuntu 11.04 and saw some problems. Here are the issues: t/31lob.t ............... 1/12 t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100) Failed 4/12 subtests t/50cursor.t ............ Can't determine open_cursors from v$parameter, so using default t/70meta.t .............. 1/13 Argument "29_1" isn't numeric in sprintf at /home/ahartmai/.cpanplus/5.14.1/build/DBD-Oracle-1.29_1/blib/lib/DBD/Oracle/GetInfo.pm line 9. The 31lob.t was: $ prove -vb 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 not ok 9 - returned length via PL/SQL # Failed test 'returned length via PL/SQL' # at t/31lob.t line 152. # got: undef # expected: '40000' Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x002491F28], [0], [0], [0], [], [], [] yy��yy��yy��}? ��W~? ��W~? ��W~? Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x002491F28], [0], [0], [0], [], [], [] �|��yy��yy��yy��}? ��W~? ��W~? ��W~? 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.03 usr 0.01 sys + 0.10 cusr 0.06 csys = 0.20 CPU) Result: FAIL Martin -- Martin J. Evans Wetherby, UK

Wed Jul 06 03:12:10 2011 bohica [...] ntlworld.com - Severity Important added

Wed Jul 06 03:13:14 2011 bohica [...] ntlworld.com - Subject changed from (no value) to '31lob.t test crashes Oracle (and other issues)'

Wed Jul 06 03:50:27 2011 bohica [...] ntlworld.com - Correspondence added

I fixed Argument "29_1" isn't numeric in sprintf at /home/ahartmai/.cpanplus/5.14.1/build/DBD-Oracle-1.29_1/blib/lib/DBD/Oracle/GetInfo.pm line 9. in r14897 in trunk Martin -- Martin J. Evans Wetherby, UK

Wed Jul 06 03:50:29 2011 bohica [...] ntlworld.com - Status changed from 'new' to 'open'

Wed Jul 06 11:42:29 2011 champoux [...] pythian.com - Correspondence added

Thanks for the patch and the bug report! I'll try to see if I can reproduce the error on one of our oracle instances over here. On Wed Jul 06 03:11:57 2011, MJEVANS wrote: Show quoted text

> Reported on behalf of abraxxa on the #dbix-class irc channel. > > abraxxa ran the test for DBD::Oracle 1.29_1 against Oracle Database > 11g > Enterprise Edition Release 11.1.0.7.0 - 64bit Production on AIX from > instant client 11.2.0.2.0 x64 on ubuntu 11.04 and saw some problems. > Here are the issues: > > t/31lob.t ............... 1/12 > t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100) > Failed 4/12 subtests > > t/50cursor.t ............ Can't determine open_cursors from > v$parameter, > so using default > > t/70meta.t .............. 1/13 Argument "29_1" isn't numeric in > sprintf > at > /home/ahartmai/.cpanplus/5.14.1/build/DBD-Oracle- > 1.29_1/blib/lib/DBD/Oracle/GetInfo.pm > line 9. > > The 31lob.t was: > > $ prove -vb 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 > not ok 9 - returned length via PL/SQL > > # Failed test 'returned length via PL/SQL' > # at t/31lob.t line 152. > # got: undef > # expected: '40000' > Errors in file : > OCI-21500: internal error code, arguments: [kghufree_06], > [0x002491F28], > [0], [0], [0], [], [], [] >

yy��yy��yy��}? Show quoted text

> ��W~? > ��W~? > ��W~? Errors in file > : > OCI-21500: internal error code, arguments: [kghufree_06], > [0x002491F28], > [0], [0], [0], [], [], [] >

�|��yy��yy��yy��}? Show quoted text

> ��W~? > ��W~? > ��W~? > 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.03 usr 0.01 sys + 0.10 cusr > 0.06 csys = 0.20 CPU) > Result: FAIL > > Martin

Fri Jul 08 09:48:37 2011 champoux [...] pythian.com - Reference by ticket #69350 added

Tue Jul 12 10:39:28 2011 champoux [...] pythian.com - Severity Important changed to Critical

Fri Apr 05 22:50:59 2019 dean [...] fragfest.com.au - Correspondence added

i think this can be closed martin?

Fri Apr 05 22:51:00 2019 dean [...] fragfest.com.au - Fixed in 1.76 added

Sat Apr 06 04:39:20 2019 bohica [...] ntlworld.com - Status changed from 'open' to 'resolved'

Bug #69305 for DBD-Oracle: 31lob.t test crashes Oracle (and other issues)

Preferred bug tracker