I have encountered a problem while attempting to execute some code with SQLite embedded. This code was working with the previous version of the source. I am developing a small framework to permit me to use the SQLite engine from within some Cocoa applications I am developing for personal use (managing team scores on a web site). I have created my own class structure for this and it was working, but when I upgraded to the 3.3.0 code and decided to test it before I added new features, I got an EXC_BAD_INSTRUCTION signal from the debugger when I attempt to step into the call to "sqlite3OsLock" procedure as noted in the call stack below. The statement I am executing at step 19 is

[theDatabase executeNonQuery:@"CREATE TABLE Table1(PKey INTEGER NOT NULL, Name VARCHAR(32) NOT NULL, BirthDate FLOAT NOT NULL, Relation VARCHAR NULL, PRIMARY KEY(PKey))"];

This statement has worked fine up until now! Does anyone have any idea why this may be the case?


#0      0x001a8ba4 in ??
#1      0x943e7e90 in sqlite3OsLock
#2      0x00216de0 in pager_wait_on_lock at pager.c:1969
#3      0x00217dcc in sqlite3pager_get at pager.c:2579
#4      0x0005e560 in getPage at btree.c:1450
#5      0x0005f430 in lockBtree at btree.c:1880
#6      0x0005fbf8 in sqlite3BtreeBeginTrans at btree.c:2087
#7      0x0005f7a8 in lockBtreeWithRetry at btree.c:1953
#8      0x00060f78 in sqlite3BtreeCursor at btree.c:2698
#9      0x0024556c in sqlite3InitOne at prepare.c:218
#10     0x00245a7c in sqlite3Init at prepare.c:353
#11     0x00245c34 in sqlite3ReadSchema at prepare.c:393
#12     0x00083e14 in sqlite3StartTable at build.c:790
#13     0x00228c6c in yy_reduce at parse.y:124
#14     0x0022bb14 in sqlite3Parser at parse.c:3221
#15     0x0027a5a8 in sqlite3RunParser at tokenize.c:391
#16     0x002462a8 in sqlite3_prepare at prepare.c:541
#17     0x000ea8dc in sqlite3_exec at legacy.c:56
#18 0x002f3fe0 in -[SQLiteDatabase executeNonQuery:] at SQLiteDatabase.m:224 #19 0x00032df0 in -[DirectoryManager createNewDatabase:] at DirectoryManager.m:62

Reply via email to