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: 69350
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: champoux [...] pythian.com
Requestors: wes [...] smellycat.com
Cc:
AdminCc:

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



X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
From wes [...] mailhost.smellycat.com Thu Jul 7 20: 34:26 2011
CC: Wes Brown <wes [...] smellycat.com>
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
Content-Disposition: inline
X-Spam-Flag: NO
content-type: text/plain; charset="utf-8"
Message-ID: <20110708003409.GA17048 [...] smellycat.com>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 7944B24049E for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Thu, 7 Jul 2011 20:34:26 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 37uFbRdVMQGM for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Thu, 7 Jul 2011 20:34:24 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 8363324035A for <bug-DBD-Oracle [...] rt.cpan.org>; Thu, 7 Jul 2011 20:34:23 -0400 (EDT)
Received: (qmail 2238 invoked by uid 103); 8 Jul 2011 00:34:22 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 8 Jul 2011 00:34:22 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Thu, 07 Jul 2011 17:34:19 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id p680YAaO024569 for <bug-DBD-Oracle [...] rt.cpan.org>; Thu, 7 Jul 2011 20:34:10 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id p680Y9AB017052; Thu, 7 Jul 2011 20:34:09 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id p680Y9cg017051; Thu, 7 Jul 2011 20:34:09 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mutt/1.4.2.2i
Subject: Issue in 31lob.t for DBD::Oracle 1.28
Return-Path: <wes [...] mailhost.smellycat.com>
X-RT-Mail-Extension: dbd-oracle
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-Spam-Check-BY: 16.mx.develooper.com
Date: Thu, 7 Jul 2011 20:34:09 -0400
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
Content-Transfer-Encoding: 8bit
From: Wes Brown <wes [...] smellycat.com>
X-RT-Original-Encoding: iso-8859-1
Content-Length: 2712
Download (untitled) / with headers
text/plain 2.6k
$ perl5 -v This is perl 5, version 12, subversion 3 (v5.12.3) built for x86_64-linux-thread-multi Very similar to ID: 69305 Ran the tests for DBD::Oracle 1.28 against Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production on HP-UX from Oracle client Release 11.2.0.2.0 Production on RedHat AS 5.5 x86_64 and saw some problems in 31lob.t. Here are the issues: [uuuuuuuu@xxxxxxxxx DBD-Oracle-1.28]$ prove -b -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 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], [0x01E724258], [0], [0], [0], [], [], [] Ð 4Ð 4Ð 4ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿm¤YÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜV²+ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜV²+ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜV²+`o¤Y`o¤Y`o¤Y`o¤Y`o¤Y`o¤Y`o¤Y`o¤YErrors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x01E724258], [0], [0], [0], [], [], [] Ð 4Ð 4Ð 4ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿo¤YÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜV²+ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜV²+ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜV²+Pq¤YPq¤YPq¤YPq¤YPq¤YPq¤YPq¤YPq¤Y 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.02 sys + 0.07 cusr 0.09 csys = 0.21 CPU) Result: FAIL Wes --- Wes Brown ewb4@alumni.cwru.edu wes@smellycat.com http://web.smellycat.com/wes/About.me.html KB8TGR
MIME-Version: 1.0
In-Reply-To: <20110708003409.GA17048 [...] smellycat.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <20110708003409.GA17048 [...] smellycat.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-9060-1310132875-1691.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 500
Download (untitled) / with headers
text/plain 500b
On Thu Jul 07 20:34:27 2011, wes@smellycat.com wrote: Show quoted text
> $ perl5 -v > > This is perl 5, version 12, subversion 3 (v5.12.3) built for x86_64- > linux-thread-multi > > Very similar to ID: 69305
Yup, looks like it. If possible, can you try to run the tests against v1.28 of DBD::Oracle? I'm curious to see if that's a new bug, or it's something that has been around and is bubbling up for 11g (it should be the former, but getting confirmation would be nice). Thanks for the bug report! `/anick
From wes [...] mailhost.smellycat.com Fri Jul 8 23: 12:00 2011
X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
CC: Wes Brown <wes [...] smellycat.com>
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-9060-1310132875-688.69350-6-0 [...] rt.cpan.org>
Content-Disposition: inline
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-9060-1310132875-688.69350-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <20110709031134.GA14547 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id F187B2404CE for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 8 Jul 2011 23:11:59 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id GxXLsosNZljX for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 8 Jul 2011 23:11:58 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 5AC462404B9 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 8 Jul 2011 23:11:57 -0400 (EDT)
Received: (qmail 15517 invoked by uid 103); 9 Jul 2011 03:11:56 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 9 Jul 2011 03:11:56 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Fri, 08 Jul 2011 20:11:53 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id p693BjWW032718 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 8 Jul 2011 23:11:45 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id p693BZLi014608; Fri, 8 Jul 2011 23:11:35 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id p693BZo6014607; Fri, 8 Jul 2011 23:11:35 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
User-Agent: Mutt/1.4.2.2i
Return-Path: <wes [...] mailhost.smellycat.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Fri, 8 Jul 2011 23:11:34 -0400
X-Spam-Level:
To: Pythian Remote DBA via RT <bug-DBD-Oracle [...] rt.cpan.org>
From: Wes Brown <wes [...] smellycat.com>
RT-Message-ID: <rt-3.8.HEAD-9056-1310181120-905.69350-0-0 [...] rt.cpan.org>
Content-Length: 1017
Download (untitled) / with headers
text/plain 1017b
On Fri, Jul 08, 2011 at 09:47:56AM -0400, Pythian Remote DBA via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=69350 > > > On Thu Jul 07 20:34:27 2011, wes@smellycat.com wrote:
> > $ perl5 -v > > > > This is perl 5, version 12, subversion 3 (v5.12.3) built for x86_64- > > linux-thread-multi > > > > Very similar to ID: 69305
> > Yup, looks like it. > > If possible, can you try to run the tests against v1.28 of DBD::Oracle? > I'm curious to see if that's a new bug, or it's something that has been > around and is bubbling up for 11g (it should be the former, but getting > confirmation would be nice). > > Thanks for the bug report! > `/anick
I shall work with the correct folks to get access to one of our Oracle 11 databases as well as do the same build using our Oracle 11 Client install. I will report the other three tests back so it can assist. 11.2 Client -> 10.2 Database (Done) 10.2 Client -> 10.2 Database 11.2 Client -> 11.2 Database 10.2 Client -> 11.2 Database Thanks Wes
From wes [...] mailhost.smellycat.com Mon Jul 11 09: 56:15 2011
X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <20110709031134.GA14547 [...] smellycat.com>
Content-Disposition: inline
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-9060-1310132875-688.69350-6-0 [...] rt.cpan.org> <20110709031134.GA14547 [...] smellycat.com>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <20110711135557.GA31582 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 8321E2404F9 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 11 Jul 2011 09:56:15 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FT2ZlChwdM8m for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 11 Jul 2011 09:56:13 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id AEA15240429 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 11 Jul 2011 09:56:11 -0400 (EDT)
Received: (qmail 6965 invoked by uid 103); 11 Jul 2011 13:56:11 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 11 Jul 2011 13:56:11 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Mon, 11 Jul 2011 06:56:08 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id p6BDtr55017754 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 11 Jul 2011 09:55:53 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id p6BDtvMx008816 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 11 Jul 2011 09:55:57 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id p6BDtv2J008815 for bug-DBD-Oracle [...] rt.cpan.org; Mon, 11 Jul 2011 09:55:57 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
User-Agent: Mutt/1.4.2.2i
Return-Path: <wes [...] mailhost.smellycat.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Mon, 11 Jul 2011 09:55:57 -0400
X-Spam-Level:
To: Pythian Remote DBA via RT <bug-DBD-Oracle [...] rt.cpan.org>
Content-Transfer-Encoding: 8bit
From: Wes Brown <wes [...] smellycat.com>
RT-Message-ID: <rt-3.8.HEAD-9058-1310392576-1150.69350-0-0 [...] rt.cpan.org>
Content-Length: 4410
Download (untitled) / with headers
text/plain 4.3k
Show quoted text
> I shall work with the correct folks to get access to one of our Oracle 11 > databases as well as do the same build using our Oracle 11 Client install. > I will report the other three tests back so it can assist. > > 11.2 Client -> 10.2 Database (Done) > 10.2 Client -> 10.2 Database > 11.2 Client -> 11.2 Database > 10.2 Client -> 11.2 Database > > Thanks > > Wes
As requested, I have attached tests from Oracle 10 clients as well. It appears that those are working without issue. Let me know how I can assist in any further testing. I will have access to both of these databases for as long as necessary. Wes 10.2 Client -> 11.2 Database Oracle 10.2.0.5.0 Client to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production $ prove -b -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 ok 10 - returned LOB as string ok 11 - returned IN/OUT LOB as string ok 12 # skip can't check num of temp lobs, no access to v$session ok All tests successful. Files=1, Tests=12, 1 wallclock secs ( 0.03 usr 0.04 sys + 0.11 cusr 0.04 csys = 0.22 CPU) Result: PASS 11.2 Client -> 11.2 Database Oracle 11.2.0.2.0 Client to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production $ prove -b -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 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], [0x0058F6258], [0], [0], [0], [], [], [] Ð 4Ð 4Ð 4ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿHÊjÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜ&®*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜ&®*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜ&®*àIÊjàIÊjàIÊjàIÊjàIÊjàIÊjàIÊjàIÊjErrors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x0058F6258], [0], [0], [0], [], [], [] Ð 4Ð 4Ð 4ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜ&®*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜ&®*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÜ&®*ÐKÊjÐKÊjÐKÊjÐKÊjÐKÊjÐKÊjÐKÊjÐKÊj 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, 1 wallclock secs ( 0.03 usr 0.00 sys + 0.12 cusr 0.03 csys = 0.18 CPU) Result: FAIL 10.2 Client -> 11.2 Database Oracle 10.2.0.5.0 Client to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production $ prove -b -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 ok 10 - returned LOB as string ok 11 - returned IN/OUT LOB as string ok 12 # skip can't check num of temp lobs, no access to v$session ok All tests successful. Files=1, Tests=12, 4 wallclock secs ( 0.04 usr 0.02 sys + 0.11 cusr 0.05 csys = 0.22 CPU) Result: PASS
From champoux [...] pythian.com Tue Jul 12 10: 44:56 2011
MIME-Version: 1.0
X-Spam-Status: No, score=-6.121 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, SPF_NEUTRAL=0.779] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-9058-1310392576-232.69350-5-0 [...] rt.cpan.org>
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-9060-1310132875-688.69350-6-0 [...] rt.cpan.org> <20110709031134.GA14547 [...] smellycat.com> <20110711135557.GA31582 [...] smellycat.com> <rt-3.8.HEAD-9058-1310392576-232.69350-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <4E1C5DDD.3060400 [...] pythian.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.121
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 913E724050A for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Tue, 12 Jul 2011 10:44:56 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 2Ig+DXLjiHVD for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Tue, 12 Jul 2011 10:44:55 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id CC03E24040B for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 12 Jul 2011 10:44:54 -0400 (EDT)
Received: (qmail 328 invoked by uid 103); 12 Jul 2011 14:44:54 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 12 Jul 2011 14:44:54 -0000
Received: from na3sys009aog105.obsmtp.com (HELO na3sys009aog105.obsmtp.com) (74.125.149.75) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with SMTP; Tue, 12 Jul 2011 07:44:52 -0700
Received: from mail-yx0-f177.google.com ([209.85.213.177]) (using TLSv1) by na3sys009aob105.postini.com ([74.125.148.12]) with SMTP ID DSNKThxd4lhBiDmdfj1Q6V2tpWK82/EF7KUY [...] postini.com; Tue, 12 Jul 2011 07:44:52 PDT
Received: by mail-yx0-f177.google.com with SMTP id 20so2319201yxj.8 for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 12 Jul 2011 07:44:50 -0700 (PDT)
Received: by 10.100.116.5 with SMTP id o5mr21444anc.60.1310481889814; Tue, 12 Jul 2011 07:44:49 -0700 (PDT)
Received: from [10.237.236.136] (host7.pythian.com [209.217.100.70]) by mx.google.com with ESMTPS id k29sm11876940anq.50.2011.07.12.07.44.47 (version=SSLv3 cipher=OTHER); Tue, 12 Jul 2011 07:44:47 -0700 (PDT)
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:5.0) Gecko/20110624 Thunderbird/5.0
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
Return-Path: <champoux [...] pythian.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Tue, 12 Jul 2011 10:44:45 -0400
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
Content-Transfer-Encoding: 7bit
From: Yanick Champoux <champoux [...] pythian.com>
RT-Message-ID: <rt-3.8.HEAD-9060-1310481897-1725.69350-0-0 [...] rt.cpan.org>
Content-Length: 581
Download (untitled) / with headers
text/plain 581b
On 07/11/11 09:56, Wes Brown via RT wrote: Show quoted text
> As requested, I have attached tests from Oracle 10 clients as well. It > appears that those are working without issue. Let me know how I can > assist in any further testing. I will have access to both of these > databases for as long as necessary.
Many thanks. That's going to be useful for the hunt of what looks like an ugly cross-version problem. *put on OCI goggles and XS-diving gears* This is going to be fun, I can feel it... Joy, `/anick -- The best compliment you could give Pythian for our service is a referral.
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-9058-1310392576-1150.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-9060-1310132875-688.69350-6-0 [...] rt.cpan.org> <20110709031134.GA14547 [...] smellycat.com> <20110711135557.GA31582 [...] smellycat.com> <rt-3.8.HEAD-9058-1310392576-1150.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-9058-1310546685-1213.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 310
Download (untitled) / with headers
text/plain 310b
Wes, If you could run a failing example with ora_verbose set high (6 I think) and attach the output it might help someone identify the issue. Just change 31lob.t so the connect call adds ora_verbose => 6 after that PrintError => 0 and rerun the test with prove -vb. Martin -- Martin J. Evans Wetherby, UK
From wes [...] mailhost.smellycat.com Wed Jul 13 17: 25:15 2011
X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
CC: Wes Brown <wes [...] smellycat.com>
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-9058-1310546685-426.69350-6-0 [...] rt.cpan.org>
Content-Disposition: inline
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-9060-1310132875-688.69350-6-0 [...] rt.cpan.org> <20110709031134.GA14547 [...] smellycat.com> <20110711135557.GA31582 [...] smellycat.com> <rt-3.8.HEAD-9058-1310392576-1150.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-9058-1310546685-426.69350-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <20110713212446.GA12208 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 8B97B61E007 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Wed, 13 Jul 2011 17:25:15 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UG+X0Bgl4Q7v for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Wed, 13 Jul 2011 17:25:10 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 2E87C2404BF for <bug-DBD-Oracle [...] rt.cpan.org>; Wed, 13 Jul 2011 17:25:09 -0400 (EDT)
Received: (qmail 3435 invoked by uid 103); 13 Jul 2011 21:25:08 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 13 Jul 2011 21:25:08 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Wed, 13 Jul 2011 14:25:03 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id p6DLOm07005235 for <bug-DBD-Oracle [...] rt.cpan.org>; Wed, 13 Jul 2011 17:24:48 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id p6DLOkAt012261; Wed, 13 Jul 2011 17:24:46 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id p6DLOkO1012260; Wed, 13 Jul 2011 17:24:46 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
User-Agent: Mutt/1.4.2.2i
Return-Path: <wes [...] mailhost.smellycat.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Wed, 13 Jul 2011 17:24:46 -0400
X-Spam-Level:
To: Martin J Evans via RT <bug-DBD-Oracle [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: Wes Brown <wes [...] smellycat.com>
RT-Message-ID: <rt-3.8.HEAD-12435-1310592316-742.69350-0-0 [...] rt.cpan.org>
Content-Length: 39449
Download (untitled) / with headers
text/plain 38.5k

Message body is not shown because it is too large.

MIME-Version: 1.0
In-Reply-To: <20110708003409.GA17048 [...] smellycat.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <20110708003409.GA17048 [...] smellycat.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-12435-1311791250-91.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 844
Download (untitled) / with headers
text/plain 844b
Hmmm... Darn. The 11.2g client/server combination is working on my machine: $ prove -v -b t/00versions.t t/31lob.t t/00versions.t .. 1..2 # OCI client library version: 11.2.0.1 ok 1 # database version: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production ok 2 ok 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 ok 10 - returned LOB as string ok 11 - returned IN/OUT LOB as string ok 12 - no temp lobs left ok All tests successful. Files=2, Tests=14, 2 wallclock secs ( 0.03 usr 0.01 sys + 0.14 cusr 0.07 csys = 0.25 CPU) Result: PASS
From wes [...] mailhost.smellycat.com Wed Aug 3 13: 12:06 2011
X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-12435-1311791251-1602.69350-6-0 [...] rt.cpan.org>
Content-Disposition: inline
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12435-1311791251-1602.69350-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <20110803171152.GA12308 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 62D612406E8 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Wed, 3 Aug 2011 13:12:06 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id QoyL-EdxUcWo for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Wed, 3 Aug 2011 13:12:04 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 5AAD52406E0 for <bug-DBD-Oracle [...] rt.cpan.org>; Wed, 3 Aug 2011 13:12:03 -0400 (EDT)
Received: (qmail 23829 invoked by uid 103); 3 Aug 2011 17:12:02 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 3 Aug 2011 17:12:02 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Wed, 03 Aug 2011 10:12:00 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id p73GZYtN014983 for <bug-DBD-Oracle [...] rt.cpan.org>; Wed, 3 Aug 2011 12:35:34 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id p73HBrmG013023 for <bug-DBD-Oracle [...] rt.cpan.org>; Wed, 3 Aug 2011 13:11:53 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id p73HBqRS013022 for bug-DBD-Oracle [...] rt.cpan.org; Wed, 3 Aug 2011 13:11:52 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
User-Agent: Mutt/1.4.2.2i
Return-Path: <wes [...] mailhost.smellycat.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Wed, 3 Aug 2011 13:11:52 -0400
X-Spam-Level:
To: Pythian Remote DBA via RT <bug-DBD-Oracle [...] rt.cpan.org>
From: Wes Brown <wes [...] smellycat.com>
RT-Message-ID: <rt-3.8.HEAD-12436-1312391527-915.69350-0-0 [...] rt.cpan.org>
Content-Length: 1250
Download (untitled) / with headers
text/plain 1.2k
On Wed, Jul 27, 2011 at 02:27:31PM -0400, Pythian Remote DBA via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=69350 > > > Hmmm... Darn. The 11.2g client/server combination is working on my machine: > > $ prove -v -b t/00versions.t t/31lob.t > t/00versions.t .. > 1..2 > # OCI client library version: 11.2.0.1 > ok 1 > # database version: Oracle Database 11g Release 11.2.0.2.0 - 64bit > Production > ok 2 > ok > 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 > ok 10 - returned LOB as string > ok 11 - returned IN/OUT LOB as string > ok 12 - no temp lobs left > ok > All tests successful. > Files=2, Tests=14, 2 wallclock secs ( 0.03 usr 0.01 sys + 0.14 cusr > 0.07 csys = 0.25 CPU) > Result: PASS
Is it possible that it is something that crept in at Oracle Client version 11.2.0.2.x? This is about the only thing that is different that I can see from my less than expert point of observation. Thanks Wes
MIME-Version: 1.0
In-Reply-To: <20110708003409.GA17048 [...] smellycat.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <20110708003409.GA17048 [...] smellycat.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-20559-1314387323-1897.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 243
Download (untitled) / with headers
text/plain 243b
Gwen was able to reproduce the problem, and confirmed that the issue is not a new one for 1.29_1, but is present to all releases since 1.24. In light of that, I'm going ahead with the release of 1.30 (and will try to squash this bug for 1.32).
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-20559-1314387323-1897.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-20559-1314387323-1897.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-10812-1330772824-670.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 505
Download (untitled) / with headers
text/plain 505b
On Fri Aug 26 15:35:23 2011, PYTHIAN wrote: Show quoted text
> Gwen was able to reproduce the problem, and confirmed that the issue is > not a new one for 1.29_1, but is present to all releases since 1.24. In > light of that, I'm going ahead with the release of 1.30 (and will try to > squash this bug for 1.32).
I don't understand why 31lob.t now says: plan skip_all => "see RT#69350" if ORA_OCI() =~ /^11\.2\./; I have 11.2 and if I uncomment the above the test runs fine. Martin -- Martin J. Evans Wetherby, UK
From champoux [...] pythian.com Mon Mar 5 13: 17:51 2012
MIME-Version: 1.0
X-Spam-Status: No, score=-1.954 tagged_above=-99.9 required=10 tests=[AWL=-0.833, BAYES_00=-1.9, SPF_NEUTRAL=0.779] autolearn=no
In-Reply-To: <rt-3.8.HEAD-10812-1330772824-1622.69350-5-0 [...] rt.cpan.org>
X-Spam-Flag: NO
Received-SPF: pass (google.com: domain of champoux [...] pythian.com designates 10.60.4.162 as permitted sender) client-ip=10.60.4.162;
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-20559-1314387323-1897.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-10812-1330772824-1622.69350-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <4F550343.2020501 [...] pythian.com>
Content-Type: text/plain; charset="utf-8"; format="flowed"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -1.954
Authentication-Results: mr.google.com; spf=pass (google.com: domain of champoux [...] pythian.com designates 10.60.4.162 as permitted sender) smtp.mail=champoux [...] pythian.com
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 37F7B240090 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 5 Mar 2012 13:17:51 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 4GlCInP3ukYc for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 5 Mar 2012 13:17:49 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 6A831240075 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 5 Mar 2012 13:17:49 -0500 (EST)
Received: (qmail 28105 invoked by uid 103); 5 Mar 2012 18:17:48 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 5 Mar 2012 18:17:48 -0000
Received: from na3sys009aog120.obsmtp.com (HELO na3sys009aog120.obsmtp.com) (74.125.149.140) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with SMTP; Mon, 05 Mar 2012 10:17:45 -0800
Received: from mail-tul01m020-f175.google.com ([209.85.214.175]) (using TLSv1) by na3sys009aob120.postini.com ([74.125.148.12]) with SMTP ID DSNKT1UDRuKV3aJYih11S5F2cQgN3/PRqGvE [...] postini.com; Mon, 05 Mar 2012 10:17:45 PST
Received: by obqv19 with SMTP id v19so5156490obq.20 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 05 Mar 2012 10:17:42 -0800 (PST)
Received: from mr.google.com ([10.60.4.162]) by 10.60.4.162 with SMTP id l2mr10281341oel.3.1330971462503 (num_hops = 1); Mon, 05 Mar 2012 10:17:42 -0800 (PST)
Received: by 10.60.4.162 with SMTP id l2mr8705601oel.3.1330971462446; Mon, 05 Mar 2012 10:17:42 -0800 (PST)
Received: by 10.60.4.162 with SMTP id l2mr8705596oel.3.1330971462334; Mon, 05 Mar 2012 10:17:42 -0800 (PST)
Received: from [10.237.236.252] (host7.pythian.com. [209.217.100.70]) by mx.google.com with ESMTPS id yv3sm10501570obb.3.2012.03.05.10.17.40 (version=SSLv3 cipher=OTHER); Mon, 05 Mar 2012 10:17:41 -0800 (PST)
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
Return-Path: <champoux [...] pythian.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Mon, 05 Mar 2012 13:17:39 -0500
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
X-GM-Message-State: ALoCoQmEIPEeE1oFNAckaxJF45sxHibaAldy9GlSQvRE287ixf/1PFMo8d33Rvi+Dq4jK9ipYa3GhiMtR5R3N5OLvGxK0tpidQ==
RT-Message-ID: <rt-3.8.HEAD-10815-1330971471-1287.69350-0-0 [...] rt.cpan.org>
Content-Length: 887
Download (untitled) / with headers
text/plain 887b
On 03/03/12 06:07, Martin J Evans via RT wrote: Show quoted text
> I don't understand why 31lob.t now says: > > plan skip_all => "see RT#69350" > if ORA_OCI() =~ /^11\.2\./; > > I have 11.2 and if I uncomment the above the test runs fine.
Yes, if you look at the previous comments, some installations with 11.2 do have successful test runs. It, however, appears that there are some instances that do die in the middle of the test file. It would be more logical to use a TODO wrapper in there instead of a skip_all, but the general idea is not to have random installations fail because of that test, until we can figure out what is the core problem. `/anick -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-10815-1330971471-1287.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-20559-1314387323-1897.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-10812-1330772824-1622.69350-5-0 [...] rt.cpan.org> <4F550343.2020501 [...] pythian.com> <rt-3.8.HEAD-10815-1330971471-1287.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-10810-1330974180-471.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1704
Download (untitled) / with headers
text/plain 1.6k
On Mon Mar 05 13:17:51 2012, PYTHIAN wrote: Show quoted text
> On 03/03/12 06:07, Martin J Evans via RT wrote:
> > I don't understand why 31lob.t now says: > > > > plan skip_all => "see RT#69350" > > if ORA_OCI() =~ /^11\.2\./; > > > > I have 11.2 and if I uncomment the above the test runs fine.
> > Yes, if you look at the previous comments, some installations with > 11.2 do have successful test runs. It, however, appears that there are > some instances that do die in the middle of the test file. > > It would be more logical to use a TODO wrapper in there instead of > a skip_all, but the general idea is not to have random installations > fail because of that test, until we can figure out what is the core
problem. Wouldn't it make more sense to run the test whatever, as in fact, there is a problem. If I had this issue with my 11.2 I'd want to know I've probably got a issue with lobs rather than just skip it then find lobs fail later in my code. In DBD::ODBC there are a number of drivers I've found with bugs and I've wrestled with whether to leave the test failing or to catch the failure and issue a warning but not fail the test. Where there is a workaround I've always done the latter and where there isn't I always did the former but then I got loads of people reporting a test error I already knew about so I changed it to no fail and issue a warning. I think it is better to run the test, catch the issue and warn the user they could have problems with lobs. It is also more likely to lead to a fix from Oracle as the issue looks like an oracle one. I would have reported it to Oracle but as I've never seen it myself I cannot do that. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <20110708003409.GA17048 [...] smellycat.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
References: <20110708003409.GA17048 [...] smellycat.com>
Content-Type: multipart/mixed; boundary="----------=_1332785531-12231-272"
Message-ID: <rt-3.8.HEAD-12231-1332785531-126.69350-0-0 [...] rt.cpan.org>
X-RT-Original-Encoding: utf-8
Content-Length: 0
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 261
Download (untitled) / with headers
text/plain 261b
31lob.t fails for me with Perl 5.12.3 and Oracle 11.1.07. I'm not sure how long it's been failing (presumably since 1.28 but I'm not positive). I've attached the output of prove -vb t/31lob.t with ora_verbose => 6 (sanitizied to remove db username/password).
MIME-Version: 1.0
Subject: 31lob failed.txt
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Type: text/plain; name="31lob failed.txt"
Content-Disposition: inline; filename="31lob failed.txt"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 55346
Download 31lob failed.txt
text/plain 54k

Message body is not shown because it is too large.

MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-12231-1332785531-126.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-25276-1340529319-1440.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 798
Download (untitled) / with headers
text/plain 798b
On Mon Mar 26 14:12:11 2012, MMUSGROVE wrote: Show quoted text
> 31lob.t fails for me with Perl 5.12.3 and Oracle 11.1.07. I'm not sure > how long it's been failing (presumably since 1.28 but I'm not positive). > > I've attached the output of prove -vb t/31lob.t with ora_verbose => 6 > (sanitizied to remove db username/password). >
I really don't know what to do with this RT. It is failing in OCIDescriptorFree with an internal Oracle error and I cannot find that error listed in Oracle bug fixes. I cannot personally report issues to Oracle so I'm stuck. Changing to stalled for now. I still think it would be best not to skip this test but run it and capture the problem outputting a warning if found then at least the people with this issue will know to avoid it. Martin -- Martin J. Evans Wetherby, UK
From wes [...] mailhost.smellycat.com Sun Jun 24 16: 54:24 2012
X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org>
Content-Disposition: inline
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <20120624205408.GA29375 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id CAFB72403A4 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Sun, 24 Jun 2012 16:54:24 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VXn-gGo-f+Ar for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Sun, 24 Jun 2012 16:54:23 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id EF0942400E0 for <bug-DBD-Oracle [...] rt.cpan.org>; Sun, 24 Jun 2012 16:54:21 -0400 (EDT)
Received: (qmail 27833 invoked by uid 103); 24 Jun 2012 20:54:21 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 24 Jun 2012 20:54:21 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Sun, 24 Jun 2012 13:54:18 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id q5OKs7x6003856 for <bug-DBD-Oracle [...] rt.cpan.org>; Sun, 24 Jun 2012 16:54:07 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id q5OKs8YR029434; Sun, 24 Jun 2012 16:54:08 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id q5OKs8iU029433; Sun, 24 Jun 2012 16:54:08 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
User-Agent: Mutt/1.4.2.2i
Return-Path: <wes [...] mailhost.smellycat.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Sun, 24 Jun 2012 16:54:08 -0400
X-Spam-Level:
To: Martin J Evans via RT <bug-DBD-Oracle [...] rt.cpan.org>
From: Wes Brown <wes [...] smellycat.com>
RT-Message-ID: <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org>
Content-Length: 1310
Download (untitled) / with headers
text/plain 1.2k
On Sun, Jun 24, 2012 at 05:15:26AM -0400, Martin J Evans via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=69350 > > > On Mon Mar 26 14:12:11 2012, MMUSGROVE wrote:
> > 31lob.t fails for me with Perl 5.12.3 and Oracle 11.1.07. I'm not sure > > how long it's been failing (presumably since 1.28 but I'm not positive). > > > > I've attached the output of prove -vb t/31lob.t with ora_verbose => 6 > > (sanitizied to remove db username/password). > >
> > I really don't know what to do with this RT. It is failing in > OCIDescriptorFree with an internal Oracle error and I cannot find that > error listed in Oracle bug fixes. I cannot personally report issues to > Oracle so I'm stuck. > > Changing to stalled for now. > > I still think it would be best not to skip this test but run it and > capture the problem outputting a warning if found then at least the > people with this issue will know to avoid it. > > Martin > -- > Martin J. Evans > Wetherby, UK
I am willing to attempt to report the bug to Oracle, but I am not sure how exactly to go about that. Let me know if that is something that should be tried. I think I can open this as something that is impacting the business that I work for. It just may be a challenge to get visibility to this at the Oracle level. Thanks Wes
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 2287
Download (untitled) / with headers
text/plain 2.2k
On Sun Jun 24 16:54:25 2012, wes@smellycat.com wrote: Show quoted text
> On Sun, Jun 24, 2012 at 05:15:26AM -0400, Martin J Evans via RT wrote:
> > <URL: https://rt.cpan.org/Ticket/Display.html?id=69350 > > > > > On Mon Mar 26 14:12:11 2012, MMUSGROVE wrote:
> > > 31lob.t fails for me with Perl 5.12.3 and Oracle 11.1.07. I'm not sure > > > how long it's been failing (presumably since 1.28 but I'm not
positive). Show quoted text
> > > > > > I've attached the output of prove -vb t/31lob.t with ora_verbose => 6 > > > (sanitizied to remove db username/password). > > >
> > > > I really don't know what to do with this RT. It is failing in > > OCIDescriptorFree with an internal Oracle error and I cannot find that > > error listed in Oracle bug fixes. I cannot personally report issues to > > Oracle so I'm stuck. > > > > Changing to stalled for now. > > > > I still think it would be best not to skip this test but run it and > > capture the problem outputting a warning if found then at least the > > people with this issue will know to avoid it. > > > > Martin > > -- > > Martin J. Evans > > Wetherby, UK
> > I am willing to attempt to report the bug to Oracle, but I am not sure how > exactly to go about that. Let me know if that is something that should > be tried. I think I can open this as something that is impacting the > business that I work for. It just may be a challenge to get visibility to > this at the Oracle level. > > Thanks > > Wes
Thanks for coming back on this one Wes. To give some background, I'm trying very hard to clean up the RT queue. Had the issue you found been one I could reproduce I might have had some chance but in any case it ends on an Oracle internal error. I cannot report this to Oracle as I don't personally have access to Oracle support. What you do boils down to what matters to you as this is only a test case and I would assume you do not hit the situation for real. If you choose to report it I would imagine the script and the log output (you posted previously) would be sufficient for Oracle (along with various versions etc). As it appears you are the only one to hit this there seems little greater good in getting it sorted. That leaves us with the dilemma of what to do with the RT but that is our problem. Martin -- Martin J. Evans Wetherby, UK
From wes [...] mailhost.smellycat.com Mon Jun 25 20: 57:00 2012
X-Scanned-BY: MIMEDefang 2.67 on 192.168.5.14
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-27766-1340645073-1626.69350-6-0 [...] rt.cpan.org>
Content-Disposition: inline
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645073-1626.69350-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <20120626005642.GA27078 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 51AB12403EA for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 25 Jun 2012 20:57:00 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id V8lX+yw-2FMg for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 25 Jun 2012 20:56:56 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 52F7C2403CF for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 25 Jun 2012 20:56:55 -0400 (EDT)
Received: (qmail 3312 invoked by uid 103); 26 Jun 2012 00:56:54 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 26 Jun 2012 00:56:54 -0000
Received: from mailhost.smellycat.com (HELO mailhost.smellycat.com) (66.93.12.231) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Mon, 25 Jun 2012 17:56:51 -0700
Received: from prozac.brown-dom (prozac.brown-dom [192.168.5.15]) by mailhost.smellycat.com (8.14.2/8.14.2) with ESMTP id q5Q0ueAg011801 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 25 Jun 2012 20:56:40 -0400
Received: from mailhost.smellycat.com (IDENT:1001 [...] localhost [127.0.0.1]) by prozac.brown-dom (8.13.8/8.13.8) with ESMTP id q5Q0ugcU030162; Mon, 25 Jun 2012 20:56:42 -0400
Received: (from wes [...] localhost) by mailhost.smellycat.com (8.13.8/8.13.8/Submit) id q5Q0ugnK030161; Mon, 25 Jun 2012 20:56:42 -0400
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
User-Agent: Mutt/1.4.2.2i
Return-Path: <wes [...] mailhost.smellycat.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
Date: Mon, 25 Jun 2012 20:56:42 -0400
X-Spam-Level:
To: Martin J Evans via RT <bug-DBD-Oracle [...] rt.cpan.org>
From: Wes Brown <wes [...] smellycat.com>
RT-Message-ID: <rt-3.8.HEAD-27762-1340672221-1629.69350-0-0 [...] rt.cpan.org>
Content-Length: 3769
Download (untitled) / with headers
text/plain 3.6k
On Mon, Jun 25, 2012 at 01:24:33PM -0400, Martin J Evans via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=69350 > > > On Sun Jun 24 16:54:25 2012, wes@smellycat.com wrote:
> > On Sun, Jun 24, 2012 at 05:15:26AM -0400, Martin J Evans via RT wrote:
> > > <URL: https://rt.cpan.org/Ticket/Display.html?id=69350 > > > > > > > On Mon Mar 26 14:12:11 2012, MMUSGROVE wrote:
> > > > 31lob.t fails for me with Perl 5.12.3 and Oracle 11.1.07. I'm not sure > > > > how long it's been failing (presumably since 1.28 but I'm not
> positive).
> > > > > > > > I've attached the output of prove -vb t/31lob.t with ora_verbose => 6 > > > > (sanitizied to remove db username/password). > > > >
> > > > > > I really don't know what to do with this RT. It is failing in > > > OCIDescriptorFree with an internal Oracle error and I cannot find that > > > error listed in Oracle bug fixes. I cannot personally report issues to > > > Oracle so I'm stuck. > > > > > > Changing to stalled for now. > > > > > > I still think it would be best not to skip this test but run it and > > > capture the problem outputting a warning if found then at least the > > > people with this issue will know to avoid it. > > > > > > Martin > > > -- > > > Martin J. Evans > > > Wetherby, UK
> > > > I am willing to attempt to report the bug to Oracle, but I am not sure how > > exactly to go about that. Let me know if that is something that should > > be tried. I think I can open this as something that is impacting the > > business that I work for. It just may be a challenge to get visibility to > > this at the Oracle level. > > > > Thanks > > > > Wes
> > Thanks for coming back on this one Wes. To give some background, I'm > trying very hard to clean up the RT queue. Had the issue you found been > one I could reproduce I might have had some chance but in any case it > ends on an Oracle internal error. > > I cannot report this to Oracle as I don't personally have access to > Oracle support. What you do boils down to what matters to you as this is > only a test case and I would assume you do not hit the situation for > real. If you choose to report it I would imagine the script and the log > output (you posted previously) would be sufficient for Oracle (along > with various versions etc). > > As it appears you are the only one to hit this there seems little > greater good in getting it sorted. That leaves us with the dilemma of > what to do with the RT but that is our problem. > > Martin > -- > Martin J. Evans > Wetherby, UK
I would like to do everything that I can to assist in helping you resolve this test failure. To be honest, the amount that I know about Oracle can be captured in a small container. I ran across this problem as part of the tests run after the module build. I do also seem to recall that someone was able to reproduce the problem, but I know that you were not able to. Might it have something to do with permissions? I asked our DBA to create the account I used to test with as few permissions as possible. As it has been some time since the first occurance of this, I would like to try to rebuild things with the latest version of Oracle 11 as well as the latest version of the DBD. I do not believe that will occur this month, but I can try to do that in July. Might you be able to provide a code to English translation of the test that was running and where you saw it blow up from the trace I was able to provide? I will also review this with my DBA to see if there is some obscure permission that I need to have to do the operation that the system is not happy about. Thanks for your work on this DBD. I can honestly say we use it every day with our Oracle 10.x client connecting to databases as old as 8.1.7. Wes
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org>
Content-Type: multipart/mixed; boundary="----------=_1342114293-4573-3"
Message-ID: <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org>
From: mcdave [...] stanford.edu
X-RT-Original-Encoding: utf-8
Content-Length: 0
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1116
On Mon Jun 25 13:24:32 2012, MJEVANS wrote: Show quoted text
> I cannot report this to Oracle as I don't personally have access to > Oracle support. What you do boils down to what matters to you as this is > only a test case and I would assume you do not hit the situation for > real. If you choose to report it I would imagine the script and the log > output (you posted previously) would be sufficient for Oracle (along > with various versions etc). > > As it appears you are the only one to hit this there seems little > greater good in getting it sorted. That leaves us with the dilemma of > what to do with the RT but that is our problem. > > Martin
I came across this issue today while trying to set up a brand new server. It has Oracle Instantclient version 11.2, connecting back to an Oracle 11.1.0.6.0 database. I used DBD::Oracle version 1.36. I edited 31lob.t to remove the "skip" statement and to add "ora_verbose => 6" as recommended above. I've attached the results of "prove -vb t/31lob.t" (after editing out my ORACLE_USERID values). I can try filing a service ticket with Oracle and see what comes of that.
MIME-Version: 1.0
Subject: 31lob_tkt69350.txt
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Type: text/plain; charset="utf-8"; name="31lob_tkt69350.txt"
Content-Disposition: inline; filename="31lob_tkt69350.txt"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 35767
Download 31lob_tkt69350.txt
text/plain 34.9k

Message body is not shown because it is too large.

MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1655
Download (untitled) / with headers
text/plain 1.6k
On Thu Jul 12 13:31:33 2012, mcdave@stanford.edu wrote: Show quoted text
> On Mon Jun 25 13:24:32 2012, MJEVANS wrote:
> > I cannot report this to Oracle as I don't personally have access to > > Oracle support. What you do boils down to what matters to you as this is > > only a test case and I would assume you do not hit the situation for > > real. If you choose to report it I would imagine the script and the log > > output (you posted previously) would be sufficient for Oracle (along > > with various versions etc). > > > > As it appears you are the only one to hit this there seems little > > greater good in getting it sorted. That leaves us with the dilemma of > > what to do with the RT but that is our problem. > > > > Martin
> > I came across this issue today while trying to set up a brand new > server. It has Oracle Instantclient version 11.2, connecting back to an > Oracle 11.1.0.6.0 database. I used DBD::Oracle version 1.36. I edited > 31lob.t to remove the "skip" statement and to add "ora_verbose => 6" as > recommended above. I've attached the results of "prove -vb t/31lob.t" > (after editing out my ORACLE_USERID values). > > I can try filing a service ticket with Oracle and see what comes of that.
You log shows a similar result which is again an internal error. I'm not saying DBD::Oracle's use of OCI is flawless but whatever, I'd not expect an internal error. If you can file a ticket and you are happy to do so I'd be very interested in the outcome and I will help in whatever way I can. You can use my CPAN email address mjevans@cpan.org and I can be found on #dbi on irc.perl.org. Thanks Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org>
Content-Type: multipart/mixed; boundary="----------=_1345247814-2963-2"
Message-ID: <rt-3.8.HEAD-2963-1345247814-1888.69350-0-0 [...] rt.cpan.org>
X-RT-Original-Encoding: utf-8
Content-Length: 0
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 46
Just attaching a log from Win64 with OIC 11.2.
MIME-Version: 1.0
Subject: 31lob.log
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Type: application/octet-stream; name="31lob.log"
Content-Disposition: inline; filename="31lob.log"
Content-Transfer-Encoding: base64
Content-Length: 30853
Download 31lob.log
application/octet-stream 30.1k

Message body not shown because it is not plain text.

MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-23297-1352831062-1510.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
From: rmd+bcrd [...] sanger.ac.uk
X-RT-Original-Encoding: utf-8
Content-Length: 1171
Download (untitled) / with headers
text/plain 1.1k
On Thu Jul 12 13:42:20 2012, MJEVANS wrote: Show quoted text
> You log shows a similar result which is again an internal error. I'm not > saying DBD::Oracle's use of OCI is flawless but whatever, I'd not expect > an internal error. If you can file a ticket and you are happy to do so > I'd be very interested in the outcome and I will help in whatever way I > can. You can use my CPAN email address mjevans@cpan.org and I can be > found on #dbi on irc.perl.org.
I just came across this bug while attempting to build DBD::Oracle 1.52, and may have found a solution. The attached patch for t/31lob.t fixes it for me. I have tested it on various versions of perl, and against both the full and instant 11.2 clients. The trigger appears to be at line 127 in t/31lob.t, where reusing $sth causes the LOB in $loc to be destroyed before it gets bound as input in line 129. This makes the test fail, and also seems to lead to a double free later on when everything is being tidied up. Using a new statement handle for this query means $loc still contains a valid LOB, the test works and the internal error goes away. I have attached before and after log files for you to compare. Rob.
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-23297-1352831062-1510.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-23297-1352831062-1510.69350-0-0 [...] rt.cpan.org>
Content-Type: multipart/mixed; boundary="----------=_1352831973-8232-1"
Message-ID: <rt-3.8.HEAD-8232-1352831973-1189.69350-0-0 [...] rt.cpan.org>
From: rmd+bcrd [...] sanger.ac.uk
X-RT-Original-Encoding: utf-8
Content-Length: 0
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 149
Download (untitled) / with headers
text/plain 149b
On Tue Nov 13 13:24:22 2012, rob1999 wrote: Show quoted text
> The attached patch for t/31lob.t ....
Grrr. My attachments didn't. I will try again, sorry. Rob.
Subject: 31lob.t.patch.txt
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"; name="31lob.t.patch.txt"
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline; filename="31lob.t.patch.txt"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 752
Download 31lob.t.patch.txt
text/plain 752b
--- DBD-Oracle-1.52/t/31lob.t 2012-10-19 16:41:17.000000000 +0100 +++ DBD-Oracle-1.52.patch/t/31lob.t 2012-11-12 13:35:56.000000000 +0000 @@ -124,10 +124,10 @@ my $plsql_testcount = 4; $stmt = "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;"; - $sth = $dbh->prepare( $stmt, { ora_auto_lob => 0 } ); - $sth->bind_param_inout( 1, \$len, 16 ); - $sth->bind_param( 2, $loc, { ora_type => ORA_BLOB } ); - $sth->execute; + my $sth2 = $dbh->prepare( $stmt, { ora_auto_lob => 0 } ); + $sth2->bind_param_inout( 1, \$len, 16 ); + $sth2->bind_param( 2, $loc, { ora_type => ORA_BLOB } ); + $sth2->execute; # ORA-00600: internal error code # ORA-00900: invalid SQL statement
Subject: 31lob_patched.log
MIME-Version: 1.0
Content-Type: text/x-log; name="31lob_patched.log"
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline; filename="31lob_patched.log"
Content-Transfer-Encoding: binary
Content-Length: 217638
Download 31lob_patched.log
text/x-log 212.5k

Message body is not shown because it is too large.

MIME-Version: 1.0
Subject: 31lob_orig.log
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Type: text/x-log; name="31lob_orig.log"
Content-Disposition: inline; filename="31lob_orig.log"
Content-Transfer-Encoding: binary
Content-Length: 75094
Download 31lob_orig.log
text/x-log 73.3k

Message body is not shown because it is too large.

MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-23297-1352831062-1510.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-4573-1342114293-682.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-19217-1342114940-1963.69350-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-23297-1352831062-1510.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-25478-1353007182-1782.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1545
Download (untitled) / with headers
text/plain 1.5k
On Tue Nov 13 13:24:22 2012, rob1999 wrote: Show quoted text
> On Thu Jul 12 13:42:20 2012, MJEVANS wrote: >
> > You log shows a similar result which is again an internal error. I'm not > > saying DBD::Oracle's use of OCI is flawless but whatever, I'd not expect > > an internal error. If you can file a ticket and you are happy to do so > > I'd be very interested in the outcome and I will help in whatever way I > > can. You can use my CPAN email address mjevans@cpan.org and I can be > > found on #dbi on irc.perl.org.
> > I just came across this bug while attempting to build DBD::Oracle > 1.52, and may have found a solution. The attached patch for t/31lob.t > fixes it for me. I have tested it on various versions of perl, and > against both the full and instant 11.2 clients. > > The trigger appears to be at line 127 in t/31lob.t, where reusing $sth > causes the LOB in $loc to be destroyed before it gets bound as input in > line 129. This makes the test fail, and also seems to lead to a double > free later on when everything is being tidied up. Using a new statement > handle for this query means $loc still contains a valid LOB, the test > works and the internal error goes away. > > I have attached before and after log files for you to compare. > > Rob. > >
Thanks Rob. I've never been able to reproduce this. Your patch seems pretty straight forward but it would be nice to understand what is happening. I'll take a look at it as soon as I can and apply it once I understand what is going on. Martin -- Martin J. Evans Wetherby, UK
From champoux [...] pythian.com Mon Nov 26 14: 13:53 2012
MIME-Version: 1.0
X-Spam-Status: No, score=-4.356 tagged_above=-99.9 required=10 tests=[AWL=1.765, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, SPF_NEUTRAL=0.779] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-25478-1353007182-493.69350-5-0 [...] rt.cpan.org>
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20110708003409.GA17048 [...] smellycat.com> <rt-3.8.HEAD-12231-1332785531-126.69350-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-25276-1340529320-1598.69350-6-0 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-4573-1342114293-682.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-19217-1342114940-1963.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-23297-1352831062-1510.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-25478-1353007182-493.69350-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <50B3BF61.9050403 [...] pythian.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.356
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id BFF2F2403B6 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 26 Nov 2012 14:13:53 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VCGh-lWsRGNb for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Mon, 26 Nov 2012 14:13:51 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 8034B24036B for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 26 Nov 2012 14:13:51 -0500 (EST)
Received: (qmail 21303 invoked by uid 103); 26 Nov 2012 19:13:50 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 26 Nov 2012 19:13:50 -0000
Received: from na3sys009aog105.obsmtp.com (HELO na3sys009aog105.obsmtp.com) (74.125.149.75) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with SMTP; Mon, 26 Nov 2012 11:13:46 -0800
Received: from mail-oa0-f70.google.com ([209.85.219.70]) (using TLSv1) by na3sys009aob105.postini.com ([74.125.148.12]) with SMTP ID DSNKULO/Zu/bvy2wVEKG+s3ki1dvKH1BGuxX [...] postini.com; Mon, 26 Nov 2012 11:13:46 PST
Received: by mail-oa0-f70.google.com with SMTP id k14so52375466oag.9 for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 26 Nov 2012 11:13:42 -0800 (PST)
Received: by 10.50.13.138 with SMTP id h10mr15524729igc.55.1353957221671; Mon, 26 Nov 2012 11:13:41 -0800 (PST)
Received: by 10.50.13.138 with SMTP id h10mr15524708igc.55.1353957221397; Mon, 26 Nov 2012 11:13:41 -0800 (PST)
Received: from [10.237.236.149] (host7.pythian.com. [209.217.100.70]) by mx.google.com with ESMTPS id gz10sm192766igc.9.2012.11.26.11.13.38 (version=SSLv3 cipher=OTHER); Mon, 26 Nov 2012 11:13:39 -0800 (PST)
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:15.0) Gecko/20120907 Thunderbird/15.0.1
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
Return-Path: <champoux [...] pythian.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
X-Google-Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:x-gm-message-state; bh=2zy+8oajlGGJG2DH6s0vCWF69JVY+4ek+7w2u4jVcaU=; b=S7+bYrWACoO0Wl3ZmPebdqLXcTlZIk3pLB2yWKOuGUFxWksI3Do5pjLbDXGgIPQXjZ JNUuIFeCg0aOwS3sAQMCsw8RAVMBtDZ8eKBboNgJUOokfdVwkWCIETlGcXM45cropBxf nCuFebXznUUTRjwQH9EmOkQ4nID0uNbuc+K6PoAfIfnjkZ1lyXsXGiZYLplsphgkbuy9 a3wuiGe113/+OcCm3mQg1Gyq1sTKM4UXVy8pfZHmT+eP/hOzF9P7cOknCsV0aP/YV+im 3K5fCJ4DEFXFfH1IcBA3Ihx4GI/MfKywPEs9CzyYWEYS93oSnBKmcidJ4F1L71s/4/Es Lkzg==
Date: Mon, 26 Nov 2012 14:13:37 -0500
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
X-GM-Message-State: ALoCoQmyknCWlJ5Mq8Tas3XwLvOrWvi7ZdRz0JEtY2pS8w2Xs1BsssHZ/W4g4oAVAt2ssCMtal584e08mZciBAdju4aoJkKjzP/AYN8Sp8/DBktweg9V+XPfUxAE+OGdLGDNFsw0O/tvRnwos497tv5SM8yPrL3Ruw1vXEMHTCfmZcNkM0xzYTo=
RT-Message-ID: <rt-3.8.HEAD-1572-1353957234-877.69350-0-0 [...] rt.cpan.org>
Content-Length: 561
Download (untitled) / with headers
text/plain 561b
On 12-11-15 02:19 PM, Martin J Evans via RT wrote: Show quoted text
> Your patch seems pretty straight forward but it would be nice to > understand what is happening. I'll take a look at it as soon as I can > and apply it once I understand what is going on.
I've committed an even simpler version of the patch to trunk. But yeah, it'd still be nice to know why in this case the $lob is not surviving the deallocation of its parent $sth. Cheers, `/anick -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- --
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-1572-1353957234-877.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-5-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-4574-1354012066-1942.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1847
Download (untitled) / with headers
text/plain 1.8k
On Mon Nov 26 14:13:54 2012, PYTHIAN wrote: Show quoted text
> On 12-11-15 02:19 PM, Martin J Evans via RT wrote:
> > Your patch seems pretty straight forward but it would be nice to > > understand what is happening. I'll take a look at it as soon as I can > > and apply it once I understand what is going on.
> > I've committed an even simpler version of the patch to trunk. But > yeah, it'd still be nice to know why in this case the $lob is not > surviving the deallocation of its parent $sth. > > Cheers, > `/anick >
Yanick. Your change seemed to be: Modified: dbd-oracle/trunk/t/31lob.t ============================================================================== --- dbd-oracle/trunk/t/31lob.t (original) +++ dbd-oracle/trunk/t/31lob.t Mon Nov 26 11:09:03 2012 @@ -123,8 +123,10 @@ ## test calling PL/SQL with LOB placeholder my $plsql_testcount = 4; - $stmt = "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;"; - $sth = $dbh->prepare( $stmt, { ora_auto_lob => 0 } ); + my $sth = $dbh->prepare( + 'BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;', + { ora_auto_lob => 0 } + ); $sth->bind_param_inout( 1, \$len, 16 ); $sth->bind_param( 2, $loc, { ora_type => ORA_BLOB } ); $sth->execute; I don't think this has the same result as Rob's patch. Lines numbers after your patch: The problem is that $loc is a lob locator associated with the statement $sth created a line 94. By reassigning $sth to a new prepared statement at line 126 the original $sth is thrown away and the $loc is no longer valid. Rob's change got around that by ensuring the second statement was a new scalar thus not destroying the original $sth with the lob locator. Now that Rob has pointed this out it makes sense. I think his patch is a proper fix. Martin -- Martin J. Evans Wetherby, UK
From champoux [...] pythian.com Tue Nov 27 10: 52:45 2012
MIME-Version: 1.0
X-Spam-Status: No, score=-4.454 tagged_above=-99.9 required=10 tests=[AWL=1.667, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, SPF_NEUTRAL=0.779] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-4574-1354012067-1103.69350-5-0 [...] rt.cpan.org>
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-4574-1354012067-1103.69350-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <50B4E1BA.1080002 [...] pythian.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.454
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 72D10240A42 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Tue, 27 Nov 2012 10:52:45 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id XcKZLD9qVYjs for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Tue, 27 Nov 2012 10:52:40 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 11C2C240A3F for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 27 Nov 2012 10:52:39 -0500 (EST)
Received: (qmail 23200 invoked by uid 103); 27 Nov 2012 15:52:39 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 27 Nov 2012 15:52:39 -0000
Received: from na3sys009aog129.obsmtp.com (HELO na3sys009aog129.obsmtp.com) (74.125.149.142) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with SMTP; Tue, 27 Nov 2012 07:52:32 -0800
Received: from mail-ie0-f198.google.com ([209.85.223.198]) (using TLSv1) by na3sys009aob129.postini.com ([74.125.148.12]) with SMTP ID DSNKULThvYMvj5K1jZ9IfhPUj0eBKS2O6xnt [...] postini.com; Tue, 27 Nov 2012 07:52:31 PST
Received: by mail-ie0-f198.google.com with SMTP id s9so28426297iec.9 for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 27 Nov 2012 07:52:28 -0800 (PST)
Received: by 10.43.58.14 with SMTP id wi14mr14449092icb.9.1354031548667; Tue, 27 Nov 2012 07:52:28 -0800 (PST)
Received: by 10.43.58.14 with SMTP id wi14mr14449081icb.9.1354031548447; Tue, 27 Nov 2012 07:52:28 -0800 (PST)
Received: from [10.237.236.149] (host7.pythian.com. [209.217.100.70]) by mx.google.com with ESMTPS id rd10sm1830302igb.1.2012.11.27.07.52.27 (version=SSLv3 cipher=OTHER); Tue, 27 Nov 2012 07:52:27 -0800 (PST)
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:15.0) Gecko/20120907 Thunderbird/15.0.1
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
Return-Path: <champoux [...] pythian.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
X-Google-Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:x-gm-message-state; bh=+n3ma/18272WqztaygVNPErVlk+eiY2SW9OaEqX6tTI=; b=Wk6zXkREsiyQlGvO8oWciVF8u/UI71tos1MUb6zdiI+G6jr/yfMefoTA8eFfkAb3uM ysYP9TaVzNjoP64pDCswxke/6PpIlmba1TDLvgDj5EMQiDk4U+L0o/R7QcAZIVT9cKGF g6oce5uzYT5l/ZCAL/1JMCAhbcgpyR3+Krz2AQDhw99htx6gWxchz5+kiXIiImt0UDbO 49z2MAoJR/Nl8wEQqI8EXqDcayLMeRip2nye254ZPnRi6Yurvgf3G/GsxCtEuyJ6wm3g UsWJg9OytJFOvl5OHDZxgs0dgvybPpeN53heG+QpKzAw4XQrZZdEZXQh27vGHGhl9tbQ 2I4w==
Date: Tue, 27 Nov 2012 10:52:26 -0500
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
X-GM-Message-State: ALoCoQn0xcUYCNwSrP4bxCiXoCcVX4Stiag6PnhPkuPzH0PcT5kQ9LQ4zywQa3++7HAR3BHi2BkwOC6NF0//HRohDkaDjiBGa+tEH2iGXGfBXEsVJ0xSHVUIlosBG850kE8Ejmi81ugq5OcLTyZ5zcpwWjc/GiAYKOtIiA5Hnjjj06zsudb4jsY=
RT-Message-ID: <rt-3.8.HEAD-28866-1354031566-1990.69350-0-0 [...] rt.cpan.org>
Content-Length: 432
Download (untitled) / with headers
text/plain 432b
On 12-11-27 05:27 AM, Martin J Evans via RT wrote: Show quoted text
> I don't think this has the same result as Rob's patch.
I think it does. :-) The patch doesn't reassign $sth, it creates a new lexical variable of the same name in the inner block that eclipses the original variable, but otherwise leaves it untouched. Try it! my $foo = "hello world"; { my $foo = "buh-bye"; } print $foo; -- --
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-28866-1354031566-1990.69350-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-69350 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-4574-1354012067-1103.69350-5-0 [...] rt.cpan.org> <50B4E1BA.1080002 [...] pythian.com> <rt-3.8.HEAD-28866-1354031566-1990.69350-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-28883-1354032150-1766.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 282
Download (untitled) / with headers
text/plain 282b
On Tue Nov 27 10:52:46 2012, PYTHIAN wrote: Show quoted text
> On 12-11-27 05:27 AM, Martin J Evans via RT wrote:
> > I don't think this has the same result as Rob's patch.
> > I think it does. :-)
OOPs. Me having a bad day. Sorry, I missed the "my". Martin -- Martin J. Evans Wetherby, UK
From champoux [...] pythian.com Tue Nov 27 11: 20:36 2012
MIME-Version: 1.0
X-Spam-Status: No, score=-4.542 tagged_above=-99.9 required=10 tests=[AWL=1.579, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, SPF_NEUTRAL=0.779] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-28883-1354032150-209.69350-5-0 [...] rt.cpan.org>
X-Spam-Flag: NO
References: <RT-Ticket-69350 [...] rt.cpan.org> <20120624205408.GA29375 [...] smellycat.com> <rt-3.8.HEAD-19050-1340571265-405.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-27766-1340645072-776.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-4574-1354012067-1103.69350-5-0 [...] rt.cpan.org> <50B4E1BA.1080002 [...] pythian.com> <rt-3.8.HEAD-28866-1354031566-1990.69350-5-0 [...] rt.cpan.org> <rt-3.8.HEAD-28883-1354032150-209.69350-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <50B4E848.8050506 [...] pythian.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.542
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 7BA4124028D for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Tue, 27 Nov 2012 11:20:36 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id DD9FmqUi8Ujg for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Tue, 27 Nov 2012 11:20:34 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id EEF34240086 for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 27 Nov 2012 11:20:33 -0500 (EST)
Received: (qmail 26295 invoked by uid 103); 27 Nov 2012 16:20:33 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 27 Nov 2012 16:20:33 -0000
Received: from na3sys009aog104.obsmtp.com (HELO na3sys009aog104.obsmtp.com) (74.125.149.73) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with SMTP; Tue, 27 Nov 2012 08:20:30 -0800
Received: from mail-ob0-f198.google.com ([209.85.214.198]) (using TLSv1) by na3sys009aob104.postini.com ([74.125.148.12]) with SMTP ID DSNKULToS0ZC6MWC7kAA+qFrYVUaFzMa9Eba [...] postini.com; Tue, 27 Nov 2012 08:20:30 PST
Received: by mail-ob0-f198.google.com with SMTP id un3so50893523obb.9 for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 27 Nov 2012 08:20:27 -0800 (PST)
Received: by 10.50.16.172 with SMTP id h12mr16177241igd.41.1354033226733; Tue, 27 Nov 2012 08:20:26 -0800 (PST)
Received: by 10.50.16.172 with SMTP id h12mr16177217igd.41.1354033226370; Tue, 27 Nov 2012 08:20:26 -0800 (PST)
Received: from [10.237.236.149] (host7.pythian.com. [209.217.100.70]) by mx.google.com with ESMTPS id 10sm1876888ign.5.2012.11.27.08.20.25 (version=SSLv3 cipher=OTHER); Tue, 27 Nov 2012 08:20:25 -0800 (PST)
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:15.0) Gecko/20120907 Thunderbird/15.0.1
Subject: Re: [rt.cpan.org #69350] Issue in 31lob.t for DBD::Oracle 1.28
Return-Path: <champoux [...] pythian.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
X-Google-Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:x-gm-message-state; bh=RPaFMkFmtnq+dXsDCzYDLPjkRUlOVSbhuMe9Tk3StsE=; b=C8VIkQklJOtjC8gM7tcsrn8IzgvJ8U5L4N8qv400MuAv5zIslEl1YMVJ/uKUn1Uv83 ti/mWfYhLqyUMl8dqb040EC6VKFYAZXwYL6b0721ZE35XDuCcPP/l3ncxDTveCrH5CZJ IIqUlDPyF2k52GE0IVmI9uLnriT4+zu5INj/pqWhIx8Zi61veW0WPXgiHYufWDeiADX0 ZY8ToVPU8FP2lCaYZ5Z+L3VMAiCqMWmMaNVFzPFG0/GgEBpWXmFaoR0At82i6cH5pMov u4OvzdU8igMn/UsZwXm3A8CqdJWL0zeHUOs7mJELO5fCVs7QjjFT116ZjMRj4k6mxsiL z5wQ==
Date: Tue, 27 Nov 2012 11:20:24 -0500
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
X-GM-Message-State: ALoCoQm1x/zdxEfVjehSSOiCjRfK6Pvm1tZVrNBd9BtdZmy0/nCLugay+Fgo1B5qJW0Jv+qxzGEnlp59rbKLS7xtOQLxLeVSnaiTTqMYwoeGr1ecOCW6UaJRLHQCrGe8EUWpsfj6xgxcew4TJc7QM78OiVQGjzYCpcBWKt+PsAPJbal7+7COd3g=
RT-Message-ID: <rt-3.8.HEAD-20232-1354033237-1032.69350-0-0 [...] rt.cpan.org>
Content-Length: 368
Download (untitled) / with headers
text/plain 368b
On 12-11-27 11:02 AM, Martin J Evans via RT wrote: Show quoted text
>>> > >I don't think this has the same result as Rob's patch.
>> > >> > I think it does.:-)
> OOPs. Me having a bad day. > > Sorry, I missed the "my".
Heh. No problem. It's still good to have a second pair of eyes, because God knows I also have my share of derping days. :-) Cheers, `/anick -- --
MIME-Version: 1.0
In-Reply-To: <20110708003409.GA17048 [...] smellycat.com>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <20110708003409.GA17048 [...] smellycat.com>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.11-22882-1367614162-1209.69350-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 9
deployed.


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.