Re: [galaxy-dev] purging deleted datasets
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 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/
Re: [galaxy-dev] purging deleted datasets
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 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/
[galaxy-dev] purging deleted datasets
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/
