Hi Rainer et al, round about a year ago we had a relativly long thread about a bug with DA queues where one message always gets lost. -> "rsyslog 4.5.x queue file cleanup"
This bug is still present in 4.6.4 ... I can trigger the bug the following way: Setup: DA MainMsgQueue + ompgsql Action Steps to reproduce with 4.6.4: 1. Stop the Database, rsyslogd still running 2. Produce 50 log messages for the database 3. Shutdown rsyslogd, queue gets saved to disk 4. Startup rsyslogd 5. Startup databae again. Result: only 49 Messages arrive at the Database. (These are only INSERT statements where message ORDER does not matter at all) At that time we had another issue with that setup and you found a bug and fixed it: http://git.adiscon.com/?p=rsyslog.git;a=commitdiff;h=8e45fd5c8e7df45532c5d239676cd92107c9e942 With that patch it worked but with one issue left which is described here or later in the mentioned thread. Additionally (maybe I just confuse something now) it seems that the MainMsgQueue is not DA at all, but only saves mem-Q-messages to disk on shutdown but not when the mem-queue is full... This is the relevant part of the config: $WorkDirectory /var/spool/rsyslog # default location for work (spool) files $MainMsgQueueType LinkedList # use asynchronous processing $MainMsgQueueFileName mainq # set file name, also enables disk mode $MainMsgQueueMaxFileSize 10M # when to start new file $MainMsgQueueSaveOnShutdown on # save queued message to DA queue on shutdown $MainMsgQueueSize 100 # very small for testing only $ModLoad ompgsql $ActionResumeRetryCount -1 $ActionResumeInterval 5 if $syslogtag startswith 'postfix/smtpd[' \ then :ompgsql:localhost,maillog,syslog,XXXXX;mail_t1 [ .. some more actions .. ] BTW: I tested the same config with v5 stable (5.6.0) and noticed that this version does not save the queue to disk at all. When stopping rsyslogd the process consumes some time but does not write anything to disk. regards -Marc -- Senior Consultant :: Solution Architect IT-Security :: Free Software :: GNU/Linux :: Virtualization Mobile +49_151_16227402 :: Fon +49_6187_9058695 :: Fax +49_2645_976896250 MightyCare Solutions GmbH http://www.mightycare.de Firmenangaben unter http://www.mightycare.de/impressum _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com

