# Mount Storage RAID
/dev/sdb /storage btrfs defaults 0 1
# Bind mount
/storage/lxd /var/snap/lxd none defaults,bind 0 0
lxd.daemon[5204]: lvl=warn msg="Failed connecting to global database (attempt 60): failed to create dqlite connection: no available dqlite leader server found" t=2018-09-27T08:46:58-0400
Please run (as root):
Also, install the sqlite3 package and run:
Hi Stephane! Thanks for the reply. Here are my outputs.
root@R510-LXD6-Backup:/var/log/lxd# systemctl stop snap.lxd.daemon
root@R510-LXD6-Backup:/var/log/lxd# pkill -9 lxd
root@R510-LXD6-Backup:/var/log/lxd# lxd --debug --group lxd
DBUG[09-27|13:08:35] Connecting to a local LXD over a Unix socket
DBUG[09-27|13:08:35] Sending request to LXD etag= method=GET url=http://unix.socket/1.0
INFO[09-27|13:08:35] LXD 3.5 is starting in normal mode path=/var/snap/lxd/common/lxd
INFO[09-27|13:08:35] Kernel uid/gid map:
INFO[09-27|13:08:35] - u 0 0 4294967295
INFO[09-27|13:08:35] - g 0 0 4294967295
INFO[09-27|13:08:35] Configured LXD uid/gid map:
INFO[09-27|13:08:35] - u 0 1000000 1000000000
INFO[09-27|13:08:35] - g 0 1000000 1000000000
WARN[09-27|13:08:35] CGroup memory swap accounting is disabled, swap limits will be ignored.
DBUG[09-27|13:08:35] Running kernel does not support netnsid-based network retrieval
INFO[09-27|13:08:35] Initializing local database
INFO[09-27|13:08:35] Initializing database gateway
INFO[09-27|13:08:35] LXD isn't socket activated
DBUG[09-27|13:08:35] Connecting to a local LXD over a Unix socket
DBUG[09-27|13:08:35] Sending request to LXD etag= method=GET url=http://unix.socket/1.0
DBUG[09-27|13:08:35] Detected stale unix socket, deleting
DBUG[09-27|13:08:35] Detected stale unix socket, deleting
INFO[09-27|13:08:35] Starting /dev/lxd handler:
INFO[09-27|13:08:35] - binding devlxd socket socket=/var/snap/lxd/common/lxd/devlxd/sock
INFO[09-27|13:08:35] REST API daemon:
INFO[09-27|13:08:35] - binding Unix socket socket=/var/snap/lxd/common/lxd/unix.socket
INFO[09-27|13:08:35] - binding TCP socket socket=[::]:8443
INFO[09-27|13:08:35] Initializing global database
DBUG[09-27|13:08:35] Found cert k=0
DBUG[09-27|13:08:35] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=0
DBUG[09-27|13:08:35] Dqlite: connection failed err=no available dqlite leader server found attempt=0
DBUG[09-27|13:08:35] Found cert k=0
DBUG[09-27|13:08:35] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=1
DBUG[09-27|13:08:35] Dqlite: connection failed err=no available dqlite leader server found attempt=1
DBUG[09-27|13:08:35] Found cert k=0
DBUG[09-27|13:08:35] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=2
DBUG[09-27|13:08:35] Dqlite: connection failed err=no available dqlite leader server found attempt=2
DBUG[09-27|13:08:36] Found cert k=0
DBUG[09-27|13:08:36] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=3
DBUG[09-27|13:08:36] Dqlite: connection failed err=no available dqlite leader server found attempt=3
DBUG[09-27|13:08:37] Found cert k=0
DBUG[09-27|13:08:37] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=4
DBUG[09-27|13:08:37] Dqlite: connection failed err=no available dqlite leader server found attempt=4
DBUG[09-27|13:08:38] Found cert k=0
DBUG[09-27|13:08:38] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=5
DBUG[09-27|13:08:38] Dqlite: connection failed err=no available dqlite leader server found attempt=5
DBUG[09-27|13:08:39] Found cert k=0
DBUG[09-27|13:08:39] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=6
DBUG[09-27|13:08:39] Dqlite: connection failed err=no available dqlite leader server found attempt=6
DBUG[09-27|13:08:40] Found cert k=0
DBUG[09-27|13:08:40] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=7
DBUG[09-27|13:08:40] Dqlite: connection failed err=no available dqlite leader server found attempt=7
DBUG[09-27|13:08:41] Found cert k=0
DBUG[09-27|13:08:41] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=8
DBUG[09-27|13:08:41] Dqlite: connection failed err=no available dqlite leader server found attempt=8
DBUG[09-27|13:08:42] Found cert k=0
DBUG[09-27|13:08:42] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=9
DBUG[09-27|13:08:42] Dqlite: connection failed err=no available dqlite leader server found attempt=9
DBUG[09-27|13:08:43] Found cert k=0
DBUG[09-27|13:08:43] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=10
DBUG[09-27|13:08:43] Dqlite: connection failed err=no available dqlite leader server found attempt=10
DBUG[09-27|13:08:44] Found cert k=0
DBUG[09-27|13:08:44] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=11
DBUG[09-27|13:08:44] Dqlite: connection failed err=no available dqlite leader server found attempt=11
DBUG[09-27|13:08:45] Failed connecting to global database (attempt 0): failed to create dqlite connection: no available dqlite leader server found
DBUG[09-27|13:08:47] Found cert k=0
DBUG[09-27|13:08:47] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=0
DBUG[09-27|13:08:47] Dqlite: connection failed err=no available dqlite leader server found attempt=0
DBUG[09-27|13:08:48] Found cert k=0
DBUG[09-27|13:08:48] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=1
DBUG[09-27|13:08:48] Dqlite: connection failed err=no available dqlite leader server found attempt=1
DBUG[09-27|13:08:48] Found cert k=0
DBUG[09-27|13:08:48] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=2
DBUG[09-27|13:08:48] Dqlite: connection failed err=no available dqlite leader server found attempt=2
DBUG[09-27|13:08:48] Found cert k=0
DBUG[09-27|13:08:48] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=3
DBUG[09-27|13:08:48] Dqlite: connection failed err=no available dqlite leader server found attempt=3
DBUG[09-27|13:08:49] Found cert k=0
DBUG[09-27|13:08:49] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=4
DBUG[09-27|13:08:49] Dqlite: connection failed err=no available dqlite leader server found attempt=4
DBUG[09-27|13:08:50] Found cert k=0
DBUG[09-27|13:08:50] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=5
DBUG[09-27|13:08:50] Dqlite: connection failed err=no available dqlite leader server found attempt=5
DBUG[09-27|13:08:51] Found cert k=0
DBUG[09-27|13:08:51] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=6
DBUG[09-27|13:08:51] Dqlite: connection failed err=no available dqlite leader server found attempt=6
DBUG[09-27|13:08:52] Found cert k=0
DBUG[09-27|13:08:52] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=7
DBUG[09-27|13:08:52] Dqlite: connection failed err=no available dqlite leader server found attempt=7
DBUG[09-27|13:08:53] Found cert k=0
DBUG[09-27|13:08:53] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=8
DBUG[09-27|13:08:53] Dqlite: connection failed err=no available dqlite leader server found attempt=8
DBUG[09-27|13:08:55] Found cert k=0
DBUG[09-27|13:08:55] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=9
DBUG[09-27|13:08:55] Dqlite: connection failed err=no available dqlite leader server found attempt=9
DBUG[09-27|13:08:56] Found cert k=0
DBUG[09-27|13:08:56] Dqlite: server connection failed err=failed to establish network connection: some nodes are behind this node's version address=10.1.1.180:8443 attempt=10
DBUG[09-27|13:08:56] Dqlite: connection failed err=no available dqlite leader server found attempt=10
root@R510-LXD6-Backup:~# sqlite3 /var/snap/lxd/common/lxd/database/local.db .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE schema (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
version INTEGER NOT NULL,
updated_at DATETIME NOT NULL,
UNIQUE (version)
);
INSERT INTO "schema" VALUES(1,36,1511307143);
INSERT INTO "schema" VALUES(2,37,1522741883);
CREATE TABLE config (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
key VARCHAR(255) NOT NULL,
value TEXT,
UNIQUE (key)
);
INSERT INTO "config" VALUES(4,'core.https_address','[::]:8443');
CREATE TABLE patches (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name VARCHAR(255) NOT NULL,
applied_at DATETIME NOT NULL,
UNIQUE (name)
);
INSERT INTO "patches" VALUES(1,'invalid_profile_names',1511307143);
INSERT INTO "patches" VALUES(2,'leftover_profile_config',1511307143);
INSERT INTO "patches" VALUES(3,'network_permissions',1511307143);
INSERT INTO "patches" VALUES(4,'storage_api',1511307143);
INSERT INTO "patches" VALUES(5,'storage_api_v1',1511307143);
INSERT INTO "patches" VALUES(6,'storage_api_dir_cleanup',1511307143);
INSERT INTO "patches" VALUES(7,'storage_api_lvm_keys',1511307143);
INSERT INTO "patches" VALUES(8,'storage_api_keys',1511307143);
INSERT INTO "patches" VALUES(9,'storage_api_update_storage_configs',1511307143);
INSERT INTO "patches" VALUES(10,'storage_api_lxd_on_btrfs',1511307143);
INSERT INTO "patches" VALUES(11,'storage_api_lvm_detect_lv_size',1511307143);
INSERT INTO "patches" VALUES(12,'storage_api_insert_zfs_driver',1511307143);
INSERT INTO "patches" VALUES(13,'storage_zfs_noauto',1511307143);
INSERT INTO "patches" VALUES(14,'storage_zfs_volume_size',1511307143);
INSERT INTO "patches" VALUES(15,'network_dnsmasq_hosts',1511307143);
INSERT INTO "patches" VALUES(16,'storage_api_dir_bind_mount',1511307143);
INSERT INTO "patches" VALUES(17,'fix_uploaded_at',1511307143);
INSERT INTO "patches" VALUES(18,'storage_api_ceph_size_remove',1511307143);
INSERT INTO "patches" VALUES(19,'devices_new_naming_scheme',1513875991);
INSERT INTO "patches" VALUES(20,'storage_api_permissions',1524064149);
INSERT INTO "patches" VALUES(21,'container_config_regen',1531504253);
INSERT INTO "patches" VALUES(22,'lvm_node_specific_config_keys',1532962241);
INSERT INTO "patches" VALUES(23,'candid_rename_config_key',1534470958);
CREATE TABLE raft_nodes (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
address TEXT NOT NULL,
UNIQUE (address)
);
INSERT INTO "raft_nodes" VALUES(1,'10.1.1.180:8443');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('schema',2);
INSERT INTO "sqlite_sequence" VALUES('patches',23);
INSERT INTO "sqlite_sequence" VALUES('config',4);
INSERT INTO "sqlite_sequence" VALUES('raft_nodes',1);
COMMIT;
After starting lxd:
root@R510-LXD6-Backup:/var/log/lxd# systemctl status snap.lxd.daemon
● snap.lxd.daemon.service - Service for snap application lxd.daemon
Loaded: loaded (/etc/systemd/system/snap.lxd.daemon.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2018-09-27 13:11:43 EDT; 6s ago
Process: 12115 ExecStop=/usr/bin/snap run --command=stop lxd.daemon (code=exited, status=0/SUCCESS)
Main PID: 12746 (daemon.start)
Tasks: 0
Memory: 9.1M
CPU: 186ms
CGroup: /system.slice/snap.lxd.daemon.service
‣ 12746 /bin/sh /snap/lxd/8882/commands/daemon.start
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Preparing a clean copy of /etc
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Setting up ceph configuration
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Setting up LVM configuration
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Rotating logs
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Setting up ZFS (0.6)
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Escaping the systemd cgroups
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: ==> Escaping the systemd process resource limits
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: => Re-using existing LXCFS
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: => Starting LXD
Sep 27 13:11:43 R510-LXD6-Backup lxd.daemon[12746]: lvl=warn msg="CGroup memory swap accounting is disabled, swap limits will be ignored." t=2018-09-27T13:11:43-0400
root@R510-LXD6-Backup:/var/log/lxd# lxc list
Then it just hangs.
Can you show ifconfig -a?
root@R510-LXD6-Backup:~# ifconfig -a
bond0 Link encap:Ethernet HWaddr 00:10:18:ac:a5:16
inet6 addr: fe80::210:18ff:feac:a516/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
RX packets:8415958 errors:0 dropped:325 overruns:0 frame:0
TX packets:647 errors:0 dropped:1 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:4662821304 (4.6 GB) TX bytes:82055 (82.0 KB)
br0 Link encap:Ethernet HWaddr 00:10:18:ac:a5:16
inet addr:10.1.1.180 Bcast:10.1.255.255 Mask:255.255.0.0
inet6 addr: fe80::210:18ff:feac:a516/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:11787 errors:0 dropped:0 overruns:0 frame:0
TX packets:312 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:2129850 (2.1 MB) TX bytes:37715 (37.7 KB)
eno1 Link encap:Ethernet HWaddr d4:ae:52:93:1b:53
BROADCAST MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
eno2 Link encap:Ethernet HWaddr d4:ae:52:93:1b:54
BROADCAST MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 B) TX bytes:0 (0.0 B)
enp5s0f0 Link encap:Ethernet HWaddr 00:10:18:ac:a5:16
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:256309 errors:0 dropped:0 overruns:0 frame:0
TX packets:108 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:147948088 (147.9 MB) TX bytes:17974 (17.9 KB)
enp5s0f1 Link encap:Ethernet HWaddr 00:10:18:ac:a5:16
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:459651 errors:0 dropped:0 overruns:0 frame:0
TX packets:125 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:324340422 (324.3 MB) TX bytes:13530 (13.5 KB)
enp6s0f0 Link encap:Ethernet HWaddr 00:10:18:ac:a5:16
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:3551031 errors:0 dropped:1 overruns:0 frame:0
TX packets:188 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:3611644504 (3.6 GB) TX bytes:29090 (29.0 KB)
enp6s0f1 Link encap:Ethernet HWaddr 00:10:18:ac:a5:16
UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1
RX packets:4148967 errors:0 dropped:12 overruns:0 frame:0
TX packets:226 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:3784512890 (3.7 GB) TX bytes:21461 (21.4 KB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:31745 errors:0 dropped:0 overruns:0 frame:0
TX packets:31745 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1
RX bytes:11993172 (11.9 MB) TX bytes:11993172 (11.9 MB)
So looks like the core of the issue is that you have clustering enabled even though you only have a single node, you've then modified core.https_address to globally bind all addresses which effectively broke clustering. Things likely worked fine until the current schema update where a cluster consistency check is now running and failing.
I suspect you can get things back online by doing:
Stephane, thank you. That was it. Thanks so much for your assistance here. Seriously, when you're in Montreal again PLEASE contact me so I can feed you +1 amazing food. Your contributions and support are very appreciated.
Glad it worked!
Phew, i just found this and it fixed mine! :D
So this is the issue I'm having as mentioned in my closing statement of #5423, I set the address as you said to 192.168.1.1 (the address the server has on lan0 (bridge of eno1 and eno2)), but I'm still coming up with this error. Here's my ifconfig for completeness
$ ifconfig -a
eno1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 169.254.156.232 netmask 255.255.0.0 broadcast 169.254.255.255
ether 94:18:82:38:64:2c txqueuelen 1000 (Ethernet)
RX packets 2475 bytes 456171 (456.1 KB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 880 bytes 254000 (254.0 KB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
device interrupt 16
eno2: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
ether 94:18:82:38:64:2d txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
device interrupt 17
lan0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.1.1 netmask 255.255.248.0 broadcast 192.168.7.255
inet6 2604:6000:1003:44ad:9618:82ff:fe38:642c prefixlen 64 scopeid 0x0<global>
inet6 fe80::9618:82ff:fe38:642c prefixlen 64 scopeid 0x20<link>
inet6 2604:6000:1003:44ad:6218:8340:c488:601f prefixlen 64 scopeid 0x0<global>
ether 94:18:82:38:64:2c txqueuelen 1000 (Ethernet)
RX packets 2081 bytes 276984 (276.9 KB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 754 bytes 230828 (230.8 KB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 24554 bytes 188911027 (188.9 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 24554 bytes 188911027 (188.9 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
Edit also looks like raft_nodes is a wildcard? Is it supposed to be? How do I fix that?
DBUG[01-24|20:10:47] Dqlite: server connection failed err=failed to establish network connection: Head https://[::]:8443/internal/database: dial tcp [::]:8443: connect: connection refused address=[::]:8443 attempt=8
DBUG[01-24|20:10:47] Dqlite: connection failed err=no available dqlite leader server found attempt=8
DBUG[01-24|20:10:48] Dqlite: server connection failed err=failed to establish network connection: Head https://[::]:8443/internal/database: dial tcp [::]:8443: connect: connection refused address=[::]:8443 attempt=9
DBUG[01-24|20:10:48] Dqlite: connection failed err=no available dqlite leader server found attempt=9
^C
[20:10:49] nephele@nephele:~$ sudo sqlite3 /var/snap/lxd/common/lxd/database/local.db .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE schema (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
version INTEGER NOT NULL,
updated_at DATETIME NOT NULL,
UNIQUE (version)
);
INSERT INTO schema VALUES(1,37,1529720435);
INSERT INTO schema VALUES(2,38,1544680613);
CREATE TABLE config (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
key VARCHAR(255) NOT NULL,
value TEXT,
UNIQUE (key)
);
INSERT INTO config VALUES(3,'cluster.https_address','192.168.1.1:8443');
INSERT INTO config VALUES(4,'core.https_address','192.168.1.1:8443');
CREATE TABLE patches (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
name VARCHAR(255) NOT NULL,
applied_at DATETIME NOT NULL,
UNIQUE (name)
);
INSERT INTO patches VALUES(1,'invalid_profile_names',1529720435);
INSERT INTO patches VALUES(2,'leftover_profile_config',1529720435);
INSERT INTO patches VALUES(3,'network_permissions',1529720435);
INSERT INTO patches VALUES(4,'storage_api',1529720435);
INSERT INTO patches VALUES(5,'storage_api_v1',1529720435);
INSERT INTO patches VALUES(6,'storage_api_dir_cleanup',1529720435);
INSERT INTO patches VALUES(7,'storage_api_lvm_keys',1529720435);
INSERT INTO patches VALUES(8,'storage_api_keys',1529720435);
INSERT INTO patches VALUES(9,'storage_api_update_storage_configs',1529720435);
INSERT INTO patches VALUES(10,'storage_api_lxd_on_btrfs',1529720435);
INSERT INTO patches VALUES(11,'storage_api_lvm_detect_lv_size',1529720435);
INSERT INTO patches VALUES(12,'storage_api_insert_zfs_driver',1529720435);
INSERT INTO patches VALUES(13,'storage_zfs_noauto',1529720435);
INSERT INTO patches VALUES(14,'storage_zfs_volume_size',1529720435);
INSERT INTO patches VALUES(15,'network_dnsmasq_hosts',1529720435);
INSERT INTO patches VALUES(16,'storage_api_dir_bind_mount',1529720435);
INSERT INTO patches VALUES(17,'fix_uploaded_at',1529720435);
INSERT INTO patches VALUES(18,'storage_api_ceph_size_remove',1529720435);
INSERT INTO patches VALUES(19,'devices_new_naming_scheme',1529720435);
INSERT INTO patches VALUES(20,'storage_api_permissions',1529720435);
INSERT INTO patches VALUES(21,'container_config_regen',1531453517);
INSERT INTO patches VALUES(22,'lvm_node_specific_config_keys',1532726207);
INSERT INTO patches VALUES(23,'candid_rename_config_key',1534281880);
INSERT INTO patches VALUES(24,'move_backups',1536801812);
INSERT INTO patches VALUES(25,'storage_api_rename_container_snapshots_dir',1539293314);
INSERT INTO patches VALUES(26,'shrink_logs_db_file',1541499067);
INSERT INTO patches VALUES(27,'storage_api_rename_container_snapshots_links',1541747171);
CREATE TABLE raft_nodes (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
address TEXT NOT NULL,
UNIQUE (address)
);
INSERT INTO raft_nodes VALUES(1,'[::]:8443');
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('schema',2);
INSERT INTO sqlite_sequence VALUES('patches',27);
INSERT INTO sqlite_sequence VALUES('config',4);
INSERT INTO sqlite_sequence VALUES('raft_nodes',4);
COMMIT;
Most helpful comment
Phew, i just found this and it fixed mine! :D