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



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
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>
Download (untitled) / with headers
text/plain 2.6k
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
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>
Download (untitled) / with headers
text/plain 3.1k
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
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>
Download (untitled) / with headers
text/plain 280b
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?
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>
Download (untitled) / with headers
text/plain 619b
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?
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>
Download (untitled) / with headers
text/plain 6.6k
[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?
Download (untitled) / with headers
text/plain 151b
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.
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.
Download (untitled) / with headers
text/plain 760b
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...
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>
Download (untitled) / with headers
text/plain 1.1k
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...
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>
Download (untitled) / with headers
text/plain 1.1k
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...
Download (untitled) / with headers
text/plain 210b
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.
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>
Download (untitled) / with headers
text/plain 654b
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.
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>
Download (untitled) / with headers
text/plain 358b
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
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>
Download (untitled) / with headers
text/plain 1.1k
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
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>
Download (untitled) / with headers
text/plain 444b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.