[syslog-ng] inserts into a sqlite3 database are not delayed

9 Oct 2014

      Hi,
I'm using a SQLite 3 database as a destination,
but it seems that the options to delay the insert
of new rows are ignored.

The destination is something like:

destination sqlite_db {
        sql(type(sqlite3)
        flags('explicit-commits')
        flush_timeout(60000)
        log_fifo_size(1000)
        flush_lines(1000)
        retry_sql_inserts(2)
        database("/tmp/logs.db")
        [...table, columns, values, indexes definitions...]
};

Every time a log arrives, it's immediately written into
the database, while I expected to have it delayed accordingly
to flush_timeout and flush_lines.

Currently I'm using syslog-ng OSE 3.4.2, but looking at
the code of the latest version doesn't seem to have
changed much.
SQLite version is 3.8.4.
libdbi 0.8.4
libdbi-drivers 0.8.3
libdbi-dbd-sqlite 0.8.3
libol 0.3.16
libevtlog 0.2.13

Any idea about how to fix it?

Thanks in advance,

-- 
Davide Alberani <davide.alberani@gmail.com>  [PGP KeyID: 0x465BFD47]
http://www.mimante.net/