Database error: "sql: transaction has already been committed or rolled back"

[tomp (Thomas Parrott)]

@kpfa

Error: Failed to fetch from "config" table: sql: transaction has already been committed or rolled back

We’ve seen this error before in relation to transaction contention related to slow I/O, see

LXD 4.19 has been released

Here is the lxd log on the node that went off (host and ip addresses have been redacted): journalctl -u snap.lxd.daemon -n 100 -- Logs begin at Fri 2021-03-26 12:26:54 UTC, end at Wed 2021-11-17 12:59:13 UTC. -- Nov 16 11:03:24 server1 lxd.daemon[2148742]: github.com/lxc/lxd/lxd/storage/drivers.(*btrfs).getSubvolumes(0xc03422c1e0, {0xc02495d110, 0x62}) Nov 16 11:03:24 server1 lxd.daemon[2148742]: /build/lxd/parts/lxd/src/lxd/storage/drivers/driver_btrfs_utils.go:62 +0xee Nov 16 11:03:24…