Skip Menu |

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 69829
Status: resolved
Priority: 0/
Queue: DBIx-Class
People
Owner: Nobody in particular
Requestors: Duncan.Garland [...] motortrak.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 0.08195

History Show all quoted text
  Wed Jul 27 07:17:12 2011 Duncan.Garland [...] motortrak.com - Ticket created
Subject: DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 12:07:13 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Hi, There's a problem with Catalyst/DBIx on one of our machines. I suspect it's a dependency problem but there error messages aren't giving me much of a clue. This is happening at the end of the cycle when Catalyst tries to store the session data: [error] Caught exception in engine "DBIx::Class::Relationship::CascadeActions::update(): Can't bind unknown placeholder ':p2' (2) at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1574. at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm line 131" The session table is a simple table with three columns: Show quoted text
SQL> desc mbfl2_sessions
Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL VARCHAR2(72) SESSION_DATA BLOB EXPIRES NUMBER Its DBIx definition is: __PACKAGE__->add_columns( "id", { data_type => "varchar2", is_nullable => 0, size => 72 }, "session_data", { data_type => "blob", is_nullable => 1 }, "expires", { data_type => "numeric", is_nullable => 1, original => { data_type => "number" }, size => 126, }, ); __PACKAGE__->set_primary_key("id"); There aren't any cascaded deletes, so what's it doing in CascadeActions anyway? The line which is failing is: $row->update if $row->in_storage; The row objects look OK. I'm stuck! Any ideas? I'm supposed to do a proper release today. Show quoted text
cpan> i DBIx::Class
CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Database was generated on Mon, 25 Jul 2011 23:27:12 GMT Strange distribution name [DBIx::Class] Module id = DBIx::Class CPAN_USERID FREW (Arthur Axel 'fREW' Schmidt <frioux@gmail.com>) CPAN_VERSION 0.08194 CPAN_FILE A/AB/ABRAXXA/DBIx-Class-0.08194.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.08194 Regards Duncan
  Wed Jul 27 08:59:29 2011 ribasushi [...] leporine.io - Correspondence added
Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:59:16 +0200
To: bug-DBIx-Class [...] rt.cpan.org
From: Peter Rabbitson <ribasushi [...] cpan.org>
Duncan Garland via RT wrote: Show quoted text
> Wed Jul 27 07:17:12 2011: Request 69829 was acted upon. > Transaction: Ticket created by Duncan.Garland@motortrak.com > Queue: DBIx-Class > Subject: DBIx::Class::Relationship::CascadeActions > Broken in: (no value) > Severity: (no value) > Owner: Nobody > Requestors: Duncan.Garland@motortrak.com > Status: new > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > > Hi, > > There's a problem with Catalyst/DBIx on one of our machines. I suspect it's a dependency problem but there error messages aren't giving me much of a clue. > > This is happening at the end of the cycle when Catalyst tries to store the session data: > > [error] Caught exception in engine "DBIx::Class::Relationship::CascadeActions::update(): Can't bind unknown placeholder ':p2' (2) at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1574. at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm line 131" > > The session table is a simple table with three columns: >
> SQL> desc mbfl2_sessions
> Name Null? Type > ----------------------------------------- -------- ---------------------------- > ID NOT NULL VARCHAR2(72) > SESSION_DATA BLOB > EXPIRES NUMBER > > Its DBIx definition is: > > __PACKAGE__->add_columns( > "id", > { data_type => "varchar2", is_nullable => 0, size => 72 }, > "session_data", > { data_type => "blob", is_nullable => 1 }, > "expires", > { > data_type => "numeric", > is_nullable => 1, > original => { data_type => "number" }, > size => 126, > }, > ); > __PACKAGE__->set_primary_key("id"); > > There aren't any cascaded deletes, so what's it doing in CascadeActions anyway? > > The line which is failing is: > > $row->update if $row->in_storage; > > The row objects look OK.
You did not provide a DBIC_TRACE=1 Show quoted text
> I'm stuck! Any ideas? I'm supposed to do a proper release today. >
> cpan> i DBIx::Class
> CPAN: Storable loaded ok > Going to read /root/.cpan/Metadata > Database was generated on Mon, 25 Jul 2011 23:27:12 GMT > Strange distribution name [DBIx::Class] > Module id = DBIx::Class > CPAN_USERID FREW (Arthur Axel 'fREW' Schmidt <frioux@gmail.com>) > CPAN_VERSION 0.08194 > CPAN_FILE A/AB/ABRAXXA/DBIx-Class-0.08194.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.08194 >
This looks odd (again). The USERID which released 0.08194 is *not* FREW Cheers
  Wed Jul 27 08:59:32 2011 The RT System itself - Status changed from 'new' to 'open'
  Wed Jul 27 09:02:44 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:02:31 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Any ideas? I'm getting a lot of stick about this, but I daren't release it to UAT until I'm sure it won't break that. Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 14:00 To: Duncan Garland Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > Duncan Garland via RT wrote:
> Wed Jul 27 07:17:12 2011: Request 69829 was acted upon. > Transaction: Ticket created by Duncan.Garland@motortrak.com > Queue: DBIx-Class > Subject: DBIx::Class::Relationship::CascadeActions > Broken in: (no value) > Severity: (no value) > Owner: Nobody > Requestors: Duncan.Garland@motortrak.com > Status: new > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > > Hi, > > There's a problem with Catalyst/DBIx on one of our machines. I suspect it's a dependency problem but there error messages aren't giving me much of a clue. > > This is happening at the end of the cycle when Catalyst tries to store the session data: > > [error] Caught exception in engine "DBIx::Class::Relationship::CascadeActions::update(): Can't bind unknown placeholder ':p2' (2) at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1574. at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm line 131" > > The session table is a simple table with three columns: >
> SQL> desc mbfl2_sessions
> Name Null? Type > ----------------------------------------- -------- ---------------------------- > ID NOT NULL VARCHAR2(72) > SESSION_DATA BLOB > EXPIRES NUMBER > > Its DBIx definition is: > > __PACKAGE__->add_columns( > "id", > { data_type => "varchar2", is_nullable => 0, size => 72 }, > "session_data", > { data_type => "blob", is_nullable => 1 }, > "expires", > { > data_type => "numeric", > is_nullable => 1, > original => { data_type => "number" }, > size => 126, > }, > ); > __PACKAGE__->set_primary_key("id"); > > There aren't any cascaded deletes, so what's it doing in CascadeActions anyway? > > The line which is failing is: > > $row->update if $row->in_storage; > > The row objects look OK.
You did not provide a DBIC_TRACE=1
> I'm stuck! Any ideas? I'm supposed to do a proper release today. >
> cpan> i DBIx::Class
> CPAN: Storable loaded ok > Going to read /root/.cpan/Metadata > Database was generated on Mon, 25 Jul 2011 23:27:12 GMT > Strange distribution name [DBIx::Class] > Module id = DBIx::Class > CPAN_USERID FREW (Arthur Axel 'fREW' Schmidt <frioux@gmail.com>) > CPAN_VERSION 0.08194 > CPAN_FILE A/AB/ABRAXXA/DBIx-Class-0.08194.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.08194 >
This looks odd (again). The USERID which released 0.08194 is *not* FREW Cheers
  Wed Jul 27 09:04:23 2011 rabbit [...] rabbit.us - Correspondence added
Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 15:04:12 +0200
To: bug-DBIx-Class [...] rt.cpan.org
From: Peter Rabbitson <rabbit [...] rabbit.us>
Duncan Garland via RT wrote: Show quoted text
> Queue: DBIx-Class > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > Any ideas? I'm getting a lot of stick about this, but I daren't release it to UAT until I'm sure it won't break that. >
Where is the info I asked for?
  Wed Jul 27 09:05:44 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:05:35 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Sorry. Didn't notice that. Give me 5 minutes. Show quoted text
-----Original Message----- From: rabbit@rabbit.us via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 14:04 To: Duncan Garland Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > Duncan Garland via RT wrote:
> Queue: DBIx-Class > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > Any ideas? I'm getting a lot of stick about this, but I daren't release it to UAT until I'm sure it won't break that. >
Where is the info I asked for?
  Wed Jul 27 09:09:12 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:09:02 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
[error] Caught exception in engine "Can't bind unknown placeholder ':p2' (2) at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1574. at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Schema.pm line 1078 DBIx::Class::Schema::throw_exception('MBFL2SCHEMA=HASH(0x12e4f4d0)', 'Can\'t bind unknown placeholder \':p2\' (2) at /usr/lib/perl5...') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage.pm line 111 DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::Oracle::Generic=HASH(0x12e53e10)', 'Can\'t bind unknown placeholder \':p2\' (2) at /usr/lib/perl5...') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI/Oracle/Generic.pm line 324 DBIx::Class::Storage::DBI::Oracle::Generic::__ANON__('Can\'t bind unknown placeholder \':p2\' (2) at /usr/lib/perl5...') called at /usr/lib/perl5/site_perl/5.8.8/Try/Tiny.pm line 100 Try::Tiny::try('CODE(0x2b8a260aa5d0)', 'Try::Tiny::Catch=REF(0x146f47c0)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI/Oracle/Generic.pm line 326 DBIx::Class::Storage::DBI::Oracle::Generic::_dbh_execute('DBIx::Class::Storage::DBI::Oracle::Generic=HASH(0x12e53e10)', 'DBI::db=HASH(0x14119e10)', 'WHERE ( id = ? )', 'ARRAY(0x1458e870)', 'ARRAY(0x1459b850)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 788 DBIx::Class::Storage::DBI::__ANON__() called at /usr/lib/perl5/site_perl/5.8.8/Try/Tiny.pm line 71 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/Try/Tiny.pm line 67 Try::Tiny::try('CODE(0x147508c0)', 'Try::Tiny::Catch=REF(0x145869b0)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 799 DBIx::Class::Storage::DBI::dbh_do('undef', 'undef', 'WHERE ( id = ? )', 'ARRAY(0x1458e870)', 'ARRAY(0x1459b850)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1551 DBIx::Class::Storage::DBI::_execute('DBIx::Class::Storage::DBI::Oracle::Generic=HASH(0x12e53e10)', 'update', 'DBIx::Class::ResultSource::Table=HASH(0x13349a30)', 'HASH(0x11e55bf0)', 'HASH(0x11ea5600)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 1969 DBIx::Class::Storage::DBI::update('DBIx::Class::Storage::DBI::Oracle::Generic=HASH(0x12e53e10)', 'DBIx::Class::ResultSource::Table=HASH(0x13349a30)', 'HASH(0x11e55bf0)', 'HASH(0x11ea5600)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Row.pm line 503 DBIx::Class::Row::update('mbfl2::Model::DB::Mbfl2Session=HASH(0x12bd6310)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Relationship/CascadeActions.pm line 74 DBIx::Class::Relationship::CascadeActions::update('mbfl2::Model::DB::Mbfl2Session=HASH(0x12bd6310)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm line 131 Catalyst::Plugin::Session::Store::DBIC::Delegate::flush('Catalyst::Plugin::Session::Store::DBIC::Delegate=HASH(0x14109...') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/Delegate.pm line 72 Catalyst::Plugin::Session::Store::Delegate::finalize_session_delegate('mbfl2=HASH(0x12a9ff50)', 'Catalyst::Plugin::Session::Store::DBIC::Delegate=HASH(0x14109...') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/Delegate.pm line 65 Catalyst::Plugin::Session::Store::Delegate::_clear_session_instance_data('mbfl2=HASH(0x12a9ff50)') called at /usr/lib/perl5/site_perl/5.8.8/Class/C3/next.pm line 71 maybe::next::method('mbfl2=HASH(0x12a9ff50)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session.pm line 297 Catalyst::Plugin::Session::_clear_session_instance_data('mbfl2=HASH(0x12a9ff50)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session.pm line 131 Catalyst::Plugin::Session::finalize_session('mbfl2=HASH(0x12a9ff50)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session.pm line 117 Catalyst::Plugin::Session::finalize_body('mbfl2=HASH(0x12a9ff50)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst.pm line 1795 Catalyst::finalize('mbfl2=HASH(0x12a9ff50)') called at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Class/MOP/Method/Wrapped.pm line 50 Class::MOP::Method::Wrapped::__ANON__('mbfl2=HASH(0x12a9ff50)') called at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Class/MOP/Method/Wrapped.pm line 91 mbfl2::finalize('mbfl2=HASH(0x12a9ff50)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst.pm line 1953 eval {...} called at /usr/lib/perl5/site_perl/5.8.8/Catalyst.pm line 1943 Catalyst::handle_request('mbfl2', 'env', 'HASH(0x138231a0)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Engine/HTTP.pm line 395 Catalyst::Engine::HTTP::_handler('Catalyst::Engine::HTTP=HASH(0xd448d60)', 'mbfl2', 3000, 'GET', '/', 'HTTP/1.1') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Engine/HTTP.pm line 292 Catalyst::Engine::HTTP::run('Catalyst::Engine::HTTP=HASH(0xd448d60)', 'mbfl2', 3000, 'undef', 'HASH(0xcd23100)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst.pm line 2396 Catalyst::run('mbfl2', 3000, 'undef', 'HASH(0xcd23100)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/ScriptRole.pm line 49 Catalyst::ScriptRole::_run_application('Catalyst::Script::Server=HASH(0xc43f980)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Script/Server.pm line 142 Catalyst::Script::Server::__ANON__() called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Restarter/Forking.pm line 20 Catalyst::Restarter::Forking::_fork_and_start('Catalyst::Restarter::Forking=HASH(0xcd39ed0)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Restarter.pm line 89 Catalyst::Restarter::run_and_watch('Catalyst::Restarter::Forking=HASH(0xcd39ed0)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/Script/Server.pm line 189 Catalyst::Script::Server::run('Catalyst::Script::Server=HASH(0xc43f980)') called at /usr/lib/perl5/site_perl/5.8.8/Catalyst/ScriptRunner.pm line 20 Catalyst::ScriptRunner::run('Catalyst::ScriptRunner', 'mbfl2', 'Server') called at /usr/local/etc/httpd/fcgi/catalyst/mbfl2/script/mbfl2_server.pl line 9" Show quoted text
-----Original Message----- From: rabbit@rabbit.us via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 14:04 To: Duncan Garland Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > Duncan Garland via RT wrote:
> Queue: DBIx-Class > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > Any ideas? I'm getting a lot of stick about this, but I daren't release it to UAT until I'm sure it won't break that. >
Where is the info I asked for?
  Wed Jul 27 09:11:16 2011 ribasushi [...] leporine.io - Correspondence added
No, this is the full stacktrace of the error. Before this there was one last SQL statement that DBIC tried to prepare/execute - this is the one I want.
  Wed Jul 27 09:26:36 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:26:24 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
[info] mbfl2 powered by Catalyst 5.80032 ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS': ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS': BEGIN WORK SELECT me.id, me.session_data, me.expires FROM mbfl2_sessions me WHERE ( me.id = ? ) : 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' INSERT INTO mbfl2_sessions ( id) VALUES ( ? ): 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' COMMIT WHERE ( id = ? ): '1311779263', 'BQcDAAAAAgoKMTMxMTc3MjA2MwAAAAlfX2NyZWF0ZWQKCjEzMTE3NzIwNjQAAAAJX191cGRhdGVk ', 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 14:11 To: Duncan Garland Subject: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > No, this is the full stacktrace of the error. Before this there was one last SQL statement that DBIC tried to prepare/execute - this is the one I want.
  Wed Jul 27 09:35:40 2011 ribasushi [...] leporine.io - Correspondence added
On Wed Jul 27 09:26:36 2011, Duncan.Garland@motortrak.com wrote: Show quoted text
> [info] mbfl2 powered by Catalyst 5.80032 > ALTER SESSION SET > NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS': > ALTER SESSION SET > NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS': > BEGIN WORK > SELECT > me.id, me.session_data, me.expires FROM mbfl2_sessions me WHERE ( > me.id = ? ) : 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' > INSERT INTO mbfl2_sessions ( id) VALUES ( ? ): > 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' > COMMIT > > WHERE ( > id = ? ): '1311779263', >
'BQcDAAAAAgoKMTMxMTc3MjA2MwAAAAlfX2NyZWF0ZWQKCjEzMTE3NzIwNjQAAAAJX191cGRhdGVk Show quoted text
> ', 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62'
Are you sure this is all you got? The last WHERE is missing its select...
  Wed Jul 27 09:39:14 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:39:04 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Hi Peter, The string SELECT does not exist anywhere else. There's only the one INSERT and no UPDATEs. Duncan Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 14:36 To: Duncan Garland Subject: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > On Wed Jul 27 09:26:36 2011, Duncan.Garland@motortrak.com wrote:
> [info] mbfl2 powered by Catalyst 5.80032 > ALTER SESSION SET > NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS': > ALTER SESSION SET > NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS': > BEGIN WORK > SELECT > me.id, me.session_data, me.expires FROM mbfl2_sessions me WHERE ( > me.id = ? ) : 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' > INSERT INTO mbfl2_sessions ( id) VALUES ( ? ): > 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' > COMMIT > > WHERE ( > id = ? ): '1311779263', >
'BQcDAAAAAgoKMTMxMTc3MjA2MwAAAAlfX2NyZWF0ZWQKCjEzMTE3NzIwNjQAAAAJX191cGRhdGVk
> ', 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62'
Are you sure this is all you got? The last WHERE is missing its select...
  Wed Jul 27 09:42:30 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 14:42:21 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
I've managed to log on to http://02.chat.mibbit.com/#dbix-class@irc.perl.org if that helps. Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 14:36 To: Duncan Garland Subject: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > On Wed Jul 27 09:26:36 2011, Duncan.Garland@motortrak.com wrote:
> [info] mbfl2 powered by Catalyst 5.80032 > ALTER SESSION SET > NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS': > ALTER SESSION SET > NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS': > BEGIN WORK > SELECT > me.id, me.session_data, me.expires FROM mbfl2_sessions me WHERE ( > me.id = ? ) : 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' > INSERT INTO mbfl2_sessions ( id) VALUES ( ? ): > 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62' > COMMIT > > WHERE ( > id = ? ): '1311779263', >
'BQcDAAAAAgoKMTMxMTc3MjA2MwAAAAlfX2NyZWF0ZWQKCjEzMTE3NzIwNjQAAAAJX191cGRhdGVk
> ', 'session:a8960fef7b820439a666fe1a25021ab3b9f72f62'
Are you sure this is all you got? The last WHERE is missing its select...
  Wed Jul 27 10:04:33 2011 ribasushi [...] leporine.io - Correspondence added
On Wed Jul 27 09:42:30 2011, Duncan.Garland@motortrak.com wrote: Show quoted text
> I've managed to log on to http://02.chat.mibbit.com/#dbix- > class@irc.perl.org if that helps. >
I do not see you. I am ribasushi over there.
  Wed Jul 27 10:26:37 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 15:26:21 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
I can't see anybody at all. I am definitely connected to astral.shadowcat.co.uk but can't get any further. Any ideas about the main problem? Duncan Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 15:05 To: Duncan Garland Subject: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > On Wed Jul 27 09:42:30 2011, Duncan.Garland@motortrak.com wrote:
> I've managed to log on to http://02.chat.mibbit.com/#dbix- > class@irc.perl.org if that helps. >
I do not see you. I am ribasushi over there.
  Wed Jul 27 10:29:57 2011 ribasushi [...] leporine.io - Correspondence added
Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 16:29:45 +0200
To: bug-DBIx-Class [...] rt.cpan.org
From: Peter Rabbitson <ribasushi [...] cpan.org>
Duncan Garland via RT wrote: Show quoted text
> Queue: DBIx-Class > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > I can't see anybody at all. > > I am definitely connected to astral.shadowcat.co.uk but can't get any further. > > Any ideas about the main problem? >
None whatsoever, please try to reconnect, it will go much quicker over IRC
  Wed Jul 27 10:44:05 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions
Date: Wed, 27 Jul 2011 15:43:56 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS': ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS': BEGIN WORK SELECT me.id, me.session_data, me.expires FROM mbfl2_sessions me WHERE ( me.id = ? ) : 'session:aeabf21a598d44e9b23b343b82bed003d3454329' INSERT INTO mbfl2_sessions ( id) VALUES ( ? ): 'session:aeabf21a598d44e9b23b343b82bed003d3454329' COMMIT WHERE ( id = ? ): '1311784857', 'BQcDAAAAAgoKMTMxMTc3NzY1NwAAAAlfX2NyZWF0ZWQKCjEzMTE3Nzc2NTcAAAAJX191cGRhdGVk ', 'session:aeabf21a598d44e9b23b343b82bed003d3454329' Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 27 July 2011 15:30 To: Duncan Garland Subject: Re: [rt.cpan.org #69829] DBIx::Class::Relationship::CascadeActions <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > Duncan Garland via RT wrote:
> Queue: DBIx-Class > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > > > I can't see anybody at all. > > I am definitely connected to astral.shadowcat.co.uk but can't get any further. > > Any ideas about the main problem? >
None whatsoever, please try to reconnect, it will go much quicker over IRC
  Mon Aug 01 05:20:07 2011 ribasushi [...] leporine.io - Subject changed from 'DBIx::Class::Relationship::CascadeActions' to 'Broken update of blob columns on Oracle'
  Mon Aug 01 05:20:08 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'
  Mon Aug 01 05:20:08 2011 ribasushi [...] leporine.io - Fixed in 0.08195 added
  Mon Aug 01 05:20:58 2011 Duncan.Garland [...] motortrak.com - Correspondence added
Subject: RE: [rt.cpan.org #69829] Resolved: Broken update of blob columns on Oracle
Date: Mon, 1 Aug 2011 10:20:43 +0100
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Everything OK. Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 01 August 2011 10:20 To: Duncan Garland Subject: [rt.cpan.org #69829] Resolved: Broken update of blob columns on Oracle <URL: https://rt.cpan.org/Ticket/Display.html?id=69829 > According to our records, your request has been resolved. If you have any further questions or concerns, please respond to this message.
  Mon Aug 01 05:21:01 2011 The RT System itself - Status changed from 'resolved' to 'open'
  Mon Aug 01 05:21:40 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'