I got the same errors where the python application would just crap out. For some time I thought it was a problem with apsw. I migrated to apsw frompysqlite.
I searched all over but then did a .dump of my database and recreated it and the error went away. Pretty scary though and I never received it with earlier versions of sqlite. --- Hugh Gibson <[EMAIL PROTECTED]> wrote: > Hi, > > Using PySQLite 2.0.4 I get a crash with the > following sequence, starting > from no database. If the page_size pragma is removed > it works OK. > Reproducible under Windows 2K and XP. Running Python > 2.4.1. > > > pragma short_column_names=0 > pragma full_column_names=0 > PRAGMA page_size = 8192 > CREATE TABLE Versions (sVersions Primary Key) > INSERT INTO Versions (sVersions) VALUES > ('NMUkO6Wev0IOhWL/WLPPiGRl > ') > SELECT * FROM sqlite_master WHERE type = 'table' AND > name = 'Versions' > SELECT * FROM Versions > CREATE TABLE General (sValue Text DEFAULT '',sType > Text DEFAULT '', > PRIMARY KEY > (sType)) > SELECT * FROM Versions > DELETE FROM Versions > INSERT INTO Versions (sVersions) VALUES > ('7WPylc1+LISbvuZMsrmvnWQ3OkdlbmVyYWxkMT > oxaTRlZWU= > ') > DELETE FROM Versions > INSERT INTO Versions (sVersions) VALUES > ('7WPylc1+LISbvuZMsrmvnWQ3OkdlbmVyYWxkMT > oxaTRlZWU= > ') > SELECT sType, sValue FROM General WHERE sType = > '_LastLogin' > Assertion failed: > &pPage->aData[pPage->pBt->pageSize]==(unsigned > char*)pPage, file btree.c, line 1166 > > This application has requested the Runtime to > terminate it in an unusual > way. > Please contact the application's support team for > more information. > > > Other failure reports include: > > Assertion failed: n==4-4*pPage->leaf, file btree.c, > line 601 > Assertion failed: pPage->leaf==0 || pPage->leaf==1, > file btree.c, line 599 > > Hugh Gibson >