Thanks both of you @sqweek and @ddevienne. It is in WAL mode, not Persistent mode. The database file is retrieved from a device, having no -shm or -wal file. I do see those -shm, and -wal files alongside db file under a readwrite snapshot after I opened it.