Oracle::DBD under mod_perl on Sun/Solaris

[Alex Povolotsky <ta...@over.ru>]

Hello!

I've run into immeasurable lots of problem with Orcale and DBD::Oracle
under mod_perl.

Many things that works OK in plain perl scripts fail mysterically
under mod_perl, producing WEIRD errors.

If anyone have positive experience with Orale 8.1.7, DBD::Orcale 1.07
and mod_perl 1.26 on Solaris, or with similar environment, please
help.

I can post logs and examples, I just don't want to spare maillist
bandwidth.

Alex.

Re: Oracle::DBD under mod_perl on Sun/Solaris

[Alex Povolotsky <ta...@over.ru>]

On Wed, Aug 22, 2001 at 08:33:53PM +0100, Ged Haywood wrote:
> > DBD::Oracle::db prepare failed: ORA-03120: two-task conversion routine:
> [snip]
> > DBD::Oracle::db prepare failed: ORA-03113: end-of-file on communication channel (DBD: oopen error)
> > and EVERY connect to database fails since that.
> > I was NOT able to reproduce this bug outside of mod_perl.
> 
> Are you running out of memory?
... should not... HOWEVER, Apache::Resource, when it was installed, dropped
children on MEMORY at the time of connect to Oracle. I've set limit to 128
Mb, it didn't help.

Alex.

Re: Oracle::DBD under mod_perl on Sun/Solaris

[Ged Haywood <ge...@www2.jubileegroup.co.uk>]

Hi there,

On Wed, 22 Aug 2001, Alex Povolotsky wrote:

> DBD::Oracle::db prepare failed: ORA-03120: two-task conversion routine:
[snip]
> DBD::Oracle::db prepare failed: ORA-03113: end-of-file on communication channel (DBD: oopen error)
> and EVERY connect to database fails since that.
> I was NOT able to reproduce this bug outside of mod_perl.

Are you running out of memory?

73,
Ged.

Re: Oracle::DBD under mod_perl on Sun/Solaris

[Alex Povolotsky <ta...@over.ru>]

On Fri, Aug 10, 2001 at 12:52:48PM -0400, Robert Landrum wrote:
The show continues...
> alter session set COMPATIBILITY = '8.1.6';
> 
> when you first create your database handle.
I've rebuilt DBD::Oracle with "-8" key, as it was suggested by README;
I've added 'alter session' to each connection open;

I'm getting:

DBD::Oracle::db prepare failed: ORA-03120: two-task conversion routine:
integer 
overflow (DBD: error possibly near <*> indicator at char 1 in '<*>select
slogan_
text from slogans where SHOW_ON_MAINPAGE='Y'') at /usr/local/www/lib/SQL.pm
line
 221.
SQLMethods-/usr/local/www/lib/SQLMethods.pm-56select slogan_text from
slogans wh
ere SHOW_ON_MAINPAGE='Y'DBD::Oracle::db prepare failed: ORA-03113:
end-of-file o
n communication channel (DBD: oopen error) at
/usr/local/www/lib/SQLMethods.pm l
ine 102.

and EVERY connect to database fails since that.

I was NOT able to reproduce this bug outside of mod_perl.

Alex.

Re: Oracle::DBD under mod_perl on Sun/Solaris

[Robert Landrum <rl...@capitoladvantage.com>]

At 7:34 PM +0400 8/10/01, Alex Povolotsky wrote:
>[snip]
>Many things that works OK in plain perl scripts fail mysterically
>under mod_perl, producing WEIRD errors.
>If anyone have positive experience with Orale 8.1.7, DBD::Orcale 1.07
>and mod_perl 1.26 on Solaris, or with similar environment, please
>help.
>
>I can post logs and examples, I just don't want to spare maillist
>bandwidth.

Understood... But saying that you have WEIRD errors without posting 
any examples is wasting mailing list bandwidth....


Rob


--
"A good magician never reveals his secret; the unbelievable trick
becomes simple and obvious once it is explained. So too with UNIX."