[galaxy-dev] Error in database after trying the innocently named, but devastatingly evil test in manage_db.sh

2013-02-08 Thread Thon de Boer
Hi, I had a small issue with the total usage of my galaxy system showing some negative random number so I figured my database was a little “off”. I snooped around for some database management tools and found “manage_db.sh” which had an option innocently called “test”. I ran it,

Re: [galaxy-dev] Error in database after trying the innocently named, but devastatingly evil test in manage_db.sh

2013-02-08 Thread Daniel Blankenberg
Hi Thon, The test option runs the upgrade and downgrade of the latest migration script. I'm assuming that you had already run the latest migrations available and the server was up and running OK (other than the dataset size issue) before trying the test command. On a COPY of your database,

Re: [galaxy-dev] Error in database after trying the innocently named, but devastatingly evil test in manage_db.sh

2013-02-08 Thread Thon de Boer
Hi Dan, I tried that but it failed ofcourse since the table it tries to drop from 109 - 108 does not exisit. sh manage_db.sh downgrade 108 109 - 108... 0109_add_repository_dependency_tables DEBUG 2013-02-08 13:04:33,464 Dropping repository_repository_dependency_association table

Re: [galaxy-dev] Error in database after trying the innocently named, but devastatingly evil test in manage_db.sh

2013-02-08 Thread Thon de Boer
OK..I tried it a few more times and this time with different results! HA! I knew I wasn’t insane…As long as you try anything often enough in the same manner, you WILL get a different outcome…Yea uncertainty principle! I also had to resort to downloading the whole complete galaxy-dist from