Here is what the error looks like...
[1436] 25 Mar 16:24:24 OnEveryHour: Failure occurred while updating the
OneMonth table. Exception: System.Data.Odbc.OdbcException: ERROR [HY000]
database is locked (5)
What does the error code 5 stands for? Also I started getting the errors when I
started using transactions with my queries. I have 4 threads which create their
own connections to the DB. One thread access the DB every 10 seconds, another
every 5 minutes, another every hour and another every day. Even if the database
is locked because of one thread shouldnt it starts working again once the
database is done with that transaction? I'm doing all this from inside a
windows service. I found that once I started seeing the errors it does not
eventually correct itself like I'm expecting it to, but I have to restart the
service for it to work.
-Vin
_________________________________________________________________
Windows Live Hotmail is giving away Zunes.
http://www.windowslive-hotmail.com/ZuneADay/?locale=en-US&ocid=TXT_TAGLM_Mobile_Zune_V3
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
