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

2001-08-22 Thread Alex Povolotsky
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 t

Re: Problem with DBD::Oracle with mod_perl

2001-08-22 Thread Alex Povolotsky
On Wed, Aug 22, 2001 at 09:42:59AM -0400, Perrin Harkins wrote: > > > Are you using Apache::DBI? Are you opening a connection in the parent > > > process (in startup.pl or equivalent)? > > Yes, yes. > > Don't open a connection during startup. If you do, it will be shared when > Apache forks, an

Re: Problem with DBD::Oracle with mod_perl

2001-08-22 Thread Alex Povolotsky
On Wed, Aug 22, 2001 at 09:07:59AM -0400, Perrin Harkins wrote: > > (DBD: error possibly near <*> indicator at char 1 in '<*>select > slogan_text > > from > > slogans') at /usr/local/www/lib/SQL.pm line 221. > Are you using Apache::DBI? Are you opening a connection in the parent > process (in st

Problem with DBD::Oracle with mod_perl

2001-08-22 Thread Alex Povolotsky
Hello! I'm getting constant troubles with DBD::Oracle and mod_perl. DBD::Oracle 1.08, DBI 1.19, mod_perl 1.26 on Apache 1.3.20, SunOS netra 5.8 Generic_108528-09 sun4u sparc SUNW,UltraAX-i2 gcc 2.95.3 20010315 (release) This is perl, v5.6.1 built for sun4-solaris # perl -V:usemymalloc usemymall

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

2001-08-22 Thread Alex Povolotsky
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 o

Re: DSO problems summary? (was Re: Children dying)

2001-08-16 Thread Alex Povolotsky
On Thu, Aug 16, 2001 at 09:35:43AM -0700, Doug MacEachern wrote: > that should be any platform where perl defaults to using its own malloc, > that is, if: > % perl -V:usemymalloc > reports: > usemymalloc='y' > > which is fine if: > % perl -V:bincompat5005 > reports: > bincompat5005='undef'; > >