SQLite Forum

lsm1 compression
The lsm datastore was created using a Python webapp (built using sanic) running under Python 3.8. The webapp logs these version numbers:

[2020-09-05 12:24:57 -0700] [95053] [INFO] sqlite3.version is 2.6.0
[2020-09-05 12:24:57 -0700] [95053] [INFO] sqlite3.sqlite_version is 3.33.0


lsm.so was built from `SQLite version 3.34.0 2020-09-01 19:02:52`.

Maybe the version mismatch is the underlying issue?

Here's the webapp datastore code (we also use a standard sqlite table):
        self.conn = sqlite3.connect(":memory:")
        self.conn.create_function("REGEXP", 2, regex_match)
        self.conn.execute('''CREATE VIRTUAL TABLE cdx USING lsm1 ('collections/%s/%s.lsm', key, TEXT, cdxline);''' % (name, name,) )
        self.replicator = sqlite3.connect("collections/%s/%s.replication.sqlite" % (name, name,))

I've tried to open the .lsm within the sqlite3 cli, but I'm missing something (`Error: lsm_open failed with 266`):
% ./sqlite3
SQLite version 3.34.0 2020-09-01 19:02:52
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .load ext/lsm1/lsm.so
sqlite> CREATE VIRTUAL TABLE cdx USING lsm1 ('/Users/baraherself/collections/lz4_weetest/lz4_weetest.lsm', key, TEXT, cdxline);
Error: lsm_open failed with 266

I can provide webapp code, the ingested data, or the troubled .lsm, if helpful.