Explorer's container fails to start when vector extension installed

[mwytock0812]

Steps to reproduce

Establish a new kuzu database and run INSTALL VECTOR. In python:

self.connection.execute("INSTALL vector; LOAD vector;")

Run the explorer container. With podman:

podman run -p 8004:8000 \
           -v ./data/kuzu_db:/database:U \
           --rm kuzudb/explorer:0.11.0

Expected result

Successful load of the explorer.

Actual result

[22:23:35.326] ERROR (1): Error getting version of Kuzu: Error: Error during recovery: IO exception: Failed to load library: /home/node/.kuzu/extension/0.11.0/linux_arm64/vector/libvector.kuzu_extension which is needed by extension: vector.
Error: /home/node/.kuzu/extension/0.11.0/linux_arm64/vector/libvector.kuzu_extension: cannot open shared object file: No such file or directory.

[mewim]

Hi @mwytock0812,

I think #299 is related. Can you try the solution mentioned in that issue and see if it fixes your problem?

[mwytock0812]

Thanks @mewim that fix does seem to work. For others viewing the issue.

self.connection.execute("INSTALL vector; LOAD vector; CHECKPOINT;")

Would you recommend running CHECKPOINT like this every time extensions are installed in an app's development startup loop (where the CHECKPOINT_THRESHOLD may not trigger a merge of the data from the WAL to disk)?

[mewim]

@mwytock0812 Usually it is not required to checkpoint frequently. Just need to do it once before closing the database to make sure the WAL is empty.

[mwytock0812]

Perfect, I added a checkpoint on app shutdown, which seems to prevent this. Thanks for your swift reply and help!