[jira] [Resolved] (VCL-904) BIGINT UNSIGNED issue in isAvailable function

["Josh Thompson (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/VCL-904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Josh Thompson resolved VCL-904.
-------------------------------
    Resolution: Fixed

> BIGINT UNSIGNED issue in isAvailable function
> ---------------------------------------------
>
>                 Key: VCL-904
>                 URL: https://issues.apache.org/jira/browse/VCL-904
>             Project: VCL
>          Issue Type: Bug
>          Components: web gui (frontend)
>            Reporter: Josh Thompson
>
> Using mariadb 5.5.41, the frontend encounters an error with a query in the isAvailable function under certain conditions. If a vmhost only has VMs assigned to with currentimageid pointing to noimage, they query that checks for a vmhost having enough RAM available has a problem with (v.allocRAM - i.minram + {$images[$imageid]['minram']). Apparently, something internal to mariadb casts that to be BIGINT UNSIGNED but also considers something in there to be negative, causing an error. This is easily dealt with by creating allocRAM as 'int' instead of 'unsigned mediumint' and casting i.minram as signed.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)