Ticket Hash: | ec17f31f2ecf090f38943dd5f3e374575cd42cba | |||
Title: | Database base disk is malformed | |||
Status: | Closed | Type: | Incident | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Native_Assembly | Resolution: | External | |
Last Modified: | 2017-10-16 03:07:06 | |||
Version Found In: | 1.105.2 | |||
User Comments: | ||||
anonymous added on 2017-10-02 14:40:59:
(text/x-fossil-plain)
Hello, I got 1 issue and 2 questions 1) We were working with an old version of System.data.sqlite.dll (1.0.66) wicj was prety stable. But we needed to work with concat index (CREATE INDEX IDX ON TABLE_1 (FIELD1 || FIELD2) to upgrade performance. Since we changed the dll we often got a Database base disk is malformed issue. We can repair the base via an sql dump of the base. The issue itself is never exactly the same : we can have a duplicate TRIGGER or TABLE or sometimes INSERT INTO with non valide data. That's crazy. We tried to change the DROP / CREATE code. Catchall exception and close connections... But the issue is still here and worst of all it happend randomly ! 2) does someone know when the index concatenation feature has been released ? (to try with the oldest version of System.data.sqlite.dll compatible) 3) Is there a way to get the old version of dll witout having to recompile the source code ? Many thanks !!(we're getting nuts so help will be really appreciate ^^) Cheers Regards mistachkin added on 2017-10-02 15:31:57: (text/x-fossil-plain) Without more details, it will be difficult to diagnose this issue. It may be better to discuss this on the "sqlite-users" mailing list: [/doc/trunk/www/support.wiki] anonymous added on 2017-10-03 10:16:11: (text/x-fossil-plain) Hi, ok it's done ty ^^ |