I cannot seem to find the implementation for COLLATE JSON anywhere in your source code. Can you give me a hint as to which source file I should be looking in?
On 4/16/17, Brendan Duddridge <brend...@gmail.com> wrote: > Hi, > > I know this is an old thread, but I just found it now when I was doing some > research on this topic. Thanks Jens for starting this thread. When Jens > said he knew a developer who could create a corrupted database by turning > off the power, I'm pretty sure he was talking about me. This has been an > ongoing problem for me for a while now. My customers keep getting corrupted > SQLite databases due to power failures or forced shutdowns. > > I wrote a small sample app to demonstrate the problem just to make sure it > wasn't my own app causing the problem in some complex way. > > Someone on this thread said to post a sample of a corrupted database. So > here's a link to download a file that has become corrupted: > > https://www.dropbox.com/s/5xwsfhorrfvefjy/corrupted-sqlite-powerfailure-mac.zip?dl=0 > > The way it started out was an SQLite file with a table in it called docs > (along with other tables) with 408 rows in it. I imported a bunch of data > into the SQLite file so that there should be 4402 rows in the docs table, > along with data stored in other tables. > > After the import and the data was committed to the database (while the app > was still launched but not doing anything), I shutdown my MacBook Pro > forcibly by holding the power key down until it shut off. When I restarted > and opened the database file using the Mac SQLiteManager app, The docs > table now contained only 2631 rows, with a lot of NULL data displayed in > the docs table. That should not be possible with the library I'm using. > > If you're interested in trying out the sample application I wrote to see > the corruption for yourself, you can download it here: > > https://www.dropbox.com/s/q2r4bz7n1d5fgag/PowerFailureTest.zip?dl=0 > > You'll need a Mac and Xcode 8.x to run it. I would just have only Xcode and > the sample app running when I caused the Mac's power to be killed. > > When the database is opened, it's using WAL journal_mode and also has > pragma fullfsync=1 enabled. > > Any ideas of settings I could try to resolve this problem would be greatly > appreciated by me and my customers. > > Thanks, > > Brendan Duddridge > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
