[rsyslog] mysql inserts and message queues

[Rainer Gerhards]

On Tue, 2008-07-29 at 23:07 -0700, Rory Toma wrote:
> As a side note, I stopped mysql, saw the number of queue files increase, 
> restarted mysql and they went back down to the original 300 or so.
> 
> So, maybe I just have some horked queue files.

that's now even more probable. But let's verify with the debug log.

Rainer
> 
> 
> Rory Toma wrote:
> > Rainer Gerhards wrote:
> >   
> >> 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
> >>
> >>   
> >>     
> > the db is getting populated and there is no .qi file. If I run in with 
> > "-dn" there is a ton of output, so I need to know what to look for. I've 
> > been running for about a day, and I'm at 20+ million records.
> >
> > I do get an error -2040 when accessing on-disk files. Should I just nuke 
> > these?
> >
> >
> > _______________________________________________
> > rsyslog mailing list
> > http://lists.adiscon.net/mailman/listinfo/rsyslog
> >   
> 
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog