System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
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 ^^