[rt-users] Can't add attachments anymore - Possibly DB switch?

[Thomas Sibley]

On 05/15/2013 11:57 AM, Cena, Stephen (ext. 300) wrote:
> 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.