I have a fairly simple db with fts3
TABLE pages (page_id INTEGER PRIMARY KEY, page_name TEXT, page_text TEXT);
VIRTUAL TABLE fts_pages USING fts3 (page_name, page_text);
and the following triggers --
CREATE TRIGGER delete_fts
AFTER DELETE ON pages
BEGIN
DELETE FROM fts_pages WHERE rowid = old.page_id;
END;
CREATE TRIGGER insert_fts
AFTER INSERT ON pages
BEGIN
INSERT INTO fts_pages (rowid, page_text)
VALUES (new.page_id, new.page_text);
END;
CREATE TRIGGER update_fts
AFTER UPDATE OF page_text ON pages
BEGIN
UPDATE fts_pages
SET page_text = new.page_text
WHERE rowid = old.page_id;
END;
When I enter a new row like so via the sqlite3 (version 3.5.6) shell
on my MBP with OS X 10.5.2, I get the following error
sqlite> INSERT INTO pages (page_name, page_text) VALUES ('foo', 'bar');
Bus error
and the sqlite3 shell quits out to the bash shell.
A small journal file is left, and if I enter sqlite3 again, I get the
message that the db is locked. I can proceed once I delete the journal
file. I have the following crash log to report
Process: sqlite3 [1464]
Path: /usr/local/bin/sqlite3
Identifier: sqlite3
Version: ??? (???)
Code Type: X86 (Native)
Parent Process: bash [291]
Date/Time: 2008-03-02 15:24:45.729 -0600
OS Version: Mac OS X 10.5.2 (9C31)
Report Version: 6
Exception Type: EXC_BAD_ACCESS (SIGBUS)
Exception Codes: KERN_PROTECTION_FAILURE at 0x0000000000000000
Crashed Thread: 0
Thread 0 Crashed:
0 libsqlite3.0.dylib 0x000ba7d8 sqlite3Step + 15862
1 libsqlite3.0.dylib 0x000bde17 sqlite3_step + 75
2 libsqlite3.0.dylib 0x000a333d sqlite3_exec + 209
3 sqlite3 0x00006059 process_input + 1124
4 sqlite3 0x00006c2a main + 2527
5 sqlite3 0x00002596 start + 54
Thread 0 crashed with X86 Thread State (32-bit):
eax: 0x00807480 ebx: 0x000b69f3 ecx: 0x0013d808 edx: 0x00000000
edi: 0x0080b04c esi: 0x00000018 ebp: 0xbfffed98 esp: 0xbfffe930
ss: 0x0000001f efl: 0x00010206 eip: 0x000ba7d8 cs: 0x00000017
ds: 0x0000001f es: 0x0000001f fs: 0x00000000 gs: 0x00000037
cr2: 0x00000000
Binary Images:
0x1000 - 0x7fe7 +sqlite3 ??? (???) /usr/local/bin/sqlite3
0x21000 - 0x37fea libedit.2.dylib ??? (???)
<be5a6f391887bb96bdeeafd443cf19fb> /usr/lib/libedit.2.dylib
0x6a000 - 0xc8fff +libsqlite3.0.dylib ??? (???)
/usr/local/lib/libsqlite3.0.dylib
0x8fe00000 - 0x8fe2da53 dyld 96.2 (???)
<7af47d3b00b2268947563c7fa8c59a07> /usr/lib/dyld
0x9001c000 - 0x90020fff libmathCommon.A.dylib ??? (???)
/usr/lib/system/libmathCommon.A.dylib
0x908cb000 - 0x908d2fe9 libgcc_s.1.dylib ??? (???)
<f53c808e87d1184c0f9df63aef53ce0b> /usr/lib/libgcc_s.1.dylib
0x9126b000 - 0x9129aff7 libncurses.5.4.dylib ??? (???)
<3b2ac2ca8190942b6b81d2a7012ea859> /usr/lib/libncurses.5.4.dylib
0x923c8000 - 0x92527ff3 libSystem.B.dylib ??? (???)
<4899376234e55593b22fc370935f8cdf> /usr/lib/libSystem.B.dylib
0xffff0000 - 0xffff1780 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib
Any advice?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
