Re: [sqlite] Database gets locked for other processes

2013-11-02 Thread Israel Lins Albuquerque
I know well the qt sqlite to say, maybe you aren't destroing the QSqlQuery class or simple call finish function, and the statement is openned helding the lock! Enviado via iPhone > Em 29/10/2013, às 10:51, Stephan Beal escreveu: > >> On Tue, Oct 29, 2013 at 1:52 PM,

Re: [sqlite] Database gets locked for other processes

2013-10-29 Thread jose isaias cabrera
"Martin Kropfinger" Am Tue, 29 Oct 2013 12:00:02 -0400 schrieb sqlite-users-requ...@sqlite.org: Date: Tue, 29 Oct 2013 14:51:08 +0100 From: Stephan Beal <sgb...@googlemail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite

Re: [sqlite] Database gets locked for other processes

2013-10-29 Thread Martin Kropfinger
Am Tue, 29 Oct 2013 12:00:02 -0400 schrieb sqlite-users-requ...@sqlite.org: > Date: Tue, 29 Oct 2013 14:51:08 +0100 > From: Stephan Beal <sgb...@googlemail.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] Database gets lo

Re: [sqlite] Database gets locked for other processes

2013-10-29 Thread Stephan Beal
On Tue, Oct 29, 2013 at 1:52 PM, Martin wrote: > The program is running on Windows7. > ... The program runs parallel on multiple machines all sharing the same > SQLite-Database-file. Connecting multiple clients over a network share is a sure-fire way to corrupt your

Re: [sqlite] Database gets locked for other processes

2013-10-29 Thread Richard Hipp
Sounds like something changed in Qt 5.1.1 so that it is holding open a read transaction. The first process acquires the read transaction, which permits other processes to read but prevents anybody else from writing. I have no idea why Qt would do this, though. You can change to WAL mode, which

[sqlite] Database gets locked for other processes

2013-10-29 Thread Martin
Hi there! I have a program written in Qt and using the SQLite-drivers shipped with Qt. AFAIK those are the original SQLite-drivers. The program is running on Windows7. Originally the program was written using Qt4.8 (which came with SQLite 3.7.14.1). The program runs parallel on multiple machines