Hello SQLite devs,

We've found a hung-up issue in the current sqlite3.
Could you please read the below issue report?


=== 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

Reply via email to