Wow, James, that looks really nice. And thanks Rainer for putting it on the
website.
Will make sure to send PRs whenever I'm using something un/less-documented.
2014-02-03 12:54 GMT+00:00 Boylan, James :
> Hey Everyone -
>
> I have the initial version for all branches (v5-stable, v7-stable,
> v
Threw it in debug an I'm seeing the SQL errors. I'm guessing this is an
rsyslog log problem then - errors are very infrequently written to
syslog.*, even though they are occurring multiple times a second in the
debug log.
That behavior basically led me to believe I'm getting ~2 SQL errors per
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 mo
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
f
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 t
Another patch ( not yet tested ) without useless PG connect..
-patch--
diff --git a/plugins/ompgsql/ompgsql.c b/plugins/ompgsql/ompgsql.c
index 11f346f..e236234 100644
--- a/plugins/ompgsql/ompgsql.c
+++ b/plugins/ompgsql/ompgsql.c
Little remark
To be honest, I don't see any advantage to init the PG connection during the
instance creation.
We could just suppress the call to initPgSQL and keep in this patch the test
part in the BeginTransaction to init the connection if the handle is NULL.
Alain
ecze wrote
> Purpose
Xuri, Mike, thanks a lot for your thoughts. Besides being funny, it's nice
to know that maybe I'm not crazy in having similar thoughts to you guys.
Or at least I'm not a special kind of crazy :D
___
rsyslog mailing list
http://lists.adiscon.net/mailman/l
Purpose of a patch for Stable Release 7.4.9 :
diff -Nru ompgsql.c /new/ompgsql.c
--- ompgsql.c 2014-01-21 13:14:21.0 +0100
+++ /new/ompgsql.c2014-02-05 12:01:51.557026475 +0100
@@ -262,8 +262,13 @@
BEGINbeginTransaction
CODESTARTbeginTransaction
+if ( pData->f_hpgsql == NULL
9 matches
Mail list logo