SQLite Forum

Error: database disk image is malformed for every large database after a few SELECT instruction
Login
sqlite> pragma integrity_check;

^CError: interrupted

sqlite> EXPLAIN QUERY PLAN

   ...> select count(*) from combination7 where amylogen < 0.5;

QUERY PLAN

`--SEARCH TABLE combination7 USING COVERING INDEX id_amylogen (amylogen<?)

sqlite> EXPLAIN

   ...> select count(*) from combination7 where amylogen < 0.5;

addr  opcode         p1    p2    p3    p4             p5  comment      

----  -------------  ----  ----  ----  -------------  --  -------------

0     Init           0     13    0                    00  Start at 13  

1     Null           0     1     1                    00  r[1..1]=NULL 

2     OpenRead       1     35847181  0     k(2,,)         00  root=35847181 iDb=0; 
id_amylogen

3     Null           0     2     0                    00  r[2]=NULL    

4     SeekGT         1     9     2     1              00  key=r[2]     

5     Real           0     2     0     0.5            00  r[2]=0.5     

6       IdxGE          1     9     2     1              00  key=r[2]     

7       AggStep        0     0     1     count(0)       00  accum=r[1] step(r[0])

8     Next           1     6     0                    00               

9     AggFinal       1     0     0     count(0)       00  accum=r[1] N=0

10    Copy           1     3     0                    00  r[3]=r[1]    

11    ResultRow      3     1     0                    00  output=r[3]  

12    Halt           0     0     0                    00               

13    Transaction    0     0     15    0              01  usesStmtJournal=0

14    Goto           0     1     0                    00

Error still is here:

sqlite> select count(*) from combination7 where amylogen < 0.5;

Error: database disk image is malformed

I will setup a user and login tomorrow (can you use teamviewer?)

Thank you so much for your help.

Best

Witek