Re: [sqlite] SQLITE_LOCKED and SQLITE_BUSY

On 29 Nov 2018, at 11:35am, Prajeesh Prakash wrote: > I am writing to a table 1 and reading from table 2 both operation are from > different DB connection i am getting SQLITE_LOCKED SQLite locks the entire database. It does not lock each table independently. > and when i try to read and writ

Re: [sqlite] SQLITE_LOCKED and SQLITE_BUSY

Hi Team, I am writing to a table 1 and reading from table 2 both operation are from different DB connection i am getting SQLITE_LOCKED and when i try to read and write the same table from different connection i am getting same error. (I know read and write are the incompatible at same time). W

Re: [sqlite] SQLITE_LOCKED and SQLITE_BUSY

t there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Prajeesh Prakash >Sent: Wednesday, 28 November, 2018 08:36 >To

[sqlite] SQLITE_LOCKED and SQLITE_BUSY

Hi members, The SQLITE_LOCKED error will happen on same database connection when two thread trying to do read/write operation at same time. SQLITE_BUSY will get when one thread on one connection is doing read/write operation and another thread on another connection trying to read/write the DB.