Re: [sqlite] Problem with many connections

On 2014/07/03 14:05, Simon Slavin wrote: On 3 Jul 2014, at 8:47am, Hick Gunter wrote: This function is already available in the sqlite3 C interface. I did not understand that at all. I have never needed to look at that statement. But yes, it does allow you to find out

Re: [sqlite] Problem with many connections

On 3 Jul 2014, at 8:47am, Hick Gunter wrote: > This function is already available in the sqlite3 C interface. I did not understand that at all. I have never needed to look at that statement. But yes, it does allow you to find out if there are any open statements for a

Re: [sqlite] Problem with many connections

On Wed, 02 Jul 2014 17:03:43 +0100, Grzegorz Sikorski wrote: > Hi Hick, > > You were right I was not finalizing statements and this prevented close > to complete. When I modified my code to finalize all statements before > close it works fine. > > However I was always

Re: [sqlite] Problem with many connections

: General Discussion of SQLite Database Betreff: Re: [sqlite] Problem with many connections On 3 Jul 2014, at 8:24am, Hick Gunter <h...@scigames.at> wrote: > How about this? > > > sqlite3_stmt *sqlite3_next_stmt(sqlite3 *pDb, sqlite3_stmt *pStmt); > > This interface returns a

Re: [sqlite] Problem with many connections

On 3 Jul 2014, at 8:24am, Hick Gunter wrote: > How about this? > > > sqlite3_stmt *sqlite3_next_stmt(sqlite3 *pDb, sqlite3_stmt *pStmt); > > This interface returns a pointer to the next prepared statement after pStmt > associated with the database connection pDb. If pStmt

Re: [sqlite] Problem with many connections

. -Ursprüngliche Nachricht- Von: Simon Slavin [mailto:slav...@bigfraud.org] Gesendet: Mittwoch, 02. Juli 2014 18:18 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Problem with many connections On 2 Jul 2014, at 5:03pm, Grzegorz Sikorski <g.sikor...@kelvatek.com> wrote: >

Re: [sqlite] Problem with many connections

Grzegorz Sikorski wrote: > Hi Hick, > > You were right I was not finalizing statements and this prevented close to > complete. When I modified my code to finalize all statements before close it > works fine. This implies that you have not checked your application with

Re: [sqlite] Problem with many connections

On Wed, 2 Jul 2014 17:18:23 +0100 Simon Slavin wrote: > I hope SQLite4 changes this and if there are statements still open > either returns an error code or automatically closes any open > statements. Or both. Me too. I can't think of any other application I use that

Re: [sqlite] Problem with many connections

On Wed, 02 Jul 2014 15:50:58 +0100 Grzegorz Sikorski wrote: > > 1020 simultaneus connections? Perhaps iOS exhausted del max. file > > descriptor per process. > 1020 is the number of open operations. Number of connections opened > at the same time is much lower (2-3). If

Re: [sqlite] Problem with many connections

On 2 Jul 2014, at 5:03pm, Grzegorz Sikorski wrote: > I admit I had missed this sentence, but to be honest, it seems to be very > confusing behaviour. I'm glad you have found the problem. It's not good and I don't think this is a good way to handle things. I hope

Re: [sqlite] Problem with many connections

Is there a lsof command or a /proc filesystem or equivalent? -Ursprüngliche Nachricht- Von: Grzegorz Sikorski [mailto:g.sikor...@kelvatek.com] Gesendet: Mittwoch, 02. Juli 2014 13:02 An: sqlite-users@sqlite.org Betreff: [sqlite] Problem with many connections Hi, I am not sure if my previo

Re: [sqlite] Problem with many connections

eturn status, thus missing SQLite having a lot of open files. Is there a lsof command or a /proc filesystem or equivalent? -Ursprüngliche Nachricht- Von: Grzegorz Sikorski [mailto:g.sikor...@kelvatek.com] Gesendet: Mittwoch, 02. Juli 2014 13:02 An: sqlite-users@sqlite.org Betreff: [sqlit

Re: [sqlite] Problem with many connections

Eduardo Morras wrote: > On Wed, 02 Jul 2014 12:02:27 +0100 > Grzegorz Sikorski wrote: > >> Hi, >> >> I am not sure if my previous email had reached the list, so I just >> repeat it: >> >> I am developing sharding database using SQLite3 for embedded >>

Re: [sqlite] Problem with many connections

On 02/07/14 15:41, Eduardo Morras wrote: On Wed, 02 Jul 2014 12:02:27 +0100 Grzegorz Sikorski wrote: Hi, I am not sure if my previous email had reached the list, so I just repeat it: I am developing sharding database using SQLite3 for embedded application. My code

Re: [sqlite] Problem with many connections

On 2 Jul 2014, at 1:00pm, Grzegorz Sikorski wrote: > On 02/07/14 12:20, Simon Slavin wrote: >> On 2 Jul 2014, at 12:02pm, Grzegorz Sikorski wrote: >> >>> My code works fine up to about 1020 connections to the database. After >>> around this

Re: [sqlite] Problem with many connections

On Wed, 02 Jul 2014 12:02:27 +0100 Grzegorz Sikorski wrote: > Hi, > > I am not sure if my previous email had reached the list, so I just > repeat it: > > I am developing sharding database using SQLite3 for embedded > application. My code works fine up to about 1020

Re: [sqlite] Problem with many connections

On 02/07/14 12:20, Simon Slavin wrote: On 2 Jul 2014, at 12:02pm, Grzegorz Sikorski wrote: My code works fine up to about 1020 connections to the database. After around this number, I get an error "unable to open database file". [snip] This should not happen. But I

Re: [sqlite] Problem with many connections

On 2 Jul 2014, at 12:02pm, Grzegorz Sikorski wrote: > My code works fine up to about 1020 connections to the database. After around > this number, I get an error "unable to open database file". [snip] This should not happen. But I don't know why it would happen. I

[sqlite] Problem with many connections

Hi, I am not sure if my previous email had reached the list, so I just repeat it: I am developing sharding database using SQLite3 for embedded application. My code works fine up to about 1020 connections to the database. After around this number, I get an error "unable to open database file".