Hi all,
what databases does Beaker support? I had the impression that it should support
MySQL and PostgreSQL to name a few but with Postgre I keep getting errors.
When you import a distro in Cobbler and then run the osversion.trigger script on
the beaker-server I get this error:
ProgrammingError: (ProgrammingError) function min(boolean) does not exist at
character 639
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
'SELECT watchdog.id AS watchdog_id, watchdog.system_id AS watchdog_system_id,
watchdog.recipe_id AS watchdog_recipe_id, watchdog.recipetask_id AS
watchdog_recipetask_id, watchdog.subtask AS watchdog_subtask, watchdog.kill_time
AS watchdog_kill_time \nFROM watchdog JOIN system ON system.id =
watchdog.system_id JOIN recipe ON recipe.id = watchdog.recipe_id JOIN recipe_set
ON recipe_set.id = recipe.recipe_set_id \nWHERE %(param_1)s =
system.lab_controller_id AND recipe_set.id IN (SELECT recipe_set.id \nFROM
watchdog JOIN recipe ON recipe.id = watchdog.recipe_id JOIN recipe_set ON
recipe_set.id = recipe.recipe_set_id GROUP BY recipe_set.id \nHAVING
min(watchdog.kill_time <= %(kill_time_1)s)) ORDER BY watchdog.id'
{'kill_time_1': datetime.datetime(2011, 4, 15, 18, 10, 26, 66766),
'param_1': 1}
2011-04-15 21:10:26,097 bkr.server.xmlrpccontroller ERROR Error handling XML-RPC
method
The offending part I think is HAVING min(watchdog.kill_time <= %(kill_time_1)s))
Regards,
Alexander.