[Release-1.27] - Single server with SQLite

[vitorsavian]

Backport fix for Single server with SQLite

• Single server with SQLite #5957

[VestigeJ]

Cluster is ready and healthy

$ COMMIT=c852d3c71b5fdd741a7df7513836ef719087e282

config.yaml

token: YOUR_TOKEN_HERE
write-kubeconfig-mode: 644
debug: true
cni: multus,cilium
disable-etcd: true

$ kgn

NAME              STATUS   ROLES                  AGE   VERSION
ip-1-1-1-2        Ready    control-plane,master   48m   v1.27.14+rke2r1

$ kgp -A

NAMESPACE     NAME                                                    READY   STATUS      RESTARTS      AGE
kube-system   cilium-b65x8                                            1/1     Running     0             47m
kube-system   cilium-operator-7cc5f4bf64-kn9p6                        0/1     Pending     0             47m
kube-system   cilium-operator-7cc5f4bf64-lhcdn                        1/1     Running     0             47m
kube-system   cloud-controller-manager-ip-1-1-1-2                     1/1     Running     0             47m
kube-system   helm-install-rke2-cilium-q7x9n                          0/1     Completed   0             47m
kube-system   helm-install-rke2-coredns-cqnj8                         0/1     Completed   0             47m
kube-system   helm-install-rke2-ingress-nginx-wzvkb                   0/1     Completed   0             47m
kube-system   helm-install-rke2-metrics-server-fmtx9                  0/1     Completed   0             47m
kube-system   helm-install-rke2-multus-rbbm7                          0/1     Completed   0             42m
kube-system   helm-install-rke2-snapshot-controller-crd-2pwml         0/1     Completed   0             47m
kube-system   helm-install-rke2-snapshot-controller-j7f89             0/1     Completed   1             47m
kube-system   helm-install-rke2-snapshot-validation-webhook-5zsz6     0/1     Completed   0             47m
kube-system   kube-apiserver-ip-1-1-1-2                               1/1     Running     0             47m
kube-system   kube-controller-manager-ip-1-1-1-2                      1/1     Running     0             47m
kube-system   kube-proxy-ip-1-1-1-2                                   1/1     Running     0             47m
kube-system   kube-scheduler-ip-1-1-1-2                               1/1     Running     0             47m
kube-system   rke2-coredns-rke2-coredns-864fbd7785-l4dnq              1/1     Running     0             47m
kube-system   rke2-coredns-rke2-coredns-autoscaler-6c87968579-svv4l   1/1     Running     0             47m
kube-system   rke2-ingress-nginx-controller-zdx5j                     1/1     Running     0             44m
kube-system   rke2-metrics-server-7f745dbddf-x9h96                    1/1     Running     0             45m
kube-system   rke2-multus-g7qzt                                       1/1     Running     2 (45m ago)   47m
kube-system   rke2-multus-rke2-whereabouts-7b5q8                      1/1     Running     0             42m
kube-system   rke2-snapshot-controller-7d6476d7cb-j9bcg               1/1     Running     0             44m
kube-system   rke2-snapshot-validation-webhook-5649fbd66c-j2ff2       1/1     Running     0             45m

//observe sqlite start up in journalctl
$ sudo journalctl -u rke2-server | grep -i sqlite

Jun 11 18:56:12 ip-1-1-1-2 rke2[2771]: time="2024-06-11T18:56:12Z" level=info msg="Configuring sqlite3 database connection pooling: maxIdleConns=2, maxOpenConns=0, connMaxLifetime=0s"
Jun 11 18:56:15 ip-1-1-1-2 rke2[2771]: time="2024-06-11T18:56:15Z" level=info msg="Configuring sqlite3 database connection pooling: maxIdleConns=2, maxOpenConns=0, connMaxLifetime=0s"

//observe kine table stored in state.db /var/lib/rancher/rke2/server/db/state.db

$ sudo sqlite3 /var/lib/rancher/rke2/server/db/state.db
// sample output from sqlite query on kine table

3585|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3580|0|k8s|k8s
3586|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3578|0|k8s|k8s
3587|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3583|0|k8s|k8s
3588|/registry/leases/kube-node-lease/ip-1-1-1-2|0|0|412|3576|0|k8s|k8s
3589|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3587|0|k8s|k8s
3590|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3589|0|k8s|k8s
3591|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3585|0|k8s|k8s
3592|/registry/masterleases/cronkite|0|0|226|3581|15|k8s|k8s
3593|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3590|0|k8s|k8s
3594|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3586|0|k8s|k8s
3595|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3593|0|k8s|k8s
3596|/registry/leases/kube-system/apiserver-pyj7xergzm27bncry5nhddlroi|0|0|92|3584|0|k8s|k8s
3597|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3591|0|k8s|k8s
3598|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3595|0|k8s|k8s
3599|/registry/leases/kube-node-lease/ip-1-1-1-2|0|0|412|3588|0|k8s|k8s
3600|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3598|0|k8s|k8s
3601|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3600|0|k8s|k8s
3602|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3594|0|k8s|k8s
3603|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3597|0|k8s|k8s
3604|/registry/masterleases/cronkite|0|0|226|3592|15|k8s|k8s
3605|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3601|0|k8s|k8s
3606|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3605|0|k8s|k8s
3607|/registry/minions/ip-1-1-1-2|0|0|223|3260|0|k8s|k8s
3608|/registry/leases/kube-system/apiserver-pyj7xergzm27bncry5nhddlroi|0|0|92|3596|0|k8s|k8s
3609|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3603|0|k8s|k8s
3610|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3606|0|k8s|k8s
3611|/registry/leases/kube-node-lease/ip-1-1-1-2|0|0|412|3599|0|k8s|k8s
3612|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3610|0|k8s|k8s
3613|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3602|0|k8s|k8s
3614|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3612|0|k8s|k8s
3615|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3609|0|k8s|k8s
3616|/registry/masterleases/cronkite|0|0|226|3604|15|k8s|k8s
3617|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3614|0|k8s|k8s
3618|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3617|0|k8s|k8s
3619|/registry/leases/kube-system/apiserver-pyj7xergzm27bncry5nhddlroi|0|0|92|3608|0|k8s|k8s
3620|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3613|0|k8s|k8s
3621|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3615|0|k8s|k8s
3622|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3618|0|k8s|k8s
3623|/registry/leases/kube-node-lease/ip-1-1-1-2|0|0|412|3611|0|k8s|k8s
3624|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3622|0|k8s|k8s
3625|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3624|0|k8s|k8s
3626|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3621|0|k8s|k8s
3627|/registry/masterleases/cronkite|0|0|226|3616|15|k8s|k8s
3628|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3625|0|k8s|k8s
3629|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3620|0|k8s|k8s
3630|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3628|0|k8s|k8s
3631|/registry/leases/kube-system/apiserver-pyj7xergzm27bncry5nhddlroi|0|0|92|3619|0|k8s|k8s
3632|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3626|0|k8s|k8s
3633|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3630|0|k8s|k8s
3634|/registry/leases/kube-node-lease/ip-1-1-1-2|0|0|412|3623|0|k8s|k8s
3635|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3633|0|k8s|k8s
3636|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3635|0|k8s|k8s
3637|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3629|0|k8s|k8s
3638|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3632|0|k8s|k8s
3639|/registry/masterleases/cronkite|0|0|226|3627|15|k8s|k8s
3640|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3636|0|k8s|k8s
3641|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3640|0|k8s|k8s
3642|/registry/leases/kube-system/apiserver-pyj7xergzm27bncry5nhddlroi|0|0|92|3631|0|k8s|k8s
3643|/registry/leases/kube-system/snapshot-controller-leader|0|0|1210|3638|0|k8s|k8s
3644|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3641|0|k8s|k8s
3645|/registry/leases/kube-node-lease/ip-1-1-1-2|0|0|412|3634|0|k8s|k8s
3646|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1406|3637|0|k8s|k8s
3647|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3644|0|k8s|k8s
3648|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|701|3647|0|k8s|k8s
sqlite>