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/