After further troubleshooting, turns out that this is a specific problem with a corrupted index.
The sqlite3 guys have developed a fix for sqlite3. From http://www.sqlite.org/src/ci/83395a3d24: "If a database becomes corrupted such that an index is out of sync with its table, make sure the corruption is detected and reported back. Do not assume that indices always contain rowids for valid table rows." This is being fixed in sqlite3 3.7.1 If anyone encounters this issue, they can do the following: ch...@ubuntu:~/.mozilla/firefox/1u64q3v3.default$ for i in *.sqlite; do echo "Reindexing $i"; echo "reindex;" | sqlite3 $i; done Reindexing content-prefs.sqlite Reindexing cookies.sqlite Reindexing downloads.sqlite Reindexing formhistory.sqlite Reindexing permissions.sqlite Reindexing places.sqlite Reindexing search.sqlite Reindexing signons.sqlite Reindexing urlclassifier3.sqlite ch...@ubuntu:~/.mozilla/firefox/1u64q3v3.default$ -- firefox-bin crashed with SIGSEGV in sqlite3VdbeExec() https://bugs.launchpad.net/bugs/610039 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
