SQLite Forum

lsm1 compression
Login
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.enable_load_extension(True)
        self.conn.load_extension("lsm.so")
        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
sqlite> 
```

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