Can't add attachments anymore - Possibly DB switch?

RT Users
1

Is this an error due to me switching to MariaDB from MySQL? It’s looking
like some file attachments can’t get added.

[Tue May 14 22:05:25 2013] [warning]: RT::Handle=HASH(0xbd328224)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename,
Headers, MessageId, Creator, Parent, Created, ContentEncoding, Content,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/local/share/pe
rl/5.14.2/DBIx/SearchBuilder/Handle.pm line 600.

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbd328224)’,
‘INSERT INTO Attachments (Subject, ContentType, Filename, Head…’, ‘06
0741-2_new.pdf’, ‘application/pdf’, ‘060741-2_new.pdf’, ‘Subject:
060741-2_new.pdf\x{a}MIME-Version: 1.0\x{a}Content-Type: app…’, ‘’,
821, 20024, …
) called at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm
line 350

Stephen Cena
QVII
MIS/IT Dept
850 Hudson Ave.
Rochester, NY. 14620
585-544-0450 x300
sjc@qvii.com
“Thank you for helping us help you help us all.”
–For email related issues, please contact postmaster@qvii.com

2

Is this an error due to me switching to MariaDB from MySQL? It’s looking
like some file attachments can’t get added.

[Tue May 14 22:05:25 2013] [warning]: RT::Handle=HASH(0xbd328224)
couldn’t execute the query ‘INSERT INTO Attachments (Subject,
ContentType, Filename,
Headers, MessageId, Creator, Parent, Created, ContentEncoding, Content,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/local/share/pe
rl/5.14.2/DBIx/SearchBuilder/Handle.pm line 600.

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xbd328224)’,
‘INSERT INTO Attachments (Subject, ContentType, Filename, Head…’, ‘06
0741-2_new.pdf’, ‘application/pdf’, ‘060741-2_new.pdf’, ‘Subject:
060741-2_new.pdf\x{a}MIME-Version: 1.0\x{a}Content-Type: app…’, ‘’,
821, 20024, …
) called at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm
line 350

Hmm, there’s no reason in the error message why the query failed.
That is strange. Is there anything in Maria’s logs?

Are you seeing this happen more than once? Is there any pattern in what
attachments fail?

FWIW, RT doesn’t officially support MariaDB, and there are a few
differences from MySQL, so you’re running in uncharted territory right
now. Support may be added in the future, as MariaDB does seem to be
gaining usage.