Fatal error when calling get_prices

Technical Help
#1

I'm new to the platform and have been setting up databases (for QuantRocket data, zipline data, and realtime data through IB). My first attempts to use get_prices after ingesting the minute data for a universe of 26 stocks has been the following message:

prices = get_prices('select-minute', start_date='2017-08-15', fields='Close')
prices.head()

HTTPError: ('500 Server Error: Internal Server Error for url: http://houston/realtime/databases', {'status': 'error', 'msg': 'an unhandled exception occurred, please check flightlog for the traceback and notify support if the problem persists as this might be a bug', 'error': '(psycopg2.OperationalError) FATAL: database "_quantrocket_v2_realtime_meta" does not exist\n\n(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)'})

Got the same error with a call on the daily data:

prices = get_prices('usstock-daily', start_date='2020-06-01', fields=['Open', 'Close', 'High', 'Low'])
prices.head()

It looked like something to do with the realtime database, so I checked and confirmed that one had been set up to receive real-time ticks from IB. However, I'm requesting from static data that has already been downloaded, so not sure what realtime has to do with it.

Am I using this incorrectly? Happy to capture flightlog if needed.

#2

This sounds like the same issue and resolution reported here:

#3

I tried recreating the realtime service (and restarting the container as well). The fatal error no longer appears, so I assume the database has been created. However, there's no response to the get_prices call at all now in the notebook or in the top level flightlog. Other commands like list_databases and list_gateway_status generate the expected response.

In the detailed log, I see a GET request for the data pop up about 2-3 minutes after executing in notebook but no response to user after that:

quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:20 +0000] "GET /zipline/bundles/data/select-minute.csv?start_date=2017-08-15&fields=Close HTTP/1.1" 200 57265443 "-" "-"
quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:22 +0000] "GET /master/securities.csv?sids=FIBBG000BVPV84&sids=FIBBG000BCQZS4&sids=FIBBG000BZ0DK8&sids=FIBBG000BCWCG1&sids=FIBBG000BF0K17&sids=FIBBG000BGKTF9&sids=FIBBG000BG4202&sids=FIBBG000QBR5J5&sids=FIBBG000BH4R78&sids=FIBBG000BBVJZ8&sids=FIBBG000BP0KQ8&sids=FIBBG000C43RR5&sids=FIBBG000BG8M31&sids=FIBBG000QY3XZ2&sids=FIBBG000BLCCQ2&sids=FIBBG000MM2P62&sids=FIBBG000BJDB15&sids=FIBBG000BJF1Z8&sids=FIBBG000BMHYD1&sids=FIBBG000CL9VN6&sids=FIBBG000BHCYJ1&sids=FIBBG000F0KF42&sids=FIBBG000H8TVT2&sids=FIBBG000BNX0H1&sids=FIBBG000H6HNW3&sids=FIBBG000HS77T5&fields=Timezone HTTP/1.1" 200 872 "-" "-"
quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:41 +0000] "GET /history/databases HTTP/1.1" 200 18 "-" "-"
quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:41 +0000] "GET /realtime/databases HTTP/1.1" 200 20 "-" "-"
quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:41 +0000] "GET /zipline/bundles HTTP/1.1" 200 49 "-" "-"
quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:42 +0000] "GET /zipline/bundles/data/select-minute.csv?start_date=2020-06-15&fields=Close HTTP/1.1" 200 1005463 "-" "-"
quantrocket_houston_1|172.18.0.19 - - [02/Jul/2020:21:45:42 +0000] "GET /master/securities.csv?sids=FIBBG000BVPV84&sids=FIBBG000BCQZS4&sids=FIBBG000BZ0DK8&sids=FIBBG000BCWCG1&sids=FIBBG000BF0K17&sids=FIBBG000BGKTF9&sids=FIBBG000BG4202&sids=FIBBG000QBR5J5&sids=FIBBG000BH4R78&sids=FIBBG000BBVJZ8&sids=FIBBG000BP0KQ8&sids=FIBBG000C43RR5&sids=FIBBG000BG8M31&sids=FIBBG000QY3XZ2&sids=FIBBG000BLCCQ2&sids=FIBBG000MM2P62&sids=FIBBG000BJDB15&sids=FIBBG000BJF1Z8&sids=FIBBG000BMHYD1&sids=FIBBG000CL9VN6&sids=FIBBG000BHCYJ1&sids=FIBBG000F0KF42&sids=FIBBG000H8TVT2&sids=FIBBG000BNX0H1&sids=FIBBG000H6HNW3&sids=FIBBG000HS77T5&fields=Timezone HTTP/1.1" 200 872 "-" "-"
quantrocket_account_1|waiting until ECB's next expected 4PM CET update to collect exchange rates
quantrocket_jupyter_1|[I 21:45:55.604 NotebookApp] Saving file at /Sandbox/Data.ipynb
quantrocket_license-service_1|fetching license profile for YXV0a........hNDAw
quantrocket_houston_1|172.18.0.10 - - [02/Jul/2020:21:46:08 +0000] "GET /account/balances.csv?latest=True&fields=NetLiquidation&fields=Paper HTTP/1.1" 200 146 "-" "-"
quantrocket_houston_1|172.18.0.4 - - [02/Jul/2020:21:46:13 +0000] "GET /ibg1/gateway HTTP/1.1" 200 22 "-" "python-requests/2.22.0"
quantrocket_houston_1|172.18.0.3 - - [02/Jul/2020:21:46:13 +0000] "GET /ibgrouter/gateways?status=running HTTP/1.1" 200 9 "-" "-"
quantrocket_houston_1|172.18.0.4 - - [02/Jul/2020:21:46:20 +0000] "GET /ibg1/gateway HTTP/1.1" 200 22 "-" "python-requests/2.22.0"
quantrocket_houston_1|172.18.0.11 - - [02/Jul/2020:21:46:20 +0000] "GET /ibgrouter/gateways?status=running HTTP/1.1" 200 9 "-" "-"
quantrocket_houston_1|172.18.0.22 - - [02/Jul/2020:21:46:24 +0000] "POST /ibgrouter/registration/ibg1 HTTP/1.1" 200 5 "-" "python-requests/2.22.0"
quantrocket_houston_1|172.18.0.4 - - [02/Jul/2020:21:47:14 +0000] "GET /ibg1/gateway HTTP/1.1" 200 22 "-" "python-requests/2.22.0"
quantrocket_houston_1|172.18.0.3 - - [02/Jul/2020:21:47:14 +0000] "GET /ibgrouter/gateways?status=running HTTP/1.1" 200 9 "-" "-"
quantrocket_account_1|waiting until ECB's next expected 4PM CET update to collect exchange rates

Is there anything else I should try resetting?

#4

I managed to get this working by logging into IB as live trading instead of paper. I assume my license had to be validated again by checking the balance, even though I already did this earlier (I checked the license info and it showed my actual balance)? In any case, switched it back to paper trading and seems to be working still.