Question: Database Error When Bootstrapping Tool Shed
gravatar for bgrande
3.0 years ago by
bgrande40 wrote:

I'm attempting to host a local instance of the Galaxy Tool Shed for development purposes. I've already gotten the Galaxy server up and running. I don't know where the Galaxy version number is located, but I have revision 78c9a97be4b6+ of galaxy-dist repository. I did manage to get the Tool Shed server working, but upon reading this blog post (see section "Hosting Your Own Tool Shed for Developing Galaxy Tools and Utilities"), I wanted to bootstrap from the main Galaxy Tool Shed ( 

First of all, I'm trying to make use of PostgreSQL as the database backend. I have enabled the database_connection option in my tool_shed.ini configuration file using the appropriate postgresql:// connection string. However, the default SQLite database file in database/community.sqlite is still created, even with the database_file = database/community.sqlite line commented out in the tool_shed.ini config file. Is this normal? I can see a Galaxy-like schema in both the SQLite and PostgreSQL databases. However, I don't know which one is actually being used, as they're both empty. One thing is for sure: in order to re-run the bootstrapping command, the SQLite database file must be cleared. Otherwise, I get the following error:

Unable to bootstrap tool shed. The database configured for this Tool Shed is not new, so bootstrapping is not allowed. Create a new database that has not been migrated before attempting to bootstrap.

Second of all, while running the bootstrapping command (command and output), I run into a SQLAlchemy error claiming that the "repository" table doesn't exist. It's unclear which database it's referring to, but that table exists in both the SQLite and PostgreSQL databases. Therefore, I'm left wondering if it's referring to the public Tool Shed I'm bootstrapping from. Also, while the following steps say that they're "done", neither databases are populated with categories, nor with users. When I look into the tool_shed_bootstrap.log file, one thing I notice that that one of the GET HTTP requests fails with a 404 status ("GET /api/authenticate/baseauth/ HTTP/1.1" 404 - "-" "curl/7.35.0"), followed by many POST requests ("POST /api/users?key=a HTTP/1.1" 200 - "-" "Python-urllib/2.7"). Let me know if you could use any additional information to troubleshoot these issues. 

toolshed software error galaxy • 1.2k views
ADD COMMENTlink modified 2.8 years ago by jmchilton1000 • written 3.0 years ago by bgrande40
gravatar for jmchilton
2.8 years ago by
United States
jmchilton1000 wrote:

For posterity - this problem was discussed in greater detail on the galaxy-dev mailing list - here is a link -

ADD COMMENTlink written 2.8 years ago by jmchilton1000

I should have linked back to that mailing list post when it got resolved. Making this the official answer. Thanks for that!

ADD REPLYlink written 2.8 years ago by bgrande40
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 97 users visited in the last hour