This message was deleted.
# k3sa
adamant-kite-43734
11/27/2024, 9:55 AMThis message was deleted.
b
billowy-computer-46613
11/27/2024, 9:57 AMOn a side quest I've tried to open the underlying sqlite db directly:
Copy code
sqlite state.db <<< ".tables"
Unable to open database "state.db": file is encrypted or is not a databasebillowy-computer-46613
11/27/2024, 9:59 AMIn the "backup/restore" docs there is a note:
In addition to backing up the datastore itself, you must also back up the server token file at /var/lib/rancher/k3s/server/token
billowy-computer-46613
11/27/2024, 9:59 AMShould I use the token file at opening the db? Bot how, I don't see an encryption flag for sqlite ...
billowy-computer-46613
11/27/2024, 12:39 PMOk, 1 issue I solved: you can open up the sqlite db file directly, but you have to use sqlite3 :
Copy code
sqlite3 state.db <<< ".tables"
kines
sticky-summer-13450
11/27/2024, 2:27 PMLooking at a K3s cluster which is over 4 year old, my kine db is 190MB - so 21GB seems quite large. Do you have a lot of CRDs and data stored in them?
b
billowy-computer-46613
11/27/2024, 2:43 PMI did a
Copy code
kubectl get-all | wc -l
2291billowy-computer-46613
11/27/2024, 2:43 PMso there are 2000 objects (including CRDs) in the api server, it still doesn't explaimn it ...
s
sticky-summer-13450
11/27/2024, 3:04 PMAh - I've found another node which was running hundreds of thousnads of jobs a day for a long time and it is a bit larger...
Copy code
-rw-r--r-- 1 root root 7.1G Nov 27 14:28 state.db
-rw-r--r-- 1 root root 170M Nov 27 14:28 state.db-shm
-rw-r--r-- 1 root root 86G Nov 27 14:28 state.db-wal.db-wal.db29 Views