Bug #70664 for DBIx-Class: DBIx::Class and Oracle 10.2.0.3

Thu Sep 01 06:16:11 2011 Duncan.Garland [...] motortrak.com - Ticket created

Subject:	DBIx::Class and Oracle 10.2.0.3
Date:	Thu, 1 Sep 2011 11:15:57 +0100
To:	Peter Rabbitson via RT <bug-DBIx-Class [...] rt.cpan.org>
From:	Duncan Garland <Duncan.Garland [...] motortrak.com>

Hi Peter, Are there any known issue with DBIx::Class and Oracle 10.2.0.3 at the moment? We are experiencing unexplained database slowdowns at the moment. I don't really believe that DBIx::Class is the problem, but I've been asked to ask. Module id = DBIx::Class CPAN_USERID ARCANEZ (Justin Hunter <justin.d.hunter@gmail.com>) CPAN_VERSION 0.08195 CPAN_FILE A/AB/ABRAXXA/DBIx-Class-0.08195.tar.gz MANPAGE DBIx::Class - Extensible and flexible object <-> relational mapper. INST_FILE /usr/lib/perl5/site_perl/5.8.8/DBIx/Class.pm INST_VERSION 0.08195 Regards Duncan

Thu Sep 01 06:41:13 2011 ribasushi [...] leporine.io - Correspondence added

On Thu Sep 01 06:16:11 2011, Duncan.Garland@motortrak.com wrote: Show quoted text

> Hi Peter, > > Are there any known issue with DBIx::Class and Oracle 10.2.0.3 at the > moment? > > We are experiencing unexplained database slowdowns at the moment. I > don't really believe that DBIx::Class is the problem, but I've been > asked to ask. > > Module id = DBIx::Class > CPAN_USERID ARCANEZ (Justin Hunter <justin.d.hunter@gmail.com>) > CPAN_VERSION 0.08195 > CPAN_FILE A/AB/ABRAXXA/DBIx-Class-0.08195.tar.gz > MANPAGE DBIx::Class - Extensible and flexible object <-> > relational mapper. > INST_FILE /usr/lib/perl5/site_perl/5.8.8/DBIx/Class.pm > INST_VERSION 0.08195 > > Regards > > Duncan

Hi, It *is* possible that the blob condition handling code misfires. Things will still work but excrutiatingly slow. Refer to https://rt.cpan.org/Ticket/Display.html?id=70045 for more info. Note this may not be your problem at all, this just happened to affect someone else recently.

Thu Sep 01 06:41:16 2011 The RT System itself - Status changed from 'new' to 'open'

Thu Sep 01 06:48:26 2011 Duncan.Garland [...] motortrak.com - Correspondence added

Subject:	RE: [rt.cpan.org #70664] DBIx::Class and Oracle 10.2.0.3
Date:	Thu, 1 Sep 2011 11:48:15 +0100
To:	"bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From:	Duncan Garland <Duncan.Garland [...] motortrak.com>

Hi Peter, This refers to someone using an incorrect datatype. We haven't done that. All the best. Duncan Show quoted text

-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 01 September 2011 11:41 To: Duncan Garland Subject: [rt.cpan.org #70664] DBIx::Class and Oracle 10.2.0.3 <URL: https://rt.cpan.org/Ticket/Display.html?id=70664 > On Thu Sep 01 06:16:11 2011, Duncan.Garland@motortrak.com wrote:

> Hi Peter, > > Are there any known issue with DBIx::Class and Oracle 10.2.0.3 at the > moment? > > We are experiencing unexplained database slowdowns at the moment. I > don't really believe that DBIx::Class is the problem, but I've been > asked to ask. > > Module id = DBIx::Class > CPAN_USERID ARCANEZ (Justin Hunter <justin.d.hunter@gmail.com>) > CPAN_VERSION 0.08195 > CPAN_FILE A/AB/ABRAXXA/DBIx-Class-0.08195.tar.gz > MANPAGE DBIx::Class - Extensible and flexible object <-> > relational mapper. > INST_FILE /usr/lib/perl5/site_perl/5.8.8/DBIx/Class.pm > INST_VERSION 0.08195 > > Regards > > Duncan

Hi, It *is* possible that the blob condition handling code misfires. Things will still work but excrutiatingly slow. Refer to https://rt.cpan.org/Ticket/Display.html?id=70045 for more info. Note this may not be your problem at all, this just happened to affect someone else recently.

Thu Sep 01 11:18:57 2011 ribasushi [...] leporine.io - Correspondence added

On Thu Sep 01 06:48:26 2011, Duncan.Garland@motortrak.com wrote: Show quoted text

> Hi Peter, > > This refers to someone using an incorrect datatype. We haven't done that. >

Then no, I am not aware of any issues at the moment. I suggest examining the SQL trace dumps (DBIC_TRACE=1=logfile) and comparing them between the new (slow) and old (normal) versions of dbic to see if anything jumps out. It may not even be related to DBIC in any way. I am closing this ticket for the time being, feel free to reopen it if you get something more definitive.

Thu Sep 01 11:19:01 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'rejected'

Thu Sep 01 11:20:12 2011 Duncan.Garland [...] motortrak.com - Correspondence added

Subject:	RE: [rt.cpan.org #70664] DBIx::Class and Oracle 10.2.0.3
Date:	Thu, 1 Sep 2011 16:19:59 +0100
To:	"bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From:	Duncan Garland <Duncan.Garland [...] motortrak.com>

Hi Peter, Yes, please close the ticket. I was just trying to cover all the bases. Duncan Show quoted text

-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 01 September 2011 16:19 To: Duncan Garland Subject: [rt.cpan.org #70664] DBIx::Class and Oracle 10.2.0.3 <URL: https://rt.cpan.org/Ticket/Display.html?id=70664 > On Thu Sep 01 06:48:26 2011, Duncan.Garland@motortrak.com wrote:

> Hi Peter, > > This refers to someone using an incorrect datatype. We haven't done that. >

Then no, I am not aware of any issues at the moment. I suggest examining the SQL trace dumps (DBIC_TRACE=1=logfile) and comparing them between the new (slow) and old (normal) versions of dbic to see if anything jumps out. It may not even be related to DBIC in any way. I am closing this ticket for the time being, feel free to reopen it if you get something more definitive.

Thu Sep 01 11:20:15 2011 The RT System itself - Status changed from 'rejected' to 'open'

Thu Sep 01 12:36:24 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'rejected'