Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
[EMAIL PROTECTED] wrote: > The attachment size limitation of the bug report is 100k :( I'm sorry about the late follow up, but I have been away for a while. Can you contact me off list to see about transferring the compressed database so I can use it to look into the problem? Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
The attachment size limitation of the bug report is 100k :( - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Thursday, May 15, 2008 9:49 PM Subject: Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation > [EMAIL PROTECTED] wrote: >> >> My DB file is too big, how can I provide it to your guys? > > You said a compressed copy of the database file is 18M. > > One possibility is to create a bug report ticket at > http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew and attach the > compressed database file to the bug report. Then it would be available > to anyone who needs to look at it. I don't think there is a limitation > on the size of an attached file, but I could be wrong. > >> Even the DB is damaged, sqlite should return an fault result instead of >> crashing, shouldn't it? >> > > You are correct, it should not crash. That's why it is important to get > a copy of the database that is causing the problem so that it can be > used to find the bug. > > Dennis Cote > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
[EMAIL PROTECTED] wrote: > > My DB file is too big, how can I provide it to your guys? You said a compressed copy of the database file is 18M. One possibility is to create a bug report ticket at http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew and attach the compressed database file to the bug report. Then it would be available to anyone who needs to look at it. I don't think there is a limitation on the size of an attached file, but I could be wrong. > Even the DB is damaged, sqlite should return an fault result instead of > crashing, shouldn't it? > You are correct, it should not crash. That's why it is important to get a copy of the database that is causing the problem so that it can be used to find the bug. Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
[EMAIL PROTECTED] wrote: > > Maybe the database has been damaged. Possibly. > > The shcema of table "CarImages" is : > CREATE TABLE CarImages( > CarID char(32) NOT NULL, > CarNumber char(20) NULL, > OpTime datetime NOT NULL , > TSCode char(6) NOT NULL, > LaneNum int NOT NULL, > PicBigPlate Long null, > PicSmallPlate Long null, > PicBlackWhitePlate Long null, > PicLane Long null, > Constraint CarImages_Key Primary Key (CarID) > ); > The only thing I see here is that you have mixed the syntax for a column def constraint and a table constraint. You should use either a variation with a column definition with a column constraint (which can accept a constraint name clause); CREATE TABLE CarImages( CarID char(32) NOT NULL Constraint CarImages_Key Primary Key, CarNumber char(20) NULL, OpTime datetime NOT NULL , TSCode char(6) NOT NULL, LaneNum int NOT NULL, PicBigPlate Long null, PicSmallPlate Long null, PicBlackWhitePlate Long null, PicLane Long null ); or a variation with a table constraint definition (which does not allow for a constraint name); CREATE TABLE CarImages( CarID char(32) NOT NULL, CarNumber char(20) NULL, OpTime datetime NOT NULL , TSCode char(6) NOT NULL, LaneNum int NOT NULL, PicBigPlate Long null, PicSmallPlate Long null, PicBlackWhitePlate Long null, PicLane Long null, Primary Key (CarID) ); SQLite does accept the table definition as you have it written without any error messages, but it does not agree with the documentation. So there is either an error in the documentation or in the parser. You may want to file a bug report for this issue. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
The sqlite3_analyzer-3_5_4 also crash when analyzing my DB: AppName: sqlite3_analyzer.exe AppVer: 0.0.0.0 ModName: sqlite3_analyzer.exe ModVer: 0.0.0.0 Offset: 00028c72 sqlite3 (3.5.9) crash when excute "PRAGMA integrity_check": AppName: sqlite3.exe AppVer: 0.0.0.0 ModName: sqlite3.exe ModVer: 0.0.0.0 Offset: d17e My DB file is too big, how can I provide it to your guys? Even the DB is damaged, sqlite should return an fault result instead of crashing, shouldn't it? - Original Message - From: "Teg" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, May 14, 2008 10:17 PM Subject: Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation > Hello qinligeng, > > Wednesday, May 14, 2008, 12:58:32 AM, you wrote: > > q1c> When I execute sql statement "delete from Carimages where OpTime > q1c> <'2008-05-01 00:00:00'" in my database, sqlite3 crashed. > q1c> The Exception Information reported by XP is: > q1c> Code: 0xc005 Flags:0x > q1c> Record: 0x Address: 0x00406652 > > q1c> The sqlite3.exe is downloaded from > q1c> http://www.sqlite.org/sqlite-3_5_8.zip > q1c> The database file is to big ( about 600M, after compressed by > q1c> WinRAR, the size is 18M), so I can't upload here. > q1c> ___ > q1c> sqlite-users mailing list > q1c> sqlite-users@sqlite.org > q1c> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > I have a smallish DB that will do that here. It's interesting, the > commandline tool Sqlite3.exe simply reports it's damaged. The > statically linked version I use in my program will crash my program. I > traced it down to "sqlite_step" but, no further. > > I'd try an integrity check on your DB. Mine's definitely damaged. > > > > -- > Best regards, > Tegmailto:[EMAIL PROTECTED] > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
I am sorry that I can not provide any sample records of the table because every time I acces the table sqlite will crash. exceute sql: select * from carimages limit 0,1; OK! exceute sql: select * from carimages limit 1,1; OK! exceute sql: select * from carimages limit 2,1; CRASH!! Maybe the database has been damaged. The shcema of table "CarImages" is : CREATE TABLE CarImages( CarID char(32) NOT NULL, CarNumber char(20) NULL, OpTime datetime NOT NULL , TSCode char(6) NOT NULL, LaneNum int NOT NULL, PicBigPlate Long null, PicSmallPlate Long null, PicBlackWhitePlate Long null, PicLane Long null, Constraint CarImages_Key Primary Key (CarID) ); - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, May 14, 2008 9:50 PM Subject: Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation > [EMAIL PROTECTED] wrote: >> When I execute sql statement "delete from Carimages where OpTime >> <'2008-05-01 00:00:00'" in my database, sqlite3 crashed. >> The Exception Information reported by XP is: >> Code: 0xc005 Flags:0x >> Record: 0x Address: 0x00406652 >> >> The sqlite3.exe is downloaded from http://www.sqlite.org/sqlite-3_5_8.zip >> The database file is to big ( about 600M, after compressed by WinRAR, the >> size is 18M), so I can't upload here. > > Please don't hijack other threads. > http://en.wikipedia.org/wiki/Thread_hijacking > > What is the schema of Carimages table? Can you provide a couple of > sample records instead of the entire database? > > Dennis Cote > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!!! sqlite 3.5.8 crash: access violation
[EMAIL PROTECTED] wrote: > When I execute sql statement "delete from Carimages where OpTime <'2008-05-01 > 00:00:00'" in my database, sqlite3 crashed. > The Exception Information reported by XP is: > Code: 0xc005 Flags:0x > Record: 0x Address: 0x00406652 > > The sqlite3.exe is downloaded from http://www.sqlite.org/sqlite-3_5_8.zip > The database file is to big ( about 600M, after compressed by WinRAR, the > size is 18M), so I can't upload here. Please don't hijack other threads. http://en.wikipedia.org/wiki/Thread_hijacking What is the schema of Carimages table? Can you provide a couple of sample records instead of the entire database? Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Help!!! sqlite 3.5.8 crash: access violation
When I execute sql statement "delete from Carimages where OpTime <'2008-05-01 00:00:00'" in my database, sqlite3 crashed. The Exception Information reported by XP is: Code: 0xc005 Flags:0x Record: 0x Address: 0x00406652 The sqlite3.exe is downloaded from http://www.sqlite.org/sqlite-3_5_8.zip The database file is to big ( about 600M, after compressed by WinRAR, the size is 18M), so I can't upload here. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
