[rt-devel] RT 4.2.7: SQL error on ticket traffic
Brian McNally
bmcnally at uw.edu
Thu Sep 25 20:05:15 EDT 2014
Hi,
I'm running RT 4.2.7 (having recently upgraded from 3.6.6) and am
running in to issues on ticket creation, correspondence, or comments
(that is, everything). I've attached log entries that show the errors.
My issue sounds very similar to this problem:
https://bugzilla.redhat.com/show_bug.cgi?id=1121601#c6
https://bugzilla.redhat.com/show_bug.cgi?id=1121601#c7
After lots of frustration I tried upgrading from 3.6.6 to 4.0.8 based on
the above user's experience and I discovered that I do not have the same
SQL errors on ticket traffic. I'm using Postgres 9.3.5,
DBIx::SearchBuilder 1.66, DBD::Pg 3.4.1, RHEL 6.5.
I've narrowed down the failure to a particular SQL query:
rt3_admin=# SELECT main.* FROM Scrips main JOIN ObjectScrips
ObjectScrips_1 ON ( ObjectScrips_1.Scrip = main.id ) JOIN
ScripConditions ScripConditions_2 ON ( ScripConditions_2.id =
main.ScripCondition ) WHERE (ObjectScrips_1.ObjectId = '3' OR
ObjectScrips_1.ObjectId = '0') AND (ObjectScrips_1.Stage =
'TransactionCreate') AND (ScripConditions_2.ApplicableTransTypes LIKE
'%Create%' OR ScripConditions_2.ApplicableTransTypes LIKE '%Any%') AND
(main.Disabled = '0') GROUP BY main.id ORDER BY
MIN(ObjectScrips_1.SortOrder) ASC
rt3_admin-# ;
ERROR: column "main.description" must appear in the GROUP BY clause or
be used in an aggregate function
LINE 1: SELECT main.* FROM Scrips main JOIN ObjectScrips ObjectScrip...
What's confusing is that I also upgraded another RT instance using the
same procedure and I do not have this same issue (the SQL query above
and ticket updates work fine).
--
Brian McNally
-------------- next part --------------
[30933] [Wed Sep 24 23:24:00 2014] [debug]: Converting 'iso-8859-1' to 'utf-8' for text/plain - admin-new test 4 (/data/rt/admin/sbin/../lib/RT/I18N.pm:295)
[30933] [Wed Sep 24 23:24:00 2014] [debug]: Mail from user #61 (bmcnally at uw.edu) (/data/rt/admin/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:82)
[30933] [Wed Sep 24 23:24:01 2014] [debug]: About to prepare scrips for transaction #461650 (/data/rt/admin/sbin/../lib/RT/Transaction.pm:187)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: DBD::Pg::st execute failed: ERROR: column "main.description" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT main.* FROM Scrips main JOIN ObjectScrips ObjectScrip...
^ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: RT::Handle=HASH(0x7f94dcc7c1d8) couldn't execute the query 'SELECT main.* FROM Scrips main JOIN ObjectScrips ObjectScrips_1 ON ( ObjectScrips_1.Scrip = main.id ) JOIN ScripConditions ScripConditions_2 ON ( ScripConditions_2.id = main.ScripCondition ) WHERE (ObjectScrips_1.ObjectId = '3' OR ObjectScrips_1.ObjectId = '0') AND (ObjectScrips_1.Stage = 'TransactionCreate') AND (ScripConditions_2.ApplicableTransTypes LIKE '%Create%' OR ScripConditions_2.ApplicableTransTypes LIKE '%Any%') AND (main.Disabled = '0') GROUP BY main.id ORDER BY MIN(ObjectScrips_1.SortOrder) ASC ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f94dcc7c1d8), "SELECT main.* FROM Scrips main JOIN ObjectScrips ObjectScrips"...) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/SearchBuilder.pm line 985
RT::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 493
RT::Scrips::_FindScrips(RT::Scrips=HASH(0x7f94e2196b18), "Stage", "TransactionCreate", "Type", "Create") called at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 343
RT::Scrips::Prepare(RT::Scrips=HASH(0x7f94e2196b18), "Stage", "TransactionCreate", "Type", "Create", "Ticket", 29808, "Transaction", 461650, ...) called at /data/rt/admin/sbin/../lib/RT/Transaction.pm line 189
RT::Transaction::Create(RT::Transaction=HASH(0x7f94e2145488), "ObjectId", 29808, "ObjectType", "RT::Ticket", "TimeTaken", 0, "Type", "Create", ...) called at /data/rt/admin/sbin/../lib/RT/Record.pm line 1694
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f94dcc8ab00), "Type", "Create", "TimeTaken", 0, "MIMEObj", MIME::Entity=HASH(0x7f94dcc84ef0), "CommitScrips", 1, ...) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 536
RT::Ticket::Create(RT::Ticket=HASH(0x7f94dcc8ab00), "Queue", 3, "Subject", "admin-new test 4", "Requestor", ARRAY(0x7f94de697990), "Cc", ARRAY(0x7f94de697960), ...) called at /data/rt/admin/sbin/../lib/RT/Interface/Email.pm line 1437
RT::Interface::Email::Gateway(HASH(0x7f94e142e7d0)) called at /data/rt/admin/share/html/REST/1.0/NoAuth/mail-gateway line 61
HTML::Mason::Commands::__ANON__("action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f94dcc84500), "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"..., ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f94e1512348), HASH(0x7f94e1424fc8), HASH(0x7f94e0ee3730)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f94dcc7e650)) called at /data/rt/admin/sbin/../lib/RT/Interface/Web/Handler.pm line 310
RT::Interface::Web::Handler::__ANON__(CODE(0x7f94dcc7e650)) called at /usr/local/share/perl5/Plack/Util.pm line 301
Plack::Util::__ANON__(CODE(0x7f94dcc7c010)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app("Plack::Handler::Apache2", Apache2::RequestRec=SCALAR(0x7f94dcc71a98), CODE(0x7f94dcc6e408)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f94dcc71a98)) called at -e line 0
eval {...} called at -e line 0 (/usr/share/perl5/Carp.pm:169)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: RT::Handle=HASH(0x7f94dcc7c1d8) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ObjectScrips ObjectScrips_1 ON ( ObjectScrips_1.Scrip = main.id ) JOIN ScripConditions ScripConditions_2 ON ( ScripConditions_2.id = main.ScripCondition ) WHERE (ObjectScrips_1.ObjectId = '3' OR ObjectScrips_1.ObjectId = '0') AND (ObjectScrips_1.Stage = 'TransactionCreate') AND (ScripConditions_2.ApplicableTransTypes LIKE '%Create%' OR ScripConditions_2.ApplicableTransTypes LIKE '%Any%') AND (main.Disabled = '0') ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f94dcc7c1d8), "SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ObjectSc"...) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 295
DBIx::SearchBuilder::_DoCount(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/SearchBuilder.pm line 996
RT::SearchBuilder::_DoCount(RT::Scrips=HASH(0x7f94e2196b18)) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
DBIx::SearchBuilder::Count(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 495
RT::Scrips::_FindScrips(RT::Scrips=HASH(0x7f94e2196b18), "Stage", "TransactionCreate", "Type", "Create") called at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 343
RT::Scrips::Prepare(RT::Scrips=HASH(0x7f94e2196b18), "Stage", "TransactionCreate", "Type", "Create", "Ticket", 29808, "Transaction", 461650, ...) called at /data/rt/admin/sbin/../lib/RT/Transaction.pm line 189
RT::Transaction::Create(RT::Transaction=HASH(0x7f94e2145488), "ObjectId", 29808, "ObjectType", "RT::Ticket", "TimeTaken", 0, "Type", "Create", ...) called at /data/rt/admin/sbin/../lib/RT/Record.pm line 1694
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f94dcc8ab00), "Type", "Create", "TimeTaken", 0, "MIMEObj", MIME::Entity=HASH(0x7f94dcc84ef0), "CommitScrips", 1, ...) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 536
RT::Ticket::Create(RT::Ticket=HASH(0x7f94dcc8ab00), "Queue", 3, "Subject", "admin-new test 4", "Requestor", ARRAY(0x7f94de697990), "Cc", ARRAY(0x7f94de697960), ...) called at /data/rt/admin/sbin/../lib/RT/Interface/Email.pm line 1437
RT::Interface::Email::Gateway(HASH(0x7f94e142e7d0)) called at /data/rt/admin/share/html/REST/1.0/NoAuth/mail-gateway line 61
HTML::Mason::Commands::__ANON__("action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f94dcc84500), "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"..., ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f94e1512348), HASH(0x7f94e1424fc8), HASH(0x7f94e0ee3730)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f94dcc7e650)) called at /data/rt/admin/sbin/../lib/RT/Interface/Web/Handler.pm line 310
RT::Interface::Web::Handler::__ANON__(CODE(0x7f94dcc7e650)) called at /usr/local/share/perl5/Plack/Util.pm line 301
Plack::Util::__ANON__(CODE(0x7f94dcc7c010)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app("Plack::Handler::Apache2", Apache2::RequestRec=SCALAR(0x7f94dcc71a98), CODE(0x7f94dcc6e408)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f94dcc71a98)) called at -e line 0
eval {...} called at -e line 0 (/usr/share/perl5/Carp.pm:169)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: Use of uninitialized value in concatenation (.) or string at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 495. (/data/rt/admin/sbin/../lib/RT/Scrips.pm:495)
[30933] [Wed Sep 24 23:24:01 2014] [debug]: Found scrips for TransactionCreate stage with applicable type(s) Create for txn #461650 on ticket #29808 (/data/rt/admin/sbin/../lib/RT/Scrips.pm:495)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: RT::Handle=HASH(0x7f94dcc7c1d8) couldn't execute the query 'SELECT main.* FROM Scrips main JOIN ObjectScrips ObjectScrips_1 ON ( ObjectScrips_1.Scrip = main.id ) JOIN ScripConditions ScripConditions_2 ON ( ScripConditions_2.id = main.ScripCondition ) WHERE (ObjectScrips_1.ObjectId = '3' OR ObjectScrips_1.ObjectId = '0') AND (ObjectScrips_1.Stage = 'TransactionCreate') AND (ScripConditions_2.ApplicableTransTypes LIKE '%Create%' OR ScripConditions_2.ApplicableTransTypes LIKE '%Any%') AND (main.Disabled = '0') GROUP BY main.id ORDER BY MIN(ObjectScrips_1.SortOrder) ASC ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f94dcc7c1d8), "SELECT main.* FROM Scrips main JOIN ObjectScrips ObjectScrips"...) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/SearchBuilder.pm line 985
RT::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x7f94e2196b18)) called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 507
DBIx::SearchBuilder::Next(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 253
RT::Scrips::Next(RT::Scrips=HASH(0x7f94e2196b18)) called at /data/rt/admin/sbin/../lib/RT/Scrips.pm line 347
RT::Scrips::Prepare(RT::Scrips=HASH(0x7f94e2196b18), "Stage", "TransactionCreate", "Type", "Create", "Ticket", 29808, "Transaction", 461650, ...) called at /data/rt/admin/sbin/../lib/RT/Transaction.pm line 189
RT::Transaction::Create(RT::Transaction=HASH(0x7f94e2145488), "ObjectId", 29808, "ObjectType", "RT::Ticket", "TimeTaken", 0, "Type", "Create", ...) called at /data/rt/admin/sbin/../lib/RT/Record.pm line 1694
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f94dcc8ab00), "Type", "Create", "TimeTaken", 0, "MIMEObj", MIME::Entity=HASH(0x7f94dcc84ef0), "CommitScrips", 1, ...) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 536
RT::Ticket::Create(RT::Ticket=HASH(0x7f94dcc8ab00), "Queue", 3, "Subject", "admin-new test 4", "Requestor", ARRAY(0x7f94de697990), "Cc", ARRAY(0x7f94de697960), ...) called at /data/rt/admin/sbin/../lib/RT/Interface/Email.pm line 1437
RT::Interface::Email::Gateway(HASH(0x7f94e142e7d0)) called at /data/rt/admin/share/html/REST/1.0/NoAuth/mail-gateway line 61
HTML::Mason::Commands::__ANON__("action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f94dcc84500), "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"..., ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f94e1512348), HASH(0x7f94e1424fc8), HASH(0x7f94e0ee3730)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f94dcc7e650)) called at /data/rt/admin/sbin/../lib/RT/Interface/Web/Handler.pm line 310
RT::Interface::Web::Handler::__ANON__(CODE(0x7f94dcc7e650)) called at /usr/local/share/perl5/Plack/Util.pm line 301
Plack::Util::__ANON__(CODE(0x7f94dcc7c010)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app("Plack::Handler::Apache2", Apache2::RequestRec=SCALAR(0x7f94dcc71a98), CODE(0x7f94dcc6e408)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f94dcc71a98)) called at -e line 0
eval {...} called at -e line 0 (/usr/share/perl5/Carp.pm:169)
[30933] [Wed Sep 24 23:24:01 2014] [debug]: About to commit scrips for transaction #461650 (/data/rt/admin/sbin/../lib/RT/Transaction.pm:210)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: RT::Handle=HASH(0x7f94dcc7c1d8) couldn't execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f94dcc7c1d8), "UPDATE Tickets SET LastUpdated=? WHERE id=? ", "2014-09-24 23:24:01", 29808) called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 453
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x7f94dcc7c1d8), "Table", "Tickets", "IsSQLFunction", undef, "Column", "LastUpdated", "PrimaryKeys", HASH(0x7f94e219eab0), ...) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Ticket=HASH(0x7f94dcc8ab00), "Field", "LastUpdated", "Value", "2014-09-24 23:24:01") called at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Ticket=HASH(0x7f94dcc8ab00), "Field", "LastUpdated", "Value", "2014-09-24 23:24:01") called at /data/rt/admin/sbin/../lib/RT/Record.pm line 548
RT::Record::_SetLastUpdated(RT::Ticket=HASH(0x7f94dcc8ab00)) called at /data/rt/admin/sbin/../lib/RT/Record.pm line 1717
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f94dcc8ab00), "Type", "Create", "TimeTaken", 0, "MIMEObj", MIME::Entity=HASH(0x7f94dcc84ef0), "CommitScrips", 1, ...) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 536
RT::Ticket::Create(RT::Ticket=HASH(0x7f94dcc8ab00), "Queue", 3, "Subject", "admin-new test 4", "Requestor", ARRAY(0x7f94de697990), "Cc", ARRAY(0x7f94de697960), ...) called at /data/rt/admin/sbin/../lib/RT/Interface/Email.pm line 1437
RT::Interface::Email::Gateway(HASH(0x7f94e142e7d0)) called at /data/rt/admin/share/html/REST/1.0/NoAuth/mail-gateway line 61
HTML::Mason::Commands::__ANON__("action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f94dcc84500), "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"..., ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f94e1512348), HASH(0x7f94e1424fc8), HASH(0x7f94e0ee3730)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f94dcc7e650)) called at /data/rt/admin/sbin/../lib/RT/Interface/Web/Handler.pm line 310
RT::Interface::Web::Handler::__ANON__(CODE(0x7f94dcc7e650)) called at /usr/local/share/perl5/Plack/Util.pm line 301
Plack::Util::__ANON__(CODE(0x7f94dcc7c010)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app("Plack::Handler::Apache2", Apache2::RequestRec=SCALAR(0x7f94dcc71a98), CODE(0x7f94dcc6e408)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f94dcc71a98)) called at -e line 0
eval {...} called at -e line 0 (/usr/share/perl5/Carp.pm:169)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: RT::Handle=HASH(0x7f94dcc7c1d8) couldn't execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f94dcc7c1d8), "UPDATE Tickets SET LastUpdated=? WHERE id=? ", "2014-09-24 23:24:01", 29808) called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 453
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x7f94dcc7c1d8), "Table", "Tickets", "IsSQLFunction", undef, "Column", "LastUpdated", "PrimaryKeys", HASH(0x7f94e21964d0), ...) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 871
DBIx::SearchBuilder::Record::__Set(RT::Ticket=HASH(0x7f94dcc8ab00), "Field", "LastUpdated", "Value", "2014-09-24 23:24:01") called at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 140
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Ticket=HASH(0x7f94dcc8ab00), "Field", "LastUpdated", "Value", "2014-09-24 23:24:01") called at /data/rt/admin/sbin/../lib/RT/Record.pm line 548
RT::Record::_SetLastUpdated(RT::Ticket=HASH(0x7f94dcc8ab00)) called at /data/rt/admin/sbin/../lib/RT/Record.pm line 501
RT::Record::_Set(RT::Ticket=HASH(0x7f94dcc8ab00), "Field", "TimeWorked", "Value", 0) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 2696
RT::Ticket::_Set(RT::Ticket=HASH(0x7f94dcc8ab00), "Field", "TimeWorked", "Value", 0, "RecordTransaction", 0, "CheckACL", 0, ...) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 2845
RT::Ticket::_UpdateTimeTaken(RT::Ticket=HASH(0x7f94dcc8ab00), 0, "Transaction", RT::Transaction=HASH(0x7f94e2145488)) called at /data/rt/admin/sbin/../lib/RT/Record.pm line 1719
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f94dcc8ab00), "Type", "Create", "TimeTaken", 0, "MIMEObj", MIME::Entity=HASH(0x7f94dcc84ef0), "CommitScrips", 1, ...) called at /data/rt/admin/sbin/../lib/RT/Ticket.pm line 536
RT::Ticket::Create(RT::Ticket=HASH(0x7f94dcc8ab00), "Queue", 3, "Subject", "admin-new test 4", "Requestor", ARRAY(0x7f94de697990), "Cc", ARRAY(0x7f94de697960), ...) called at /data/rt/admin/sbin/../lib/RT/Interface/Email.pm line 1437
RT::Interface::Email::Gateway(HASH(0x7f94e142e7d0)) called at /data/rt/admin/share/html/REST/1.0/NoAuth/mail-gateway line 61
HTML::Mason::Commands::__ANON__("action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f94dcc84500), "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1300
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"..., ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484
eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f94e1512c30)) called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef, "action", "correspond", "queue", "GS Admin", "message", "From bmcnally\@uw.edu Wed Sep 24 16:24:00 2014\x{a}Return-Path: <"...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x7f94e1512348), HASH(0x7f94e1424fc8), HASH(0x7f94e0ee3730)) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f94dcc7e650)) called at /data/rt/admin/sbin/../lib/RT/Interface/Web/Handler.pm line 310
RT::Interface::Web::Handler::__ANON__(CODE(0x7f94dcc7e650)) called at /usr/local/share/perl5/Plack/Util.pm line 301
Plack::Util::__ANON__(CODE(0x7f94dcc7c010)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app("Plack::Handler::Apache2", Apache2::RequestRec=SCALAR(0x7f94dcc71a98), CODE(0x7f94dcc6e408)) called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f94dcc71a98)) called at -e line 0
eval {...} called at -e line 0 (/usr/share/perl5/Carp.pm:169)
[30933] [Wed Sep 24 23:24:01 2014] [info]: Ticket 29808 created in queue 'GS Admin' by bmcnally (/data/rt/admin/sbin/../lib/RT/Ticket.pm:548)
[30933] [Wed Sep 24 23:24:01 2014] [debug]: RT::Ticket=HASH(0x7f94e21b6b10) tried to load a bogus ticket: 29808 (/data/rt/admin/sbin/../lib/RT/Ticket.pm:148)
[30933] [Wed Sep 24 23:24:01 2014] [warning]: TransactionBatch was fired on a ticket that no longer exists; unable to run scrips! Call ->ApplyTransactionBatch before shredding the ticket, for consistent results. (/data/rt/admin/sbin/../lib/RT/Ticket.pm:2588)
More information about the rt-devel
mailing list