[rt-users] Postgres doesn't like Barracuda notification mails

2007-10-17 Thread Rainer Duffner
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

2007-10-17 Thread Ruslan Zakirov
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