[rsyslog] Indefinite number of retries with ompgsql

[Rudolf van der Leeden]

Hi,

I'm currently testing ompgsql and running into a problem with the  
number of pgsql retries if the INSERT statement is wrong.
My rsyslog.conf setting:

$ModLoad ompgsql  # load the output driver for PostgreSQL
$ModLoad imudp    # network reception
$MaxMessageSize 8192  # default 2048; use 32768 to support large  
message sizes for IHE
$UDPServerRun 514 # start a udp server at port 514
$WorkDirectory /var/spool/rsyslog/work # default location for work  
(spool) files
$ActionQueueType LinkedList # use asynchronous processing
$ActionQueueFileName dbq    # set file name, also enables disk mode
$ActionResumeRetryCount 0
$template applogFormat,"INSERT INTO applog (message, host, priority,  
priotext, tag, logtime) VALUES \
   (E'%msg%', '%hostname%', '%syslogpriority%', '%syslogpriority-text 
%', '%programname%', '%timegenerated:::date-pgsql%')",stdsql
if $programname contains 'production'   
then :ompgsql:loghost,syslog,syslog,syslog;applogFormat

I changed $ActionResumeRetryCount from -1 to 1 and then to 0, but  
always the same result:  indefinite retries of rsyslogd to get the  
INSERT done.
This setup is basically running OK.
Only if a binary 0 (\000) is contained in the message Postgres  
returns:  ERROR:  invalid byte sequence for encoding "UTF8": 0x00

What am I doing wrong? Any hints are welcome.

Thanks for your help,
Rudolf.

Rudolf VanderLeeden
Scoreloop GmbH
vanderleeden at scoreloop.com