Re: [sqlite] Database locking issue

Lothar Behrens Sun, 28 Sep 2008 03:46:33 -0700

Hi,

now I have tried the actual version 3.6.3 as of sqlite- 
amalgamation-3.6.3.tgz, but still get database locks I cannot explain.


Brief information:

I use two database files. One (lbDMF.db3) for system informations such  
as what my application should show in forms
of a database (Template Designer.db3).

The system database therefore is required to store sql queries of the  
application database (Template Designer.db3).

Looking at the files after I have the lock situation (after a  
successfull close I also get a lock when reopened) I have determined
content in Template Designer.db3-journal that shows words (of columns  
or tables from lbDMF.db3.

How could it be, that there is content in that file that fas nothing  
to do with that database ?

Here is the content:

Ÿ’˘ °c◊öÃts/CPP/Test/GUI/wxWrapper/Template  
Designer 
.db3 
 
 
ö 
 
Ö 
 
V 
 
8 
 
 
 
¸ 
 
› 
æ 
 
ü 
 
Å 
 
c 
 
E 
 
. 
 
 
 
 
‡ 
¿ 
†åxdJ0ÚŒ™ãlM"3IdAnwendungsparameter! 
3idAnwendungsparameter  
 
 
 
3 
 
 
 
IDAnwendungsparameter 
 
" 
 
 
 
= 
 
 
 
IdFormularaktionenzuordnen 
 
" 
 
 
 
= 
 
 
 
idFormularaktionenzuordnen 
 
" 
 
 
 
= 
 
 
 
IDFormularaktionenzuordnen 
 
 
 
 
 
 
) 
 
 
IdUebersetzungen 
 
 
 
 
 
 
) 
 
 
idUebersetzungen 
 
 
 
 
 
 
) 
 
 
IDUebersetzungen 
 
 
 
 
 
 
 
 
 
 
IdAktionen 
 
 
 
 
 
 
 
 
 
idAktionenIDAktionen5IdAnwendungenFormulare
úÏÿƒ∞ú 
LiliLiliLiliLuluLuluLuluLoloLoloLoloLalaLalaLalaTestTestTestöÃ

The words Anwendungsparameter, Formularaktionenzuordnen,  
Uebersetzungen, Aktionen and AnwendungenFormulare are columns or  
tables from lbDMF.

I am confused !!

Also I could rename these files while the application claims they are  
locked.
(This happens while an update attempt I'll give a retry with a shortly  
closed database to get rid of the lock, but the lock remains)

Any hints are welcome.

Thanks,

Lothar

Am 19.09.2008 um 17:37 schrieb Lothar Behrens:

>
> Am 19.09.2008 um 17:03 schrieb Ken:
>
>> Try it with the latest full build say version 3.6.2 and see what
>> happens instead of a "patched"
>>
>
> I'll give that a try. Could the current code be compiled with Open
> Watcom as A DLL ?
> (I haven't seen these __declspec(dllexport) and the opposite stuff in
> the actual code)
>
> Lothar
>
>>
>
> -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
> Lothar Behrens
> Heinrich-Scheufelen-Platz 2
> 73252 Lenningen
>
>
>
>
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database locking issue

Reply via email to