Re: [sqlite] System.Data.SQLite and pooling problem

Greg Carter wrote: > > We recently upgraded to 1.0.80.0 from 1.0.77.0 and have found when we turn > connection pooling on we get seemingly random memory access violations that > happen in calls to UnsafeNativeMethods.sqlite3_busy_timeout ,call stack - > Open/SetTimeout (line 259 of SQLite3.cs).

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On Fri, Apr 27, 2012 at 7:04 PM, Richard Hipp wrote: > On Fri, Apr 27, 2012 at 6:45 PM, Pavel Ivanov wrote: >> > If two database connections share the same cache, and one connection >> rolls >> > back, that means it will be changing cache content out from

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On Fri, Apr 27, 2012 at 6:45 PM, Pavel Ivanov wrote: > > If two database connections share the same cache, and one connection > rolls > > back, that means it will be changing cache content out from under the > other > > database connection, so any queries ongoing in the other

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

> The insert finishes before the select finishes, but the new row does not > show up > in the select either (not that I'm sure if it should or not, I guess that > might > be a dirty read). I'm not really sure if this is fully intended behavior or > not ... That's indeed an intended behavior for

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

> If two database connections share the same cache, and one connection rolls > back, that means it will be changing cache content out from under the other > database connection, so any queries ongoing in the other connection have to > abort. Richard, Could you please explain this? I understand

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On 04/27/2012 04:38 PM, Richard Hipp wrote: Disable shared cache mode and you should be good to go. If two database connections share the same cache, and one connection rolls back, that means it will be changing cache content out from under the other database connection, so any queries ongoing

Re: [sqlite] Using a select with 'where'

On 27 Apr 2012 at 22:16, Simon Slavin wrote: > On 27 Apr 2012, at 9:00pm, Tim Streater wrote: >> delete from addressbook where absid=(select personnick from grouplinks where >> groupnick='27') >> >> The 'select personnick ...' can return zero,

Re: [sqlite] Using a select with 'where'

On 27 Apr 2012, at 9:00pm, Tim Streater wrote: > > delete from addressbook where absid=(select personnick from grouplinks where > groupnick='27') > > The 'select personnick ...' can return zero, one, or many results, and I'd > like to have the 'delete from ...'

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On Fri, Apr 27, 2012 at 3:50 PM, Brad House wrote: > On 04/27/2012 02:00 PM, Brad House wrote: > >> >> Only the connection that does the rollback has its queries aborted. >>> >> >> That is not the behavior I am seeing in 3.7.11, but was the behavior >> I saw in 3.7.10. >> >>

Re: [sqlite] Using a select with 'where'

On 27 Apr 2012 at 21:03, Stephan Beal wrote: > On Fri, Apr 27, 2012 at 10:00 PM, Tim Streater wrote: > >> delete from addressbook where absid=(select personnick from grouplinks >> where groupnick='27') > > i think what you want is IN instead of =.

Re: [sqlite] Using a select with 'where'

On Fri, Apr 27, 2012 at 10:00 PM, Tim Streater wrote: > delete from addressbook where absid=(select personnick from grouplinks > where groupnick='27') > i think what you want is IN instead of =. -- - stephan beal http://wanderinghorse.net/home/stephan/

[sqlite] Using a select with 'where'

I'd like to delete multiple rows using the following syntax, but experiment appears to show that at most one row is deleted. I tried the following: delete from addressbook where absid=(select personnick from grouplinks where groupnick='27') The 'select personnick ...' can return zero, one,

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

Ok, I guess attachments don't come through. I've uploaded it here: http://www.brad-house.com/other/sqlite_test.c -Brad On 04/27/2012 03:50 PM, Brad House wrote: On 04/27/2012 02:00 PM, Brad House wrote: Only the connection that does the rollback has its queries aborted. That is not the

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On Fri, Apr 27, 2012 at 3:50 PM, Brad House wrote: > > > As promised, I've attached a test case which uses the SQLITE amalgamation. > The mailing list strips attachments. Send us a link, instead. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On 04/27/2012 02:00 PM, Brad House wrote: Only the connection that does the rollback has its queries aborted. That is not the behavior I am seeing in 3.7.11, but was the behavior I saw in 3.7.10. If you are seeing other connections get queries aborted, that is something new that I have not

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug??

Only the connection that does the rollback has its queries aborted. That is not the behavior I am seeing in 3.7.11, but was the behavior I saw in 3.7.10. If you are seeing other connections get queries aborted, that is something new that I have not seen before and will need to investigate.

[sqlite] Replying to posts here, threaded [was: SQLITE3 64-bit version]

Gabriel Corneanu (and others) ask: Off-topic: what do I need to do for a proper reply?? If your email client is setup to handle 'mailto:' URLs, clicking on the one just to the right of the poster's name will initiate a reply which has the 'Subject' and 'In-Reply-To' headers filled in. The

Re: [sqlite] System.Data.SQLite and pooling problem

Greg Carter, on Fri Apr 27, wrote: We recently upgraded to 1.0.80.0 from 1.0.77.0 and have found when we turn connection pooling on we get seemingly random memory access violations that happen in calls to UnsafeNativeMethods.sqlite3_busy_timeout ,call stack - Open/SetTimeout (line 259 of

[sqlite] System.Data.SQLite and pooling problem

We recently upgraded to 1.0.80.0 from 1.0.77.0 and have found when we turn connection pooling on we get seemingly random memory access violations that happen in calls to UnsafeNativeMethods.sqlite3_busy_timeout ,call stack - Open/SetTimeout (line 259 of SQLite3.cs). After compiling SQLite debug

Re: [sqlite] SQLITE3 64-bit version

On 27.04.2012 15:08, Gabriel Corneanu wrote: > With the amalgamation, it's also quite easy to compile to one obj and > link directly in Delphi (similar to jpeg; that's probably what you also > do). No pun intended, why should I pay for it? - DISQLite3 Personal edition if free! - DISQLite3 is

Re: [sqlite] SQLITE3 64-bit version

Off-topic: what do I need to do for a proper reply?? Depends on your email client (I see you are using Opera Mail which I don't know). In general it should include the "In-Reply-To" and "References" header. Mircea On 27/04/2012 9:08 AM, Gabriel Corneanu wrote: I read about it, but I prefer

Re: [sqlite] Problem with insert

I needed some practice this morning to get my juju going...code could be modularized a bit...I'll leave that exercise for the student...in particular, the rc checking could be a function: checkerr(rc,SQLITE_OK,"Insert error: "); Or fancier yet with varargs According to your data you

Re: [sqlite] SQLITE3 64-bit version

I read about it, but I prefer to use dll binding. With the amalgamation, it's also quite easy to compile to one obj and link directly in Delphi (similar to jpeg; that's probably what you also do). No pun intended, why should I pay for it? Off-topic: what do I need to do for a proper reply??

Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

On Fri, Apr 27, 2012 at 1:31 AM, nn6eumtr wrote: > In response to Stepheen Beal's previous comments I do understand that not > all combinations of -DSQLITE_OMIT statements will work, and past experience > has shown its usually because the dependencies between the various

[sqlite] [solution] - Re: Possible bug when rebuilding amalgamation without triggers or altertable

I looked into the problem more tonight and found all of the references to the omitted functions were from the auto-generated parser. I looked at the parser source and it was checking for omits in all the right places so the functions should have have been referenced. I checked the Makefile and

Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

In response to Stepheen Beal's previous comments I do understand that not all combinations of -DSQLITE_OMIT statements will work, and past experience has shown its usually because the dependencies between the various options are not clear in the documentation. However someone has invested the

[sqlite] the xRead method in sqlite3_io_methods

We should add a new output argument for xRead method which is in sqlite3_io_methods structure like this: int (*xRead)(sqlite3_file*, void*, int iAmt, sqlite3_int64 iOfst, int* piRealAmt); The new 'piRealAmt' could be used to report the actual read data, this argument will greatly boost the

Re: [sqlite] Problem with insert

Thanks for your suggestion.. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with insert

On 27 Apr 2012, at 12:36pm, Bageesh.M.Bose wrote: > so how can i do thai in c? > can you please tell me... Sorry that would be a lesson in how to manipulate text strings in C. It doesn't have much to do with SQLite. I cannot train you to be a C programmer. Simon.

Re: [sqlite] Problem with insert

so how can i do thai in c? can you please tell me... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with insert

On 27 Apr 2012, at 12:25pm, "Bageesh.M.Bose" wrote: > Thanks for your attention sir.. > > I tried ".import stock.txt myStockTable" > But in c it shows some errors... This is not a C command. It it not part of the SQLite library. It is interpreted by the shell tool

Re: [sqlite] Problem with insert

On 27 Apr 2012, at 5:58am, "Bageesh.M.Bose" wrote: > I have a file named "stock.txt" with datas seperated by "|" symbol.I want > insert these datas into a table named "stock".How can i do this in c(in > linux) with sqlite. If you want to write the program yourself, you

Re: [sqlite] SQLITE3 64-bit version

On 27.04.2012 11:38, Gabriel Corneanu wrote: > There is one more reason to use DLLs, I'm surprised noone mentioned it. > What if you don't use C??? (I use myself Delphi with a header conversion). DISQLite3 compiles right into your Delphi application. Both 32-bit and 64-bit supported:

Re: [sqlite] SQLITE3 64-bit version

There is one more reason to use DLLs, I'm surprised noone mentioned it. What if you don't use C??? (I use myself Delphi with a header conversion). Gabriel -- Using Opera's revolutionary email client: http://www.opera.com/mail/ ___ sqlite-users mailing

Re: [sqlite] EXT :Re: Re Query planner creating a slow plan

Black, Michael (IS) wrote, On 26/04/12 22:40: I must be blind (something my wife would agree with)...but I did use "order by transfer_date"the "asc" making no difference. Not at all. What you posted was the slow plan. The three queries that show the planner's behaviour are: 1) sqlite>