On Tue, 15 Oct 2019 21:11:05 +0000 "t...@qvgps.com" <t...@qvgps.com> wrote:
> Hi Group, > > here is a very strange and rare fault which one of our users > experienced on macOS . > > He was working in our app for a while creating a lot of new data. > So over several hours many INSERT INTO mytable .... > Without any errors. > > Then he did a query SELECT COUNT(*) FROM mytable WHERE (deleted=0 OR > deleted IS NULL) AND IdCat=2 and an exception occurs: > "no such table: mytable" > > The client sent us the database and the table "mytable" was really > gone. The database also seems to be fine, no errors. > How can this happen? > In our app is no DROP TABLE command, what else can cause a table to > be deleted? > > We have a few hundred copies of our app out, and this is the first > time this error happens. Its on macOS and the sqlite-version is > 3024000 Did he closed the transaction?? If he did BEGIN CREATE TABLE ..... INSERT ..... INSERT.... SELECT COUNT(*).... the table didn't exist and on close, whole transaction in backrolled. I say he, but it could be the application used to manage the db too that forgot the COMMIT after the INSERTS > > > Thanks > Tom > > > > /**************************************** > ** Flemming Software Development CC > ** Thomas Flemming > ** PO Box 81244 > ** Windhoek, Namibia > ** http://www.quovadis-gps.com > ** mail t...@qvgps.com<mailto:t...@qvgps.com> > ** +264 (0)81 3329923 Nam mobile > ** +49 (0)175 7313081 D mobile > ** +49 (0)6182 8492599 D office > ***************************************/ > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
