SQLite error on Mint Linux 12 #8

New Issue

2012-11-29T20:15:30+01:00

philipmorg commented

2012-11-29 20:15:30 +01:00

(Migrated from github.com)

Trying PyBitmessage on an updated install of Mint Linux 12, and I get the following SQLite error:

python bitmessagemain.py 
Loading config files from /home/philip/.PyBitmessage/
reloading my address hashes
Database file already exists.
Problem: The version of SQLite you have cannot store Null values. Please download and install the latest revision of your version of Python (for example, the latest Python 2.7 revision) and try again. Exiting.
Exception KeyError: KeyError(-1226089616,) in <module 'threading' from '/usr/lib/python2.7/threading.pyc'> ignored

(python:1860): GLib-CRITICAL **: g_main_context_pop_thread_default: assertion `g_queue_peek_head (stack) == context' failed

Trying PyBitmessage on an updated install of Mint Linux 12, and I get the following SQLite error: ``` python bitmessagemain.py Loading config files from /home/philip/.PyBitmessage/ reloading my address hashes Database file already exists. Problem: The version of SQLite you have cannot store Null values. Please download and install the latest revision of your version of Python (for example, the latest Python 2.7 revision) and try again. Exiting. Exception KeyError: KeyError(-1226089616,) in <module 'threading' from '/usr/lib/python2.7/threading.pyc'> ignored (python:1860): GLib-CRITICAL **: g_main_context_pop_thread_default: assertion `g_queue_peek_head (stack) == context' failed ```

maran commented

2012-11-29 21:39:09 +01:00

(Migrated from github.com)

Did you check the error message? Do you have sqlite 3 installed?

philipmorg commented

2012-11-29 23:24:11 +01:00

(Migrated from github.com)

SQLite appears to be installed.

maran commented

2012-11-29 23:29:02 +01:00

(Migrated from github.com)

Yes but do you have Sqlite3 or perhaps an older version?

Atheros1 commented

2012-11-29 23:37:32 +01:00

(Migrated from github.com)

I believe that some of the earlier minor revisions of Sqlite3 may not be able to store NULL values either. I'm not sure when they added the feature. Google is not proving to be helpful.

philipmorg commented

2012-11-29 23:41:39 +01:00

(Migrated from github.com)

Hmmm...

>>> import sqlite3
>>> sqlite3.sqlite_version
'3.7.7'
>>> sqlite3.version
'2.6.0'

I can't seem to upgrade beyond these versions of sqlite.

Is the problem in the installed version of SQLite or the Python SQLite library?

Hmmm... ``` >>> import sqlite3 >>> sqlite3.sqlite_version '3.7.7' >>> sqlite3.version '2.6.0' ``` I can't seem to upgrade beyond these versions of sqlite. Is the problem in the installed version of SQLite or the Python SQLite library?

Atheros1 commented

2012-11-29 23:51:27 +01:00

(Migrated from github.com)

Your version numbers are higher and equal to mine. Mine are:
3.6.21
2.6.0

I'm not sure what to try.

Your version numbers are higher and equal to mine. Mine are: 3.6.21 2.6.0 I'm not sure what to try.

philipmorg commented

2012-11-30 00:20:44 +01:00

(Migrated from github.com)

Ok, thanks for looking in to it. I'm happy to try to keep troubleshooting on my end if you have other things I should check.

This repo is archived. You cannot comment on issues.