Any idea why "SQL error: database is locked" why this comesup?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tvnaidu
    Contributor
    • Oct 2009
    • 365

    Any idea why "SQL error: database is locked" why this comesup?

    Any idea why "SQL error: database is locked" why this comesup? using sqlite3 database here.
  • weaknessforcats
    Recognized Expert Expert
    • Mar 2007
    • 9214

    #2
    I would guess that there is another query in progress.

    Comment

    • ycoerohan
      New Member
      • Jan 2010
      • 5

      #3
      please write down your code here and do look the way u r opening the database in c language .
      i believe that you must be trying to open the already opened database that is why u r facing such problem

      Comment

      • johny10151981
        Top Contributor
        • Jan 2010
        • 1059

        #4
        The thing I have faced before is
        1. opening a connection by locking table or database but didnt close
        2. Then Try to reopen from somewhere else but table or database is still lock.

        what to do: check carefully what connection you have opened with lock criteria and make sure to close them. or open those connection without locking.

        And of course it would be better if you submit your code here.

        Regards,
        Johny

        Comment

        Working...