[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-02 Thread Yannick Duchêne
On Thu, 28 Jan 2016 14:55:28 + Simon Slavin wrote: > > On 28 Jan 2016, at 1:38pm, Bernard McNeill wrote: > > > === > > Like the user reading ?saving OK? and throwing away the > > Post-It with the original information > > === > > > > This is exactly my concern. > > The user throwing away

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Hick Gunter
Does the error still occur if you run with only one thread? Does each thread have ist own connection or are you sharing a single connection across multiple threads? -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Clemens Ladisch
Vin?cius da Silva wrote: > after commenting the pragmas, Which ones? omp or SQLite? > SQLiteManager is throwing > an exception because stepping the statement in endTransaction() is > returning SQLITE_IOERR_DELETE_NOENT > in the parallel loop.

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-02 Thread James K. Lowden
On Mon, 01 Feb 2016 06:39:05 -0700 "Keith Medcalf" wrote: > OS/2 had IBM cache technology in it which worked properly. I remember OS/2. I remember that, like VMS, you could back up the whole OS to ... well, floppies, I suppose, and later restore them to brand new drive, with nothing else

[sqlite] Is the first column of a composite primary key, special?

2016-02-02 Thread James K. Lowden
On Tue, 2 Feb 2016 16:19:07 +0100 Yannick Duch?ne wrote: > There are also representations. Sometimes there is not really a > value, just an identity which is the only thing offering > sense/meaning, and what may be erroneously seen as a value is rather > a representation. Representation is

[sqlite] Customizing the location of the .sqlite_history

2016-02-02 Thread James K. Lowden
On Sun, 31 Jan 2016 21:46:18 -0800 Jes Slow wrote: > Many applications do this by allowing the user to set an environment > variable to customize the location, altho personally I would prefer > another way since environment variables are also global. Global? Environment variables are

[sqlite] Documentation comment: VFS

2016-02-02 Thread James K. Lowden
On Mon, 1 Feb 2016 14:24:28 +0200 R Smith wrote: > > does it say what "VFS" stands for. Please don't tell me...// > > I'm going to ignore the request and tell you anyway: It clearly > stands for "Variably F-Syncing Software". Oh, come now. In the tradition of RTMF, surely it's Very

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Vinícius da Silva
Using BEGIN EXCLUSIVE TRANSACTION in place of BEGIN TRANSACTION does not change the result: SQLITE_IOERR_DELETE_NOENT is being returned when stepping the END TRANSACTION statement. I'm using ext4 with Ubuntu. 2016-02-02 19:40 GMT-02:00 Clemens

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Vinícius da Silva
Each thread access the SQLiteManager array m_dbs, indexed by its unique index provided by openmp. Since SQLiteManager opens a connection in its init() method each thread has a private connection. The tests are passing when I set the parallel loops for one thread only. 2016-02-02 19:27 GMT-02:00

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-02 Thread James K. Lowden
On Sun, 31 Jan 2016 20:27:56 -0700 Scott Robison wrote: > On Sun, Jan 31, 2016 at 7:35 PM, Rowan Worth wrote: > > > On 31 January 2016 at 03:56, James K. Lowden > > wrote: > > > > > Surely SQLite does both -- fsync on file and directory -- as part > > > of a commit. That's not in doubt, is

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Vinícius da Silva
The error occur after commenting the SQLite setup pragmas. All threads access the same database file and the same table. I'm using an ext4 file system with Ubuntu. 2016-02-02 17:58 GMT-02:00 Clemens Ladisch : > Vin?cius da Silva wrote: > > after commenting the pragmas, > > Which ones? omp or

[sqlite] Pointer to building SQLITE4

2016-02-02 Thread Simon Slavin
On 2 Feb 2016, at 11:43am, Tanish Bansal wrote: > SQLITE4 Please note that SQLite4 is experimental at this time. It's a way for the developers to test new features or techniques that may one day be used in a stable release. It should not be used for any program you need to work correctly.

[sqlite] Pointer to building SQLITE4

2016-02-02 Thread Tanish Bansal
Hi Sir, I want to build SQLITE4, but i am facing some errors when i follow your READ ME guidance Steps. May be i am Missing some steps here .. These are the steps i followed to build sqlite4 1. Downloaded sqlite.tar.gz from ( https://www.sqlite.org/src4/tree?ci=trunk ) 2. tar xzf

[sqlite] Is the first column of a composite primary key, special?

2016-02-02 Thread Yannick Duchêne
On Sun, 31 Jan 2016 18:15:48 -0500 "James K. Lowden" wrote: > > The relational model, as you well know, doesn't describe > implementation. It's math. It says what relations are, and how > they're manipulated. One data type, and an algebra closed over that > domain. Math doesn't have

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Vinícius da Silva
Using only omp_get_thread_num() in the parallel loop do not change the results. However, after commenting the pragmas, SQLiteManager is throwing an exception because stepping the statement in endTransaction() is returning SQLITE_IOERR_DELETE_NOENT

[sqlite] “btreeInitPage() returns error code 11”

2016-02-02 Thread Richard Hipp
On 2/2/16, Felipe Gasper wrote: > I?ve got a corrupt SQLite database, and I?m trying to figure out what > produced the corruption. > > A ?pragma integrity_check? on it yielded the following. Does this trip > anyone?s ?danger sense? of what may have happened? > With few exceptions,

[sqlite] “btreeInitPage() returns error code 11”

2016-02-02 Thread Felipe Gasper
Hi all, I?ve got a corrupt SQLite database, and I?m trying to figure out what produced the corruption. A ?pragma integrity_check? on it yielded the following. Does this trip anyone?s ?danger sense? of what may have happened? Thank you! -FG SQLite

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Clemens Ladisch
Dominique Devienne wrote: > On Tue, Feb 2, 2016 at 10:32 AM, Clemens Ladisch > wrote: > >> Vin?cius da Silva wrote: >>> #pragma omp parallel for >>> for( int i = 0; i < dispatchedThreads; ++i ) >> >> Does OMP guarantee that there is exactly one thread for

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Dominique Devienne
On Tue, Feb 2, 2016 at 10:32 AM, Clemens Ladisch wrote: > Vin?cius da Silva wrote: > > #pragma omp parallel for > > for( int i = 0; i < dispatchedThreads; ++i ) > > Does OMP guarantee that there is exactly one thread for each > loop iteration? > Yes,

[sqlite] Table entries disappearing for unknown reason.

2016-02-02 Thread Clemens Ladisch
Vin?cius da Silva wrote: > #pragma omp parallel for > for( int i = 0; i < dispatchedThreads; ++i ) Does OMP guarantee that there is exactly one thread for each loop iteration? > sqlite3_exec( m_db, "PRAGMA synchronous = OFF", NULL, NULL, NULL ); >

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-02 Thread Rowan Worth
On 2 February 2016 at 08:22, Stephen Chrzanowski wrote: > On Mon, Feb 1, 2016 at 11:20 AM, Rowan Worth wrote: > As I indicated in the last paragraph of my mail, I'm not in favour of > > fsync-directory-on-commit in the general case. But that's because I worry > > about the performance impact,

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-02 Thread Olivier Mascia
alutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160202/2d3d45f0/attachment.pgp>

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

2016-02-02 Thread Gabor Grothendieck
> It is a standard feature of pysqlite2 (the sqlite3 library shipped with > Python). I am quite sure you can read the documentation just as well as I > can copy and paste it. In short, you can use anything you like as the data > type in sqlite. You could specify that some column contains: >

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

2016-02-02 Thread Keith Medcalf
> > There is no impedence mismatch. Simply inadequate wattage by the > person(s) solving the problem. As I said, this problem has been solved > with SQLite and Python for a decade. So I would suggest the problem is > that the wattage was so low, the lights were completely out. > The impedence

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-02 Thread Rowan Worth
Hi Stephen, On 1 February 2016 at 21:45, Stephen Chrzanowski wrote: > > SQLite is nothing more than part of a program run by the OS. It completely > relies on whatever the OS tells it. If the OS tells it that things are OK, > then that is all that can be done. SQLite can't take on the