CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo #2608

slrslr · 2016-11-01T22:07:16Z

Tribler version/branch+revision:

One that was available 1st November 2016 at https://github.com/Tribler/tribler.git

Operating system and version:

Linux kali 4.6.0-kali1-686-pae #1 SMP Debian 4.6.4-1kali1 (2016-07-21) i686 GNU/Linux

Steps to reproduce the behavior:

I tried to install Tribler via command line inside Virtualbox VM.

sudo apt-get install libav-tools libjs-excanvas libjs-mootools libsodium* libx11-6 python-apsw python-cherrypy3 python-crypto python-cryptography python-feedparser python-leveldb python-libtorrent python-m2crypto python-netifaces python-pil python-pyasn1 python-twisted python-wxgtk3.0 python2.7 vlc-data* python-pip python-chardet python-configobj

sudo pip install decorator libnacl

git clone --recursive https://github.com/Tribler/tribler.git

cd tribler

./tribler.sh

ImportError: No module named cherrypy.lib.httputil

pip install cherrypy

./tribler.sh

/root/tribler/Tribler/Core/TorrentDef.py:9: RuntimeWarning: to-Python converter for boost::shared_ptrlibtorrent::alert already registered; second conversion method ignored.
from libtorrent import bencode, bdecode
ERROR 1478037226.50 util:239 Exception raised on the reactor's thread CorruptedDatabaseError: "Failed to load database version: SQLError: no such table: MyInfo".
Traceback from this thread:
File "Tribler/Main/tribler.py", line 95, in
main()
File "Tribler/Main/tribler.py", line 85, in main
run()
File "Tribler/Main/tribler.py", line 68, in run
run_main()
File "/root/tribler/Tribler/Main/tribler_main.py", line 930, in run
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 111, in init
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 330, in InitStage1
self.upgrader = session.prestart()
File "/root/tribler/Tribler/dispersy/util.py", line 46, in helper
return blockingCallFromThread(reactor, func, *args, **kargs)
File "/root/tribler/Tribler/dispersy/util.py", line 236, in blockingCallFromThread
this_thread_tb = traceback.extract_stack()

Traceback from the reactor's thread:
File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 150, in maybeDeferred
result = f(*args, **kw)
File "/root/tribler/Tribler/Core/Session.py", line 192, in prestart
self.sqlite_db.initialize()
File "/root/tribler/Tribler/dispersy/util.py", line 46, in helper
return blockingCallFromThread(reactor, func, *args, **kargs)
File "/root/tribler/Tribler/dispersy/util.py", line 225, in blockingCallFromThread
return f(*args, **kwargs)
File "/root/tribler/Tribler/Core/CacheDB/sqlitecachedb.py", line 87, in initialize
self._open_connection()
File "/root/tribler/Tribler/Core/CacheDB/sqlitecachedb.py", line 187, in _open_connection
raise CorruptedDatabaseError(msg)

Traceback (most recent call last):
File "/root/tribler/Tribler/Main/tribler_main.py", line 930, in run
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 111, in init
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 330, in InitStage1
self.upgrader = session.prestart()
File "/root/tribler/Tribler/dispersy/util.py", line 46, in helper
return blockingCallFromThread(reactor, func, *args, **kargs)
File "/root/tribler/Tribler/dispersy/util.py", line 240, in blockingCallFromThread
result.raiseException()
File "", line 2, in raiseException
CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo

devos50 · 2016-11-03T17:14:30Z

Thanks for your report!

devos50 · 2016-11-06T20:15:02Z

@slrslr can you try to backup your .Tribler directory (in ~/.Tribler), remove the original .Tribler dir and try again?

slrslr · 2016-11-06T20:40:49Z

@devos50 here are commands i did and its results. Please let me know if anything else i should try.

COMMAND:
mv ~/.Tribler ~/.Tribler0
cd ~/.Tribler
RESULT:
bash: cd: /root/.Tribler: No such file or directory
COMMAND:
./tribler.sh
RESULT:
/root/tribler/Tribler/Core/TorrentDef.py:9: RuntimeWarning: to-Python converter for boost::shared_ptrlibtorrent::alert already registered; second conversion method ignored.
from libtorrent import bencode, bdecode
ERROR 1478464447.40 util:239 Exception raised on the reactor's thread SQLError: "SQLError: no such module: fts4".
Traceback from this thread:
File "Tribler/Main/tribler.py", line 95, in
main()
File "Tribler/Main/tribler.py", line 85, in main
run()
File "Tribler/Main/tribler.py", line 68, in run
run_main()
File "/root/tribler/Tribler/Main/tribler_main.py", line 930, in run
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 111, in init
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 330, in InitStage1
self.upgrader = session.prestart()
File "/root/tribler/Tribler/dispersy/util.py", line 46, in helper
return blockingCallFromThread(reactor, func, _args, *_kargs)
File "/root/tribler/Tribler/dispersy/util.py", line 236, in blockingCallFromThread
this_thread_tb = traceback.extract_stack()

Traceback from the reactor's thread:
File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 150, in maybeDeferred
result = f(_args, *_kw)
File "/root/tribler/Tribler/Core/Session.py", line 192, in prestart
self.sqlite_db.initialize()
File "/root/tribler/Tribler/dispersy/util.py", line 46, in helper
return blockingCallFromThread(reactor, func, _args, *_kargs)
File "/root/tribler/Tribler/dispersy/util.py", line 225, in blockingCallFromThread
return f(_args, *_kwargs)
File "/root/tribler/Tribler/Core/CacheDB/sqlitecachedb.py", line 87, in initialize
self._open_connection()
File "/root/tribler/Tribler/Core/CacheDB/sqlitecachedb.py", line 176, in _open_connection
cursor.execute(sql_script)
File "src/cursor.c", line 236, in resetcursor

Traceback (most recent call last):
File "/root/tribler/Tribler/Main/tribler_main.py", line 930, in run
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 111, in init
use_torrent_search=use_torrent_search, use_channel_search=use_channel_search)
File "/root/tribler/Tribler/Main/tribler_main.py", line 330, in InitStage1
self.upgrader = session.prestart()
File "/root/tribler/Tribler/dispersy/util.py", line 46, in helper
return blockingCallFromThread(reactor, func, _args, *_kargs)
File "/root/tribler/Tribler/dispersy/util.py", line 240, in blockingCallFromThread
result.raiseException()
File "", line 2, in raiseException
SQLError: SQLError: no such module: fts4

devos50 · 2016-11-06T20:43:14Z

@slrslr thanks! It appears that an error occurred during the creation of the database, in particular, you don't have FTS4 support in your sqlite version. Can you post your sqlite version by running the following command?

dpkg-query -l | grep sqlite

slrslr · 2016-11-06T20:44:23Z

dpkg-query -l | grep sqlite
ii libaprutil1-dbd-sqlite3:i386 1.5.4-2 i386 Apache Portable Runtime Utility Library - SQLite3 Driver
ii libdbd-sqlite3-perl 1.50-1 i386 Perl DBI driver with a self-contained RDBMS
ii libqt5sql5-sqlite:i386 5.6.1+dfsg-3+b1 i386 Qt 5 SQLite 3 database driver
ii libsqlite3-0:i386 3.14.1-1 i386 SQLite 3 shared library
ii python-pysqlite2 2.7.0-1 i386 Python interface to SQLite 3
ii ruby-dataobjects-sqlite3 0.10.16-1+b3 i386 SQLite adapter for ruby-dataobjects
ii ruby-dm-sqlite-adapter 1.2.0-0kali2+build1 all Sqlite3 Adapter for DataMapper
ii ruby-sqlite3 1.3.11-2 i386 SQLite3 interface for Ruby
ii sqlite3 3.14.1-1 i386 Command line interface for SQLite 3
ii sqlitebrowser 3.8.0-1 i386 GUI editor for SQLite databases

Can i enable/install FTS4 anyhow?

devos50 · 2016-11-06T20:54:42Z

Hmm it appears that the libsqlite3 on your system has not been compiled with FTS support. Do you see an opportunity to compile the sqlite3 library yourself (with passing the -DSQLITE_ENABLE_FTS4 flag)?

slrslr · 2016-11-06T22:20:56Z

I would like to do it, but i do not know how. I followed tutorial how to compile sqlite3, but i do not know how to pass that flag, mind giving me command/s please? thx

sqlite-autoconf-3150100# ls -lh
total 8.8M
-rw-r--r-- 1 1000 users 364K Nov 4 08:21 aclocal.m4
-rwxr-xr-x 1 1000 users 7.2K Nov 4 08:21 compile
-rwxr-xr-x 1 1000 users 42K Nov 4 08:21 config.guess
-rwxr-xr-x 1 1000 users 36K Nov 4 08:21 config.sub
-rwxr-xr-x 1 1000 users 461K Nov 4 08:21 configure
-rw-r--r-- 1 1000 users 6.1K Nov 4 08:21 configure.ac
-rwxr-xr-x 1 1000 users 24K Nov 4 08:21 depcomp
-rw-r--r-- 1 1000 users 16K Nov 4 08:21 INSTALL
-rwxr-xr-x 1 1000 users 15K Nov 4 08:21 install-sh
-rw-r--r-- 1 1000 users 317K Nov 4 08:21 ltmain.sh
-rw-r--r-- 1 1000 users 718 Nov 4 08:21 Makefile.am
-rw-r--r-- 1 1000 users 37K Nov 4 08:21 Makefile.in
-rw-r--r-- 1 1000 users 27K Nov 4 08:21 Makefile.msc
-rwxr-xr-x 1 1000 users 6.8K Nov 4 08:21 missing
-rw-r--r-- 1 1000 users 3.5K Nov 4 08:21 README.txt
-rw-r--r-- 1 1000 users 7.2K Nov 4 08:21 Replace.cs
-rw-r--r-- 1 1000 users 178K Nov 4 08:21 shell.c
-rw-r--r-- 1 1000 users 8.8K Nov 4 08:21 sqlite3.1
-rw-r--r-- 1 1000 users 6.7M Nov 4 08:21 sqlite3.c
-rw-r--r-- 1 1000 users 30K Nov 4 08:21 sqlite3ext.h
-rw-r--r-- 1 1000 users 480K Nov 4 08:21 sqlite3.h
-rw-r--r-- 1 1000 users 267 Nov 4 08:21 sqlite3.pc.in
-rw-r--r-- 1 1000 users 2.0K Nov 4 08:21 sqlite3.rc
drwxr-xr-x 6 1000 users 4.0K Nov 4 08:21 tea

devos50 · 2016-11-08T08:10:00Z

@slrslr try to following command when building:

make CFLAGS=-DSQLITE_ENABLE_FTS4=1

slrslr · 2016-11-08T13:16:12Z

@devos50
so i did:

./configure
make CFLAGS=-DSQLITE_ENABLE_FTS4=1
make check
make install
make clean
./tribler.sh

The result:

...some code here...
CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo

devos50 · 2016-11-08T13:16:59Z

@slrslr please remove the Tribler state dir (~/.Tribler) and try again 👍

slrslr · 2016-11-08T13:23:42Z

@devos50
so i did:

mv ~/.Tribler ~/.Tribler0
./tribler.sh

now the error is:

...some code here...
SQLError: SQLError: no such module: fts4

dpkg-query -l | grep sqlite
returns: this

loadletter · 2016-11-09T20:42:14Z

I ran in the same issue some time ago.
It's not sqlite but apsw lacking FTS4 support, I solved it by manually downloading and building (will probably require libsqlite3-dev if not installed) apsw with:

python setup.py build --enable-all-extensions

More info @ https://rogerbinns.github.io/apsw/build.html

devos50 · 2016-11-10T08:51:14Z

@loadletter thank you for the info!

@slrslr please let me know whether this works for you 👍

slrslr · 2016-11-10T17:41:31Z

Im a newbie in this so i am unsure how to install properly.
I did:

git clone https://github.com/rogerbinns/apsw.git
cd apsw
python setup.py build --enable-all-extensions
apt-get install libsqlite3-dev
rm -rf ~/.Tribler
/root/tribler/tribler.sh

but returns:

/root/tribler/Tribler/Core/TorrentDef.py:9: RuntimeWarning: to-Python converter for boost::shared_ptrlibtorrent::alert already registered; second conversion method ignored.
from libtorrent import bencode, bdecode
ERROR 1478799581.50 util:239 Exception raised on the reactor's thread SQLError: "SQLError: no such module: fts4".

devos50 · 2016-11-10T17:43:16Z

@slrslr you're not installing the newly built apsw. Please also run the following command after building apsw:

python setup.py install

so the library gets copied to the site-packages directory.

slrslr · 2016-11-10T17:47:14Z

i did:

cd apsw
python setup.py install
rm -rf ~/.Tribler
/root/tribler/tribler.sh

error is the same (no such module fts4)

loadletter · 2016-11-11T12:50:26Z

Try running this:

apt-get purge python-apsw
cd apsw
python2 setup.py build --enable-all-extensions --sqlite install

The --sqlite flag should tell apsw to build it's own copy of sqlite

slrslr · 2016-11-11T21:22:29Z

loadletter: that did not work. "error: option --sqlite not recognized"
so i did same command, only replace install by fetch. And also tried:
"python2 setup.py build --enable=fts4 install"
still tribler complains about missing fts4

loadletter · 2016-11-14T10:12:50Z

Try

cat /root/tribler/Tribler/schema_sdb_v29.sql | sqlite3 /tmp/test.db

If it still gives an error then it's caused by sqlite, otherwise there's something wrong with the python environment

slrslr · 2016-11-15T20:31:21Z

Thx, seems something is wrong with python environment then.

devos50 · 2017-01-12T09:56:49Z

@slrslr did you manage to fix this? Since it's not an issue in Tribler itself, I will close this.

devos50 added the type: bug label Nov 3, 2016

devos50 added this to the V7.0 milestone Nov 3, 2016

devos50 closed this as completed Jan 12, 2017

xvapx mentioned this issue Apr 11, 2018

tribler: 7.0.1 -> 7.0.2 NixOS/nixpkgs#38690

Closed

xoriole mentioned this issue Apr 25, 2018

Issue with installation on Ubuntu 18.04 #3601

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo #2608

CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo #2608

slrslr commented Nov 1, 2016

devos50 commented Nov 3, 2016

devos50 commented Nov 6, 2016

slrslr commented Nov 6, 2016 •

edited

Loading

devos50 commented Nov 6, 2016

slrslr commented Nov 6, 2016 •

edited

Loading

devos50 commented Nov 6, 2016

slrslr commented Nov 6, 2016

devos50 commented Nov 8, 2016

slrslr commented Nov 8, 2016

devos50 commented Nov 8, 2016

slrslr commented Nov 8, 2016

loadletter commented Nov 9, 2016 •

edited

Loading

devos50 commented Nov 10, 2016

slrslr commented Nov 10, 2016

devos50 commented Nov 10, 2016

slrslr commented Nov 10, 2016 •

edited

Loading

loadletter commented Nov 11, 2016 •

edited

Loading

slrslr commented Nov 11, 2016

loadletter commented Nov 14, 2016

slrslr commented Nov 15, 2016

devos50 commented Jan 12, 2017

CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo #2608

CorruptedDatabaseError: Failed to load database version: SQLError: no such table: MyInfo #2608

Comments

slrslr commented Nov 1, 2016

Tribler version/branch+revision:

Operating system and version:

Steps to reproduce the behavior:

devos50 commented Nov 3, 2016

devos50 commented Nov 6, 2016

slrslr commented Nov 6, 2016 • edited Loading

devos50 commented Nov 6, 2016

slrslr commented Nov 6, 2016 • edited Loading

devos50 commented Nov 6, 2016

slrslr commented Nov 6, 2016

devos50 commented Nov 8, 2016

slrslr commented Nov 8, 2016

devos50 commented Nov 8, 2016

slrslr commented Nov 8, 2016

loadletter commented Nov 9, 2016 • edited Loading

devos50 commented Nov 10, 2016

slrslr commented Nov 10, 2016

devos50 commented Nov 10, 2016

slrslr commented Nov 10, 2016 • edited Loading

loadletter commented Nov 11, 2016 • edited Loading

slrslr commented Nov 11, 2016

loadletter commented Nov 14, 2016

slrslr commented Nov 15, 2016

devos50 commented Jan 12, 2017

slrslr commented Nov 6, 2016 •

edited

Loading

slrslr commented Nov 6, 2016 •

edited

Loading

loadletter commented Nov 9, 2016 •

edited

Loading

slrslr commented Nov 10, 2016 •

edited

Loading

loadletter commented Nov 11, 2016 •

edited

Loading