With OS_UNIX version 3.4.0 (AMALGAMATION), I do the following: a) open a database file, it contains one table with 3 records in it. b) insert 9997 records in side a begin/end transaction c) delete 9997 records d) vacuum the database e) close the database file
Whether I use VACUUM on it's own or VACUUM table-name, I get this error: SQL error: SQL logic error or missing database I have no views and I havn't changed the schema. Any ideas? Preston Zaugg wrote: > > Incase anybody runs into this in the future... I found the cause of this > problem... I had a view that was pointing to a column of the table that no > longer exsists. As soon as i dropped the view i was able to vacuum the > database without error. > > --Preston > ----- Original Message ----- > From: "Preston Zaugg" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Tuesday, October 04, 2005 10:58 AM > Subject: RE: [sqlite] SQL logic error when running vacuum; > > >> Well, based on your comment i tried a vacuum from the API and i still get >> the error. >> >> ----Original Message Follows---- >> From: "Cariotoglou Mike" <[EMAIL PROTECTED]> >> Reply-To: sqlite-users@sqlite.org >> To: <sqlite-users@sqlite.org> >> Subject: RE: [sqlite] SQL logic error when running vacuum; >> Date: Tue, 4 Oct 2005 18:46:27 +0300 >> >> as a matter of fact, I have also noticed that using the vaccum command >> from the command-line interface does bring this error up sometimes. >> however, since I use the graphical UI most of the time (being its >> author:) I don't use the command line interface that much. >> I suspect it has nothing to do with the engine itself, rather with the >> command-line tool. >> >> > -----Original Message----- >> > From: Preston Zaugg [mailto:[EMAIL PROTECTED] >> > Sent: Tuesday, October 04, 2005 6:35 PM >> > To: sqlite-users@sqlite.org >> > Subject: [sqlite] SQL logic error when running vacuum; >> > >> > I have a database (encrypted w/ encryption extensions from >> > drh). After run a sql file on this database it gives the >> > error "SQL error: SQL logic error or missing database" after >> > running a vacuum. it also seems to give this error >> > sporadically on other statements. >> > >> > the sql file that i run does the following: >> > drops a table >> > creates a new table (same name different structure from the >> > the table that was just dropped) adds a unique constraint >> > runs 7000+ insert statements >> > >> > the file is executed using the .read of the command line >> > utility, and runs without error/warning. >> > >> > As a side note i am able to run this same script against a MS >> > SQL Server database without error. >> > >> > Between the fact that i can run this script on sql server and >> > don't get any errors on the .read, makes me think that my >> > script is valid/well formed. >> > >> > Oh.. other important stuff... i was on 3.2.2 when i started >> > running into this problem. Upgraded to 3.2.7 with the same >> > results. I'm on Windows 2003 and using a local database. >> > >> > Any suggestions? >> > --Preston >> > >> > >> > >> > >> > >> >> >> > > -- View this message in context: http://www.nabble.com/SQL-logic-error-when-running-vacuum--tf373521.html#a11760962 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------