Re: [sqlite] Crash while rollback database in journal_mode=DELETE

[Taewon Park]

Thank you for your quick reply!

> If so, please tell us the email address that is associated with your SEE
license.

Unfortunately I'm using my own implementation, not SEE. Of course via
SQLite3 C API interface, such as sqlite3CodecAttach and etc.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Crash while rollback database in journal_mode=DELETE

[Taewon Park]

Hello,

I'm developing an application with C++ and sqlite C api, and I updated
SQLite 3.17.0 from 3.7.12 recently.

Because of changed default page size, My application has different
page-sized encrypted databases : 1024 and 4096.

After the crash while writing something in 4096 page-sized
database(exactly, between beginning transaction and commit), the
application crashes during opening the database and It happens 1~4 times
until I success to launch it.

As a result of some inspections, I realized the struct database has
different page size: the page size in struct Btree is 4096, but the value
in struct Pager is 1024.

And I'm only allowed to retrieve the value of Btree(by using
sqlite3BtreeGetPagerSize), so when the application decrypts 1024 page-sized
database as it has 4096 page size the crash happens.

The databases using synchronous=0 for performance and journal_mode =
DELETE. Is there any method to prevent this?

PS. When I changed journal_mode into WAL, it didn't happened. Is this the
solution?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users