[galaxy-dev] deleted datasets inconsistent

[Sarah Diehl]

Hi all,

it seems my clean-up enthusiasm caused some inconsistencies with datasets' 
deleted status. I encounter the following phenomenon: datasets appear totally 
fine in the data libraries, but once they are loaded into a history, they 
appear as deleted there.

I dug through the database and found out that the following query returns all 
datasets in the libraries that were uploaded before my clean-up:

SELECT * FROM library_dataset_dataset_association INNER JOIN library_dataset ON 
 library_dataset_dataset_association.library_dataset_id = library_dataset.id
WHERE library_dataset_dataset_association.deleted = TRUE AND 
library_dataset.deleted = FALSE;

When I set both deleted to false, only datasets that were added after the 
clean-up appear.

Do I break something, if I reset library_dataset_dataset_association.deleted to 
FALSE for the inconsistent datasets? I tried it for one dataset and that seems 
to have fixed the problem. Is this some bug in the clean-up scripts? I guess 
that actually they should have been removed completely.

Best regards,
Sarah
___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

  http://lists.bx.psu.edu/

[galaxy-dev] Deleted datasets

[SHAUN WEBB]

Hi,

looking at Galaxy reports I have 505 datasets which have been deleted  
>60 days ago but have not been purged. My purging scripts seem to be  
working correctly in cron. Why do these datasets not get deleted? Is  
it likely that these are in shared or accessible histories and only  
deleted by the owner? Any tips would be good, trying to free up some  
space on our server.


Thanks
Shaun Webb

--
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.


___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

 http://lists.bx.psu.edu/