Error parsing VM_STATE: syntax error, unexpected VARIABLE, expecting EQUAL or EQUAL_EMPTY at line 0, columns 10:12

Community Support
1

When i create vms , i get following error messages in oned.log :

Wed Apr 17 15:56:53 2024 [Z0][InM][E]: Received message was: database is locked

Wed Apr 17 15:56:58 2024 [Z0][InMeow][E]: Error parsing VM_STATE: syntax error, unexpected VARIABLE, expecting EQUAL or EQUAL_EMPTY at line 0, columns 10:12payload: database is locked

Wed Apr 17 15:56:58 2024 [Z0][InM][E]: Received message was: database is locked

Wed Apr 17 15:57:03 2024 [Z0][InMeow][E]: Error parsing VM_STATE: syntax error, unexpected VARIABLE, expecting EQUAL or EQUAL_EMPTY at line 0, columns 10:12payload: database is locked

Wed Apr 17 15:57:03 2024 [Z0][InM][E]: Received message was: database is locked

Please help me with this error, i am using OpenNebula 6.0.0.2 ().

Versions of the related components and OS (frontend, hypervisors, VMs):

Steps to reproduce:

Current results:

Expected results:

2

Try again with a more recent version like 6.4 or 6.8

3

Unfortunately i can’t , since i did many updates to adapt 6.0.0.2 for my other tools . is it some kind of known issue for Opennebula 6.0.0.2 ?

4

The problem is that 6.0 is no longer supported so, any bugs or issues it has will stay like that.

Try to take a look at the sqlite database file that holds the VM state in the hypervisor node. It should be located at /var/tmp/one/im/status_kvm_<host_id>.db. The VM state is held there and for some reason the database can’t be read apparently. If you can’t fix it, try deleting it. It should be recreated afterwards by the monitoring drivers automatically.

5

Deleting /var/tmp/one/im/status_kvm_<host_id>.db did not solve the problem, i still receive error messages into my oned.log , also i have these hanging processes , last 2 processes turn on and off periodically.

oneadmin  6905  0.0  0.0 1756420 35968 ?       Ssl  Apr13   2:33 ruby ./monitord-client.rb kvm 0 198.18.224.169
oneadmin  7537  0.0  0.0 1756424 36188 ?       Ssl  Apr13   2:33 ruby ./monitord-client.rb kvm 0 198.18.224.169
oneadmin  8429  0.0  0.0 1756420 35996 ?       Ssl  Apr13   2:30 ruby ./monitord-client.rb kvm 0 198.18.224.169
oneadmin  9485  0.0  0.0 1756416 36200 ?       Ssl  Apr13   2:32 ruby ./monitord-client.rb kvm 0 198.18.224.169
oneadmin 12658  0.0  0.0 315444 18976 ?        Sl   14:19   0:00 ruby ./../kvm-probes.d/vm/status/state.rb kvm 0 198.18.224.169
oneadmin 12662  0.0  0.0  95660 13276 ?        R    14:19   0:00 ruby ./../kvm-probes.d/vm/status/state.rb kvm 0 198.18.224.169
root     12667  0.0  0.0  11468  1120 pts/0    S+   14:19   0:00 grep ruby
root@vt-dev2-host.vtastic-dev:/a#