I am running sqlite3 on a Linux Mint 18 desktop.
I first realized the problem with the stock sqlite3 client 3.11.0
2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f.
I confirmed it still exists with the currently published most recent
version 3.30.1 2019-10-10 20:19:45
18db032d058f1436ce3dea84081f4ee5a0f2259ad97301d43c426bc7f3df1b0b
Steps to reproduce:
--
$ sqlite3
SQLite version 3.30.1 2019-10-10 20:19:45
Enter ".help" for usage hints.
sqlite> create table feedback (fid integer primary key autoincrement,
cid integer not null references characters, game_number integer not null
default 1, players integer not null default 2, playtime text check
(playtime in ("kurz", "20-30", "30-45", "45-60", "lang")),
beginning_player boolean, liked integer, duration integer, luckiness
integer, complexity integer, rules integer, rule_suggestions text,
budget integer, text text);
sqlite> insert into feedback values (1, 1, 1, 2, "kurz", 1, 10, 3, 2, 3,
9, NULL, 10, NULL);
sqlite> select * from feedback;
1|1|1|2|kurz|1|10|3|2|3|9||10|
sqlite> .explain on
sqlite> select * from feedback;
--
This triggers an infinite loop. It uses a full cpu. strace shows it is
doing write(1, " "..., 1024) repeatedly (spaces).
gdb shows the following stack (no debug symbols in the sqlite binary
unfortunately):
(gdb) bt
#0 0xf7fd7fe9 in __kernel_vsyscall ()
#1 0xf7e4fb93 in write () from /lib/i386-linux-gnu/libc.so.6
#2 0xf7de30b1 in _IO_file_write () from /lib/i386-linux-gnu/libc.so.6
#3 0xf7de23e4 in ?? () from /lib/i386-linux-gnu/libc.so.6
#4 0xf7de412d in _IO_do_write () from /lib/i386-linux-gnu/libc.so.6
#5 0xf7de4518 in _IO_file_overflow () from /lib/i386-linux-gnu/libc.so.6
#6 0xf7de379e in _IO_file_xsputn () from /lib/i386-linux-gnu/libc.so.6
#7 0xf7dd95f5 in _IO_padn () from /lib/i386-linux-gnu/libc.so.6
#8 0xf7dbd6b7 in vfprintf () from /lib/i386-linux-gnu/libc.so.6
#9 0xf7dc3668 in fprintf () from /lib/i386-linux-gnu/libc.so.6
#10 0x080ea46b in ?? ()
#11 0x080eb033 in ?? ()
#12 0x080eccc9 in ?? ()
#13 0x080ed698 in ?? ()
#14 0x080f5e8f in ?? ()
#15 0x0804f03a in ?? ()
#16 0xf7d92637 in __libc_start_main () from /lib/i386-linux-gnu/libc.so.6
#17 0x0804f139 in ?? ()
Regards,
-Jan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
