search

galaxyproject / gxadmin

Handy command line utility for Galaxy administrators :rocket:
https://galaxyproject.github.io/gxadmin/#/
GNU General Public License v3.0
23 stars 27 forks source link

`gxadmin query jobs-max-by-cpu-hours` seems to be broken #130

Closed bgruening closed 1 year ago

bgruening commented 1 year ago

galaxy@sn06:~$ gxadmin query jobs-max-by-cpu-hours
ERROR: column "cpu_hours" does not exist LINE 10: ORDER BY cpu_hours desc

bgruening commented 1 year ago

@kysrpex can you look at this one please.

kysrpex commented 1 year ago 
(venv) stats@sn06:~$ gxadmin query jobs-max-by-cpu-hours
    id (encoded)                  |                                            tool_id                                             |        create_time         |       cpu_days        
----------------------------------+------------------------------------------------------------------------------------------------+----------------------------+-----------------------
 11ac94870d0bb33a2b2edeeb30e9468a | upload1                                                                                        | 2021-07-30 20:51:07.55812  |   106751.991167300599
 ...

It is also working without activating the venv. Is it still not working for user galaxy@sn06? I assume both stats and galaxy are calling the same executable located in /usr/bin.

bgruening commented 1 year ago

I fixed it locally ;) I should revert my changes.