It doesn't.
Torsten.
On 30-Jan-01 Tim Bunce wrote:
> 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
>> ----------------------------------
----------------------------------
E-Mail: [EMAIL PROTECTED]
Date: 30-Jan-01
Time: 18:25:46
----------------------------------
