[SOLVED] pve-cluster config.db issue?

sondzack

New Member
Dec 9, 2023
4
0
1
Hello Everyone,
Been messing with my proxmox host as one does and it seems I've caused some issue to bork it. Web GUI isn't accessible and my VM's aren't spinning up. Naturally I assumed the first to be a networking issue but it isn't, I'm able to ssh into the server no issue and the interface used to talk to my LAN is up and running.

Running
Code:
systemctl --type=service
reveals that a few core services are not running.
Code:
pve-cluster.service
pve-firewall.service
pve-guests.service
pve-ha-crm.service
pve-ha-lrm.service
pvescheduler.service
pvestatd.service
My assumption is that since the cluster service is unable to start, the other services follow suit.

Output of
Code:
journalctl -u pve-cluster
gives me the following output:

Code:
Dec 09 22:22:26 neptune pmxcfs[3463]: [database] crit: found entry with duplicate name 'lxc' - A:(inode = 0x00000000000237DA, parent = 0x00000000000237D8, v./mtime = 0x237DA/0x1702118905) vs. B:(inode = 0x0000000000023885, parent = 0x00000000000237D8, v./mtime = 0x23>
Dec 09 22:22:26 neptune pmxcfs[3463]: [database] crit: found entry with duplicate name 'lxc' - A:(inode = 0x00000000000237DA, parent = 0x00000000000237D8, v./mtime = 0x237DA/0x1702118905) vs. B:(inode = 0x0000000000023885, parent = 0x00000000000237D8, v./mtime = 0x23>
Dec 09 22:22:26 neptune pmxcfs[3463]: [database] crit: DB load failed
Dec 09 22:22:26 neptune pmxcfs[3463]: [database] crit: DB load failed
Dec 09 22:22:26 neptune pmxcfs[3463]: [main] crit: memdb_open failed - unable to open database '/var/lib/pve-cluster/config.db'
Dec 09 22:22:26 neptune pmxcfs[3463]: [main] notice: exit proxmox configuration filesystem (-1)
Dec 09 22:22:26 neptune pmxcfs[3463]: [main] crit: memdb_open failed - unable to open database '/var/lib/pve-cluster/config.db'
Dec 09 22:22:26 neptune pmxcfs[3463]: [main] notice: exit proxmox configuration filesystem (-1)
Dec 09 22:22:26 neptune systemd[1]: pve-cluster.service: Control process exited, code=exited, status=255/EXCEPTION
Dec 09 22:22:26 neptune systemd[1]: pve-cluster.service: Failed with result 'exit-code'.
Dec 09 22:22:26 neptune systemd[1]: Failed to start pve-cluster.service - The Proxmox VE cluster filesystem.
Dec 09 22:22:26 neptune systemd[1]: pve-cluster.service: Scheduled restart job, restart counter is at 5.
Dec 09 22:22:26 neptune systemd[1]: Stopped pve-cluster.service - The Proxmox VE cluster filesystem.

I've found a few threads that describes a similar issue (this one specifically) and a fix, sadly I'm not well versed in sql to edit the code pasted there nor interpret it.
Any advice would be helpful.
 
Researching the thread and reverse engineering the sqlite synthax I was able to delete the duplicate database entries and start the services, just needed a bit more concentration to get the whole thing going...

So to recap:
Using this thread will most likely solve your issue.
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!