Assertion `pCtx->pParse->rc==SQLITE_OK' failed

(1) By Jinsheng Ba (bajinsheng) on 2022-06-14 11:39:15 [source]

Here is another assertion error:

java: target/sqlite-3.39.0-Linux-x86_64/sqlite3.c:80159: int valueFromFunction(sqlite3 *, const Expr *, u8, u8, sqlite3_value **, struct ValueNewStat4Ctx *): Assertion `pCtx->pParse->rc==SQLITE_OK' failed.

We can not reproduce it at the CLI mode, so I attach the full list of executed SQL sentences here: https://drive.google.com/file/d/1QEcMgw4waPdsxoL4B1P0TdrfSr9Rl9Q4/view?usp=sharing

Note that the log file is huge, however, hope it helps.

Environment:

Version: 3.39.0

Commit ID: 342c501f

OS: Ubuntu 20.04

Configuration Options: ./configure --enable-all --enable-debug

Compiler: gcc-9

Client: JDBC

(2.1) By Richard Hipp (drh) on 2022-06-14 12:06:38 edited from 2.0 in reply to 1 [link] [source]

Your 2,228,032 line long test script appears to be truncated. The last line ends with...

OR(vt5.c1)))AND(vt3.c0

There is no closing ; or \n. The final '0' in vt3.c0 is the last character in the file.

(Edit:) The database3-cur.log test script that we have is 612,040,704 bytes in size and has a SHA1 of 0a868b87aacb2dd5c353ac492fb03831efbfe585. It does not assert().

(3) By Jinsheng Ba (bajinsheng) on 2022-06-14 23:57:30 in reply to 2.1 [link] [source]

We are also struggling to reproduce the assertion errors. Maybe we need a better way to log.

Thanks!

(4) By Richard Hipp (drh) on 2022-06-25 02:50:59 in reply to 1 [link] [source]

Follow-up. Repo case reported at forum post ed29e196d5c4f3d5.