Our setup : opennebula 6.0.0.1-1.ce
We are using API and get error : 0x2000 | INTERNAL | Internal error, e.g. the resource could not be loaded from the DB
Command : one.vmpool.monitoring(34, 3600)
Error message in oned.log :
Tue Jun 15 09:33:24 2021 [Z0][ONE][E]: SQL command was: SELECT vm_monitoring.body FROM vm_monitoring INNER JOIN vm_pool ON vmid = oid WHERE qnn > 1623738425 ANS (uid = 34) ORDER BY vmid, vm_monitoring.last_poll;, error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘ANS (uid = 34) ORDER BY vmid, vm_monitoring.last_poll’ at line 1
Tue Jun 15 09:33:24 2021 [Z0][ReM][E]: Req:9760 UID:34 one.vmpool.monitoring result FAILURE [one.vmpool.monitoring] Internal error