API one.vmpool.monitoring sql error

Our setup : opennebula

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

Hi @aruslan,

We’ve already submitted a fix for this typo: M #: Fix typo in vmpool monitoring query (#1301) · OpenNebula/one@a5b2be4 · GitHub. It will be released in the next maintenance release.


Thank you !