On 04/29/2015 04:28 PM, Navaneeth K N wrote: > Hi Dan, > > >> On 27-Apr-2015, at 11:34 am, Dan Kennedy <danielk1977 at gmail.com> wrote: >> >> On 04/27/2015 12:55 PM, Navaneeth K N wrote: >>> Hi Dan, >>> >>> >>>> On 27-Apr-2015, at 10:52 am, Dan Kennedy <danielk1977 at gmail.com> wrote: >>>> >>>> On 04/26/2015 07:01 PM, Navaneeth K N wrote: >>>>> Hello, >>>>> >>>>> My application runs the following right after opening the connection to >>>>> the database. >>>>> >>>>> pragma journal_mode=wal; >>>>> pragma page_size=4096 >>>> Did executing the "PRAGMA journal_mode=wal" statement succeed? Or did it >>>> return SQLITE_BUSY or some other error code? >>> Yes. It succeeded. I can see -wal files after this. >> Sorry, it's early here. I meant the "PRAGMA journal_mode=delete" - did it >> succeed? > Yes. It succeeded. Running `pragma journal_mode;` again shows delete for that > connection. So does that mean, all the other connections uses WAL mode and > just this connection will use DELETE mode for all the transactions?
If it succeeded, it should mean that the connection was able to gain exclusive access to the database file and switch the database back to rollback (non-WAL) mode. The *-wal and *-shm files should have been deleted when the command returns. Dan.
