Deleting images doesn't free space

[dgarneau]

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

[jmoore]

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.

[dgarneau]

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)


[jmoore]

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.

[dgarneau]

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

[jmoore]

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.

[dgarneau]

Hi,

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

Daniel

[jmoore]

Glad to hear it, Daniel.

~Josh