Slow operations should be non-blocking

[brummett]

Creating a database, new and from a template
dropping a database

[brummett]

uploading a template file

[brummett]

The only possible slow thing now can be creating a DB from a template or a template from a DB

[nnutter]

I'm wondering if create the DB from the template has some Postgres lock contention, see genome/genome#524, which is causing HTTP timeouts.

[nnutter]

I increased the timeouts to 30 seconds in genome-env and now I saw 4 out of ~12 model tests get this error:

Got error response 502: Proxy Error at /usr/bin/test-db-database-create line 15

[brummett]

The original purpose of this issue was to start using the Mojo event loop in places where long-running handlers (like the old dump-database-load to copy DBs) would block the system from servicing other HTTP requests.

The docs for Mojo::Pg shows how this might work. Look for Mojo::IOLoop->delay.

Do you know if the timeouts we're getting are because it's taking too long to service a new HTTP connection (because it's still busy doing the last one) or to copy the database? The first problem would be fixed with this event loop thing, but not the second.