[rsyslog] mysql inserts and message queues

[Rainer Gerhards]

I don't see any obvious error and, yes, the queue files should be
deleted. Actually, you should only see any files at all if the inserts
take too long. What you have may be an artifact of a previous failure.

To get down to what it is, we need to check how things progress. Is your
database populated? In any case, a debug log (rsyslogd with -dn
additional options run interactively) will tell us what is there. Also,
there should be a .qi file. Let us know its contents.

Thanks,
Rainer

> -----Original Message-----
> From: rsyslog-bounces at lists.adiscon.com [mailto:rsyslog-
> bounces at lists.adiscon.com] On Behalf Of Rory Toma
> Sent: Wednesday, July 30, 2008 3:15 AM
> To: rsyslog-users
> Subject: [rsyslog] mysql inserts and message queues
> 
> I have enabled mysql and disk message queues as per below:
> 
> $ModLoad immark.so # provides --MARK-- message capability
> $ModLoad imuxsock.so # provides support for local system logging (e.g.
> via logger command)
> $ModLoad imklog.so # kernel logging (formerly provided by rklogd)
> $ModLoad ommysql.so
> $ModLoad imudp.so  # provides UDP syslog reception
> $UDPServerRun 514 # start a UDP syslog server at standard port 514
> 
> $WorkDirectory /var/rsyslog
> 
> $ActionQueueType LinkedList
> $ActionQueueFileName dbq
> $ActionResumeRetryCount -1
> 
> *.*    :ommysql:127.0.0.1,Syslog,syslogwriter,writeme
> # *.*    /var/log/messages
> 
> 
> The question I have is... does the disk queue drain w/o me having to
> intervene? I currently have 323 queue files (I was adding some keys
and
> playing with tuning mysql... kind of slowed it down) and the number of
> queue files is not going down.
> 
> thx
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog