-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

every now and then - very hard to reproduce - I get the SQLite error
"malformed database schema" (error code 1). This happens when running
lots of schema-changing statements after another and seems to occur
only on systems with a very fast hard-disk (SSD).
Fortunately, the database seems to be ok, i.e. everything works fine
after closing and re-opening the file and re-issuing the statement.
This is with in-memory temp database, WAL and PRAGMA synchronous=NORMAL.
The statements (schema migrations) are grouped into blocks where each
starts with a BEGIN EXCLUSIVE TRANSACTION and ends with committing the
transaction.

Maybe someone else had this problem or has an idea how it may be caused?

All the best
Marcus
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJQ9SZaAAoJELuOTdgGQnyZIh4H/RJtoJl9p1GEz3BP31qvF0eF
w8jBxNoIhjAcGGA5reVF0BtLyn2mklQqCIkZJG2F5/yKTxepRo7jcsJiPi2imfw+
r+AWO9rOREhxiXq35F3FxS4kFavXX1BCzelY4WnP1knZbvZiCKSBRSqJmn4cM09W
8LLb6PY62WWyd9smTGmNtkV8JlmPHvrNkzTIs3KuICDIB/yM/epM9f1Huu/nNrhS
+Go17P1oSqPaD9MlzErdvY6eOT9T8l+cRHYvOfJYhcJ71C3O6qpMsoAJVZ/eVsa0
Qwbph6z+j4Bw5GwnHYmpIsCb6T3ouYncURIjuY4WOn4hE8bjmK47ya4hr8iYO6s=
=I7Bc
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to