[sqlite] Corrupted sqlite_sequence table
I would remove the leading/trailing quotes external to the import of the file, using something like sed or gawk. I couldn't work out how to do this purely using sqlite, however. _ It's simple! Sell your car for just $30 at CarPoint.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641_t=762955845_r=tig_OCT07_m=EXT ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Corrupted sqlite_sequence table
Were you able to successfully reproduce the corruption using the scripts and databases I sent? We're having a lot more trouble with this problem and our earlier workaround is proving troublesome in some situations. Thanks, Sam On Wed, May 28, 2008 at 7:25 PM, D. Richard Hipp [EMAIL PROTECTED] wrote: On May 28, 2008, at 7:21 PM, Samuel Neff wrote: It happens every time. I can send you a db and the update scripts, but I'll need you to keep it confidential (not signed affidavit or anything like that, just understanding that it's confidential). Please confirm this is ok and also which address I should send it to (if other than the one you're using for this list). No one will see the database besides me. I will delete it once the bug is fixed. Send to the address below. D. Richard Hipp [EMAIL PROTECTED] -- - We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer. Position is in the Washington D.C. metro area. Contact [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Corrupted sqlite_sequence table
Samuel Neff wrote: Were you able to successfully reproduce the corruption using the scripts and databases I sent? We're having a lot more trouble with this problem and our earlier workaround is proving troublesome in some situations. I think it has been fixed. See http://www.sqlite.org/cvstrac/tktview?tn=3148 for details. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Corrupted sqlite_sequence table
great, thanks! On Mon, Jun 2, 2008 at 11:55 AM, Dennis Cote [EMAIL PROTECTED] wrote: Samuel Neff wrote: Were you able to successfully reproduce the corruption using the scripts and databases I sent? We're having a lot more trouble with this problem and our earlier workaround is proving troublesome in some situations. I think it has been fixed. See http://www.sqlite.org/cvstrac/tktview?tn=3148 for details. HTH Dennis Cote -- - We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer. Position is in the Washington D.C. metro area. Contact [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Corrupted sqlite_sequence table
On May 28, 2008, at 7:21 PM, Samuel Neff wrote: It happens every time. I can send you a db and the update scripts, but I'll need you to keep it confidential (not signed affidavit or anything like that, just understanding that it's confidential). Please confirm this is ok and also which address I should send it to (if other than the one you're using for this list). No one will see the database besides me. I will delete it once the bug is fixed. Send to the address below. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Corrupted sqlite_sequence table
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; nameseq -- -- Transactions2 ActiveTransaction 2 AnnotationIcons_History 21 TransactionSequences494 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. 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
Re: [sqlite] Corrupted sqlite_sequence table
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; nameseq -- -- Transactions2 ActiveTransaction 2 AnnotationIcons_History 21 TransactionSequences494 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