Re: [sqlite] sqlite-3.20.1: test/fts3conf.test is the only test failing on powerpc32/powerpc64 (suspect big-endian)

2017-09-17 Thread Richard Hipp
On 9/16/17, Sergei Trofimovich wrote: > test/fts3conf.test is the only faulty test on powerpc. Probably fixed by this check-in: https://www.sqlite.org/src/info/87ccdf9cbb928455 Can you confirm? > It looks like test fails due to minor endianness issue: > > ! fts3conf-3.8

Re: [sqlite] Figuring out the Cause of SQLite Error 11: Corrupt Database

2017-09-17 Thread Richard Hipp
On 9/15/17, Esplin, Justin wrote: > I was able to access a computer which encountered these errors, about 10 > minutes after they occurred. I ran "PRAGMA integrity_check" and it returned > "ok". How/why would this have changed? I verified the user did not > re-install our app

Re: [sqlite] 'database disk image is malformed' only on the mac

2017-09-17 Thread Simon Slavin
On 15 Sep 2017, at 2:24pm, Fahad wrote: > #define SQLITE_ENABLE_STAT4 1 Should not affect your problem. > I also changed this: > > #define SQLITE_DEFAULT_WAL_AUTOCHECKPOINT 1000 > > to 250 That may affect your problem. Try extreme values, with the objective being to

[sqlite] sqlite-3.20.1: test/fts3conf.test is the only test failing on powerpc32/powerpc64 (suspect big-endian)

2017-09-17 Thread Sergei Trofimovich
test/fts3conf.test is the only faulty test on powerpc. It looks like test fails due to minor endianness issue: ! fts3conf-3.8 expected: [X'02000200'] ! fts3conf-3.8 got: [X'00020002'] All other tests work fine. Full output: $ ./testfixture test/fts3conf.test

[sqlite] [PATCH] Fix csv handling hangup on -funsigned-char platforms

2017-09-17 Thread Sergei Trofimovich
The bug csv01.test hangs on powerpc32 and powerpc64 (both are 'char' == 'unsigned char' platforms) Hangup happens in static int csvtabNext(sqlite3_vtab_cursor *cur){ ... if( z==0 || pCur->rdr.cTerm==EOF ){ Here 'pCur->rdr.cTerm' is of type 'char' (holds truncated EOF) while

Re: [sqlite] Figuring out the Cause of SQLite Error 11: Corrupt Database

2017-09-17 Thread Esplin, Justin
I was able to access a computer which encountered these errors, about 10 minutes after they occurred. I ran "PRAGMA integrity_check" and it returned "ok". How/why would this have changed? I verified the user did not re-install our app or otherwise reconfigure the database. Justin Esplin

Re: [sqlite] 'database disk image is malformed' only on the mac

2017-09-17 Thread Fahad
Hi Simon Wanted to chime in to say I was able to in fact cause the database to go corrupt from other external processes trying to write to the database (in WAL mode) while the main app was also using the database. So I have a feeling it's something else. I've tried hard to create a mini-app that

Re: [sqlite] Download documentation for 3.20.1 still shows as Draft

2017-09-17 Thread dwellman
Yep. That looks good now. Thanks. On 2017-09-16 21:55, Richard Hipp wrote: > On 9/16/17, David Wellman wrote: > >> Hi, >> >> If you download the 3.20.1 documentation zip file from >> http://www.sqlite.org/download.html the pages still show as 'Draft' (in big >>