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

Thomas Sibley trs at bestpractical.com
Wed May 15 19:04:16 EDT 2013


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.



More information about the rt-users mailing list