Technical Note: LXD Database and patch SQL
I deleted some unused zfs storage pools without realizing that they are used by LXD, so today after a machine rebooted, LXD refused to startups with following log messages were output to lxd.log files t = 2019-10-07T23:02:43+0900 lvl = info msg = "Initializing storage pools" t = 2019-10-07T23:02:43+0900 lvl = eror msg = "Failed to start the daemon: ZFS storage pool \"juju-zfs\" could not be imported: " t = 2019-10-07T23:02:43+0900 lvl = info msg = "Starting shutdown sequence" t As lxd settings are stored in dqlite database (distributed sqlite) at /var/snap/lxd/common/lxd/database/global/db.bin , so I go confirm the record settings. sqlite> .tables certificates networks config networks_config images networks_nodes images_aliases nodes images_nodes operations images_properties profiles i