Hello,
I am having a weird error only on some tickets and only sometimes when there is a “You’re” is used for reply to requestor. If “You are” is used it works.
I have created tickets and it works with “You’re” in the subject line. I am trying to zero in the exact cause.
Below is part of the “rt.log”. Note partial removal emails in log.
[28463] [Sat Feb 27 22:23:22 2021] [warning]: RT::Handle=HASH(0x7f4f2001ef10) couldn't execute the query 'INSERT INTO Transactions (Created, OldReference, Type, Data, NewReference, Creator, NewValue, OldValue, ObjectType, ObjectId, Field, ReferenceType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7f4f2001ef10), "INSERT INTO Transactions (Created, OldReference, Type, Data, "..., "2021-02-27 22:23:22", undef, "Correspond", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., undef, 383256, ...) called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x7f4f2001ef10), "Transactions", "Created", "2021-02-27 22:23:22", "OldReference", undef, "Type", "Correspond", ...) called at /usr/share/perl5/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert(RT::Handle=HASH(0x7f4f2001ef10), "Transactions", "Created", "2021-02-27 22:23:22", "OldReference", undef, "NewReference", undef, ...) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RT::Transaction=HASH(0x7f4f283845c0), "Created", "2021-02-27 22:23:22", "OldReference", undef, "Type", "Correspond", "Data", ...) called at /usr/share/request-tracker4/lib/RT/Record.pm line 316
RT::Record::Create(RT::Transaction=HASH(0x7f4f283845c0), "Created", undef, "OldReference", undef, "NewReference", undef, "Data", ...) called at /usr/share/request-tracker4/lib/RT/Transaction.pm line 160
RT::Transaction::Create(RT::Transaction=HASH(0x7f4f283845c0), "ObjectId", 85553, "ObjectType", "RT::Ticket", "TimeTaken", "", "Type", ...) called at /usr/share/request-tracker4/lib/RT/Record.pm line 1682
RT::Record::_NewTransaction(RT::Ticket=HASH(0x7f4f246626e0), "Type", "Correspond", "Data", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "TimeTaken", "", "MIMEObj", ...) called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1722
RT::Ticket::_RecordNote(RT::Ticket=HASH(0x7f4f246626e0), "Encrypt", undef, "BccMessageTo", "", "MIMEObj", MIME::Entity=HASH(0x7f4f281bd368), "CcMessageTo", ...) called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1603
RT::Ticket::Correspond(RT::Ticket=HASH(0x7f4f246626e0), "Encrypt", undef, "BccMessageTo", "", "AttachExisting", undef, "MIMEObj", ...) called at /usr/share/request-tracker4/lib/RT/Interface/Web.pm line 2423
HTML::Mason::Commands::ProcessUpdateMessage("ARGSRef", HASH(0x7f4f1c0a6678), "TicketObj", RT::Ticket=HASH(0x7f4f246626e0)) called at /usr/share/request-tracker4/html/Helpers/PreviewScrips line 66
HTML::Mason::Commands::__ANON__() called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1829
eval {...} called at /usr/share/request-tracker4/lib/RT/Ticket.pm line 1829
RT::Ticket::DryRun(RT::Ticket=HASH(0x7f4f246626e0), CODE(0x7f4f24083368)) called at /usr/share/request-tracker4/html/Helpers/PreviewScrips line 74
HTML::Mason::Commands::__ANON__("UpdateIgnoreAddressCheckboxes", 0, "UpdateSubject", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "UpdateBcc", "", "UpdateTimeWorked-TimeUnits", "minutes", ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f4f1c1bf140), "UpdateIgnoreAddressCheckboxes", 0, "UpdateSubject", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "UpdateBcc", "", "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, undef, "UpdateIgnoreAddressCheckboxes", 0, "UpdateSubject", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "UpdateBcc", ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next(RT::Interface::Web::Request=HASH(0x7f4f288305f8)) called at /usr/share/request-tracker4/html/Helpers/autohandler line 51
HTML::Mason::Commands::__ANON__("UpdateIgnoreAddressCheckboxes", 0, "UpdateSubject", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "UpdateBcc", "", "UpdateTimeWorked-TimeUnits", "minutes", ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f4f1c1bfab8), "UpdateIgnoreAddressCheckboxes", 0, "UpdateSubject", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "UpdateBcc", "", "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, undef, "UpdateIgnoreAddressCheckboxes", 0, "UpdateSubject", "Congratulations, You\x{2019}re Approved to Receive a Device from Fre"..., "UpdateBcc", ...) called at /usr/share/request-tracker4/lib/RT/Interface/Web.pm line 701
RT::Interface::Web::ShowRequestedPage(HASH(0x7f4f281b9618)) called at /usr/share/request-tracker4/lib/RT/Interface/Web.pm line 380
RT::Interface::Web::HandleRequest(HASH(0x7f4f281b9618)) called at /usr/share/request-tracker4/html/autohandler line 53
HTML::Mason::Commands::__ANON__("UpdateIgnoreAddressCheckboxes", 0, "UpdateBcc", "", "TxnRecipients", "emailremoved\@gmail.com,emailremoved\@freegeek.org", "UpdateType", "response", ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x7f4f2006bdd8), "UpdateIgnoreAddressCheckboxes", 0, "UpdateBcc", "", "TxnRecipients", "emailremoved\@gmail.com,emailremoved\@freegeek.org", "UpdateType", ...) 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, "UpdateIgnoreAddressCheckboxes", 0, "UpdateBcc", "", "TxnRecipients", ...) 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(0x7f4f288305f8)) 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(0x7f4f288305f8)) called at /usr/share/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, "UpdateIgnoreAddressCheckboxes", 0, "UpdateBcc", "", "TxnRecipients", "emailremoved\@gmail.com,emailremoved\@freegeek.org", ...) 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(0x5576375e6d08), HASH(0x7f4f485911e8), HASH(0x7f4f4925d028)) called at /usr/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__(CODE(0x7f4f283cac30)) called at /usr/share/perl5/Plack/Util.pm line 339
Plack::Util::__ANON__(CODE(0x7f4f28393fc8)) called at /usr/share/perl5/Plack/Handler/Apache2.pm line 89
Plack::Handler::Apache2::call_app("Plack::Handler::Apache2", Apache2::RequestRec=SCALAR(0x7f4f24738b48), CODE(0x557645c1a618)) called at /usr/share/perl5/Plack/Handler/Apache2.pm line 126
Plack::Handler::Apache2::handler(Apache2::RequestRec=SCALAR(0x7f4f24738b48)) called at -e line 0
eval {...} called at -e line 0 (/usr/share/perl/5.28/Carp.pm:292)