Dear List,
For the past two days our OTRS installation has been discarding some
incoming messages. PostMaster.pl is emitting the below error messages
into the mail log. I have searched the mailing list archive and read
the OTRS documentation but have not found any direction thus far.
We are using OTRS 1.3.2p01 from Debian's 1.3.2p01-5 package and pgsql
version 7.4.7-6. We have not made any changes to our OTRS, pgsql, or
mail delivery configuration recently.
This has affected some incoming messages to existing tickets, and some
messages that should open new tickets. I unfortunately do not have
copies of the incoming messages. I have started storing copies of the
inbound mail today. Note that the incoming mail that has been discarded
in this manner is not believed to contain large file attachments or any
other "common problems" that might prevent normal delivery.
Jun 6 20:02:34 odyssey qmail: 1118102554.671902 delivery 24427:
success:
DBD::Pg::db_do_failed:_called_with_2_bind_variables_when_0_are_needed_at_/usr/share/otrs/Kernel/System/DB.pm_line_376./ERROR:_OTRS-PM-1_Perl:_5.8.4_OS:_linux_Time:_Mon_Jun__6_20:02:34_2005//_Message:_called_with_2_bind_variables_when_0_are_needed,_SQL:_'INSERT_INTO_article__(ticket_id,_article_type_id,_article_sender_type_id,_a_from,_a_reply_to,_a_to,__a_cc,_a_subject,_a_message_id,_a_body,_a_content_type,_content_path,__valid_id,_incoming_time,__create_time,_create_by,_change_time,_change_by)__VALUES__(5102,_1,_3,__'"From_Person"_