SQLite Forum

Error: database disk image is malformed for every large database after a few SELECT instruction
Login
Schema:

CREATE TABLE combination7 (mer7 TEXT PRIMARY KEY, pop_ur50 DEFAULT 0, pop_dev_ur50 DEFAULT 0, pop_est DEFAULT 0, amylogen DEFAULT 0, pop_ur50_nr DEFAULT 0, pop_dev_ur50_nr DEFAULT 0);

CREATE INDEX id_pop on combination7(pop_ur50);

CREATE INDEX id_pop_dev on combination7(pop_dev_ur50);

CREATE INDEX id_pop_est on combination7(pop_est);

CREATE INDEX id_amylogen on combination7(amylogen);

CREATE INDEX id_pop_nr on combination7(pop_ur50_nr);

CREATE INDEX id_pop_dev_nr on combination7(pop_dev_ur50_nr);

CREATE INDEX id_pop_dev_amylog on combination7(pop_dev_ur50,amylogen);

CREATE INDEX id_pop_dev_nr_amylog on combination7(pop_dev_ur50_nr,amylogen);

/* No STAT tables available */

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

Error: database disk image is malformed

sqlite> pragma quick_check;

ok

sqlite> pragma integrity_check;

(still running)

Best regards,

Witek