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

People
Owner: Nobody in particular
Requestors: LAnusauskas [...] corp.untd.com
Cc:
AdminCc:

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



MIME-Version: 1.0
X-Spam-Status: No, hits=-3.6 required=8.0 tests=BAYES_00,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
Content-Class: urn:content-classes:message
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8AEDE.564C9E90"
X-MS-Tnef-Correlator:
Received: from x1.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 76CB74D811B for <bug-DBD-Oracle [...] rt.cpan.org>; Mon, 5 May 2008 14:32:26 -0400 (EDT)
Received: (qmail 31968 invoked from network); 5 May 2008 18:32:25 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 5 May 2008 18:32:25 -0000
Received: from corp.untd.com (HELO ops1.lax.int.untd.com) (64.136.2.210) by 16.mx.develooper.com (qpsmtpd/0.43rc1) with SMTP; Mon, 05 May 2008 11:32:21 -0700
Received: (qmail 8076 invoked from network); 5 May 2008 18:32:13 -0000
Received: from unknown (HELO LAXEVS01.lax.corp.int.untd.com) (10.100.35.202) by ops1.lax.int.untd.com with SMTP; 5 May 2008 18:32:13 -0000
Delivered-To: cpan-bug+DBD-Oracle [...] diesel.bestpractical.com
Subject: Errors when closing pipe after DBI->connect
Return-Path: <LAnusauskas [...] corp.untd.com>
Thread-Index: Aciu3lYo+HZuIiBkRyeNKV0e9PgkbA==
X-Original-To: bug-DBD-Oracle [...] rt.cpan.org
X-Spam-Check-BY: 16.mx.develooper.com
Date: Mon, 5 May 2008 11:32:13 -0700
X-Spam-Level: *
X-MS-Has-Attach:
Thread-Topic: Errors when closing pipe after DBI->connect
Message-Id: <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com>
X-Mimeole: Produced By Microsoft Exchange V6.5
To: <bug-DBD-Oracle [...] rt.cpan.org>
From: "Anusauskas, Laimonas" <LAnusauskas [...] corp.untd.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: us-ascii
Content-Length: 1835
Download (untitled) / with headers
text/plain 1.7k
Hi, We are seing strange problem with Perl "close" function on a pipe returning errors no matter what the exit code of the actual program is. It only happens after connection is established to the local database, before connection is established "close" function works as it should. This only started happening after we upgraded Oracle to version 10.2 and recompiled DBD-Oracle driver. We didn't have this problem with DBD compiled with 9.2 libraries. Also, this issue doesn't appear after connection to MySQL database, so its not the issue with DBI itself. This only happens if connection is local and doesn't happen if connection is using network. My feeling that this has something to do with the fact that Oracle client forks separate server process to connect to the local database and that somehow messes up Perls waitpid call. OS: Solaris Sparc 2.10 Perl: v5.8.8 built for sun4-solaris-64 DBI: DBI-1.604 DBD-Oracle: DBD-Oracle-1.21 I also reproduced the same problem when compiling for 32bit. Test case: Show quoted text
------ Cut here ---- #!/u01/dba/config/perl -w use DBI; use strict; warn "Before connect"; open(PIPE,"|/bin/tee") || die("Can not launch command"); warn close(PIPE) ? "No errors" : $!; my $dbh = DBI->connect( "DBI:Oracle:", "system","***", {TraceLevel => 0,RaiseError => 1, AutoCommit=>0,PrintError=>1}) or die("Failed to connect:$DBI::errstr"); warn "After connect"; open(PIPE,"|/bin/tee") || die("Can not launch command"); warn close(PIPE) ? "No errors" : $!; $dbh->disconnect(); exit(0);
----- Output --- Before connect at ./dbd_bug.pl line 6. No errors at ./dbd_bug.pl line 8. After connect at ./dbd_bug.pl line 16. No child processes at ./dbd_bug.pl line 18. ----- Best regards, Limus Sr. Oracle DBA United Online, Inc.
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: us-ascii
Content-Length: 5533
MIME-Version: 1.0
X-Spam-Status: No, hits=-3.4 required=8.0 tests=ANY_BOUNCE_MESSAGE,BAYES_00,RCVD_IN_DNSWL_LOW,SPF_PASS,VBOUNCE_MESSAGE
In-Reply-To: <rt-3.6.HEAD-25348-1210012358-310.35644-3-0 [...] rt.cpan.org>
Content-Class: urn:content-classes:message
References: <RT-Ticket-35644 [...] rt.cpan.org> <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com> <rt-3.6.HEAD-25348-1210012358-310.35644-3-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
X-MS-Tnef-Correlator:
X-RT-Original-Encoding: us-ascii
Received: from x1.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id ADA994D8068 for <bug-DBD-Oracle [...] rt.cpan.org>; Tue, 6 May 2008 18:14:20 -0400 (EDT)
Received: (qmail 27938 invoked from network); 6 May 2008 22:14:19 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 6 May 2008 22:14:19 -0000
Received: from corp.untd.com (HELO ops1.lax.int.untd.com) (64.136.2.210) by 16.mx.develooper.com (qpsmtpd/0.43rc1) with SMTP; Tue, 06 May 2008 15:14:15 -0700
Received: (qmail 22562 invoked from network); 6 May 2008 22:14:08 -0000
Received: from unknown (HELO LAXEVS01.lax.corp.int.untd.com) (10.100.35.202) by ops1.lax.int.untd.com with SMTP; 6 May 2008 22:14:08 -0000
Delivered-To: cpan-bug+DBD-Oracle [...] diesel.bestpractical.com
Subject: RE: [rt.cpan.org #35644] AutoReply: Errors when closing pipe after DBI->connect
Return-Path: <LAnusauskas [...] corp.untd.com>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: bug-DBD-Oracle [...] rt.cpan.org
Thread-Index: Aciu3mc2hbqDPE5sRBG63ouxNIJExQA5+xnA
Date: Tue, 6 May 2008 15:14:08 -0700
X-Spam-Level: *
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #35644] AutoReply: Errors when closing pipe after DBI->connect
Message-Id: <D01605A1112D8947ABC2F4FA3C9D80640242FFDE [...] LAXEVS01.lax.corp.int.untd.com>
X-Mimeole: Produced By Microsoft Exchange V6.5
To: <bug-DBD-Oracle [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: "Anusauskas, Laimonas" <LAnusauskas [...] corp.untd.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.6.HEAD-25353-1210112067-1853.35644-0-0 [...] rt.cpan.org>
Content-Length: 95
It seems that DBI->connect call is throwing SIGCHLD signal. I am investigating further. Limus
MIME-Version: 1.0
In-Reply-To: <rt-3.6.HEAD-25353-1210112067-1853.35644-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.418 (Entity 5.418)
Content-Disposition: inline
Charset: utf8
References: <RT-Ticket-35644 [...] rt.cpan.org> <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com> <rt-3.6.HEAD-25348-1210012358-310.35644-3-0 [...] rt.cpan.org> <D01605A1112D8947ABC2F4FA3C9D80640242FFDE [...] LAXEVS01.lax.corp.int.untd.com> <rt-3.6.HEAD-25353-1210112067-1853.35644-0-0 [...] rt.cpan.org>
Message-Id: <rt-3.6.HEAD-8665-1211591448-1663.35644-0-0 [...] rt.cpan.org>
Content-Type: text/plain
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 176
Download (untitled) / with headers
text/plain 176b
Did you upgrade your DBD::Oracle driver as well?? Might be a bug in Oracle? That has been know to happen. Connect to your 10 DB with your 9 client and see what happens?
MIME-Version: 1.0
In-Reply-To: <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-29589-1349459769-1376.35644-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 30
No answer in 4 years. Closing.
MIME-Version: 1.0
X-Spam-Flag: NO
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.121
X-Ems-Stamp: nLXaa9WH2JCLjhviT50Aiw==
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id AEDC5240872 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 5 Oct 2012 14:10:31 -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 p6troaMbad8W for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 5 Oct 2012 14:10:30 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id DCC052401F2 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 5 Oct 2012 14:10:29 -0400 (EDT)
Received: (qmail 566 invoked by uid 103); 5 Oct 2012 18:10:28 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 5 Oct 2012 18:10:28 -0000
Received: from corp.untd.com (HELO ops1.lax.int.untd.com) (64.136.2.210) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with SMTP; Fri, 05 Oct 2012 11:10:26 -0700
Received: (qmail 3269 invoked from network); 5 Oct 2012 18:10:23 -0000
Received: from unknown (HELO LAXCAS02.lax.corp.int.untd.com) (10.100.35.190) by ops1.lax.int.untd.com with SMTP; 5 Oct 2012 18:10:23 -0000
Received: from LAXEVS03.lax.corp.int.untd.com (10.100.35.202) by LAXCAS02.lax.corp.int.untd.com (10.100.35.190) with Microsoft SMTP Server (TLS) id 14.1.339.1; Fri, 5 Oct 2012 11:10:22 -0700
Received: from LAXCAS01.lax.corp.int.untd.com ([fe80::ad2c:4150:3588:164e]) by LAXEVS03.lax.corp.int.untd.com ([::1]) with mapi id 14.01.0339.001; Fri, 5 Oct 2012 11:10:19 -0700
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #35644] Errors when closing pipe after DBI->connect
Thread-Index: AQHNoyK3mK2op2WDKEubM/KHiIOpD5erAdzg
X-Spam-Check-BY: 16.mx.develooper.com
Date: Fri, 5 Oct 2012 18:10:19 +0000
X-Spam-Level:
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
Content-Transfer-Encoding: base64
From LAnusauskas [...] corp.untd.com Fri Oct 5 14: 10:31 2012
X-Ems-Proccessed: FK8A8g0VRsmrFL4mfQj4WA==
In-Reply-To: <rt-3.8.HEAD-29589-1349459769-549.35644-6-0 [...] rt.cpan.org>
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
Content-Language: en-US
References: <RT-Ticket-35644 [...] rt.cpan.org> <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com> <rt-3.8.HEAD-29589-1349459769-549.35644-6-0 [...] rt.cpan.org>
Message-ID: <272F0DA031FC644DA39FECB571E18A173E3D7E54 [...] LAXCAS01.lax.corp.int.untd.com>
X-MS-Tnef-Correlator:
Return-Path: <LAnusauskas [...] corp.untd.com>
X-RT-Mail-Extension: dbd-oracle
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #35644] Errors when closing pipe after DBI->connect
X-Originating-Ip: [10.100.35.101]
Accept-Language: en-US
From: "Anusauskas, Laimonas" <LAnusauskas [...] corp.untd.com>
RT-Message-ID: <rt-3.8.HEAD-2142-1349460632-701.35644-0-0 [...] rt.cpan.org>
Content-Length: 559
Download (untitled) / with headers
text/plain 559b
Sorry, forgot about this ticket. The workaround that worked for us was to trap SIGCLD in beginning of the script: # Trap SIGCLD signal otherwise IPC gets all messed up after DBI calls $SIG{CLD} = sub {}; Limus Show quoted text
-----Original Message----- From: Pythian Remote DBA via RT [mailto:bug-DBD-Oracle@rt.cpan.org] Sent: Friday, October 05, 2012 10:56 AM To: Anusauskas, Laimonas Subject: [rt.cpan.org #35644] Errors when closing pipe after DBI->connect <URL: https://rt.cpan.org/Ticket/Display.html?id=35644 > No answer in 4 years. Closing.
From champoux [...] pythian.com Fri Oct 5 16: 02:22 2012
MIME-Version: 1.0
X-Spam-Status: No, score=-4.245 tagged_above=-99.9 required=10 tests=[AWL=1.875, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, SPF_NEUTRAL=0.779, URIBL_DBL_REDIR=0.001] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-2142-1349460632-820.35644-5-0 [...] rt.cpan.org>
X-Spam-Flag: NO
References: <RT-Ticket-35644 [...] rt.cpan.org> <D01605A1112D8947ABC2F4FA3C9D80640242FCE2 [...] LAXEVS01.lax.corp.int.untd.com> <rt-3.8.HEAD-29589-1349459769-549.35644-6-0 [...] rt.cpan.org> <272F0DA031FC644DA39FECB571E18A173E3D7E54 [...] LAXCAS01.lax.corp.int.untd.com> <rt-3.8.HEAD-2142-1349460632-820.35644-5-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <506F3CBF.5070407 [...] pythian.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.245
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 6ECEA240872 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 5 Oct 2012 16:02:22 -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 6lNee+Jd6gkL for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 5 Oct 2012 16:02:20 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 86F822401F2 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 5 Oct 2012 16:02:20 -0400 (EDT)
Received: (qmail 8897 invoked by uid 103); 5 Oct 2012 20:02:19 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 5 Oct 2012 20:02:19 -0000
Received: from na3sys009aog110.obsmtp.com (HELO na3sys009aog110.obsmtp.com) (74.125.149.203) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with SMTP; Fri, 05 Oct 2012 13:02:14 -0700
Received: from mail-ie0-f178.google.com ([209.85.223.178]) (using TLSv1) by na3sys009aob110.postini.com ([74.125.148.12]) with SMTP ID DSNKUG88wv0Maj8KTLT4STs4nO4kQ8jH0E8+ [...] postini.com; Fri, 05 Oct 2012 13:02:13 PDT
Received: by mail-ie0-f178.google.com with SMTP id e11so4816487iej.9 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 05 Oct 2012 13:02:10 -0700 (PDT)
Received: by 10.50.151.172 with SMTP id ur12mr2175821igb.44.1349467330698; Fri, 05 Oct 2012 13:02:10 -0700 (PDT)
Received: from [10.237.236.149] (host7.pythian.com. [209.217.100.70]) by mx.google.com with ESMTPS id i2sm1425844igl.8.2012.10.05.13.02.08 (version=SSLv3 cipher=OTHER); Fri, 05 Oct 2012 13:02:09 -0700 (PDT)
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 #35644] Errors when closing pipe after DBI->connect
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=lzG/mROw2KIgCsPYaCQ9Tn/GfHblrtYIRspRjjdwOsM=; b=DqsWrXm5+13weZ+MpTrGpTCxCir14Auhmhyr38L4WsstcmqX4u1QLFwGhFfP0Ybe9A jeTa1pacDFy0+SKAjek+GXd6p464iNrzmU7Qq4TEBzkWKTXtT/HeC/bwBcPmJa5kh5cw sPw9dlknCtRXRUBzFKXo274dSwOAx3fW6Tb/FRgK8fZgBENCgwTZq1UY8l5VZ7+aBKgO YEZDpklKERT2ReLrGnJfujMgJcWnWwcP3gbzu1y7wy6KTF3AVr8ZV5TfZDDX8L1cKtsF Jddk7AzWByUkenlUeSLhZyOrlOFB/k2LKo9VBj9KgJHjnxV85LS1ctGlUmr/z76aIV4f grSg==
Date: Fri, 05 Oct 2012 16:02:07 -0400
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
X-GM-Message-State: ALoCoQmhmTskEOd1/WRzHIgCMofI68DeZZnu7K8qgIkPclu1cVX5E7PGeD26SoRVXzd73SAenXSFNU0G3JPr6bozZVDJcJ9joCTBb95zP1kP7B+JK3hrJcw=
RT-Message-ID: <rt-3.8.HEAD-2142-1349467343-302.35644-0-0 [...] rt.cpan.org>
Content-Length: 770
Download (untitled) / with headers
text/plain 770b
On 12-10-05 02:10 PM, Anusauskas, Laimonas via RT wrote: Show quoted text
> Queue: DBD-Oracle > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=35644 > > > Sorry, forgot about this ticket. > > The workaround that worked for us was to trap SIGCLD in beginning of the script: > > # Trap SIGCLD signal otherwise IPC gets all messed up after DBI calls > $SIG{CLD} = sub {};
Excellent. Thanks! And it seems that with the current version of DBI, it's no longer an issue either. I've tried the test script in the ticket, and it runs smoothly with and without the trapping. Cheers (and thanks again), `/anick -- -- Attending Oracle OpenWorld? Be sure to watch out for the Pythian team and to catch one of our many speaking sessions bit.ly/OOW12sessions


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.