RT 4.2.7: SQL error on ticket traffic

Brian McNally <[email protected]>
Newsgroups gmane.comp.bug-tracking.request-tracker.devel
Message-ID <[email protected]> 
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

-- 
RT Training - November 4-5 Los Angeles
http://bestpractical.com/training
rt-admin.txt (text/plain, 26.7 KB) 
[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 ([email protected]) (/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)
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.