On Wed, Oct 07, 2015 at 08:42:47AM -0400, Richard Hipp wrote: > 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
Is there any way to see whether sqlite3_trace has been attached to a particular connection? Aki
