Insert problems from dqlite shell about go-dqlite HOT 4 CLOSED

I've done this and indeed solved the problem. Thank you for your help and for the quick answer.

from go-dqlite.

I couldn't reproduce this, at least with the demo application:

$ dqlite-demo -a 127.0.0.1:8001 -d 127.0.0.1:9001 &
[1] 99711
$ dqlite-demo -a 127.0.0.1:8002 -d 127.0.0.1:9002 -j 127.0.0.1:9001 &
[2] 99727
$ dqlite-demo -a 127.0.0.1:8003 -d 127.0.0.1:9003 -j 127.0.0.1:9001 &
[3] 99739
$ dqlite -s 127.0.0.1:9001,127.0.0.1:9002,127.0.0.1:9003 test
dqlite> CREATE TABLE test (id INT, s TEXT)
dqlite> INSERT INTO test VALUES (1, 'a')
dqlite> INSERT INTO test VALUES (2, 'b')
dqlite> SELECT * FROM test;
1|a
2|b

Do you have a more detailed list of steps to follow?

from go-dqlite.

Well, I ran exactly the test with default demo application and I obtained the same result. Dqlite is installed on Ubuntu 18.04 with:

But I don't have this problem from my applications, where I'm able to send insert commands to dqlite that works well.

from go-dqlite.

The dqlite shell is currently not included in the deb package in the stable archive, so I assume you have built the binary yourself with something go install -tags libsqlite3 ./cmd/dqlite.

Assuming that's the case, your clone of the go-dqlite git repo is probably behind master, since the bug you are seeing was fixed a few days ago by f90c4bc .

Please try to run go get -tags libsqlite3 -u github.com/canonical/go-dqlite, then rebuild the shell binary. That should fix the issue.

from go-dqlite.