[sqlite] Assertion hit in sqlite3VarintLen

2016-03-04 Thread Martin Raiber
Hi, I have used sqlite3VarintLen outside of SQLite and noticed that the assertion in this function is hit if the highest bit is set (and it returns 10 when it should return 9). E.g. with sqlite3VarintLen(0xF000); It could be that this is not relevant to SQLite as it is guaranteed

Re: [sqlite] Random IOERR_SHORT_READ in sqlite3_prepare_v2

2016-09-14 Thread Martin Raiber
On 14.09.2016 13:31 Dan Kennedy wrote: > On 09/14/2016 06:05 PM, Martin Raiber wrote: >> there have been three reports by users using my software of SQLite >> 3.12.0 returning SQLITE_IOERR and logging a SQLITE_IOERR_SHORT_READ >> (522). Specifically: >> >> 201

[sqlite] Random IOERR_SHORT_READ in sqlite3_prepare_v2

2016-09-14 Thread Martin Raiber
Hi, there have been three reports by users using my software of SQLite 3.12.0 returning SQLITE_IOERR and logging a SQLITE_IOERR_SHORT_READ (522). Specifically: 2016-09-12 04:37:04: WARNING: SQLite: disk I/O error errorcode: 522 2016-09-12 04:37:04: ERROR: Error preparing Query [PRAGMA cache_size

Re: [sqlite] Random IOERR_SHORT_READ in sqlite3_prepare_v2

2016-09-14 Thread Martin Raiber
On 14.09.2016 13:26 Simon Slavin wrote: > Check the hard disk format for format errors (fsck). > > Run "PRAGMA integrity_check" on the database file. > > Is the database file on a disk inside the computer running the SQLite calls, > or is it accessed across a network ? > > Do you use any PRAGMAs

Re: [sqlite] Random IOERR_SHORT_READ in sqlite3_prepare_v2

2016-09-15 Thread Martin Raiber
On 16.09.2016 00:53 Simon Slavin wrote: > On 15 Sep 2016, at 11:38pm, Martin Raiber <mar...@urbackup.org> wrote: > >> There are two instances in the program where the sqlite database file is >> opened >> and closed outside of sqlite3 (to backup the database

Re: [sqlite] Random IOERR_SHORT_READ in sqlite3_prepare_v2

2016-09-15 Thread Martin Raiber
. Solution seems to be to not close the database file after opening it and to reuse the file handle (on Linux). On 14.09.2016 13:05 Martin Raiber wrote: > Hi, > > there have been three reports by users using my software of SQLite > 3.12.0 returning SQLITE_IOERR

[sqlite] Potential small incompatibility 3.15 -> 3.16

2017-01-10 Thread Martin Raiber
Hi, with 3.15: sqlite> PRAGMA quick_check; integrity_check ok with 3.16: sqlite> PRAGMA quick_check; quick_check ok The second one is more intuitive, but existing applications may use the first column name. Regards, Martin Raiber ___ sqlite

Re: [sqlite] Enabling MMAP in Android

2017-12-12 Thread Martin Raiber
On 12.12.2017 19:47 Simon Slavin wrote: > On 12 Dec 2017, at 6:27pm, Jens Alfke wrote: > >> On Dec 12, 2017, at 5:46 AM, Simon Slavin wrote: >>> Before you answer that question, you should know that both Windows and >>> macOS have been proved to have

Re: [sqlite] Many ML emails going to GMail's SPAM

2017-11-21 Thread Martin Raiber
On 21.11.2017 17:30 John McKown wrote: > On Tue, Nov 21, 2017 at 10:27 AM, Drago, William @ CSG - NARDA-MITEQ < > william.dr...@l3t.com> wrote: > >>> I really need to come up with an alternative to the mailing list. >>> Perhaps some kind of forum system. Suggestions are welcomed. >>> -- >>> D.

Re: [sqlite] Online backup of in memory database

2019-10-06 Thread Martin Raiber
On 06.10.2019 22:02 Keith Medcalf wrote: > On Sunday, 6 October, 2019 13:03, Kadirk wrote: > >> We already have an application specific WAL file, sqlite updates + >> application data is in this WAL file. We are taking snapshot of sqlite + >> application data to the disk to truncate WAL file, then

Re: [sqlite] more efficient JSON encoding: idle musing

2020-02-21 Thread Martin Raiber
On 21.02.2020 15:03 Richard Hipp wrote: > On 2/21/20, Wout Mertens wrote: >> The idea is that upon storing the JSON >> data, the JSON1 extension parses it, extracts the layouts recursively, >> stores them when they are not known yet, and then only stores the >> values in the binary format with