The bug seems to be repeatable. ?At least, it happened again today.
I haven't used gdb in a long time. ?Here's my first crack at it; what else
should I do?
$ gdb sqliteGNU gdb (GDB) 7.8Copyright (C) 2014 Free Software Foundation,
Inc.License GPLv3+: GNU GPL version 3 or later
<http://gnu.org/licenses/gpl.html>This is free software: you are free to change
and redistribute it.There is NO WARRANTY, to the extent permitted by law. ?Type
"show copying"and "show warranty" for details.This GDB was configured as
"i686-pc-cygwin".Type "show configuration" for configuration details.For bug
reporting instructions, please see:<http://www.gnu.org/software/gdb/bugs/>.Find
the GDB manual and other documentation resources online
at:<http://www.gnu.org/software/gdb/documentation/>.For help, type "help".Type
"apropos word" to search for commands related to "word"...Reading symbols from
sqlite...done.(gdb) run /cygdrive/r/errd200.dbStarting program:
/usr/local/bin/sqlite /cygdrive/r/errd200.db[New Thread 12300.0x294c][New
Thread 12300.0x32f0][New Thread 12300.0x3530][New Thread 12300.0x328c][New
Thread 12300.0x389c]SQLite version 3.8.11.1 2015-07-29 20:00:57Enter ".help"
for usage hints.sqlite> create index d200_on_passport_fn on
d200_on_passport(fn);[New Thread 12300.0xa64]gdb: unknown target exception
0x80000001 at 0x74d66d61
Program received signal ?, Unknown signal.[Switching to Thread
12300.0xa64]0x74d66d61 in sysfer!FirstHookFunc () from
/cygdrive/c/Windows/SysWOW64/SYSFER.DLL(gdb) bt#0 ?0x74d66d61 in
sysfer!FirstHookFunc () from /cygdrive/c/Windows/SysWOW64/SYSFER.DLL#1
?0x00000000 in ?? ()
On Tuesday, August 11, 2015 1:43 AM, Dan Kennedy <danielk1977 at
gmail.com> wrote:
On 08/11/2015 12:23 AM, Robert Weiss wrote:
> Dan Kennedy--
> What address, precisely, should I use to send the database to you?? When I
> "reply" to your message I get the whole SQLite discussion group, which is
> what I want to avoid (no offense intended, guys and gals).
> BTW, the problem does not seem to occur in version 3.8.10.2.
> Robert Weiss
Thanks for the database. We couldn't reproduce the problem here though.
The crash is repeatable, correct? Are you able to capture a stack trace
from the command line shell with gdb?
Thanks,
Dan.
>
>
>? ? ? On Friday, August 7, 2015 11:31 PM, Dan Kennedy <danielk1977 at
>gmail.com> wrote:
>? ?
>
>? On 08/08/2015 04:11 AM, Robert Weiss wrote:
>> I observed the sqlite command shell version 3.8.11.1 to crash (exit to the
>> OSwithout an error message) while running in a Cygwin shell under Windows 7
>> when I tried to create anindex.? The source was compiled by gcc 4.9.2.? The
>> same type of crashhappened when I tried the operation from a Lua script
>> linked to the same objectlibrary.
>>
>>
>>? ?
>> Here are the DDL statements entered previous to the crash:
>>
>>
>>? ?
>> CREATE TABLEd200_on_passport(fn,path,size,serial,pid);
>>
>> CREATE INDEX d200_on_passport_serial ond200_on_passport(serial);
>>
>> CREATE VIEW d200 as select * fromd200_on_passport;
>>
>>
>>? ?
>> And here is the statement thatcaused the crash:
>>
>> create index d200_on_passport_fn ond200_on_passport(fn);
>>
>>
>>? ?
>> The crash didn?t happen when Itried the CREATE INDEX statement on a test
>> database with the same ddlstatements but containing no data.
>>
>>
>> The compressed version of the database that illustrates the problem is a
>> little smaller than 2 MB.? It contains some semi-personal information (it's
>> part of an attempt to organize my photo library; pathnames hint at where
>> I've been on vacation and so on, but the database contains no images) and
>> I'd prefer not to post it to a list, but I can send it for use by those
>> tracking down the bug.
>
> Can you send the database to me? Or to drh if that seems more prudent to
> you.
>
> Thanks,
> Dan.
>
>
>
>
>
>> Robert Weiss
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>? ?
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
