On 21 Sep 2015, at 10:44pm, Hugues Bruant <hugues at aerofs.com> wrote:
> We've only observed this on OS X so far, with both 3.8.7 and 3.8.11.1. The > new value is always exactly the old value +1 when the statement fails. Can you reproduce this problem with the SQLite shell tool included with Mac OS X ? You should find one already installed on your Mac as '/usr/bin/sqlite3'. Ideally, open the database which exhibits the problem and first execute PRAGMA integrity_check; If this fails to show any problems run your UPDATE command, repeatedly if necessary, and see if you can make the shell tool do anything that suggests it isn't working perfectly. > It is opened in > WAL mode with exclusive locking. Just a quick note that the journal mode is an attribute of the database itself. There is no need to specify the mode each time a connection opens the database. It is saved in the journal file and connections which access the database will automatically understand what mode to use. You can check the journal mode of the database using PRAGMA journal_mode; Simon.
