Thank you for prompt reply. Yes I have deleted many datasets through history 
panel but the history itself is exist.

Date: Wed, 23 Apr 2014 09:35:19 -0400
Subject: Re: [galaxy-dev] purging deleted datasets
From: dannon.ba...@gmail.com
To: mi.bast...@live.com
CC: galaxy-dev@lists.bx.psu.edu

Hi Milad,
That's just a warning, it should not cause any issues (I've just confirmed this 
locally on a sqlite instance).  So you're sure you have histories with deleted 
datasets older than 0 days?  The commands you have run will not remove datasets 
that haven't been deleted first by a user (usually through the history panel).

-Dannon

On Wed, Apr 23, 2014 at 9:21 AM, Milad Bastami <mi.bast...@live.com> wrote:




Dear all,I have some unwanted datasets to remove but I need their main 
histories, so in galaxy I just deleted the unwanted datasets but not the 
histories. Then I tried to purge the deleted datasets with the following 
commands: 

python scripts/cleanup_datasets/cleanup_datasets.py universe_wsgi.ini -d 0 -6 
-r  python scripts/cleanup_datasets/cleanup_datasets.py universe_wsgi.ini -d 0 
-3 -r 

and I saw the this error:
/galaxy-dist/eggs/SQLAlchemy-0.7.9-py2.7-linux-x86_64-ucs4.egg/sqlalchemy/types.py:215:
 SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects 
natively, and SQLAlchemy must convert from floating point - rounding errors and 
other issues may occur. Please consider storing Decimal numbers as strings or 
integers on this platform for lossless storage.
Purged 0 datasetsFreed disk space:  0Elapsed time:  0.0748069286346
Unfortunately I can't understand the warning and why nothing was deleted. Any 
help would be most appreciated. 

                                          

___________________________________________________________

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/



To search Galaxy mailing lists use the unified search at:

  http://galaxyproject.org/search/mailinglists/

                                          
___________________________________________________________
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/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

Reply via email to