sqlite problems on Mac OS X 10.4

[Jim Correia]

On Sep 6, 2005, at 4:57 AM, Matthias Andree wrote:

> Matthias Andree <matthias.andree at gmx.de> writes:
>
>> On Mon, 05 Sep 2005, Jim Correia wrote:
>>
>>> Literally a 0 byte file.
>>>
>>> BEGIN TRANSACTION;
>>> COMMIT;
>>>
>>> Looking at the source, it doesn't appear the tables are created
>>> unless the wordlists are opened for writing, which doesn't happen if
>>> we aren't registering or updating (if I am reading things  
>>> correctly.)
>>>
>>
>> Exactly. We have more user-friendly messages in the DB code. Not  
>> sure if
>> we can port that over to sqlite3.
>
> OK, done and committed to CVS.

Thanks for the fix. I grabbed the changes from CVS and applied/tested  
them here.

Any idea about the hangs in t.lock3? (Should I just stick with bdb  
for now?)

When the tests hang it looks like all the processes have similar  
backtraces:

#0  0x9001efe8 in select ()
#1  0x00016284 in bf_sleep (delay=909804) at system.c:57
#2  0x0000e07c in rand_sleep (min=1000, max=1000000) at rand_sleep.c:20
#3  0x00015848 in busyhandler (dummy=0x4, count=0) at  
datastore_sqlite.c:245
#4  0x9436b188 in sqlite3pager_pagecount ()
#5  0x9436be08 in sqlite3pager_begin ()
#6  0x94352f50 in sqlite3BtreeBeginTrans ()
#7  0x9437caf4 in sqlite3VdbeExec ()
#8  0x9437f26c in sqlite3_step ()
#9  0x94385a0c in sqlite3_exec ()
#10 0x000154c0 in sqlexec (db=0x4, cmd=0x27ce8 "BEGIN EXCLUSIVE  
TRANSACTION;") at datastore_sqlite.c:144
#11 0x00015dec in db_open (dummyenv=0x4, bfp=0x500220, mode=DS_WRITE)  
at datastore_sqlite.c:313
#12 0x0000d654 in ds_open (dbe=0x4, bfp=0x0, open_mode=DS_WRITE) at  
datastore.c:157
#13 0x0000cb04 in open_wordlists (mode=DS_WRITE) at wordlists.c:120
#14 0x0000a11c in bogomain (argc=8, argv=0xbffff7a0) at bogomain.c:60
#15 0x000033c4 in main (argc=8, argv=0xbffff7a0) at main.c:30

I do see this in the SQLite bug tracker. I don't know if it is relevant.

http://www.sqlite.org/cvstrac/tktview?tn=263,2

Thanks,
Jim