Hi Stefan, On Tue, Jan 28, 2014 at 5:57 PM, Stefan Kooman <ste...@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/> | cmar...@opennebula.org | @OpenNebula <http://twitter.com/opennebula>
_______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org