[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: DBI:ORACLE Defunct problem
From:       Tim Bunce <Tim.Bunce () ig ! co ! uk>
Date:       1998-11-27 10:47:59
[Download RAW message or body]

    *** From dbi-dev -- To unsubscribe, see the end of this message. ***

On Fri, Nov 27, 1998 at 10:32:34AM +0800, Reynels Lee wrote:
> I believe I am having a problem with reconnecting to the database.
> After I have connected once to the database and then disconnect, in the
> subsequent steps, a subroutine is called to connect to the database
> again. It manages to do what is required ( which is an update to the
> database), and later a defunct process appeared and the program just
> hung there.
> 
> When I set to trace mode, I have the following message  :
> 
>       DBI::st=HASH(0x227c80) debug level set to 2
>     <> $DBI::err (*) FETCH from lasth=DBI::st=HASH(0x227c80)
>     -> finish for DBD::Oracle::st (DBI::st=HASH(0x227f20)~0x227c80)
>     <- finish= 1
> 
>     -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x227c80))
>     <- DESTROY= undef
> 
> Is this a problem?
> 
> I am using Oracle 7.3.2 and Solaris 2.5 with perl 5.004_04. I understand
> 
> that there is a bug in Oracle for the mentioned version - Oracle bug:
> 374387/277305 . Could this be the source of my problem?

I don't know (I don't have the bug list handy).

Try setting the DBD_ORACLE_SIGCHLD environment variable to 0.

Please let me know if that helps.

Tim.
p.s. Please post to dbi-users, not dbi-dev.


------------------------------------------------------------------------------
To unsubscribe from this list, please visit http://www.fugue.com/dbi
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-request@fugue.com.   Please try to use the web
page first - it will take a long time for your request to be processed by hand.
------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]