Open Microscopy Environment

Hi,

it's the user number 803 (should have mention it in the previous post). It would be hard to know when the images were imported. February or March is the closest I can get.

Daniel

Hi Daniel,

can you try a query like this:

Code: Select all

$ omero hql -q "select f.id, f.templatePrefix, count(i.id) from Fileset f left outer join f.images i where f.details.creationEvent.time > '2016-02-01' and f.details.owner.id = 803 group by f.id, f.templatePrefix"
#  | Col1  | Col2                            | Col3
----+-------+---------------------------------+------
0  | 20656 | demo_2/2016-05/20/16-37-52.836/ | 3
1  | 19333 | demo_2/2016-05/18/08-05-51.906/ | 1
2  | 19462 | demo_2/2016-05/18/09-11-27.188/ | 1
...


Cheers,
~Josh.

Hi,

we tried two queries, both with no results:

Code: Select all

omero@omero3:~$ omero hql -q "select f.id, f.templatePrefix, count(i.id) from Fileset f left outer join f.images i where f.details.creationEvent.time > '2016-02-01' and f.details.owner.id = 803 group by f.id, f.templatePrefix"
Previous session expired for root on localhost:4064
Server: [localhost:4064]
Username: [root]
Password:
#
---
(0 rows)


Code: Select all

omero@omero3:~$ omero hql -q "select f.id, f.templatePrefix, count(i.id) from Fileset f left outer join f.images i where f.details.creationEvent.time > '2015-01-01' and f.details.owner.id = 803 group by f.id, f.templatePrefix"
#
---
(0 rows)


Hi Daniel,

sorry, I should have added it to my example. Can you add `--all` to your `bin/omero hql` statement when logging in as root? (since the data is likely in a different group)

~Josh.

Hi Josh,

here is the result of the new query, I'm just not sure what it means.

Code: Select all

omero@omero3:~$ omero hql --all -q "select f.id, f.templatePrefix, count(i.id) from Fileset f left outer join f.images i where f.details.creationEvent.time > '2016-02-01' and f.details.owner.id = 803 group by f.id, f.templatePrefix"
# | Col1  | Col2                                  | Col3
---+-------+---------------------------------------+------
0 | 35510 | mvasseur_803/2016-03/21/10-47-26.812/ | 0   
1 | 37573 | mvasseur_803/2016-03/31/08-48-08.538/ | 0   
2 | 32011 | mvasseur_803/2016-02/25/11-24-46.983/ | 0   
(3 rows)


Thank you for your help,
Daniel

Those 3 filesets -- 35510, 37573, 32011 -- have no images but likely have files associated. You can either check for the timestamp directories yourself, e.g. /OMERO/ManagedRepository/mvasseur_803/2016-03/21/10-47-26.812/, or you can let OMERO clean them up:

bin/omero delete Fileset:35510

Add: "--report --dry-run" if you want to see what will be deleted. (This is a good thing!)

All the best,
~Josh.

Hi,

just to let you know it worked, we finally freed the space.
Thanks for all the help.

Daniel

Glad to hear it, Daniel.

~Josh