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.baker@gmail.com
To: mi.bastami@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.bastami@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 datasets
Freed disk space: 0
Elapsed 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/