Data intensive science for everyone. https://galaxyproject.org | https://usegalaxy.org | https://help.galaxyproject.org
py3_addons
in https://github.com/galaxyproject/galaxy/blob/dev/.travis.yml for macro syntax.
CREATE TEMPORARY TABLE temp_queue_times AS
select
min(a.create_time - b.create_time) as queue_time
from
job_state_history as a
inner join
job_state_history as b
on
(a.job_id = b.job_id)
where
a.job_id in (select id from job where tool_id like '%"$1"%' and state = 'ok' and create_time > (now() - '3 months'::interval))
and a.state = 'running'
and b.state = 'queued'
group by
a.job_id
order by
queue_time desc
;
--
select
min(queue_time),
percentile_cont(0.95) WITHIN GROUP (ORDER BY queue_time) as perc_95,
percentile_cont(0.99) WITHIN GROUP (ORDER BY queue_time) as perc_99,
max(queue_time)
from temp_queue_times;
bash scripts/queue_time.sh rnastar
min | perc_95 | perc_99 | max
-----------------+-----------------+-----------------+-----------------------
00:00:08.007632 | 04:42:01.661542 | 10:59:26.373311 | 1 day 05:24:10.246863
[i for i in $var1 if i in $var2]
Hi, I did not notice immediately, but I think that since we have updated to release_18.05, the files that are ftp-uploaded by our instance's users are not seen anymore in the "Choose FTP files" panel (warning "Your FTP directory does not contain any files."). We are still using the .ini format for the galaxy config files; the galaxy log says
galaxy.webapps.galaxy.api.remote_files WARNING 2018-08-22 13:02:33,773 [p:31389,w:2,m:0] [uWSGIWorker2Core4] The directory "'/home/galaxy/galaxy-dist/database/ftp/drosofff@gmail.com'" does not exist.
which is not true !
Any new variable to adjust with release_18.05 ?
"The directory \"%s\" does not exist."
, if you fill that with a path you should get 'The directory "/some/path" does not exist.'