sqlite database lock problem

Question

4.67/5 (2 votes)

See more:

i am developing an app with sqlite. i keep getting database is lock when i try to add data to the database sometimes. here is the pseudo cod am using

        Try
Dim conn As SQLiteConnection = New SQLiteConnection("Data Source=" & dbPath)
            conn.SetPassword(dbPassword)
            conn.Open()
            Dim cmd As SQLiteCommand = New SQLiteCommand(conn)
            cmd.CommandText = "Select * From directory WHERE url = '" & sUrl & "'"
            Dim reader As SQLiteDataReader = cmd.ExecuteReader()
            Return reader.HasRows 
 reader.Close()
        Catch ex As Exception
            strLastError = ex.Message
            Debug.Print(strLastError)
            Return False
        Finally
           
            conn.Close()
        End Try

the suggestion i have got so far is to make sure i dispose the command object 'cmd', connection 'con' and reader properly before exiting the function

how do i do this in this case, as this current code which i tried to modify gives error.

Posted 1-Jun-11 10:10am

Cool Smith

Add a Solution

Comments

Orcun Iyigun 1-Jun-11 17:11pm

can you able to read but cant write?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Orcun Iyigun** · Accepted Answer · 2011-06-01T12:11:00

So you wrote that sometimes you get this database error. The reasons for getting the database lock error are;
SQLITE_LOCKED error is distinct from SQLITE_BUSY . SQLITE_BUSY means that another database connection (probably in another process) is using the database in a way that prevents you from using it. SQLITE_LOCKED means the source of contention is internal and comes from the same database connection that received the SQLITE_LOCKED error.

Sother reasons are for getting an SQLITE_LOCKED error:

*Trying to CREATE or DROP a table or index while a SELECT statement is still pending.
Sometimes people think they have finished with a SELECT statement because sqlite3_step() has returned SQLITE_DONE. But the SELECT is not really complete until sqlite3_reset() or sqlite3_finalize() have been called.
*Trying to write to a table while a SELECT is active on that same table.
*Trying to do two SELECT on the same table at the same time in a multithread application, if sqlite is not set to do so.
*fcntl(3, F_SETLK call on DB file fails. This could be caused by an NFS locking issue, for example. One solution for this issue, is to move the database away, and copy it back so that it has a new Inode value.

Here[^] is a documentation of the possible states of locking in SQLite that you can gather info about it.