# API one.vmpool.monitoring sql error

**URL:** <https://forum.opennebula.io/t/api-one-vmpool-monitoring-sql-error/9634>\
**Category:** Product Support\
**Created:** [June 15, 2021, 8:09am UTC](https://forum.opennebula.io/t/api-one-vmpool-monitoring-sql-error/9634 "2021-06-15T08:09:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aruslan](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@aruslan](https://forum.opennebula.io/u/aruslan)\
**Post date:** [June 15, 2021, 8:09am UTC](https://forum.opennebula.io/t/api-one-vmpool-monitoring-sql-error/9634/1 "2021-06-15T08:09:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![cgonzalez](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/cgonzalez/32/7096_2.png) [@cgonzalez](https://forum.opennebula.io/u/cgonzalez)\
**Post date:** [June 16, 2021, 8:42am UTC](https://forum.opennebula.io/t/api-one-vmpool-monitoring-sql-error/9634/2 "2021-06-16T08:42:10Z")

</div>

Hi @aruslan,

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

Thanks!

---

<div class="post-metadata">

**Author:** ![aruslan](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@aruslan](https://forum.opennebula.io/u/aruslan)\
**Post date:** [June 16, 2021, 10:04am UTC](https://forum.opennebula.io/t/api-one-vmpool-monitoring-sql-error/9634/3 "2021-06-16T10:04:30Z")

</div>

Thank you !