in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

v.1.0.46 breaks them all (Database file is locked)

Last post 11-25-2007 10:50 AM by Robert Simpson. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-23-2007 6:47 AM

    v.1.0.46 breaks them all (Database file is locked)

    My site was using v1.0.43. Worked like a charm and very fast.
    I decided to upgrade to v1.0.46.... worst mistake of my life (well not really but you get the idea).

    All I got as "Database file is locked" messages and a very slow site.

    I had to revert to v1.0.43.

    This really shouldn't happen, and if it's a design decision it should be explained somewhere (sorry if it is),
    but I can't seem to find anything wrong with my code, it doesn't leave connections hanging about and closes
    them as soon as possible every time. So I'm guessing this is a bug.

     

    My site works fine with v1.0.43 now, but still I think this should be fixed. 

  • 11-25-2007 10:50 AM In reply to

    Re: v.1.0.46 breaks them all (Database file is locked)

    You may be closing connections, but you're may not be disposing of your commands or data readers.

    However, I'm fixing these and several other issues for the next version ... Visual Studio 2008 coming out and all the 3.5.x changes in the SQLite engine have just added to my plate is all.

    Robert

     

Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems