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
> 

Reply via email to