Re: [sqlite] processes stuck on database locked

2012-03-08 Thread Mikołaj Radwan
n't proceed with its transaction because there's RESERVED lock on it. To continue you have to rollback transaction in the second process and start it over again. Another option is to start IMMEDIATE transaction in the second process to avoid this course of action altogether. Pavel 20

[sqlite] processes stuck on database locked

2012-03-07 Thread Mikołaj Radwan
Hi all, For a couple days now I've been trying to figure out this problem and can't seem to manage. I have two processes, both of which connect to the same SQLite database and do the following: process 1: # opens database PRAGMA foreign_keys = ON; PRAGMA journal_mode = PERSIST; INSERT INTO som