Hello SQLite devs,
We've found a hung-up issue in the current sqlite3.
Could you please read the below issue report?
Advertising
=== Summary of the issue ===
For the specified DB, sqlite3 hung-up after invoking the specified
DELETE query.
Then CPU usage keeps 100% until killing the process.
=== Affected versions ===
3.12.0
3.12.1
3.12.2
3.13.0
3.14.0
3.14.1
3.14.2
We've confirmed that 3.11.1 is OK and 3.12.0 is NG.
It seems that the issue is introduced from 3.12.0.
=== How to reproduce ===
1. Prepare Ubuntu 16.04.1 LTS.
Note: You may be able to confirm the issue on any your environments
since this issue also occurs on armv7 embedded device.
In the Ubuntu terminal,
2. Build sqlite3:
$ wget https://www.sqlite.org/2016/sqlite-autoconf-3140200.tar.gz
$ tar -xf sqlite-autoconf-3140200.tar.gz
$ cd sqlite-autoconf-3140200
$ ./configure; make
$ cd ../
3. Get the DB and query text file from the following URL using your web
browser:
https://goo.gl/J2lyef
Download hungup.db.xz and query_posing_hungup.txt.
Places the downloaded files on the same directory as
sqlite-autoconf-3140200.tar.gz.
Note: You can download the above files without creating dropbox account.
4. Reproduce the issue:
$ xz -d ./hungup.db.xz
$ cat ./query_posing_hungup.txt | ./sqlite-autoconf-3140200/sqlite3
./hungup.db
-> reproduced!
Thank you in advance.
--
Takasumi Iwamoto
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
