DBD::Oracle crashes non-deterministic

--=_alternative 00609AC3C12572B2_=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Folks,

we have strange behaviour on several of our programs written with perl=20
5.6.1,DBI 1.35 and Oracle DBD::1.14 on Linux.

I know it's old, but we can't update it easily yet.

The Oracle Client is 9i and 9i R2, Databases are having trouble beginning=20
with the latest 9er Releases and 10.2.

Our Perl-Module crashes completely on undeterministic parts of the=20
software and sometimes immediately, sometimes even NOT. (Same Data, of=20
course)

The modules usually have large queries and few updates/inserts into=20
different tables, it makes no difference if the statements are prepared or =

not.

One difference we have found is that if we are targetting a 9i R2 Database =

it happens only if more than ONE Connection from the same user is working
on the database, on 10.2 it seems to happen everytime.

The latest time it happened was when a customers database was moved to a=20
different machine, but stayed on the 9i Rx release. Unfortunately the=20
database guys "did not change anything",
so i have no clue until now what is different.
At least on this installation it happens only when more than one process=20
is working on the database.

Does anyone have a clue on whats happening? It seems to be that something=20
client/session-dependent changes from 9i to 9i Rx / 10.x, but until now=20
nothing helped, updating the client to latest
9iR2, latest DBI and latest DBD did not help.

Switching to perl 5.8 is no option for the customers until now...

Hope you can help us

Bye for now
Kai
--
Kai Schwermann, Geschäftsführer
bill-X GmbH
Möserstr. 34 49074 Osnabrück, Germany
Tel. +49-541-71008-0 Fax +49-541-71008-499
http://www.bill-X.de schwermann@bill-X.de
____________________ ____=5F=
____________________ ____=5F=
____________________ ____=5F=
=5F
--=_alternative 00609AC3C12572B2_=--

Re: DBD::Oracle crashes non-deterministic

If you are getting

" DBD::Oracle::st execute failed: ORA-01008: not all variables bound (DBD
ERROR: OCIStmtExecute) " errors on 10

it is a know a bug in Oracle.

http://forums.oracle.com/forums/thread.jspa?messageID=166817 6


----- Original Message -----
From: "Kai Schwermann"
To:
Sent: Tuesday, April 03, 2007 1:31 PM
Subject: DBD::Oracle crashes non-deterministic


Hi Folks,

we have strange behaviour on several of our programs written with perl
5.6.1,DBI 1.35 and Oracle DBD::1.14 on Linux.

I know it's old, but we can't update it easily yet.

The Oracle Client is 9i and 9i R2, Databases are having trouble beginning
with the latest 9er Releases and 10.2.

Our Perl-Module crashes completely on undeterministic parts of the
software and sometimes immediately, sometimes even NOT. (Same Data, of
course)

The modules usually have large queries and few updates/inserts into
different tables, it makes no difference if the statements are prepared or
not.

One difference we have found is that if we are targetting a 9i R2 Database
it happens only if more than ONE Connection from the same user is working
on the database, on 10.2 it seems to happen everytime.

The latest time it happened was when a customers database was moved to a
different machine, but stayed on the 9i Rx release. Unfortunately the
database guys "did not change anything",
so i have no clue until now what is different.
At least on this installation it happens only when more than one process
is working on the database.

Does anyone have a clue on whats happening? It seems to be that something
client/session-dependent changes from 9i to 9i Rx / 10.x, but until now
nothing helped, updating the client to latest
9iR2, latest DBI and latest DBD did not help.

Switching to perl 5.8 is no option for the customers until now...

Hope you can help us

Bye for now
Kai
--
Kai Schwermann, Geschäftsführer
bill-X GmbH
Möserstr. 34 49074 Osnabrück, Germany
Tel. +49-541-71008-0 Fax +49-541-71008-499
http://www.bill-X.de schwermann@bill-X.de
____________________________________________________________ ________________

Re: DBD::Oracle crashes non-deterministic

--=_alternative 00750E32C12572B2_=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

No, unfortunately it really CRASHES perl, i.e. it dumps core in the oracle =

libs...
--
Kai Schwermann, Geschäftsführer
bill-X GmbH
Möserstr. 34 49074 Osnabrück, Germany
Tel. +49-541-71008-0 Fax +49-541-71008-499
http://www.bill-X.de schwermann@bill-X.de
____________________ ____=5F=
____________________ ____=5F=
____________________ ____=5F=
=5F




"John Scoles"
03.04.2007 20:06

=20
To: , "Kai Schwermann" -X.de>
cc:=20
Subject: Re: DBD::Oracle crashes non-deterministic


If you are getting

" DBD::Oracle::st execute failed: ORA-01008: not all variables bound (DBD=20
ERROR: OCIStmtExecute) " errors on 10

it is a know a bug in Oracle.

http://forums.oracle.com/forums/thread.jspa?messageID=3D1668 176


----- Original Message -----=20
From: "Kai Schwermann"
To:
Sent: Tuesday, April 03, 2007 1:31 PM
Subject: DBD::Oracle crashes non-deterministic


Hi Folks,

we have strange behaviour on several of our programs written with perl
5.6.1,DBI 1.35 and Oracle DBD::1.14 on Linux.

I know it's old, but we can't update it easily yet.

The Oracle Client is 9i and 9i R2, Databases are having trouble beginning
with the latest 9er Releases and 10.2.

Our Perl-Module crashes completely on undeterministic parts of the
software and sometimes immediately, sometimes even NOT. (Same Data, of
course)

The modules usually have large queries and few updates/inserts into
different tables, it makes no difference if the statements are prepared or
not.

One difference we have found is that if we are targetting a 9i R2 Database
it happens only if more than ONE Connection from the same user is working
on the database, on 10.2 it seems to happen everytime.

The latest time it happened was when a customers database was moved to a
different machine, but stayed on the 9i Rx release. Unfortunately the
database guys "did not change anything",
so i have no clue until now what is different.
At least on this installation it happens only when more than one process
is working on the database.

Does anyone have a clue on whats happening? It seems to be that something
client/session-dependent changes from 9i to 9i Rx / 10.x, but until now
nothing helped, updating the client to latest
9iR2, latest DBI and latest DBD did not help.

Switching to perl 5.8 is no option for the customers until now...

Hope you can help us

Bye for now
Kai
--
Kai Schwermann, Geschäftsführer
bill-X GmbH
Möserstr. 34 49074 Osnabrück, Germany
Tel. +49-541-71008-0 Fax +49-541-71008-499
http://www.bill-X.de schwermann@bill-X.de
____________________ ____=5F=
____________________ ____=5F=
____________________ ____=5F=
_





--=_alternative 00750E32C12572B2_=--