Skip Menu |
 

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

Report information
The Basics
Id: 62033
Status: resolved
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: Damon.Atkins [...] contracted.pmintl.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 1.26_4



MIME-Version: 1.0
X-Bigfish: VPS-8(zz936eKzz1202hzz8275bh8275dh186Mz2dh2a8h62h)
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Content-Type: multipart/alternative; boundary="_000_9A65DF4CF1997143BF2E6380819612F0253DFF7BD9pmichlauexc07_"
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -6.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 9B8A1240E08 for <cpan-bug+DBI [...] hipster.bestpractical.com>; Sun, 10 Oct 2010 16:55:57 -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 zWktKIEeI8Ji for <cpan-bug+DBI [...] hipster.bestpractical.com>; Sun, 10 Oct 2010 16:55:54 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 05AB7240D4C for <bug-DBI [...] rt.cpan.org>; Sun, 10 Oct 2010 16:55:52 -0400 (EDT)
Received: (qmail 24092 invoked by uid 103); 10 Oct 2010 20:55:52 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 10 Oct 2010 20:55:52 -0000
Received: from va3ehsobe006.messaging.microsoft.com (HELO VA3EHSOBE006.bigfish.com) (216.32.180.16) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Sun, 10 Oct 2010 13:55:50 -0700
Received: from mail164-va3-R.bigfish.com (10.7.14.241) by VA3EHSOBE006.bigfish.com (10.7.40.26) with Microsoft SMTP Server id 14.1.225.8; Sun, 10 Oct 2010 20:55:47 +0000
Received: from mail164-va3 (localhost.localdomain [127.0.0.1]) by mail164-va3-R.bigfish.com (Postfix) with ESMTP id 044801A000B3 for <bug-DBI [...] rt.cpan.org>; Sun, 10 Oct 2010 20:55:46 +0000 (UTC)
Received: from mail164-va3 (localhost.localdomain [127.0.0.1]) by mail164-va3 (MessageSwitch) id 1286744143622846_24790; Sun, 10 Oct 2010 20:55:43 +0000 (UTC)
Received: from VA3EHSMHS009.bigfish.com (unknown [10.7.14.246]) by mail164-va3.bigfish.com (Postfix) with ESMTP id 336F31B8046 for <bug-DBI [...] rt.cpan.org>; Sun, 10 Oct 2010 20:55:42 +0000 (UTC)
Received: from pmichsmtp02.pconnect.biz (193.222.161.208) by VA3EHSMHS009.bigfish.com (10.7.99.19) with Microsoft SMTP Server (TLS) id 14.0.482.44; Sun, 10 Oct 2010 20:55:37 +0000
Received: from pmichlaucas02.PMINTL.NET (10.155.0.219) by pmichsmtp02.pconnect.biz (10.150.230.208) with Microsoft SMTP Server id 8.2.254.0; Sun, 10 Oct 2010 22:55:32 +0200
Received: from pmichlaucas04.PMINTL.NET (10.155.169.10) by pmichlaucas02.PMINTL.NET (10.155.0.219) with Microsoft SMTP Server (TLS) id 8.2.254.0; Sun, 10 Oct 2010 22:55:36 +0200
Received: from pmichlauexc07.PMINTL.NET ([10.155.41.4]) by pmichlaucas04.PMINTL.NET ([10.155.169.10]) with mapi; Sun, 10 Oct 2010 22:55:35 +0200
Delivered-To: cpan-bug+DBI [...] hipster.bestpractical.com
Subject: prepared_cache invalid after error
Thread-Index: ActovXgjI6wo5vcvRamLqOxGC6Gc1A==
X-Spam-Check-BY: 16.mx.develooper.com
Date: Sun, 10 Oct 2010 22:55:28 +0200
X-Spam-Level:
X-CR-Hashedpuzzle: B11t C8Jv Ew1J FNbZ FvPz Gjxq Gwjf HRoI IHXk IyfY J/o7 KVkv Kwyt Kz92 LA27 LOND;1;YgB1AGcALQBkAGIAaQBAAHIAdAAuAGMAcABhAG4ALgBvAHIAZwA=;Sosha1_v1;7;{36291BB0-2AC4-4B23-9692-929E976D41EA};ZABhAG0AbwBuAC4AYQB0AGsAaQBuAHMAQABjAG8AbgB0AHIAYQBjAHQAZQBkAC4AcABtAGkAbgB0AGwALgBjAG8AbQA=;Sun, 10 Oct 2010 20:55:28 GMT;cAByAGUAcABhAHIAZQBkAF8AYwBhAGMAaABlACAAaQBuAHYAYQBsAGkAZAAgAGEAZgB0AGUAcgAgAGUAcgByAG8AcgA=
To: "bug-DBI [...] rt.cpan.org" <bug-DBI [...] rt.cpan.org>
X-Spamscore: -8
From Damon.Atkins [...] contracted.pmintl.com Sun Oct 10 16: 55:57 2010
X-Spam-Status: No, score=-6.899 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5] autolearn=ham
Content-Language: en-US
Message-ID: <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET>
X-MS-Tnef-Correlator:
X-CR-Puzzleid: {36291BB0-2AC4-4B23-9692-929E976D41EA}
Return-Path: <Damon.Atkins [...] contracted.pmintl.com>
X-Reverse-DNS: pmichsmtp02.pconnect.biz
X-Original-To: cpan-bug+DBI [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbi
Thread-Topic: prepared_cache invalid after error
X-MS-Has-Attach:
Accept-Language: en-US
X-Spam-TCS-SCL: 1:0
From: "Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: us-ascii
Content-Length: 1119
For example if you prepare_cache('insert....') (Perl on Win32 ODBC to MSSQL) and then insert a NULL into a non-null field, an execute error occurs. Then you come back to do a valid insert, it freezes at the execute. (I thought I had an SQL dead lock) I found the fix was to delete the dbi hash used by the prepare_cache on execute errror, so that when prepare_cache is called again it is completed from scratch (ie no cache). DBD.pm 9530 2007-05-09 13:05:23Z W32ODBC.pm 8696 2007-01-24 23:12:38Z timbo $ This is perl, v5.8.8 built for MSWin32-x86-multi-thread (with 18 registered patches, see perl -V for more detail) Cheers Damon Show quoted text
________________________________ NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: us-ascii
Content-Length: 5827
MIME-Version: 1.0
In-Reply-To: <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2363-1286884337-641.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 61
Moved to DBD-ODBC as I'm sure this isn't a bug in DBI itself.
MIME-Version: 1.0
In-Reply-To: <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2357-1288116900-96.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 977
Download (untitled) / with headers
text/plain 977b
On Sun Oct 10 16:55:59 2010, Damon.Atkins@contracted.pmintl.com wrote: Show quoted text
> For example if you prepare_cache('insert....') (Perl on Win32 ODBC to > MSSQL) > and then insert a NULL into a non-null field, an execute error occurs. > > Then you come back to do a valid insert, it freezes at the execute. (I > thought I had an SQL dead lock) > I found the fix was to delete the dbi hash used by the prepare_cache > on execute errror, so that > when prepare_cache is called again it is completed from scratch (ie > no cache). > > DBD.pm 9530 2007-05-09 13:05:23Z > W32ODBC.pm 8696 2007-01-24 23:12:38Z timbo $ > This is perl, v5.8.8 built for MSWin32-x86-multi-thread > (with 18 registered patches, see perl -V for more detail) > > Cheers > Damon > >
Appologies for not responding earlier but I never got an email from rt to say this bug was logged so missed it. I will attempt to look into your problem in the next few days. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-2357-1288116900-96.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2357-1288116900-96.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2362-1288172468-1432.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1140
Download (untitled) / with headers
text/plain 1.1k
On Tue Oct 26 14:15:00 2010, MJEVANS wrote: Show quoted text
> On Sun Oct 10 16:55:59 2010, Damon.Atkins@contracted.pmintl.com wrote:
> > For example if you prepare_cache('insert....') (Perl on Win32 ODBC to > > MSSQL) > > and then insert a NULL into a non-null field, an execute error occurs. > > > > Then you come back to do a valid insert, it freezes at the execute. (I > > thought I had an SQL dead lock) > > I found the fix was to delete the dbi hash used by the prepare_cache > > on execute errror, so that > > when prepare_cache is called again it is completed from scratch (ie > > no cache). > > > > DBD.pm 9530 2007-05-09 13:05:23Z > > W32ODBC.pm 8696 2007-01-24 23:12:38Z timbo $ > > This is perl, v5.8.8 built for MSWin32-x86-multi-thread > > (with 18 registered patches, see perl -V for more detail) > > > > Cheers > > Damon > > > >
> > Appologies for not responding earlier but I never got an email from rt > to say this bug was logged so missed it. I will attempt to look into > your problem in the next few days. > > Martin
Hang on a minute. Are you using WIN32ODBC or DBD::ODBC? Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Bigfish: VPS-16(zz542N9370J9371Pzz1202hzz8275dhz2dh2a8h61h)
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id CE5AB240F29 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Fri, 29 Oct 2010 05:27:33 -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 rLk2s159JVLo for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Fri, 29 Oct 2010 05:27:32 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 08A50240EEF for <bug-DBD-ODBC [...] rt.cpan.org>; Fri, 29 Oct 2010 05:27:30 -0400 (EDT)
Received: (qmail 31264 invoked by uid 103); 29 Oct 2010 09:27:30 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 29 Oct 2010 09:27:30 -0000
Received: from db3ehsobe005.messaging.microsoft.com (HELO DB3EHSOBE005.bigfish.com) (213.199.154.143) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Fri, 29 Oct 2010 02:27:28 -0700
Received: from mail55-db3-R.bigfish.com (10.3.81.246) by DB3EHSOBE005.bigfish.com (10.3.84.25) with Microsoft SMTP Server id 14.1.225.8; Fri, 29 Oct 2010 09:27:24 +0000
Received: from mail55-db3 (localhost.localdomain [127.0.0.1]) by mail55-db3-R.bigfish.com (Postfix) with ESMTP id 1DEC81A0837B for <bug-DBD-ODBC [...] rt.cpan.org>; Fri, 29 Oct 2010 09:27:24 +0000 (UTC)
Received: from mail55-db3 (localhost.localdomain [127.0.0.1]) by mail55-db3 (MessageSwitch) id 1288344438823452_20053; Fri, 29 Oct 2010 09:27:18 +0000 (UTC)
Received: from DB3EHSMHS001.bigfish.com (unknown [10.3.81.244]) by mail55-db3.bigfish.com (Postfix) with ESMTP id BC4FD11C8050 for <bug-DBD-ODBC [...] rt.cpan.org>; Fri, 29 Oct 2010 09:27:18 +0000 (UTC)
Received: from pmichsmtp01.pconnect.biz (193.222.161.207) by DB3EHSMHS001.bigfish.com (10.3.87.101) with Microsoft SMTP Server (TLS) id 14.1.225.8; Fri, 29 Oct 2010 09:27:15 +0000
Received: from pmichlaucas01.PMINTL.NET (10.155.134.212) by PMICHSMTP01.pconnect.biz (10.150.230.207) with Microsoft SMTP Server id 8.2.254.0; Fri, 29 Oct 2010 05:39:02 +0200
Received: from pmichlaucas03.PMINTL.NET (10.155.41.12) by pmichlaucas01.PMINTL.NET (10.155.134.212) with Microsoft SMTP Server (TLS) id 8.2.254.0; Fri, 29 Oct 2010 05:38:49 +0200
Received: from pmichlauexc07.PMINTL.NET ([10.155.41.4]) by pmichlaucas03.PMINTL.NET ([10.155.41.12]) with mapi; Fri, 29 Oct 2010 05:38:49 +0200
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #62033] prepared_cache invalid after error
X-Spam-Check-BY: 16.mx.develooper.com
Thread-Index: Act1uxhDr1CEQAjTSICiNwrv7craUQBX4oUA
Date: Fri, 29 Oct 2010 05:38:45 +0200
X-Originatororg: contracted.pmintl.com
X-Spam-Level:
X-Spamscore: -16
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
X-FB-SS: 0,
Content-Transfer-Encoding: base64
From Damon.Atkins [...] contracted.pmintl.com Fri Oct 29 05: 27:33 2010
In-Reply-To: <rt-3.8.HEAD-2362-1288172468-962.62033-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-6.899 tagged_above=-99.9 required=10 tests=[AWL=0.001, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
Content-Language: en-US
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2357-1288116900-96.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2362-1288172468-962.62033-6-0 [...] rt.cpan.org>
Message-ID: <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET>
X-MS-Tnef-Correlator:
Return-Path: <Damon.Atkins [...] contracted.pmintl.com>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #62033] prepared_cache invalid after error
Accept-Language: en-US
X-Spam-TCS-SCL: 0:0
From: "Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>
RT-Message-ID: <rt-3.8.HEAD-2363-1288344454-784.62033-0-0 [...] rt.cpan.org>
Content-Length: 925
Download (untitled) / with headers
text/plain 925b
$$pconnectstring = DBI->connect("dbi:ODBC:$dsn", $login, $pwd Show quoted text
-----Original Message----- From: Martin J Evans via RT [mailto:bug-DBD-ODBC@rt.cpan.org] Sent: Wednesday, 27 October 2010 8:41 PM To: Atkins, Damon (contracted) Subject: [rt.cpan.org #62033] prepared_cache invalid after error <URL: https://rt.cpan.org/Ticket/Display.html?id=62033 > Hang on a minute. Are you using WIN32ODBC or DBD::ODBC? Martin -- Martin J. Evans Wetherby, UK NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-2363-1288344454-784.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2357-1288116900-96.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2362-1288172468-962.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2361-1288636334-1471.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1558
Download (untitled) / with headers
text/plain 1.5k
On Fri Oct 29 05:27:34 2010, Damon.Atkins@contracted.pmintl.com wrote: Show quoted text
> $$pconnectstring = DBI->connect("dbi:ODBC:$dsn", $login, $pwd > -----Original Message----- > From: Martin J Evans via RT > [mailto:bug-DBD-ODBC@rt.cpan.org] > Sent: Wednesday, 27 October 2010 > 8:41 PM > To: Atkins, Damon (contracted) > Subject: [rt.cpan.org > #62033] prepared_cache invalid after error > > <URL: > https://rt.cpan.org/Ticket/Display.html?id=62033 > > > > Hang on a > minute. Are you using WIN32ODBC or DBD::ODBC? > > Martin
The following works for me and outputs: C:\Users\martin\Documents\dbd_odbc\rt62033>perl test.pl DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Can not insert the value NULL into column 'b', table 'master.dbo.mje'; column does n ot allow nulls. INSERT fails. (SQL-23000) [state was 23000 now 01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated . (SQL-01000) at test.pl line 14. '1', 'fred ' 1 rows 1 use DBI; use strict; my $h = DBI->connect("dbi:ODBC:asus2", {PrintError => 0}) or die "connect"; eval {$h->do(q/drop table mje/);}; $h->do(q/create table mje (a int not null, b char(10) not null)/); my $s = $h->prepare_cached(q/insert into mje values(?,?)/); eval { $s->execute(1, undef); }; print "insert null died\n" if $@; $s->execute(1, 'fred'); my $r = $h->prepare(q/select * from mje/); $r->execute; print DBI::dump_results($r); What are you doing differently? Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Bigfish: VPS0(zzzz1202hzzz2dh2a8h61h)
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Scanned: Debian amavisd-new at bestpractical.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 D86DE240F8D for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Mon, 1 Nov 2010 19:09:29 -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 CmPnreCZBZn9 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Mon, 1 Nov 2010 19:09:28 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id B8481240F84 for <bug-DBD-ODBC [...] rt.cpan.org>; Mon, 1 Nov 2010 19:09:27 -0400 (EDT)
Received: (qmail 2987 invoked by uid 103); 1 Nov 2010 23:09:31 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 1 Nov 2010 23:09:31 -0000
Received: from db3ehsobe005.messaging.microsoft.com (HELO DB3EHSOBE005.bigfish.com) (213.199.154.143) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Mon, 01 Nov 2010 16:09:29 -0700
Received: from mail70-db3-R.bigfish.com (10.3.81.243) by DB3EHSOBE005.bigfish.com (10.3.84.25) with Microsoft SMTP Server id 14.1.225.8; Mon, 1 Nov 2010 23:09:24 +0000
Received: from mail70-db3 (localhost.localdomain [127.0.0.1]) by mail70-db3-R.bigfish.com (Postfix) with ESMTP id 77A8630413 for <bug-DBD-ODBC [...] rt.cpan.org>; Mon, 1 Nov 2010 23:09:24 +0000 (UTC)
Received: from mail70-db3 (localhost.localdomain [127.0.0.1]) by mail70-db3 (MessageSwitch) id 1288652964268296_26922; Mon, 1 Nov 2010 23:09:24 +0000 (UTC)
Received: from DB3EHSMHS005.bigfish.com (unknown [10.3.81.252]) by mail70-db3.bigfish.com (Postfix) with ESMTP id 3E44B18B8050 for <bug-DBD-ODBC [...] rt.cpan.org>; Mon, 1 Nov 2010 23:09:24 +0000 (UTC)
Received: from pmichsmtp02.pconnect.biz (193.222.161.208) by DB3EHSMHS005.bigfish.com (10.3.87.105) with Microsoft SMTP Server (TLS) id 14.0.482.44; Mon, 1 Nov 2010 23:09:23 +0000
Received: from pmichlaucas02.PMINTL.NET (10.155.0.219) by pmichsmtp02.pconnect.biz (10.150.230.208) with Microsoft SMTP Server id 8.2.254.0; Tue, 2 Nov 2010 00:09:15 +0100
Received: from pmichlauexc07.PMINTL.NET ([10.155.41.4]) by pmichlaucas02.PMINTL.NET ([10.155.0.219]) with mapi; Tue, 2 Nov 2010 00:09:22 +0100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #62033] prepared_cache invalid after error
X-Spam-Check-BY: 16.mx.develooper.com
Thread-Index: Act58x7/jpdHnDhYS9mOJsjL+4yZhAAJarjg
Date: Tue, 2 Nov 2010 00:09:19 +0100
X-Spam-Level:
X-Spamscore: 0
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: base64
From Damon.Atkins [...] contracted.pmintl.com Mon Nov 1 19: 09:30 2010
In-Reply-To: <rt-3.8.HEAD-2361-1288636334-115.62033-6-0 [...] rt.cpan.org>
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
Content-Language: en-US
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2357-1288116900-96.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2362-1288172468-962.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2361-1288636334-115.62033-6-0 [...] rt.cpan.org>
Message-ID: <9A65DF4CF1997143BF2E6380819612F0254193F008 [...] pmichlauexc07.PMINTL.NET>
X-MS-Tnef-Correlator:
X-Reverse-DNS: pmichsmtp02.pconnect.biz
Return-Path: <Damon.Atkins [...] contracted.pmintl.com>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #62033] prepared_cache invalid after error
Accept-Language: en-US
X-Spam-TCS-SCL: 0:0
From: "Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>
RT-Message-ID: <rt-3.8.HEAD-2358-1288652975-822.62033-0-0 [...] rt.cpan.org>
Content-Length: 1659
Download (untitled) / with headers
text/plain 1.6k
Prepare cache is in a function and is called every time The following works for me and outputs: C:\Users\martin\Documents\dbd_odbc\rt62033>perl test.pl DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Can not insert the value NULL into column 'b', table 'master.dbo.mje'; column does n ot allow nulls. INSERT fails. (SQL-23000) [state was 23000 now 01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated . (SQL-01000) at test.pl line 14. '1', 'fred ' 1 rows 1 use DBI; use strict; # No eval warps, call prepare_cached each time sub doit { my $dbh=shift @_; my $s = $dbh->prepare_cached(q/insert into mje values(?,?)/); $s->execute(@_); print "sql errors $DBI::errstr\n"; } my $h = DBI->connect("dbi:ODBC:asus2", {PrintError => 0}) or die "connect"; eval {$h->do(q/drop table mje/);}; $h->do(q/create table mje (a int not null, b char(10) not null)/); doit($h,1, undef); doit($h,1,'fred'); my $r = $h->prepare(q/select * from mje/); $r->execute; print DBI::dump_results($r); What are you doing differently? Martin -- Martin J. Evans Wetherby, UK NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-2358-1288652975-822.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2357-1288116900-96.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2362-1288172468-962.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2361-1288636334-115.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0254193F008 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2358-1288652975-822.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2361-1288685291-920.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 754
Download (untitled) / with headers
text/plain 754b
On Mon Nov 01 19:09:35 2010, Damon.Atkins@contracted.pmintl.com wrote: Show quoted text
> > Prepare cache is in a function and is called every time >
The following still works for me. What output do you get when you run it? use DBI; use strict; sub doit { my $dbh=shift @_; my $s = $dbh->prepare_cached(q/insert into mje values(?,?)/); $s->execute(@_); print "sql errors $DBI::errstr\n"; } my $h = DBI->connect("dbi:ODBC:asus2", {PrintError => 0}) or die "connect"; eval {$h->do(q/drop table mje/);}; $h->do(q/create table mje (a int not null, b char(10) not null)/); doit($h,1, undef); doit($h,1,'fred'); my $r = $h->prepare(q/select * from mje/); $r->execute; print DBI::dump_results($r); Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Bigfish: VPS-28(zz542N1432N9370J98dN9371Pzz1202hzz8275bh8275dhz2dh2a8h61h)
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.895
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 561B2240FB9 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 2 Nov 2010 18:59:39 -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 n2P+hjjNBTRs for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 2 Nov 2010 18:59:37 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 52445240EDC for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 2 Nov 2010 18:59:37 -0400 (EDT)
Received: (qmail 11237 invoked by uid 103); 2 Nov 2010 22:59:42 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 2 Nov 2010 22:59:42 -0000
Received: from tx2ehsobe004.messaging.microsoft.com (HELO TX2EHSOBE009.bigfish.com) (65.55.88.14) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Tue, 02 Nov 2010 15:59:41 -0700
Received: from mail183-tx2-R.bigfish.com (10.9.14.254) by TX2EHSOBE009.bigfish.com (10.9.40.29) with Microsoft SMTP Server id 14.1.225.8; Tue, 2 Nov 2010 22:59:37 +0000
Received: from mail183-tx2 (localhost.localdomain [127.0.0.1]) by mail183-tx2-R.bigfish.com (Postfix) with ESMTP id 41D533F80CE for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 2 Nov 2010 22:59:37 +0000 (UTC)
Received: from mail183-tx2 (localhost.localdomain [127.0.0.1]) by mail183-tx2 (MessageSwitch) id 128873877741912_24898; Tue, 2 Nov 2010 22:59:37 +0000 (UTC)
Received: from TX2EHSMHS009.bigfish.com (unknown [10.9.14.254]) by mail183-tx2.bigfish.com (Postfix) with ESMTP id F1649F28058 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 2 Nov 2010 22:59:36 +0000 (UTC)
Received: from pmichsmtp02.pconnect.biz (193.222.161.208) by TX2EHSMHS009.bigfish.com (10.9.99.109) with Microsoft SMTP Server (TLS) id 14.0.482.44; Tue, 2 Nov 2010 22:59:36 +0000
Received: from pmichlaucas01.PMINTL.NET (10.155.134.212) by pmichsmtp02.pconnect.biz (10.150.230.208) with Microsoft SMTP Server id 8.2.254.0; Tue, 2 Nov 2010 23:59:22 +0100
Received: from pmichlauexc07.PMINTL.NET ([10.155.41.4]) by pmichlaucas01.PMINTL.NET ([10.155.134.212]) with mapi; Tue, 2 Nov 2010 23:59:31 +0100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #62033] prepared_cache invalid after error
X-Spam-Check-BY: 16.mx.develooper.com
Thread-Index: Act6ZRyMv+JI+deyT76yY0U7C90CpAAeeE6w
Date: Tue, 2 Nov 2010 23:59:27 +0100
X-Spam-Level:
X-Spamscore: -28
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: base64
From Damon.Atkins [...] contracted.pmintl.com Tue Nov 2 18: 59:39 2010
In-Reply-To: <rt-3.8.HEAD-2361-1288685292-442.62033-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-6.895 tagged_above=-99.9 required=10 tests=[AWL=-0.005, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, T_FRT_CONTACT=0.01] autolearn=ham
Content-Language: en-US
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0253DFF7BD9 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2357-1288116900-96.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2362-1288172468-962.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2361-1288636334-115.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F0254193F008 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2358-1288652975-822.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2361-1288685292-442.62033-6-0 [...] rt.cpan.org>
Message-ID: <9A65DF4CF1997143BF2E6380819612F0254193F573 [...] pmichlauexc07.PMINTL.NET>
X-MS-Tnef-Correlator:
X-Reverse-DNS: pmichsmtp02.pconnect.biz
Return-Path: <Damon.Atkins [...] contracted.pmintl.com>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #62033] prepared_cache invalid after error
Accept-Language: en-US
X-Spam-TCS-SCL: 0:0
From: "Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>
RT-Message-ID: <rt-3.8.HEAD-2357-1288738786-291.62033-0-0 [...] rt.cpan.org>
Content-Length: 1934
Download (untitled) / with headers
text/plain 1.8k
The value returned by $s = $dbh->prepare_cached(...) is invalid. I asume that $s contains a handle to a prepared statement and that ODBC invalidates it (or closes it, or MS SQL invalidates it) but $s = $dbh->prepare_cached(...) still returns it. and so the execute fails. Assuming your connecting to a MSSQL DB via ODBC Maybe the next step is just to check versions of DLL's Cheers Show quoted text
-----Original Message----- From: Martin J Evans via RT [mailto:bug-DBD-ODBC@rt.cpan.org] Sent: Tuesday, 2 November 2010 7:08 PM To: Atkins, Damon (contracted) Subject: [rt.cpan.org #62033] prepared_cache invalid after error <URL: https://rt.cpan.org/Ticket/Display.html?id=62033 > On Mon Nov 01 19:09:35 2010, Damon.Atkins@contracted.pmintl.com wrote:
> > Prepare cache is in a function and is called every time >
The following still works for me. What output do you get when you run it? use DBI; use strict; sub doit { my $dbh=shift @_; my $s = $dbh->prepare_cached(q/insert into mje values(?,?)/); $s->execute(@_); print "sql errors $DBI::errstr\n"; } my $h = DBI->connect("dbi:ODBC:asus2", {PrintError => 0}) or die "connect"; eval {$h->do(q/drop table mje/);}; $h->do(q/create table mje (a int not null, b char(10) not null)/); doit($h,1, undef); doit($h,1,'fred'); my $r = $h->prepare(q/select * from mje/); $r->execute; print DBI::dump_results($r); Martin -- Martin J. Evans Wetherby, UK NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-2357-1288738786-291.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2359-1288772722-1948.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 716
Download (untitled) / with headers
text/plain 716b
On Tue Nov 02 18:59:46 2010, Damon.Atkins@contracted.pmintl.com wrote: Show quoted text
> The value returned by $s = $dbh->prepare_cached(...) is invalid. > I > asume that $s contains a handle to a prepared statement and that > ODBC invalidates it (or closes it, or MS SQL invalidates it) > but > $s = $dbh->prepare_cached(...) still returns it. > and so the > execute fails. > > Assuming your connecting to a MSSQL DB via ODBC > Maybe the next step is just to check versions of DLL's > > Cheers
I was connecting to MS SQL Server via ODBC. Can you send me a trace. set DBI_TRACE=15=x.log then run the smallest script which reproduces the problem and send me the log file. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-2359-1288772722-1948.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2359-1288772722-1948.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2356-1290434561-796.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 981
Download (untitled) / with headers
text/plain 981b
On Wed Nov 03 04:25:22 2010, MJEVANS wrote: Show quoted text
> On Tue Nov 02 18:59:46 2010, Damon.Atkins@contracted.pmintl.com wrote:
> > The value returned by $s = $dbh->prepare_cached(...) is invalid. > > I > > asume that $s contains a handle to a prepared statement and that > > ODBC invalidates it (or closes it, or MS SQL invalidates it) > > but > > $s = $dbh->prepare_cached(...) still returns it. > > and so the > > execute fails. > > > > Assuming your connecting to a MSSQL DB via ODBC > > Maybe the next step is just to check versions of DLL's > > > > Cheers
> > I was connecting to MS SQL Server via ODBC. > > Can you send me a trace. > > set DBI_TRACE=15=x.log > > then run the smallest script which reproduces the problem and send me > the log file. > > Martin
Have you resolved this issue? I've not heard anything in nearly 3 weeks and cannot see a way to progress this without a log as I cannot reproduce your problem. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-2356-1290434561-796.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2359-1288772722-1948.62033-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-2356-1290434561-796.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19311-1292260375-583.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1138
Download (untitled) / with headers
text/plain 1.1k
On Mon Nov 22 09:02:41 2010, MJEVANS wrote: Show quoted text
> On Wed Nov 03 04:25:22 2010, MJEVANS wrote:
> > On Tue Nov 02 18:59:46 2010, Damon.Atkins@contracted.pmintl.com wrote:
> > > The value returned by $s = $dbh->prepare_cached(...) is invalid. > > > I > > > asume that $s contains a handle to a prepared statement and that > > > ODBC invalidates it (or closes it, or MS SQL invalidates it) > > > but > > > $s = $dbh->prepare_cached(...) still returns it. > > > and so the > > > execute fails. > > > > > > Assuming your connecting to a MSSQL DB via ODBC > > > Maybe the next step is just to check versions of DLL's > > > > > > Cheers
> > > > I was connecting to MS SQL Server via ODBC. > > > > Can you send me a trace. > > > > set DBI_TRACE=15=x.log > > > > then run the smallest script which reproduces the problem and send me > > the log file. > > > > Martin
> > Have you resolved this issue? > > I've not heard anything in nearly 3 weeks and cannot see a way to > progress this without a log as I cannot reproduce your problem. > > Martin
I will code this issue in a few days. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Bigfish: VPS-3(zz936eKzz1202hzzz2dh2a8h668h34h61h)
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: multipart/mixed; boundary="_002_9A65DF4CF1997143BF2E6380819612F02545085523pmichlauexc07_"
X-Spam-Score: -6.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 6DE2C24130A for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Mon, 13 Dec 2010 19:50: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 xKJb9zzUn95N for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Mon, 13 Dec 2010 19:50:34 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 673462412E6 for <bug-DBD-ODBC [...] rt.cpan.org>; Mon, 13 Dec 2010 19:50:32 -0500 (EST)
Received: (qmail 31039 invoked by uid 103); 14 Dec 2010 00:50:31 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 14 Dec 2010 00:50:31 -0000
Received: from va3ehsobe001.messaging.microsoft.com (HELO VA3EHSOBE001.bigfish.com) (216.32.180.11) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Mon, 13 Dec 2010 16:50:28 -0800
Received: from mail55-va3-R.bigfish.com (10.7.14.243) by VA3EHSOBE001.bigfish.com (10.7.40.21) with Microsoft SMTP Server id 14.1.225.8; Tue, 14 Dec 2010 00:50:24 +0000
Received: from mail55-va3 (localhost.localdomain [127.0.0.1]) by mail55-va3-R.bigfish.com (Postfix) with ESMTP id 9CDB74B0456 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 14 Dec 2010 00:50:24 +0000 (UTC)
Received: from mail55-va3 (localhost.localdomain [127.0.0.1]) by mail55-va3 (MessageSwitch) id 12922878245803_2661; Tue, 14 Dec 2010 00:50:24 +0000 (UTC)
Received: from VA3EHSMHS019.bigfish.com (unknown [10.7.14.242]) by mail55-va3.bigfish.com (Postfix) with ESMTP id F2CB47F0050 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 14 Dec 2010 00:50:23 +0000 (UTC)
Received: from pmichsmtp01.pconnect.biz (193.222.161.207) by VA3EHSMHS019.bigfish.com (10.7.99.29) with Microsoft SMTP Server (TLS) id 14.1.225.8; Tue, 14 Dec 2010 00:50:23 +0000
Received: from pmichlaucas02.PMINTL.NET (10.155.0.219) by PMICHSMTP01.pconnect.biz (10.150.230.207) with Microsoft SMTP Server id 8.2.254.0; Tue, 14 Dec 2010 01:49:41 +0100
Received: from pmichlauexc07.PMINTL.NET ([10.155.41.4]) by pmichlaucas02.PMINTL.NET ([10.155.0.219]) with mapi; Tue, 14 Dec 2010 01:50:21 +0100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #62033] prepared_cache invalid after error
X-Spam-Check-BY: 16.mx.develooper.com
Thread-Index: Acua6P3ok+ZpAwK8SJS3OKHhCRQTnQAPrODg
Date: Tue, 14 Dec 2010 01:50:14 +0100
X-Originatororg: contracted.pmintl.com
X-Spam-Level:
X-Spamscore: -3
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
X-Forefront-Antispam-Report: KIP:(null);UIP:(null);IPVD:NLI;H:pmichsmtp01.pconnect.biz;RD:pmichsmtp01.pconnect.biz;EFVD:NLI
From Damon.Atkins [...] contracted.pmintl.com Mon Dec 13 19: 50:36 2010
In-Reply-To: <rt-3.8.HEAD-19311-1292260375-874.62033-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-6.899 tagged_above=-99.9 required=10 tests=[AWL=0.001, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
Content-Language: en-US
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2359-1288772722-1948.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2356-1290434561-796.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292260375-874.62033-6-0 [...] rt.cpan.org>
Message-ID: <9A65DF4CF1997143BF2E6380819612F02545085523 [...] pmichlauexc07.PMINTL.NET>
X-MS-Tnef-Correlator:
Return-Path: <Damon.Atkins [...] contracted.pmintl.com>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-MS-Has-Attach: yes
Thread-Topic: [rt.cpan.org #62033] prepared_cache invalid after error
Accept-Language: en-US
X-Spam-TCS-SCL: 0:0
From: "Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>
RT-Message-ID: <rt-3.8.HEAD-19313-1292287837-995.62033-0-0 [...] rt.cpan.org>
Content-Length: 0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
X-RT-Original-Encoding: utf-8
Content-Length: 4820
Download (untitled) / with headers
text/plain 4.7k
0x2a00 DBI::db::get_info 0x10000 DBI::db::take_imp_data 0x10c00 DBI::db::disconnect 0x2000 DBI::db::selectrow_array 0x2200 DBI::db::tables 0x0430 DBI::db::quote_identifier 0x0000 DBI::db::clone 0x0430 DBI::db::quote 0x2200 DBI::db::type_info 0xaa00 DBI::db::statistics_info 0x2000 DBI::db::selectrow_arrayref 0x0400 DBI::db::begin_work 0x2800 DBI::db::last_insert_id 0xaa00 DBI::db::foreign_key_info 0x2200 DBI::db::primary_key 0x0c80 DBI::db::commit 0x0404 DBI::db::ping 0x2000 DBI::db::selectall_arrayref 0x2a00 DBI::db::type_info_all 0x3200 DBI::db::do 0x2000 DBI::db::selectcol_arrayref 0xa200 DBI::db::prepare_cached 0x0004 DBI::db::rows 0x0c80 DBI::db::rollback 0xaa00 DBI::db::column_info 0xaa00 DBI::db::table_info 0xaa00 DBI::db::primary_key_info 0xa200 DBI::db::prepare 0x0000 DBI::db::preparse 0x0004 DBI::db::connected 0x0200 DBI::db::data_sources 0x2000 DBI::db::selectall_hashref 0x2000 DBI::db::selectrow_hashref 0x0000 DBI::dr::default_user 0x0800 DBI::dr::data_sources 0x0800 DBI::dr::disconnect_all 0x8000 DBI::dr::connect_cached 0x8000 DBI::dr::connect 0x0000 DBI::st::more_results 0x0000 DBI::st::blob_read 0x0000 DBI::st::fetchall_hashref 0x0000 DBI::st::bind_param_inout_array 0x0000 DBI::st::finish 0x0004 DBI::st::rows 0x5040 DBI::st::execute_for_fetch 0x0000 DBI::st::fetchrow_hashref 0x0000 DBI::st::_get_fbav 0x0000 DBI::st::_set_fbav 0x0000 DBI::st::fetchrow 0x0000 DBI::st::fetch 0x5040 DBI::st::execute_array 0x0000 DBI::st::dump_results 0x0000 DBI::st::bind_param_array 0x0000 DBI::st::fetchrow_array 0x1040 DBI::st::execute 0x0000 DBI::st::bind_col 0x0000 DBI::st::fetchall_arrayref 0x0000 DBI::st::fetchrow_arrayref 0x0000 DBI::st::bind_param_inout 0x0000 DBI::st::bind_columns 0x0800 DBI::st::cancel 0x0000 DBI::st::blob_copy_to_file 0x0000 DBI::st::bind_param 0x0404 DBI::common::parse_trace_flag 0x0004 DBI::common::errstr 0x0004 DBI::common::trace_msg 0x0004 DBI::common::err 0x0004 DBI::common::CLEAR 0x0004 DBI::common::state 0x0000 DBI::common::_not_impl 0x0004 DBI::common::NEXTKEY 0x0004 DBI::common::trace 0x0004 DBI::common::debug 0x0404 DBI::common::parse_trace_flags 0x0000 DBI::common::private_attribute_info 0x0000 DBI::common::swap_inner_handle 0x0004 DBI::common::EXISTS 0x0404 DBI::common::FETCH 0x0004 DBI::common::FIRSTKEY 0x0010 DBI::common::set_err 0x10004 DBI::common::DESTROY 0x0004 DBI::common::dump_handle 0x0404 DBI::common::FETCH_many 0x0100 DBI::common::can 0x041c DBI::common::STORE 0x0004 DBI::common::private_data 0x0006 DBI::common::func Try1 Correct CreateMaint(DBI::db=HASH(0x3e72ac4),2010-01-01 00:00:00,datkins,2010-01-01 00:00:00,2010-01-01 00:10:00,A Comment1,maint enance,blackout,Script :,myselftest) RowId 25576 Try2 NULL to fail CreateMaint(DBI::db=HASH(0x3e72ac4),2010-01-01 00:00:00,datkins,,2010-01-01 00:10:00,A Comment2,maintenance,blackout,Scr ipt :,myselftest) DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'S cheduled_Start_Date_Time', table 'System_Tools_DEV.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at bug.pl line 57. SQLexec: INSERT INTO T_Alarm_Maintenances (Created_Date_Time, Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_ Time, Comment, Source, Component, Media, Media_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ;SELECT SCOPE_IDENTITY() Data:'2010-01-01 00:00:00','datkins','','2010-01-01 00:10:00','A Comment2','maintenance','blackout','Script :','myselfte st' Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Scheduled_Start_Date_Tim e', table 'System_Tools_DEV.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at bug.pl line 62. RowId Try3 Correct CreateMaint(DBI::db=HASH(0x3e72ac4),2010-01-01 00:00:00,datkins,2010-01-01 00:00:00,2010-01-01 00:10:00,A Comment3,maint enance,blackout,Script :,myselftest) ---- It Stops, Control-C needed to break it --- Terminating on signal SIGINT(2) NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.
Content-Description: prepare_cache.log
content-type: application/octet-stream; name="prepare_cache.log"
content-disposition: attachment; creation-date="Tue, 14 Dec 2010 01:49:53 GMT"; filename="prepare_cache.log"; modification-date="Tue, 14 Dec 2010 01:49:39 GMT"; size="37370"
Content-Transfer-Encoding: base64
Content-Length: 37370
Download prepare_cache.log
application/octet-stream 36.4k

Message body not shown because it is not plain text.

MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19313-1292287837-995.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2359-1288772722-1948.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2356-1290434561-796.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292260375-874.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F02545085523 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-19313-1292287837-995.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19308-1292335947-274.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 4340
Download (untitled) / with headers
text/plain 4.2k
On Mon Dec 13 19:50:37 2010, Damon.Atkins@contracted.pmintl.com wrote: <snipped some log output> Show quoted text
> Try1 Correct > CreateMaint(DBI::db=HASH(0x3e72ac4),2010-01-01 > 00:00:00,datkins,2010-01-01 00:00:00,2010-01-01 00:10:00,A > Comment1,maint > enance,blackout,Script :,myselftest) > RowId 25576 > Try2 NULL to fail > CreateMaint(DBI::db=HASH(0x3e72ac4),2010-01-01 > 00:00:00,datkins,,2010-01-01 00:10:00,A > Comment2,maintenance,blackout,Scr > ipt :,myselftest) > DBD::ODBC::st > execute failed: [Microsoft][ODBC SQL Server Driver][SQL > Server]Cannot insert the value NULL into column 'S > cheduled_Start_Date_Time', table > 'System_Tools_DEV.dbo.T_Alarm_Maintenances'; column does not allow > nulls. INSERT fails. > (SQL-23000) > [Microsoft][ODBC SQL Server > Driver][SQL Server]The statement has been terminated. (SQL- > 01000)(DBD: st_execute/SQLExecute > err=-1) at bug.pl line 57. > SQLexec: INSERT INTO T_Alarm_Maintenances (Created_Date_Time, > Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_ > Time, > Comment, Source, Component, Media, Media_data) > VALUES (?, ?, ?, ?, > ?, ?, ?, ?, ?) > ;SELECT SCOPE_IDENTITY()
I don't think DBI ever intended that you could prepare multiple statements and cache them like this. If the first fails what should happen with the second? Just don't do this, set up a second prepare for the identity or create a procedure which does the insert, obtains the identity and returns it. Show quoted text
> Data:'2010-01-01 > 00:00:00','datkins','','2010-01-01 00:10:00','A > Comment2','maintenance','blackout','Script :','myselfte > st' > Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert > the value NULL into column 'Scheduled_Start_Date_Tim > e', table > 'System_Tools_DEV.dbo.T_Alarm_Maintenances'; column does not allow > nulls. INSERT fails. (SQL-23000) > [Microsoft][ODBC SQL Server > Driver][SQL Server]The statement has been terminated. (SQL- > 01000)(DBD: st_execute/SQLExecute > err=-1) at bug.pl line 62. > RowId > > > Try3 Correct > CreateMaint(DBI::db=HASH(0x3e72ac4),2010- > 01-01 00:00:00,datkins,2010-01-01 00:00:00,2010-01-01 00:10:00,A > Comment3,maint > enance,blackout,Script :,myselftest) > ---- It > Stops, Control-C needed to break it --- > Terminating on signal > SIGINT(2) > > NOTICE: This e-mail may contain confidential > information, which should not be copied or distributed without > authorization. If you have received this e-mail message by > mistake, please inform the sender and delete it from your system. > Please note that, for the efficient preservation of Company records > that may be required for litigation, e-mail messages sent to the > author of this message will be copied and may be retained in a > secure repository.
Admittedly, it is more than unfortunate that your script hangs but this is because the insert statement failed, SQL Server moved on to the select identity and returned the value down the socket but you never called odbc_more_results. You'd need to do something like: use DBI; use strict; sub doit { my $dbh=shift @_; my $s = $dbh->prepare_cached(q/insert into mje (b) values(?);select @@identity/); $s->execute(@_); print "sql errors $DBI::errstr\n"; $s->{odbc_more_results}; my $identity; ($identity) = $s->fetchrow_array; print "identity = ", DBI::neat($identity), "\n"; ($identity) = $s->fetchrow_array; } my $h = DBI->connect("dbi:ODBC:mydsn", "user", "password", {PrintError => 0}) or die "connect"; eval {$h->do(q/drop table mje/);}; $h->do(q/create table mje (a int identity, b char(10) not null)/); doit($h,undef); #doit($h,1, undef); #doit($h,1,'fred'); #doit($h,1, undef); doit($h,'fred'); my $r = $h->prepare(q/select * from mje/); $r->execute; print DBI::dump_results($r); But although that will probably stop the hang I doubt you'll get the identity back with DBD::ODBC 1.13 which is over 6 years old now. There is a small bug in the latest DBD::ODBC which I'll fix and then the above example will work completely but I'd strongly suggest you don't prepare 2 statements in one go as you will eventually find a MS SQL Server ODBC Driver this won't work on (one which batches up the statements for instance). Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-19308-1292335947-274.62033-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2359-1288772722-1948.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2356-1290434561-796.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292260375-874.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F02545085523 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-19313-1292287837-995.62033-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-19308-1292335947-274.62033-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-17550-1292489680-1374.62033-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1642
Download (untitled) / with headers
text/plain 1.6k
On Tue Dec 14 09:12:27 2010, MJEVANS wrote: Show quoted text
> use DBI; > use strict; > > sub doit > { > my $dbh=shift @_; > my $s = $dbh->prepare_cached(q/insert into mje (b) values(?);select > @@identity/); > $s->execute(@_); > print "sql errors $DBI::errstr\n"; > > $s->{odbc_more_results}; > my $identity; > ($identity) = $s->fetchrow_array; > print "identity = ", DBI::neat($identity), "\n"; > ($identity) = $s->fetchrow_array; > > } > > > my $h = DBI->connect("dbi:ODBC:mydsn", "user", "password", > {PrintError => 0}) or die "connect"; > > eval {$h->do(q/drop table mje/);}; > > $h->do(q/create table mje (a int identity, b char(10) not null)/); > > doit($h,undef); > #doit($h,1, undef); > #doit($h,1,'fred'); > #doit($h,1, undef); > doit($h,'fred'); > > my $r = $h->prepare(q/select * from mje/); > $r->execute; > print DBI::dump_results($r); > > But although that will probably stop the hang I doubt you'll get the > identity back with DBD::ODBC 1.13 which is over 6 years old now. > > There is a small bug in the latest DBD::ODBC which I'll fix and then the > above example will work completely but I'd strongly suggest you don't > prepare 2 statements in one go as you will eventually find a MS SQL > Server ODBC Driver this won't work on (one which batches up the > statements for instance). > > Martin
I have released 1.26_4 which fixed the small issue where odbc_more_results might not set the Active flag on the statement handle which could stop the retrieval of the $identity in the above example from working. Are you ok for me to right this off now? Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Bigfish: VPS0(zzzz1202hzzz2dh2a8h668h62h)
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 5638D241162 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Thu, 16 Dec 2010 04:50:50 -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 BAwraH2kGsaJ for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Thu, 16 Dec 2010 04:50:48 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 46836240DB8 for <bug-DBD-ODBC [...] rt.cpan.org>; Thu, 16 Dec 2010 04:50:48 -0500 (EST)
Received: (qmail 30108 invoked by uid 103); 16 Dec 2010 09:50:47 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 16 Dec 2010 09:50:47 -0000
Received: from tx2ehsobe002.messaging.microsoft.com (HELO TX2EHSOBE003.bigfish.com) (65.55.88.12) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Thu, 16 Dec 2010 01:50:46 -0800
Received: from mail23-tx2-R.bigfish.com (10.9.14.251) by TX2EHSOBE003.bigfish.com (10.9.40.23) with Microsoft SMTP Server id 14.1.225.8; Thu, 16 Dec 2010 09:50:42 +0000
Received: from mail23-tx2 (localhost.localdomain [127.0.0.1]) by mail23-tx2-R.bigfish.com (Postfix) with ESMTP id C7837BF01FC for <bug-DBD-ODBC [...] rt.cpan.org>; Thu, 16 Dec 2010 09:50:42 +0000 (UTC)
Received: from mail23-tx2 (localhost.localdomain [127.0.0.1]) by mail23-tx2 (MessageSwitch) id 1292493042731437_26567; Thu, 16 Dec 2010 09:50:42 +0000 (UTC)
Received: from TX2EHSMHS007.bigfish.com (unknown [10.9.14.247]) by mail23-tx2.bigfish.com (Postfix) with ESMTP id B0007F40052 for <bug-DBD-ODBC [...] rt.cpan.org>; Thu, 16 Dec 2010 09:50:42 +0000 (UTC)
Received: from pmichsmtp01.pconnect.biz (193.222.161.207) by TX2EHSMHS007.bigfish.com (10.9.99.107) with Microsoft SMTP Server (TLS) id 14.1.225.8; Thu, 16 Dec 2010 09:50:42 +0000
Received: from pmichlaucas01.PMINTL.NET (10.155.134.212) by PMICHSMTP01.pconnect.biz (10.150.230.207) with Microsoft SMTP Server id 8.2.254.0; Thu, 16 Dec 2010 10:49:45 +0100
Received: from pmichlauexc07.PMINTL.NET ([10.155.41.4]) by pmichlaucas01.PMINTL.NET ([10.155.134.212]) with mapi; Thu, 16 Dec 2010 10:50:26 +0100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #62033] prepared_cache invalid after error
X-Spam-Check-BY: 16.mx.develooper.com
Thread-Index: Acuc/uJwtSXWW+paQXOwMtRPVAraKAAB7aaA
Date: Thu, 16 Dec 2010 10:50:22 +0100
X-Originatororg: contracted.pmintl.com
X-Spam-Level:
X-Spamscore: 0
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: base64
X-Forefront-Antispam-Report: KIP:(null);UIP:(null);IPVD:NLI;H:pmichsmtp01.pconnect.biz;RD:pmichsmtp01.pconnect.biz;EFVD:NLI
From Damon.Atkins [...] contracted.pmintl.com Thu Dec 16 04: 50:50 2010
In-Reply-To: <rt-3.8.HEAD-17550-1292489680-904.62033-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-6.899 tagged_above=-99.9 required=10 tests=[AWL=0.001, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
Content-Language: en-US
References: <RT-Ticket-62033 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F025418B245B [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-2363-1288344454-784.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2359-1288772722-1948.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-2356-1290434561-796.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19311-1292260375-874.62033-6-0 [...] rt.cpan.org> <9A65DF4CF1997143BF2E6380819612F02545085523 [...] pmichlauexc07.PMINTL.NET> <rt-3.8.HEAD-19313-1292287837-995.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-19308-1292335947-274.62033-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-17550-1292489680-904.62033-6-0 [...] rt.cpan.org>
Message-ID: <9A65DF4CF1997143BF2E6380819612F025450CCCFA [...] pmichlauexc07.PMINTL.NET>
X-MS-Tnef-Correlator:
Return-Path: <Damon.Atkins [...] contracted.pmintl.com>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #62033] prepared_cache invalid after error
Accept-Language: en-US
X-Spam-TCS-SCL: 1:0
From: "Atkins, Damon (contracted)" <Damon.Atkins [...] contracted.pmintl.com>
RT-Message-ID: <rt-3.8.HEAD-19315-1292493050-1855.62033-0-0 [...] rt.cpan.org>
Content-Length: 473
Download (untitled) / with headers
text/plain 473b
Yes , And thanks NOTICE: This e-mail may contain confidential information, which should not be copied or distributed without authorization. If you have received this e-mail message by mistake, please inform the sender and delete it from your system. Please note that, for the efficient preservation of Company records that may be required for litigation, e-mail messages sent to the author of this message will be copied and may be retained in a secure repository.


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.