Re: [sqlite] Hot-Journal with VFS

2018-10-20 Thread Dan Kennedy
On 10/18/2018 09:27 PM, Bob schwanzer wrote: Hi, I'm seeing hot journal frequently in our SQLite installation. We use VFS which does some checksum and other operations. There are no abnormal scenarios such as power off, process crash, abandoned transactions... DB is opened by 10-20 processes

Re: [sqlite] Hot-Journal with VFS

2018-10-18 Thread Simon Slavin
On 18 Oct 2018, at 3:27pm, Bob schwanzer wrote: > DB is > opened by 10-20 processes each of which can have multiple threads. What OS are you using ? What programming language are you using ? Are you calling the SQLite C library directly or using a shim ? Does your program close each database

[sqlite] Hot-Journal with VFS

2018-10-18 Thread Bob schwanzer
Hi, I'm seeing hot journal frequently in our SQLite installation. We use VFS which does some checksum and other operations. There are no abnormal scenarios such as power off, process crash, abandoned transactions... DB is opened by 10-20 processes each of which can have multiple threads. Old