[rt-users] Postgres doesn't like Barracuda notification mails
Hi, I got a lot of mails from my fetchmail-cronjob this morning, that said: RT server error. The RT server which handled your email did not behave as expected. It said: no connection to syslog available - stream /dev/conslog is not writable - console is not writable at /usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm line 77 Stack: [/usr/local/lib/perl5/5.8.8/Carp.pm:269] [/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm:802] [/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm:709] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm:77] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Output.pm:41] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm:100] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm:79] [/usr/local/lib/perl5/5.8.8/Carp.pm:272] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:518] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:353] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm:66] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm:1294] [/usr/local/rt3/lib/RT/Record.pm:310] [/usr/local/rt3/lib/RT/Attachment_Overlay.pm:207] [/usr/local/rt3/lib/RT/Attachment_Overlay.pm:189] [/usr/local/rt3/lib/RT/Attachment_Overlay.pm:189] [/usr/local/rt3/lib/RT/Transaction_Overlay.pm:487] [/usr/local/rt3/lib/RT/Transaction_Overlay.pm:158] [/usr/local/rt3/lib/RT/Record.pm:1446] [/usr/local/rt3/lib/RT/Ticket_Overlay.pm:746] [/usr/local/rt3/lib/RT/Interface/Email.pm:730] [/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61] fetchmail: MDA returned nonzero status 75 In the rt.log, there was this: [Wed Oct 17 07:05:03 2007] [warning]: DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding UTF8: 0xdc62 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_e ncoding. (/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) [Wed Oct 17 07:05:03 2007] [warning]: RT::Handle=HASH(0xae33e88) couldn't execute the query 'INSERT INTO Attachments (ContentType, Parent, Subject, Filename, Headers, Creator, MessageId, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xae33e88)', 'INSERT INTO Attachments (ContentType, Parent, Subject, File na...', 'text/plain', 27634, '', 'undef', 'Content-Type: text/plain; charset=utf-8\x{a}Content-Transfer-En...', 14039, '', ...) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 353 DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xae33e88)', 'Attachments', 'ContentType', 'text/plain', 'Parent', 27634, 'Sub ject', '', 'Filename', ...) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm line 66 DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0xae33e88)', 'Attachments', 'ContentType', 'text/plain', 'Parent', 27634, 'Subject', '', 'Filename', ...) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1294 DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0xd662500)', 'ContentType', 'text/plain', 'Parent', 27634, 'Subject', '', 'Filename', 'undef', ...) called at /usr/local/rt3/lib/RT/Record.pm line 310 RT::Record::Create('RT::Attachment=HASH(0xd662500)', 'TransactionId', 53476, 'ContentType', 'text/plain', 'ContentEncoding', 'none' , 'Parent', 27634, ...) called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm line 207 RT::Attachment::Create('RT::Attachment=HASH(0xd662500)', 'TransactionId', 53476, 'Parent', 27634, 'Attachment', 'MIME::Entity=HASH( 0xd5ec140)') called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm line 189 RT::Attachment::Create('RT::Attachment=HASH(0xd673fb8)', 'TransactionId', 53476, 'Parent', 27633, 'Attachment', 'MIME::Entity=HASH( 0xd00e02c)') called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm line 189 RT::Attachment::Create('RT::Attachment=HASH(0xd570aa4)', 'TransactionId', 53476, 'Attachment', 'MIME::Entity=HASH(0xd31a734)') call ed at /usr/local/rt3/lib/RT/Transaction_Overlay.pm line 487 RT::Transaction::_Attach('RT::Transaction=HASH(0xd63d5d8)', 'MIME::Entity=HASH(0xd31a734)') called at /usr/local/rt3/lib/RT/Transac tion_Overlay.pm line 158 RT::Transaction::Create('RT::Transaction=HASH(0xd63d5d8)', 'ObjectId', 3687, 'ObjectType', 'RT::Ticket', 'TimeTaken', 0, 'Type', 'C reate', ...) called at /usr/local/rt3/lib/RT/Record.pm line 1446 RT::Record::_NewTransaction('RT::Ticket=HASH(0xd4ea008)', 'Type', 'Create', 'TimeTaken', 0, 'MIMEObj', 'MIME::Entity=HASH(0xd31a734 )') called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 746 RT::Ticket::Create('RT::Ticket=HASH(0xd4ea008)', 'Queue', 13, 'Subject',
Re: [rt-users] Postgres doesn't like Barracuda notification mails
That would be great if you grab one of emails and send it for analysis and most probably we'll fix an issues and write a regression test. On 10/17/07, Rainer Duffner [EMAIL PROTECTED] wrote: Hi, I got a lot of mails from my fetchmail-cronjob this morning, that said: RT server error. The RT server which handled your email did not behave as expected. It said: no connection to syslog available - stream /dev/conslog is not writable - console is not writable at /usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm line 77 Stack: [/usr/local/lib/perl5/5.8.8/Carp.pm:269] [/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm:802] [/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm:709] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm:77] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Output.pm:41] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm:100] [/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm:79] [/usr/local/lib/perl5/5.8.8/Carp.pm:272] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:518] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:353] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm:66] [/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm:1294] [/usr/local/rt3/lib/RT/Record.pm:310] [/usr/local/rt3/lib/RT/Attachment_Overlay.pm:207] [/usr/local/rt3/lib/RT/Attachment_Overlay.pm:189] [/usr/local/rt3/lib/RT/Attachment_Overlay.pm:189] [/usr/local/rt3/lib/RT/Transaction_Overlay.pm:487] [/usr/local/rt3/lib/RT/Transaction_Overlay.pm:158] [/usr/local/rt3/lib/RT/Record.pm:1446] [/usr/local/rt3/lib/RT/Ticket_Overlay.pm:746] [/usr/local/rt3/lib/RT/Interface/Email.pm:730] [/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61] fetchmail: MDA returned nonzero status 75 In the rt.log, there was this: [Wed Oct 17 07:05:03 2007] [warning]: DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding UTF8: 0xdc62 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by client_e ncoding. (/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) [Wed Oct 17 07:05:03 2007] [warning]: RT::Handle=HASH(0xae33e88) couldn't execute the query 'INSERT INTO Attachments (ContentType, Parent, Subject, Filename, Headers, Creator, MessageId, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xae33e88)', 'INSERT INTO Attachments (ContentType, Parent, Subject, File na...', 'text/plain', 27634, '', 'undef', 'Content-Type: text/plain; charset=utf-8\x{a}Content-Transfer-En...', 14039, '', ...) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 353 DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xae33e88)', 'Attachments', 'ContentType', 'text/plain', 'Parent', 27634, 'Sub ject', '', 'Filename', ...) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm line 66 DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0xae33e88)', 'Attachments', 'ContentType', 'text/plain', 'Parent', 27634, 'Subject', '', 'Filename', ...) called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1294 DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0xd662500)', 'ContentType', 'text/plain', 'Parent', 27634, 'Subject', '', 'Filename', 'undef', ...) called at /usr/local/rt3/lib/RT/Record.pm line 310 RT::Record::Create('RT::Attachment=HASH(0xd662500)', 'TransactionId', 53476, 'ContentType', 'text/plain', 'ContentEncoding', 'none' , 'Parent', 27634, ...) called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm line 207 RT::Attachment::Create('RT::Attachment=HASH(0xd662500)', 'TransactionId', 53476, 'Parent', 27634, 'Attachment', 'MIME::Entity=HASH( 0xd5ec140)') called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm line 189 RT::Attachment::Create('RT::Attachment=HASH(0xd673fb8)', 'TransactionId', 53476, 'Parent', 27633, 'Attachment', 'MIME::Entity=HASH( 0xd00e02c)') called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm line 189 RT::Attachment::Create('RT::Attachment=HASH(0xd570aa4)', 'TransactionId', 53476, 'Attachment', 'MIME::Entity=HASH(0xd31a734)') call ed at /usr/local/rt3/lib/RT/Transaction_Overlay.pm line 487 RT::Transaction::_Attach('RT::Transaction=HASH(0xd63d5d8)', 'MIME::Entity=HASH(0xd31a734)') called at /usr/local/rt3/lib/RT/Transac tion_Overlay.pm line 158 RT::Transaction::Create('RT::Transaction=HASH(0xd63d5d8)', 'ObjectId', 3687, 'ObjectType', 'RT::Ticket', 'TimeTaken', 0, 'Type', 'C reate', ...) called at /usr/local/rt3/lib/RT/Record.pm line 1446