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 includes querying Pragma encoding. So the
error message in question appear on this particular query and not when the
db is opened.
- Today I made a full scan of folder that might contain sqlite bases (based
on excluding obvious files with non-db extensions and checking the rest for
the starting sequence) and within hundreds of sqlite bases (some of them
though are identical backups), only this one and derivatives reveals the
error when performing the PRAGMA on them.
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.
Max
On Fri, 15 Mar 2019 at 18:00, Richard Hipp <d...@sqlite.org> wrote:
> On 3/15/19, Max Vlasov <max.vla...@gmail.com> 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, before you VACUUM-ed it? If so, what does it
> say if you run "PRAGMA integrity_check" on that database.
>
> Can you share the database with me, through private email? There is
> always the possibility that the enhanced early detection of corrupt
> databases is giving a false-positive.
>
> --
> D. Richard Hipp
> d...@sqlite.org
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
