[one-users] oneacct [VirtualMachinePoolAccounting] Internal Error

[Stefan Kooman]

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

-- 
| BIT BV  http://www.bit.nl/        Kamer van Koophandel 09090351
| GPG: 0xD14839C6                   +31 318 648 688 / info at bit.nl