Revert "Add transactional tests. Remove #reset_database. Add random order."

This reverts commit 6a55afd38f4153ded01289eee063b221b4c0d373.
Allowing CC to go green while we continue to work on fixing tests.
Removed pending tests in app_spec.

App state transitions tests are now in app_observer_spec.

[finished #59168792]
Resurrect pending tests after 14 months.
Use http instead of https for rubygems.org

Certificate problems on warden-jenkins prevent https from working.
CC gets app.state over NATS
Revert "Revert "Add transactional tests. Remove #reset_database. Add random order.""

This reverts commit 85eef29db24167148e506a1c6a910d45810164f8.
continuing to work on transactional tests.
Fix failing mysql tests

mysql doesn't allow creating a table in a transaction.  Tests with table
creation are done outside of a transaction and manually cleaned up.
Fixing mysql tests:  missed one
Clean up after messy apps controller test

It had to be non-transactional because of after commit hooks, and was
creating a user behind the scenes.  All better now.
probably fixes cc tests

reset database after every non-transactional test case
make one more test case non-transactional
Last attempt at fixing the parallel specs. Promise
don't deserialize app.state responses twice
added timeout to app.state nats request
Must always have non_transactional if your trying to test an after_commit hook
Make credentials and syslog_drain_url optional.
syslog_drain_url is an optional field in service broker responses