On 10/7/15, Aki Tuomi <cmouse at cmouse.fi> wrote: > Hi! > > We use SQLite3 in PowerDNS as one backend and we have implemented query > logging using sqlite3_trace. Unfortunately it seems that it does not log > all executed queries, despite being turned on. We see one or two queries > but most go unlogged. > > I tried to generate a minimal example to see if it happens, but on testing > it worked flawlessly. > > Now I'm wondering if there are some caveats or possibly something we are > doing wrong that causes this behaviour? >
The only thing I can think is that the missing SQL statements are happening on a separate database connection for which you have not enabled sqlite3_trace(). -- D. Richard Hipp drh at sqlite.org