<div dir="ltr"><div><div><div>Hi,<br><br></div>It immediately runs the query, flush_lines() controls the transaction size, which can be enabled using<br></div>flags(explicit-commits).<br><br></div>HTH<br>Bazsi<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 9, 2014 at 6:08 PM, Davide Alberani <span dir="ltr">&lt;<a href="mailto:davide.alberani@gmail.com" target="_blank">davide.alberani@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
I&#39;m using a SQLite 3 database as a destination,<br>
but it seems that the options to delay the insert<br>
of new rows are ignored.<br>
<br>
The destination is something like:<br>
<br>
destination sqlite_db {<br>
        sql(type(sqlite3)<br>
        flags(&#39;explicit-commits&#39;)<br>
        flush_timeout(60000)<br>
        log_fifo_size(1000)<br>
        flush_lines(1000)<br>
        retry_sql_inserts(2)<br>
        database(&quot;/tmp/logs.db&quot;)<br>
        [...table, columns, values, indexes definitions...]<br>
};<br>
<br>
Every time a log arrives, it&#39;s immediately written into<br>
the database, while I expected to have it delayed accordingly<br>
to flush_timeout and flush_lines.<br>
<br>
Currently I&#39;m using syslog-ng OSE 3.4.2, but looking at<br>
the code of the latest version doesn&#39;t seem to have<br>
changed much.<br>
SQLite version is 3.8.4.<br>
libdbi 0.8.4<br>
libdbi-drivers 0.8.3<br>
libdbi-dbd-sqlite 0.8.3<br>
libol 0.3.16<br>
libevtlog 0.2.13<br>
<br>
Any idea about how to fix it?<br>
<br>
<br>
Thanks in advance,<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Davide Alberani &lt;<a href="mailto:davide.alberani@gmail.com">davide.alberani@gmail.com</a>&gt;  [PGP KeyID: 0x465BFD47]<br>
<a href="http://www.mimante.net/" target="_blank">http://www.mimante.net/</a><br>
______________________________________________________________________________<br>
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>
Documentation: <a href="http://www.balabit.com/support/documentation/?product=syslog-ng" target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a><br>
FAQ: <a href="http://www.balabit.com/wiki/syslog-ng-faq" target="_blank">http://www.balabit.com/wiki/syslog-ng-faq</a><br>
<br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>Bazsi
</div>