Re: [sqlite] Malformed schema (orphan index) on particular db with the version 3.27.2

On 16 Mar 2019, at 9:34am, Max Vlasov wrote: > So I suspect that the file is a very rare example of inconsistency of data > not compatible with recent version, but working with older ones. Integrity-checking has been improved since 3.26.0. Newer versions of SQLite check for types of

Re: [sqlite] Malformed schema (orphan index) on particular db with the version 3.27.2

I noticed I replied directly to drh with the integrity_check answer So I repeat the information here PRAGMA integrity_check in 3.26.0 says *** in database main *** Page 3 is never used { skipped about 20 lines } Page 268 is never used Additional information: - My logic behind the opening

Re: [sqlite] Malformed schema (orphan index) on particular db with the version 3.27.2

On 3/15/19, Max Vlasov wrote: > > But 3.27.2 said > malformed database schema ({sqlite_autoindex_mytablename}_1) - orphan > index. This error message arises from enhanced early detection of corrupt database files that was added to version 3.27.x. Do you still have the original database,

[sqlite] Malformed schema (orphan index) on particular db with the version 3.27.2

Hi, I have a database that used in software since probably 2010, there are many variants of this database at my hd and everything was fine with it starting 3.6.10 through 3.26.00, I'm not sure about every version, but during the version history, at least several was used to open it. But 3.27.2