Sometimes when users send a email they get “message could not be recorded” and no email is sent. We can’t find a log of the email in the DB or email gateway. The rt log shows “couldn’t execute the query 'INERT INTO Transactions”. I can’t seem to find a why.
RT 4.4.3-2 is our verison.
The RT log is for the last event.
[14567] [Thu Dec 10 17:26:07 2020] [warning]: RT::Handle=HASH(0x7f0bc4029e98) couldn’t execute the query ‘INSERT INTO Transactions (ReferenceType, NewValue, Data, Objec
tId, Creator, Type, OldReference, ObjectType, Created, NewReference, Field, OldValue) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/share/perl5/DBIx/SearchBuilde
r/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f0bc4029e98), “INSERT INTO Transactions (ReferenceType, NewValue, Data, Obje”…, undef, undef, “We Hope You\x{2019}re Enjoying Your New Free Geek Device\x{a}”, 85480, 330123, “Correspond”, …) called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x7f0bc4029e98), “Transactions”, “ReferenceType”, undef, “NewValue”, undef, “Data”, “We Hope You\x{2019}re Enjoying Your New Free Geek Device\x{a}”, …) called at /usr/share/perl5/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert(RT::Handle=HASH(0x7f0bc4029e98), “Transactions”, “ReferenceType”, undef, “NewValue”, undef, “ObjectId”, 85480, …) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RT::Transaction=HASH(0x561ab65393f8), “ReferenceType”, undef, “NewValue”, undef, “Data”, “We Hope You\x{2019}re Enjoying Your New Free Geek Device\x{a}”, “ObjectId”, …) called at /usr/share/request-tracker4/lib/RT/Record.pm line 316
RT::Record::Create(RT::Transaction=HASH(0x561ab65393f8), “ReferenceType”, undef, “ObjectType”, “RT::Ticket”, “NewValue”, undef, “Created”, …) called at /usr/share/request-tracker4/lib/RT/Transaction.pm line 160
RT::Transaction::Create(RT::Transaction=HASH(0x561ab65393f8), “ObjectId”, 85480, “ObjectType”, “RT::Ticket”, “TimeTaken”, “”, “Type”, …) called at /usr/share/request-tracker4/lib/RT/Record.pm line 1682
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f0bac0aa6c8), “Type”, “Correspond”, “Data”, “We Hope You\x{2019}re Enjoying Your New Free Geek Device\x{a}”, “TimeTaken”, “”, “MIMEObj”, …) called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1722
RT:
:_RecordNote(RT::Ticket=HASH(0x7f0bac0aa6c8), “Encrypt”, undef, “Content”, undef, “Sign”, undef, “AttachExisting”, …) called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1603
RT::Correspond(RT::Ticket=HASH(0x7f0bac0aa6c8), “Encrypt”, undef, “AttachExisting”, undef, “Sign”, undef, “CcMessageTo”, …) called at /usr/share/request-tracker4/lib/RT/Interface/Web.pm line 2423
HTML::Mason::Commands::ProcessUpdateMessage(“ARGSRef”, HASH(0x561ab9fe0900), “Actions”, ARRAY(0x561ac1cb4480), “TicketObj”, RT::Ticket=HASH(0x7f0bac0aa6c8)) called at /usr/share/request-tracker4/html/Ticket/Display.html line 183
HTML::Mason::Commands::ANON() called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1777
eval {…} called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1771
RT::Atomic(RT::Ticket=HASH(0x7f0bac0aa6c8), CODE(0x561abe80f0e0)) called at /usr/share/request-tracker4/html/Ticket/Display.html line 196
HTML::Mason::Commands::ANON(“TicketObj”, RT::Ticket=HASH(0x7f0bac0aa6c8), “UpdateIgnoreAddressCheckboxes”, 0, “Status”, “resolved”, “UpdateTimeWorked-TimeUnits”, “minutes”, …) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f0bbc02d2a8), “TicketObj”, RT::Ticket=HASH(0x7f0bac0aa6c8), “UpdateIgnoreAddressCheckboxes”, 0, “Status”, “resolved”, “UpdateTimeWorked-TimeUnits”, …) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, “TicketObj”, RT::Ticket=HASH(0x7f0bac0aa6c8), “UpdateIgnoreAddressCheckboxes”, 0, “Status”, “resolved”, …) called at /usr/share/request-tracker4/html/Ticket/Update.html line 360
HTML::Mason::Commands::ANON(“Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, “Articles_Content”, “”, …) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f0bac0432a0), “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, “Articles_Content”, …) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, …) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next(RT::Interface::Web::Request=HASH(0x7f0b541f0508)) called at /usr/share/request-tracker4/html/Ticket/autohandler line 66
HTML::Mason::Commands::ANON(“Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, “Articles_Content”, “”, …) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f0bc43f3c28), “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, “Articles_Content”, …) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, …) called at /usr/share/request-tracker4/lib/RT/Interface/Web.pm line 701
RT::Interface::Web::ShowRequestedPage(HASH(0x561ab21e7df0)) called at /usr/share/request-tracker4/lib/RT/Interface/Web.pm line 380
RT::Interface::Web::HandleRequest(HASH(0x561ab21e7df0)) called at /usr/share/request-tracker4/html/autohandler line 53
HTML::Mason::Commands::ANON(“Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, “Articles_Content”, “”, …) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f0bc405c358), “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, “Articles_Content”, …) called at /usr/share/perl5/HTML/Mason/Request.pm line 1300
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, …) called at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x7f0b541f0508)) called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 96
eval {…} called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x7f0b541f0508)) called at /usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, “Status”, “resolved”, “UpdateIgnoreAddressCheckboxes”, 0, “UpdateTimeWorked-TimeUnits”, “minutes”, …) called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 59
eval {…} called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x561abb1b28a8), HASH(0x7f0bac9d5960), HASH(0x7f0b88210340)) called at /usr/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::ANON(CODE(0x561ac04fcf48)) called at /usr/share/perl5/Plack/Util.pm line 339
Plack::Util::ANON(CODE(0x7f0bac2391f0)) called at /usr/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app(“Plack::Handler::Apache2”, Apache2::RequestRec=SCALAR(0x7f0b881d0218), CODE(0x561abbfef7c8)) called at /usr/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f0b881d0218)) called at -e line 0
eval {…} called at -e line 0 (/usr/share/perl/5.28/Carp.pm:292)