Galaxy database check script
Hi, I've been getting some errors on our local Galaxy instance which haven't been solved by updating to the latest code. Some of them involve sql-type errors. My sys-admin informed me that "There are a couple of SQL errors being reported, i.e. text attempting to be inserted into an integer field within the sql statements." I'm also getting 'NoneType' object has no attribute 'x' errors [where 'x' can be a number of different attributes]. Are there any scripts in Galaxy that I can run to test the database. I'm wondering if there's some sort of corruption with the database. Many thanks, Graham Dr. Graham Etherington Bioinformatics Support Officer, The Sainsbury Laboratory, Norwich Research Park, Norwich NR4 7UH. UK Tel: +44 (0)1603 450601
There aren't any database-specific tests, but if you could get more details from your sysadmin regarding the issues they're seeing, I'd be very interested in seeing it. You could run the usual functional tests to verify galaxy itself is functional: http://wiki.galaxyproject.org/Admin/Running%20Tests -Dannon On Wed, Aug 14, 2013 at 10:39 AM, graham etherington (TSL) < graham.etherington@sainsbury-laboratory.ac.uk> wrote:
Hi, I've been getting some errors on our local Galaxy instance which haven't been solved by updating to the latest code. Some of them involve sql-type errors. My sys-admin informed me that "There are a couple of SQL errors being reported, i.e. text attempting to be inserted into an integer field within the sql statements." I'm also getting 'NoneType' object has no attribute 'x' errors [where 'x' can be a number of different attributes].
Are there any scripts in Galaxy that I can run to test the database. I'm wondering if there's some sort of corruption with the database.
Many thanks, Graham
Dr. Graham Etherington Bioinformatics Support Officer, The Sainsbury Laboratory, Norwich Research Park, Norwich NR4 7UH. UK Tel: +44 (0)1603 450601
___________________________________________________________ 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/
participants (2)
-
Dannon Baker
-
graham etherington (TSL)