[one-users] oneacct [VirtualMachinePoolAccounting] Internal Error

[Carlos Martín Sánchez]

Hi Stefan,

On Tue, Jan 28, 2014 at 5:57 PM, Stefan Kooman <stefan at bit.nl> wrote:

> Hi list,
>
> Running oneact as oneadmin user I get the following error:
>
> oneacct
> [VirtualMachinePoolAccounting] Internal Error.
>
> oned.log shows:
>
> Tue Jan 28 17:21:19 2014 [ReM][D]: Req:6624 UID:0
> VirtualMachinePoolAccounting invoked, -2, -1, -1
> Tue Jan 28 17:21:19 2014 [ONE][E]: SQL command was: SELECT history.body
> FROM history INNER JOIN vm_pool WHERE vid=oid GROUP BY vid,seq, error
> 1055 : 'opennebula.history.body' isn't in GROUP BY
> Tue Jan 28 17:21:19 2014 [ReM][E]: Req:6624 UID:0
> VirtualMachinePoolAccounting result FAILURE
> [VirtualMachinePoolAccounting] Internal Error
>
> I don't know for sure it ever worked after I upgraded to onennebula-4.4.
>
> It might have to do with our mysql server settings (sql-mode):
> sql-mode                       =
>
> STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
>
> But I'm not sure.
>
> How to best debug this issue?
>
> Gr. Stefan
>

It definitely looks like a problem with the ONLY_FULL_GROUP_BY flag.
Now that I think about it, we don't really need the group by, and it may
probably be a bug and we meant to use ORDER BY [1].

Regards

[1] http://dev.opennebula.org/issues/2700

--
Carlos Martín, MSc
Project Engineer
OpenNebula - Flexible Enterprise Cloud Made Simple
www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org |
@OpenNebula <http://twitter.com/opennebula>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20140130/ac53ff9c/attachment-0001.htm>