check and see if there are any errors happening. If it's getting an error
inserting that row, it will keep retrying (unless it's an error that the module
can tell is data related)
David Lang
On Wed, 5 Feb 2014, Jacob Steinberger wrote:
After reviewing more of the SQL logs ... it's seems more than just a little
odd.
On a cycle, rsyslogd writes maybe 100 rows to the database as a single
connection. After that connect/insert 100/disconnect, it goes into a cycle
connecting/inserting 1 row/disconnecting - but it's the same SQL for a few
hundred records. Almost as if it isn't looking at the new syslog message that
comes into the system and it's using a cache - and this is even though
writing to flat files works just as expected.
Jacob
On 2/5/2014 2:00 PM, Jacob Steinberger wrote:
I have Rsyslogd configured to send data to MySQL and I've found that
only about a third of the records (or less) are actually making it to
MySQL.
What's odd, is I can write all the SQL out to a file (generated via a
template in rsyslog) and all the SQL inserts are there - including the
ones that never made it to MySQL.
Are there any known bugs with Rsyslog 5.8.10 and MySQL? While I
understand this may be considered an old version of rsyslog, it's the
version included in RH6.
Jacob
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad
of sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you
DON'T LIKE THAT.
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T
LIKE THAT.
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE
THAT.
