On Mon, Jun 9, 2014 at 9:45 PM, Ward Willats <sqlite-us...@wardco.com> wrote:
> Hello. > > Running Sqlite 3.8.4.3 in an iOS application in WAL mode. One writer. Many > readers. Each thread on own connection. > > After a particular big bulk insert of data, during which, BTW, indices are > dropped and recreated and an ANALYZE done, sqlite is reporting on the > SQLITE_CONFIG_LOG callback: > > Message: statement aborts at NN: [SELECT xxxxx > Error code: 17 > > 17 is a SQLITE_SCHEMA error. The schema has not actually changed -- at > least not intentionally! > Dropping or creating an index counts as a schema change. > > The occurrence is pretty deterministic. > > I traced through the source and Sqlite quietly retries the error and the > second time it succeeds. No error is returned to the originating API call. > > So..is this benign? Can/should I fix? How worried should I be? > > Thanks > > -- Ward > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users