Try setting the DBD_ORACLE_SIGCHLD env var to 0.
Let me know if it helps.
Tim.
On Tue, Jan 30, 2001 at 01:11:26PM +0100, [EMAIL PROTECTED] wrote:
> I've considered the same behaviour on a Suse 6.4.
> The hanging process is consuming 100% CPU. I've traced it back to a
> call to OCIBeginSession that never returns.
> Then I've examined it with strace under different conditions (db
> running, db stopped, db stopped after first connect, ...). It is always
> OCIBeginSession that hangs. Always a pipe is opened and a new process
> is spawned. Sometimes the never ending process gets a SIGCHLD.
> Then it enters it's ever lasting loop. In the loop it executes either
> the wait4 system call or no system call at all.
>
> It seems to me as an oracle bug on linux.
>
> On 29-Jan-01 SuratSingh Bhati wrote:
> > I am installing the DBD::Oracle1.06 on
> > Redhat7, having Oracle 8.1.6 SE installed.
> >
> > If I set the env ORACLE_SID=ora8 (SID of running
> > instance) , the test fails as CASE 1 output shown below.
> > And the test hangs at "Testing repetitive
> > connect/open/close/disconnect:"
> > and command ps -ef shows a
> > <defunct> oracle process.
> >
> > But if I unset the ORACLE_SID , and set TWO_TASK=star
> > (i.e. GLOBAL databse name of SID=ora8 ), the test
> > works fine , without making any other chages. Output
> > shown in CASE 2 below.
> >
> > Somebody can please expalin me the cause of error
> > in first case. i am able to connect to my oracel data
> > base with sqlplus using both ORACLE_SID and TWO_TASK
> > environment variable. I am running server with
> > multithreaed option. Attached the lines from tnasnames.ora
> > and listener.ora files of my system.
> >
> > Please CC at my ID , I have not subscribed to list.
> > Regards,
> >
> > -Surat Singh
> >
> > OUTPUT IN CASE 1 (ORACLE_SID=ora8)
> > ``````````````````````````````````
> > /usr/bin/make -- OK
> > Running make test
> > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/lib/perl5/5.6.0/i3
> > 86-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests
> > $verbose); $v
> > erbose=0; runtests @ARGV;' t/*.t
> > t/base..............ok
> > t/general...........ok
> > t/long..............ok
> > t/plsql.............ok
> > t/reauth............skipped test on this platform
> > All tests successful, 1 test skipped.
> > Files=5, Tests=224, 6 wallclock secs ( 1.16 cusr + 0.19 csys =
> > 1.35 CPU)
> > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/lib/perl5/5.6.0/i3
> > 86-linux -I/usr/lib/perl5/5.6.0 test.pl
> > Oraperl test application $Revision: 1.2 $
> >
> > Oraperl emulation interface version 1.39
> > DBD::Oracle 1.06 using OCI8 by Tim Bunce
> > DBI 1.14 by Tim Bunce
> >
> > Data sources:
> > dbi:Oracle:EXTPROC_CONNECTION_DATA
> > dbi:Oracle:MART
> > dbi:Oracle:STAR
> > dbi:Oracle:mart
> > dbi:Oracle:ora8
> >
> >
> > Connecting
> > to '' (from command line, else uses ORACLE_SID or TWO_TASK -
> > recommended)
> > as 'scott/tiger' (via ORACLE_USERID env var or default - recommend
> > name/passwd@
> > dbname)
> > (ORACLE_SID='ora8', TWO_TASK='')
> >
> > Testing internal row fetch overhead.
> > 50000 fetches: 1 wallclock secs ( 0.21 usr + 0.00 sys = 0.21 CPU)
> > 50000 per clock second, 238095 per cpu second
> >
> > Fields: 5
> > Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T'
> > 'NULL_T'
> > Lengths: 134 76 31 21 1
> > OraTypes: 2 12 1 104 1
> > SQLTypes: 3 9 12 -9104 12
> > Scale: 0 0 0 0 0
> > Precision: 38 75 30 20 0
> > Nullable: 1 1 1 1 1
> > Est row width: 45
> > Data rows:
> > fetch: '7.2', '2001-01-30', 'SCOTT', 'AAAADDAABAAAAHSAAA', undef
> >
> > csr reassigned (forces destruction)...
> > Fetch list of tables:
> > Fetched: DUAL
> > Fetched: SYSTEM_PRIVILEGE_MAP
> > Fetched: TABLE_PRIVILEGE_MAP
> > Fetched: STMT_AUDIT_OPTION_MAP
> > Test ora_do with harmless non-select statement (set transaction read
> > only)
> > Expect an 'ORA-01453' error message:
> > ora_do: 1453: ORA-01453: SET TRANSACTION must be first statement of
> > transaction
> > (DBD ERROR: OCIStmtExecute)
> > csr out of scope...
> > ora_logoff...
> > lda out of scope...
> >
> > Testing repetitive connect/open/close/disconnect:
> > Expect sequence of digits, no other messages:
> > 1
> >
> > (test hangs at this point)
> >
> >
> > OUTPUT IN CASE 2 (TWO_TASK=star)
> > `````````````````````````````````
> > /usr/bin/make -- OK
> > Running make test
> > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/lib/perl5/5.6.0/i3
> > 86-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests
> > $verbose); $v
> > erbose=0; runtests @ARGV;' t/*.t
> > t/base..............ok
> > t/general...........ok
> > t/long..............ok
> > t/plsql.............ok
> > t/reauth............skipped test on this platform
> > All tests successful, 1 test skipped.
> > Files=5, Tests=224, 16 wallclock secs ( 1.16 cusr + 0.24 csys =
> > 1.40 CPU)
> > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/lib/perl5/5.6.0/i3
> > 86-linux -I/usr/lib/perl5/5.6.0 test.pl
> > Oraperl test application $Revision: 1.2 $
> >
> > Oraperl emulation interface version 1.39
> > DBD::Oracle 1.06 using OCI8 by Tim Bunce
> > DBI 1.14 by Tim Bunce
> >
> > Data sources:
> > dbi:Oracle:EXTPROC_CONNECTION_DATA
> > dbi:Oracle:MART
> > dbi:Oracle:STAR
> > dbi:Oracle:mart
> > dbi:Oracle:ora8
> >
> >
> > Connecting
> > to '' (from command line, else uses ORACLE_SID or TWO_TASK -
> > recommended)
> > as 'scott/tiger' (via ORACLE_USERID env var or default - recommend
> > name/passwd@
> > dbname)
> > (ORACLE_SID='', TWO_TASK='star')
> >
> > Testing internal row fetch overhead.
> > 50000 fetches: 0 wallclock secs ( 0.25 usr + 0.00 sys = 0.25 CPU)
> > 50000 per clock second, 199999 per cpu second
> >
> > Fields: 5
> > Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T'
> > 'NULL_T'
> > Lengths: 134 76 31 21 1
> > OraTypes: 2 12 1 104 1
> > SQLTypes: 3 9 12 -9104 12
> > Scale: 0 0 0 0 0
> > Precision: 38 75 30 20 0
> > Nullable: 1 1 1 1 1
> > Est row width: 45
> > Data rows:
> > fetch: '7.2', '2001-01-30', 'SCOTT', 'AAAADDAABAAAAHSAAA', undef
> >
> > csr reassigned (forces destruction)...
> > Fetch list of tables:
> > Fetched: DUAL
> > Fetched: SYSTEM_PRIVILEGE_MAP
> > Fetched: TABLE_PRIVILEGE_MAP
> > Fetched: STMT_AUDIT_OPTION_MAP
> > Test ora_do with harmless non-select statement (set transaction read
> > only)
> > Expect an 'ORA-01453' error message:
> > ora_do: 1453: ORA-01453: SET TRANSACTION must be first statement of
> > transaction
> > (DBD ERROR: OCIStmtExecute)
> > csr out of scope...
> > ora_logoff...
> > lda out of scope...
> >
> > Testing repetitive connect/open/close/disconnect:
> > Expect sequence of digits, no other messages:
> > 1 2 3 4 5
> >
> > Test interaction of explicit close/logoff and implicit DESTROYs
> > Expect just 'done.', no other messages:
> > done.
> >
> > Testing row cache (5).
> > Test completed in 0 seconds.
> >
> > Test complete (2 seconds).
> > If the tests above have produced the 'expected' output then they have
> > passed.
> > /usr/bin/make test -- OK
> > Running make install
> >
> > ENTRY IN tnsnames.ora for STAR as:
> > ```````````````````````````````````
> > STAR =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = development)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = star)
> > )
> > )
> >
> >
> ># LISTENER.ORA Configuration
> > ````````````````````````````````````
> > File:/u01/app/oracle/product/8.1.6/network/admin/listener.ora
> ># Generated by Oracle configuration tools.
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> > )
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = development)(PORT = 1521))
> > )
> > )
> > (DESCRIPTION =
> > (PROTOCOL_STACK =
> > (PRESENTATION = GIOP)
> > (SESSION = RAW)
> > )
> > (ADDRESS = (PROTOCOL = TCP)(HOST = development)(PORT = 2481))
> > )
> > )
> >
> > Regards,
> >
> > - Surat Singh Bhati
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ______________________________________________________________________
> > ___
> > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com.
>
> ----------------------------------
> E-Mail: [EMAIL PROTECTED]
> Date: 30-Jan-01
> Time: 12:36:10
> ----------------------------------
