On May 22, 2008, at 7:02 PM, Samuel Neff wrote: > I have a corrupt sqlite_sequence table. It has table names in the > "seq" > field. > > here is a trimmed version of data in sqlite_sequence: > > > -- Loading resources from C:\Documents and Settings\sam/.sqliterc > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> .width 50 50 > sqlite> select * from sqlite_sequence; > name seq > -------------------------------------------------- > -------------------------------------------------- > Transactions 2 > ActiveTransaction 2 > AnnotationIcons_History 21 > TransactionSequences 494 > CaptureDeviceTransactions 8 > Annotations > CaptureDeviceTransactions > Annotations_History 24 > ChecklistVersions > Annotations_History > ChecklistVersions_History 4 > sqlite> > > > > basically it gets corrupt when I run a bunch of scripts that update > from one > schema to a new one (usually add new columns). The queries do a lot > of > > ALTER TABLE x RENAME TO y; > CREATE TABLE x (...); > INSERT INTO x SELECT ... FROM y; > DROP TABLE y; > > and after that the sqlite_sequence table is messed up as shown > above. It > doesn't happen every time--in the above listed data both Annotations > and > Annotations_History were updated this way, but only Annotations got > messed > up.
How easily repeatable is the problem? Can you send me a database file before and after the schema update and a sequence of SQL operations the performed the update? > > > We cache all the data in sqlite_sequence before we do our updates > and our > intention is to update it afterwards (we haven't written this part > yet due > to sqlite_sequence corruption, so at this point we're only reading > from the > table, not updating/inserting into it). > > Our app is using sqlite 3.5.9. I'm still using sqlite3.exe 3.5.7 > but I see > the same corrupted data in both. > > Please help. > > Thanks, > > Sam > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
