Re: [sqlite] Unique Constraint Failed

where count < 2. That will filter the dups or count > 1 to find the dups. Lyle Ward On 2018-09-14 16:05, Simon Slavin wrote: On 14 Sep 2018, at 8:56pm, Andrew Stewart wrote: CREATE TABLE dataStreamRecord ( fwParameterID INTEGER NOT NULL, dateTime INTEGER NOT NULL, data I

[sqlite] Data view mismatch on first OpenWRT startup

ile offsets for housekeeping -- but is there anything else in there that could break if the DB file it was tracking was secretly and transparently moved from one volume to another? Or do you have any other conjecture? Thanks -- Ward ___ sqlite-us

Re: [sqlite] keys

are known to have a relationship even though the content that identifies this relation is not known. Lyle Ward Genealogist ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sq

[sqlite] keys

incomplete, and fuzzy. Two records are known to have a relationship even though the content that identifies this relation is not known. Lyle Ward Genealogist ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-b

Re: [sqlite] SQLite version 3.21.0 in approximately two weeks

> On Oct 11, 2017, at 4:26 AM, Richard Hipp wrote: > > A summary of changes for the 3.21.0 release can be seen at > >https://sqlite.org/draft/releaselog/3_21_0.html Item #5: "A forger can subverted" ==> "A forger can subvert"

Re: [sqlite] Corrupt index == disk full?

> On May 10, 2017, at 10:49 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 May 2017, at 6:31pm, Ward WIllats <sqlite-us...@wardco.com> wrote: > >> I guess with corruption, all bets are off > > I see your results from "pragma integrity_ch

Re: [sqlite] Corrupt index == disk full?

o upgrade and isolate this variable.) #2 is the one I always worry about, but generally it seems to work well. -- Ward ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Corrupt index == disk full?

> On May 10, 2017, at 10:49 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 May 2017, at 6:31pm, Ward WIllats <sqlite-us...@wardco.com> wrote: > >> I guess with corruption, all bets are off > > I see your results from "pragma integrity_ch

[sqlite] Corrupt index == disk full?

m curious as to what the mechanism might be that made a full error and not a corrupted error pop out. Thanks -- Ward sqlite> pragma integrity_check; *** in database main *** On tree page 6053 cell 29: Failed to read ptrmap key=67699289 On tree page 6053 cell 29: invalid page number 67699289 On

[sqlite] Magic self-healing database!

f somehow? What conclusions (if any) can I draw from this? Thanks, -- Ward ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Deprecated OSX functioon

This has been coming across my console when building Sqlite since upgrading to Mac OSX Sierra a few months ago. FWIW. Building sqlite3 shell... sqlite3.c:20839:17: warning: 'OSAtomicCompareAndSwapPtrBarrier' is deprecated: first deprecated in macOS 10.12 - Use atomic_compare_exchange_strong()

Re: [sqlite] sqlite3_errmsg() after sqlitr3_exec() on ATTACHed DB

> On Feb 1, 2017, at 1:18 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > > On 2/1/2017 10:32 AM, Ward WIllats wrote: >> When I perform an sqlite3_exec() to DELETE too many rows in the secondary >> ATTACHed database and a disk or database full error occurs, I

[sqlite] sqlite3_errmsg() after sqlitr3_exec() on ATTACHed DB

for others and to be sure my conceptual model was not too far off the mark before I start hacking away.) Thanks again. -- Ward ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DELETE when DB is full

> On Jan 31, 2017, at 3:54 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 31 Jan 2017, at 10:40pm, Warren Young <war...@etr-usa.com> wrote: > >> On Jan 31, 2017, at 2:03 PM, Ward WIllats <sqlite-us...@wardco.com> wrote: >> >>> the d

[sqlite] DELETE when DB is full

to force a delete of records when the DB pages are already maxed out -- esp. if I don't need to roll this back. This is sqlite 3.10.1. Thanks -- Ward ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When is data committed on one connection seen on another?

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Olivier Mascia > If I'm permitted: you're wrong. Ha, yes, well if our initial threading model is anything to go by, I think you're on safe ground with that assertion. > Unless you have a very complex

Re: [sqlite] When is data committed on one connection seen on another?

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Igor Tandetnik > Statement execution starts with the first sqlite3_step after sqlite3_prepare > or the most recent sqlite3_reset; and ends with sqlite3_reset or > sqlite3_finalize. Thanks makes sense.

Re: [sqlite] When is data committed on one connection seen on another?

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Simon Slavin > It is not enough to lock the _prepare, lock the _step()s, and lock the > _finalize. > If they're sharing a connection with other threads then the lock has to be > placed at the start of

Re: [sqlite] When is data committed on one connection seen on another?

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Hick Gunter > Sharing a connection between threads makes it practically impossible for any > one thread to tell when a transaction begins or ends. From the point of view > of the database connection, the

Re: [sqlite] When is data committed on one connection seen on another?

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Simon Slavin > Your description of your fault suggests that at least two of your > threads/processes are trying to use the same connection to the database at > the same time We have a bunch of reads

Re: [sqlite] sqlite-users Digest, Vol 105, Issue 13

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Igor Tandetnik > Realize that a transaction is a property of a connection, not a thread or a > query. Suppose thread A starts a read at time T and ends it at time > T+20; and thread B starts a read on

[sqlite] When is data committed on one connection seen on another?

We think we are seeing the case where a read on one WAL mode Sqlite database connection using the C API is reading stale data after a transaction has committed data changes on another connection. For instance, a deleted row on one connection is still found by a select on the other. The

Re: [sqlite] page_size on ATTACH-ed databases

le.com> wrote: > > Is there any possibility that the attached db already existed before > you ran this? Because once a db exists (contains pages) the page size > is fixed until you run vacuum. > > On Tue, Aug 16, 2016 at 10:53 AM, Ward WIllats <sqlite-us...@wardco.com>

Re: [sqlite] page_size on ATTACH-ed databases

>> On Aug 12, 2016, at 11:44 PM, Dan Kennedy <danielk1...@gmail.com> wrote: >> >> On 08/13/2016 01:14 AM, Ward WIllats wrote: >> >> Can't reproduce this problem here. Are you able to reproduce it with the >> shell tool? >> > > > Yes,

Re: [sqlite] page_size on ATTACH-ed databases

> On Aug 12, 2016, at 11:44 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > > On 08/13/2016 01:14 AM, Ward WIllats wrote: > > Can't reproduce this problem here. Are you able to reproduce it with the > shell tool? > Yes, if I use the shell on our embedded syste

[sqlite] page_size on ATTACH-ed databases

second.page_size and get the default page size of 1024. (We are still on 3.10.1) Is it expected that the 4096 did not "stick?" Is there some relationship between page sizes in a main and attached DB? Thanks -- Ward (In real life, we also set journal_mode=WAL on both databases AFT

Re: [sqlite] max_page_count wont round-trip between shell and program

> On Jul 5, 2016, at 3:18 PM, David Empson <demp...@emptech.co.nz> wrote: > > >> On 6/07/2016, at 8:55 AM, Ward WIllats <sqlite-us...@wardco.com> wrote: >> >>> I have noticed that when I set max_page_count programatically to 16384 and >>> rea

Re: [sqlite] max_page_count wont round-trip between shell and program

hat opens the DB *must* set this on the new connection.) Thanks, -- Ward ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] max_page_count wont round-trip between shell and program

can round-trip their own set/get cycle OK. > Oh wait, you're going to tell me the value is transient to the connection, aren't you? And 1073741823 is some kind of max sentinel? -- Ward ___ sqlite-users mailing list sqlite-users@mailinglis

[sqlite] max_page_count wont round-trip between shell and program

I have noticed that when I set max_page_count programatically to 16384 and read it back with the shell I get 1073741823. If I set max_page_count with the shell to 16384 and read it back programmatically, the program gets back 1073741823. Both the program and the shell can round-trip their own

[sqlite] pragma foreign_keys attribute of connection?

> On Mar 2, 2016, at 6:53 PM, Ward WIllats wrote: > > Now, this diagnosis may or may not be correct, Indeed, it is not. Never mind! Thanks! -- Ward

[sqlite] pragma foreign_keys attribute of connection?

another process did pragma foreign_keys=1 and turned them back on. Now, this diagnosis may or may not be correct, we are running more tests, but I thought I'd just ask here if foreign key enforcement is an attribute of the connection, or if it an aspect of the database file itself? Thanks -- Ward

[sqlite] Caveats using Sqlite on JFFS2 ?

Linux on MIPS.) Thanks -- Ward

[sqlite] Slow real world performance - Any suggestions please (warning long)

> On Jul 2, 2015, at 3:16 PM, Rob Willett > wrote: > > We?re trying to understand whether or not we have a performance problem with > our Sqlite database. It may or may not apply to your situation, but after doing lots of inserts, running ANALYZE can sometimes work wonders. -- Ward

[sqlite] Dumb statement question...

error just after a ";" in a compound statement I've compiled with a param I've bound earlier...) Thanks, -- Ward

[sqlite] Corrupting pointers to the lookaside smallacator

ike this. Thanks, as always, -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite where clause tree

> On Nov 10, 2014, at 9:31 AM, Richard Hipp <d...@sqlite.org> wrote: > > On Mon, Nov 10, 2014 at 12:28 PM, Ward Willats <sqlite-us...@wardco.com> > wrote: > >> >>> On Nov 10, 2014, at 3:11 AM, Richard Hipp <d...@sqlite.org> wrote: >>

Re: [sqlite] SQLite where clause tree

ADLINE -l readline -o sqlite3 sqlite3.c shell.c sqlite3DebugPrintf and sqlite3TreeViewSelect are undefined at link time. Must other switches be thrown? -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3.c in a library - api rename

> On Oct 28, 2014, at 8:23 PM, Richard Hipp <d...@sqlite.org> wrote: > > On Tue, Oct 28, 2014 at 11:18 PM, Ward Willats <sqlite-us...@wardco.com> > wrote: > >> Hello. >> >> I am using the amalgamation in a C++ library statically linked into other &g

[sqlite] sqlite3.c in a library - api rename

translation units can use this "secret" version? (Or, more like, so the host app doesn't accidentally use my version.) Thanks, -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] CONFIG_SERIALIED superset of CONFIG_MULITHREAD?

dle cache"when I have time" (yeah, right). -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] use sqlite3 in ios

malgamation source in the debugger! -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Support for concurrent transactions

t does a ROLLBACK, otherwise a "ROLLBACK TO X; RELEASE X" (Yes, the name of the savepoint is always X.) Works well. -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Benign SQLITE_SCHEMA error?

it succeeds. No error is returned to the originating API call. So..is this benign? Can/should I fix? How worried should I be? Thanks -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple data conversion in SQLite - please help

On Jan 22, 2014, at 8:21 AM, Richard Hipp wrote: > I seem to recall seeing some SMS databases off of an iPhone that used unix > timestamps for the date/time. That would be seconds since 1970. You can > use the 'unixepoch' modifier on the date functions within SQLite to do >

Re: [sqlite] fsync on iOS

e verge of releasing something and so I never have the guts to throw that switch without being able to give Q/A enough time to crawl all over it! After this next release, FOR SURE! :-) -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] fsync on iOS

e verge of releasing something and so I never have the guts to throw that switch without being able to give Q/A enough time to crawl all over it! After this next release, FOR SURE! :-) -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] fsync on iOS

On Jan 16, 2014, at 12:02 PM, Richard Hipp <d...@sqlite.org> wrote: > Do not compile with SQLITE_NO_SYNC. Okay. Thanks. > On Jan 16, 2014, at 1:29 PM, Roger Binns <rog...@rogerbinns.com> wrote: > >> On 16/01/14 11:43, Ward Willats wrote: >> So it looks like

[sqlite] fsync on iOS

more than the 5 second timeout I've set. What do you think? Should I make the timeout longer, or #define SQLITE_NO_SYNC, or? Thanks, as always, -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Saw something interesting in the debugger...

add your > own busy handler that sleeps for sub-second amounts of time. I was more interested in the scenario than the solution -- but I probably would have missed this simple fix and done something elaborate and stupid, so thank you very much! -- Ward __

[sqlite] Saw something interesting in the debugger...

hreads can bounce each other into busy sleep like two bocci balls colliding? (one thread wanted a read lock, the other a BEGIN EXCLUSIVE write lock) -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listi

Re: [sqlite] Connection philosophy

experiment with it in a low-risk way. I look forward to doing so. In other news, last night I coded the the "secret singleton handle" -- actually a cache keyed by DB filename -- works well, and it may be just me, but I feel like it sped up certain operations quite a

Re: [sqlite] Connection philosophy

for me. I guess I would lean toward the former (KISS). -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Connection philosophy

. > Cool idea, except the folks in Marketing want all the data or none of the data each time we collect it. (That is, in my case only, I can't partially commit along the way.) -- Ward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

[sqlite] Connection philosophy

it might be more fragile than actually closing the DB file, dumping caches, and updating the directory.) So what do all you hot-shots think is best practice? In/out, long-lived or something else? Thanks -- Ward ___ sqlite-users mailing list sqlite-user

Re: [sqlite] Is there a way to create a foreign key in existing table?

On Dec 31, 2012, at 12:57 AM, Simon Slavin wrote: > > On 31 Dec 2012, at 8:54am, Igor Korot wrote: > >> I simply forgot to do it on the table creation. And now the table has >> many rows... > > You can easily modify a TABLE definition or even an