Error on Mark all messages as seen in ticket

Hi,
I am getting an error when trying to click on the link in a ticket to
“jump to the first unread message and mark all messages as seen”

This is testing on a newly upgraded system:

  • rt 3.8.13, w/ RT-FM, RT-IR, RT::Authn::ExternalAuth and others.
  • on rhel 6
  • Using postgresql 9.2.2, nginx, and spawn-fcgi
  • We are also using the colorize status code feature as in
    ShowStatusInColor - Request Tracker Wiki

When I click on the link in a ticket (ticket # 391377) The browser
displays:
“An internal RT error has occurred. Your administrator can find more
details in RT’s log files”

I see in the nginx error.log:

2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
“Must specify ‘Name’ attribute”
LINE 1: SELECT * FROM Principals WHERE id = 'Must specify ‘‘Name’’ …
^ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 590.
RT::Handle=HASH(0x69f1e60) couldn’t execute the query ‘SELECT * FROM
Principals WHERE id = ?’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 603
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(” while
reading response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"0x69f1e60)', ‘SELECT * FROM Principals WHERE id = ?’, ‘Must specify
'Name' attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x7092440)’,
‘SELECT * FROM Principals WHERE id = ?’, ‘Must specify 'Name'
attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x7092440)’,
‘id’, ‘Must specify 'Name' attribute’) ca" while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "lled
at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x7092440)’,
‘id’, ‘Must specify 'Name' attribute’) called at
/opt/rt3/lib/RT/Record.pm line 368
RT::Record::LoadByCols(‘RT::Principal=HASH(0x7092440)’, ‘id’,
‘Must specify 'Name' attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1140

DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x7092440)’, ‘Must
specify" while reading response header from upstream, client:
10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"'Name' attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x7092440)’,
‘Must specify 'Name' attribute’) called at /opt/rt3/lib/RT/Record.pm
line 320
RT::Record::Create(‘RT::Principal=HASH(0x7092440)’,
‘PrincipalType’, ‘User’, ‘ObjectId’, 0, ‘Disabled’, 0) called at
/opt/rt3/lib/RT/Principal.pm line 110
RT::Principal::Create(‘RT::Principal=HASH(0x7092440)’,
‘PrincipalType’, ‘User’, ‘Disabled’, 0, ‘ObjectId’," while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: " 0)
called at /opt/rt3/local/lib/RT/User_Local.pm line 86
RT::Base::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘ContentType’,
‘’, ‘Creator’, 402, ‘ObjectId’, 391377, ‘LastUpdatedBy’, 402, …)
called at /opt/rt3/lib/RT/Record.pm line 289
RT::Record::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Content’, ‘2012-12-04 15:08:27’, ‘ContentType’,
‘’, ‘Description’, undef, …) called at
/opt/rt3/lib/RT/Attribute_Overlay.pm line 181
RT::Attribute::Create(‘RT::Attribute=HASH(0x72010" while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"b0)’, ‘Object’, ‘RT::Ticket=HASH(0x71cd860)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Description’, undef, ‘Content’, ‘2012-12-04
15:08:27’, …) called at /opt/rt3/lib/RT/Record.pm line 173
RT::Record::AddAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Content’,
‘2012-12-04 15:08:27’, ‘Description’, undef, ‘Name’,
‘User-402-SeenUpTo’) called at /opt/rt3/lib/RT/Record.pm line 200
RT::Record::SetAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Content’, ‘2012-12-04 15:08:27’) called at
/opt/rt3" while reading response header from upstream, client:
10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"/share/html/Ticket/Display.html line 166
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x6a67370)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, un" while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: “def,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called
at /opt/rt3/lib/RT/Interface/Web.pm line 546
RT::Interface::Web::ShowRequestedPage(‘HASH(0x6a44940)’) called at
/opt/rt3/lib/RT/Interface/Web.pm line 266
RT::Interface::Web::HandleRequest(‘HASH(0x6a44940)’) called at
/opt/rt3/share/html/autohandler line 53
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Compone” while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“nt::run(‘HTML::Mason::Component::FileBased=HASH(0x6a72048)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1279
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘MarkAsSeen’, 1,
‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called at
/usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} calle” while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "d at
/usr/share/perl5/HTML/Mason/Request.pm line 425

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x71ab468)’)
called at /usr/share/perl5/HTML/Mason/CGIHandler.pm line 190
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 190

HTML::Mason::Request::CGI::exec(‘RT::Interface::Web::Request=HASH(0x71ab468)’)
called at /usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, ‘MarkAsSeen’, 1, ‘id’,
391377, ‘Anchor’, ‘txn-10489494’) called" while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "at
/usr/share/perl5/HTML/Mason/CGIHandler.pm line 121
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 121

HTML::Mason::CGIHandler::_handler(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘HASH(0x68cc398)’) called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 73

HTML::Mason::CGIHandler::handle_cgi_object(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘CGI::Fast=HASH(0x69f5058)’) called at /opt/rt3/bin/mason_handler.fcgi
line 91
eval {…} called at /opt/rt3/bin/mason_handler.fcgi" while
reading response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "line 91
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 590.
RT::Handle=HASH(0x69f1e60) couldn’t execute the query 'UPDATE
Principals SET ObjectId=? WHERE id=? ’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 603

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x69f1e60)’, 'UPDATE
Principals SET ObjectId=? WHERE id=? ', ‘Must specify 'Name'
attribu" while reading response header from upstream, client:
10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "te’,
undef) called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm
line 454

DBIx::SearchBuilder::Handle::UpdateRecordValue(‘RT::Handle=HASH(0x69f1e60)’,
‘Table’, ‘Principals’, ‘IsSQLFunction’, undef, ‘Column’, ‘ObjectId’,
‘PrimaryKeys’, ‘HASH(0x707a5f8)’, …) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 845

DBIx::SearchBuilder::Record::__Set(‘RT::Principal=HASH(0x7092440)’,
‘Field’, ‘ObjectId’, ‘Value’, ‘Must specify 'Name' attribute’)
called at /usr/local/share/per" while reading response header from
upstream, client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"l5/DBIx/SearchBuilder/Record/Cachable.pm line 140

DBIx::SearchBuilder::Record::Cachable::__Set(‘RT::Principal=HASH(0x7092440)’,
‘Field’, ‘ObjectId’, ‘Value’, ‘Must specify 'Name' attribute’)
called at /opt/rt3/local/lib/RT/User_Local.pm line 97
RT::Base::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘ContentType’,
‘’, ‘Creator’, 402, ‘ObjectId’, 391377, ‘LastUpdatedBy’, 402, …)
called at /opt/rt3/lib/RT/Record.pm line 289
RT::Record::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘Name’,
‘User-402-SeenUpT" while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "o’,
‘Content’, ‘2012-12-04 15:08:27’, ‘ContentType’, ‘’, ‘Description’,
undef, …) called at /opt/rt3/lib/RT/Attribute_Overlay.pm line 181
RT::Attribute::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘Object’,
‘RT::Ticket=HASH(0x71cd860)’, ‘Name’, ‘User-402-SeenUpTo’,
‘Description’, undef, ‘Content’, ‘2012-12-04 15:08:27’, …) called at
/opt/rt3/lib/RT/Record.pm line 173
RT::Record::AddAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Content’,
‘2012-12-04 15:08:27’, ‘Description’, undef, ‘Name’, ‘User-402-See"
while reading response header from upstream, client: 10.67.48.228,
server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"nUpTo’) called at /opt/rt3/lib/RT/Record.pm line 200
RT::Record::SetAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Content’, ‘2012-12-04 15:08:27’) called at
/opt/rt3/share/html/Ticket/Display.html line 166
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x6a67370)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’," while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“‘txn-10489494’) called at /usr/share/perl5/HTML/Mason/Request.pm line
1284
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘MarkAsSeen’, 1,
‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called at
/opt/rt3/lib/RT/Interface/Web.pm line 546
RT::Interface::Web::ShowRequestedPage(‘HASH(0x6a44940)’) called at
/opt/rt3/lib/RT/Interface/Web.pm line 266
RT::Interface::Web::HandleRequest(‘HASH(0x6a44940)’) called at
/opt/rt3/share/html/a” while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"utohandler line 53
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x6a72048)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1279
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘MarkAsSeen’, 1,"
while reading response header from upstream, client: 10.67.48.228,
server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called at
/usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 425

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x71ab468)’)
called at /usr/share/perl5/HTML/Mason/CGIHandler.pm line 190
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 190
HTML::Mason::Request::CGI::exec(‘RT::Interface::Web" while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"::Request=HASH(0x71ab468)’) called at
/usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, ‘MarkAsSeen’, 1, ‘id’,
391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/CGIHandler.pm line 121
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 121

HTML::Mason::CGIHandler::_handler(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘HASH(0x68cc398)’) called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 73
HTML::Mason::CGIHandler::hand" while reading response header from
upstream, client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“le_cgi_object(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘CGI::Fast=HASH(0x69f5058)’) called at /opt/rt3/bin/mason_handler.fcgi
line 91
eval {…} called at /opt/rt3/bin/mason_handler.fcgi line 91
DBD::Pg::st execute failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block at
/usr/share/perl5/Apache/Session/Store/DBI.pm line 67.
[Wed Dec 12 23:35:36 2012] [error]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of”
while reading response header from upstream, client: 10.67.48.228,
server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "
transaction block at /usr/share/perl5/Apache/Session/Store/DBI.pm line
67. (/opt/rt3/lib/RT/Interface/Web/Handler.pm:277)
[Wed Dec 12 23:35:36 2012] [crit]: Transaction not committed. Usually
indicates a software fault.Data loss may have occurred
(/opt/rt3/lib/RT/Interface/Web/Handler.pm:239)" while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377

Can anyone give me some ideas as to the problem please ?

Thanks.

Susan K. McClure
Rice University
smcclure@rice.edu

Hi RT community,

We figured out the problem – a bad case of local modifications.
Sorry for the interruption.

Regards,
KenOn Wed, Dec 12, 2012 at 05:41:56PM -0600, Susan K. McClure wrote:

Hi,
I am getting an error when trying to click on the link in a ticket to
“jump to the first unread message and mark all messages as seen”

This is testing on a newly upgraded system:

  • rt 3.8.13, w/ RT-FM, RT-IR, RT::Authn::ExternalAuth and others.
  • on rhel 6
  • Using postgresql 9.2.2, nginx, and spawn-fcgi
  • We are also using the colorize status code feature as in
    ShowStatusInColor - Request Tracker Wiki

When I click on the link in a ticket (ticket # 391377) The browser
displays:
“An internal RT error has occurred. Your administrator can find more
details in RT’s log files”

I see in the nginx error.log:

2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
“Must specify ‘Name’ attribute”
LINE 1: SELECT * FROM Principals WHERE id = 'Must specify ‘‘Name’’ …
^ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 590.
RT::Handle=HASH(0x69f1e60) couldn’t execute the query ‘SELECT * FROM
Principals WHERE id = ?’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 603
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(” while
reading response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"0x69f1e60)', ‘SELECT * FROM Principals WHERE id = ?’, ‘Must specify
'Name' attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x7092440)’,
‘SELECT * FROM Principals WHERE id = ?’, ‘Must specify 'Name'
attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x7092440)’,
‘id’, ‘Must specify 'Name' attribute’) ca" while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "lled
at /usr/local/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x7092440)’,
‘id’, ‘Must specify 'Name' attribute’) called at
/opt/rt3/lib/RT/Record.pm line 368
RT::Record::LoadByCols(‘RT::Principal=HASH(0x7092440)’, ‘id’,
‘Must specify 'Name' attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1140

DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x7092440)’, ‘Must
specify" while reading response header from upstream, client:
10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"'Name' attribute’) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x7092440)’,
‘Must specify 'Name' attribute’) called at /opt/rt3/lib/RT/Record.pm
line 320
RT::Record::Create(‘RT::Principal=HASH(0x7092440)’,
‘PrincipalType’, ‘User’, ‘ObjectId’, 0, ‘Disabled’, 0) called at
/opt/rt3/lib/RT/Principal.pm line 110
RT::Principal::Create(‘RT::Principal=HASH(0x7092440)’,
‘PrincipalType’, ‘User’, ‘Disabled’, 0, ‘ObjectId’," while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: " 0)
called at /opt/rt3/local/lib/RT/User_Local.pm line 86
RT::Base::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘ContentType’,
‘’, ‘Creator’, 402, ‘ObjectId’, 391377, ‘LastUpdatedBy’, 402, …)
called at /opt/rt3/lib/RT/Record.pm line 289
RT::Record::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Content’, ‘2012-12-04 15:08:27’, ‘ContentType’,
‘’, ‘Description’, undef, …) called at
/opt/rt3/lib/RT/Attribute_Overlay.pm line 181
RT::Attribute::Create(‘RT::Attribute=HASH(0x72010" while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"b0)’, ‘Object’, ‘RT::Ticket=HASH(0x71cd860)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Description’, undef, ‘Content’, ‘2012-12-04
15:08:27’, …) called at /opt/rt3/lib/RT/Record.pm line 173
RT::Record::AddAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Content’,
‘2012-12-04 15:08:27’, ‘Description’, undef, ‘Name’,
‘User-402-SeenUpTo’) called at /opt/rt3/lib/RT/Record.pm line 200
RT::Record::SetAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Content’, ‘2012-12-04 15:08:27’) called at
/opt/rt3" while reading response header from upstream, client:
10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"/share/html/Ticket/Display.html line 166
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x6a67370)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, un" while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: “def,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called
at /opt/rt3/lib/RT/Interface/Web.pm line 546
RT::Interface::Web::ShowRequestedPage(‘HASH(0x6a44940)’) called at
/opt/rt3/lib/RT/Interface/Web.pm line 266
RT::Interface::Web::HandleRequest(‘HASH(0x6a44940)’) called at
/opt/rt3/share/html/autohandler line 53
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Compone” while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“nt::run(‘HTML::Mason::Component::FileBased=HASH(0x6a72048)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1279
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘MarkAsSeen’, 1,
‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called at
/usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} calle” while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "d at
/usr/share/perl5/HTML/Mason/Request.pm line 425

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x71ab468)’)
called at /usr/share/perl5/HTML/Mason/CGIHandler.pm line 190
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 190

HTML::Mason::Request::CGI::exec(‘RT::Interface::Web::Request=HASH(0x71ab468)’)
called at /usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, ‘MarkAsSeen’, 1, ‘id’,
391377, ‘Anchor’, ‘txn-10489494’) called" while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "at
/usr/share/perl5/HTML/Mason/CGIHandler.pm line 121
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 121

HTML::Mason::CGIHandler::_handler(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘HASH(0x68cc398)’) called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 73

HTML::Mason::CGIHandler::handle_cgi_object(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘CGI::Fast=HASH(0x69f5058)’) called at /opt/rt3/bin/mason_handler.fcgi
line 91
eval {…} called at /opt/rt3/bin/mason_handler.fcgi" while
reading response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "line 91
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 590.
RT::Handle=HASH(0x69f1e60) couldn’t execute the query 'UPDATE
Principals SET ObjectId=? WHERE id=? ’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 603

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x69f1e60)’, 'UPDATE
Principals SET ObjectId=? WHERE id=? ', ‘Must specify 'Name'
attribu" while reading response header from upstream, client:
10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "te’,
undef) called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm
line 454

DBIx::SearchBuilder::Handle::UpdateRecordValue(‘RT::Handle=HASH(0x69f1e60)’,
‘Table’, ‘Principals’, ‘IsSQLFunction’, undef, ‘Column’, ‘ObjectId’,
‘PrimaryKeys’, ‘HASH(0x707a5f8)’, …) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 845

DBIx::SearchBuilder::Record::__Set(‘RT::Principal=HASH(0x7092440)’,
‘Field’, ‘ObjectId’, ‘Value’, ‘Must specify 'Name' attribute’)
called at /usr/local/share/per" while reading response header from
upstream, client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"l5/DBIx/SearchBuilder/Record/Cachable.pm line 140

DBIx::SearchBuilder::Record::Cachable::__Set(‘RT::Principal=HASH(0x7092440)’,
‘Field’, ‘ObjectId’, ‘Value’, ‘Must specify 'Name' attribute’)
called at /opt/rt3/local/lib/RT/User_Local.pm line 97
RT::Base::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘ContentType’,
‘’, ‘Creator’, 402, ‘ObjectId’, 391377, ‘LastUpdatedBy’, 402, …)
called at /opt/rt3/lib/RT/Record.pm line 289
RT::Record::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘Name’,
‘User-402-SeenUpT" while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "o’,
‘Content’, ‘2012-12-04 15:08:27’, ‘ContentType’, ‘’, ‘Description’,
undef, …) called at /opt/rt3/lib/RT/Attribute_Overlay.pm line 181
RT::Attribute::Create(‘RT::Attribute=HASH(0x72010b0)’, ‘Object’,
‘RT::Ticket=HASH(0x71cd860)’, ‘Name’, ‘User-402-SeenUpTo’,
‘Description’, undef, ‘Content’, ‘2012-12-04 15:08:27’, …) called at
/opt/rt3/lib/RT/Record.pm line 173
RT::Record::AddAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Content’,
‘2012-12-04 15:08:27’, ‘Description’, undef, ‘Name’, ‘User-402-See"
while reading response header from upstream, client: 10.67.48.228,
server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"nUpTo’) called at /opt/rt3/lib/RT/Record.pm line 200
RT::Record::SetAttribute(‘RT::Ticket=HASH(0x71cd860)’, ‘Name’,
‘User-402-SeenUpTo’, ‘Content’, ‘2012-12-04 15:08:27’) called at
/opt/rt3/share/html/Ticket/Display.html line 166
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x6a67370)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’," while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“‘txn-10489494’) called at /usr/share/perl5/HTML/Mason/Request.pm line
1284
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘MarkAsSeen’, 1,
‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called at
/opt/rt3/lib/RT/Interface/Web.pm line 546
RT::Interface::Web::ShowRequestedPage(‘HASH(0x6a44940)’) called at
/opt/rt3/lib/RT/Interface/Web.pm line 266
RT::Interface::Web::HandleRequest(‘HASH(0x6a44940)’) called at
/opt/rt3/share/html/a” while reading response header from upstream,
client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"utohandler line 53
HTML::Mason::Commands::ANON(‘MarkAsSeen’, 1, ‘id’, 391377,
‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x6a72048)’,
‘MarkAsSeen’, 1, ‘id’, 391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1279
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘MarkAsSeen’, 1,"
while reading response header from upstream, client: 10.67.48.228,
server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"‘id’, 391377, ‘Anchor’, ‘txn-10489494’, …) called at
/usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 425

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x71ab468)’)
called at /usr/share/perl5/HTML/Mason/CGIHandler.pm line 190
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 190
HTML::Mason::Request::CGI::exec(‘RT::Interface::Web" while reading
response header from upstream, client: 10.67.48.228, server:
rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
"::Request=HASH(0x71ab468)’) called at
/usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, ‘MarkAsSeen’, 1, ‘id’,
391377, ‘Anchor’, ‘txn-10489494’) called at
/usr/share/perl5/HTML/Mason/CGIHandler.pm line 121
eval {…} called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 121

HTML::Mason::CGIHandler::_handler(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘HASH(0x68cc398)’) called at /usr/share/perl5/HTML/Mason/CGIHandler.pm
line 73
HTML::Mason::CGIHandler::hand" while reading response header from
upstream, client: 10.67.48.228, server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr:
“le_cgi_object(‘HTML::Mason::CGIHandler=HASH(0x69ef058)’,
‘CGI::Fast=HASH(0x69f5058)’) called at /opt/rt3/bin/mason_handler.fcgi
line 91
eval {…} called at /opt/rt3/bin/mason_handler.fcgi line 91
DBD::Pg::st execute failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block at
/usr/share/perl5/Apache/Session/Store/DBI.pm line 67.
[Wed Dec 12 23:35:36 2012] [error]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of”
while reading response header from upstream, client: 10.67.48.228,
server: rt3.rice.edu, request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377
2012/12/12 17:35:36 [error] 31935#0: *13 FastCGI sent in stderr: "
transaction block at /usr/share/perl5/Apache/Session/Store/DBI.pm line
67. (/opt/rt3/lib/RT/Interface/Web/Handler.pm:277)
[Wed Dec 12 23:35:36 2012] [crit]: Transaction not committed. Usually
indicates a software fault.Data loss may have occurred
(/opt/rt3/lib/RT/Interface/Web/Handler.pm:239)" while reading response
header from upstream, client: 10.67.48.228, server: rt3.rice.edu,
request: “GET
/Ticket/Display.html?id=391377&MarkAsSeen=1&Anchor=txn-10489494
HTTP/1.1”, upstream: “fastcgi://unix:/opt/rt3/var/fastcgi.sock:”,
host: “rt3.rice.edu”, referrer:
https://rt3.rice.edu/Ticket/Display.html?id=391377

Can anyone give me some ideas as to the problem please ?

Thanks.

Susan K. McClure
Rice University
smcclure@rice.edu


We’re hiring! Careers — Best Practical Solutions