Created
January 13, 2024 07:38
-
-
Save vivekteega/e7641f1ce3ed2f7143cf867ae13dbe57 to your computer and use it in GitHub Desktop.
ftt-blockbook-migration-rescan error logs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-10 02:12:27 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connection.py", line 159, in _new_conn | |
| conn = connection.create_connection( | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/util/connection.py", line 57, in create_connection | |
| for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM): | |
| File "/usr/lib/python3.8/socket.py", line 918, in getaddrinfo | |
| for res in _socket.getaddrinfo(host, port, family, type, proto, flags): | |
| socket.gaierror: [Errno -3] Temporary failure in name resolution | |
| During handling of the above exception, another exception occurred: | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connectionpool.py", line 600, in urlopen | |
| httplib_response = self._make_request(conn, method, url, | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connectionpool.py", line 344, in _make_request | |
| self._validate_conn(conn) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connectionpool.py", line 843, in _validate_conn | |
| conn.connect() | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connection.py", line 316, in connect | |
| conn = self._new_conn() | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connection.py", line 168, in _new_conn | |
| raise NewConnectionError( | |
| urllib3.exceptions.NewConnectionError: <urllib3.connection.VerifiedHTTPSConnection object at 0x7ffab4ae1ee0>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution | |
| During handling of the above exception, another exception occurred: | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/adapters.py", line 439, in send | |
| resp = conn.urlopen( | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/connectionpool.py", line 640, in urlopen | |
| retries = retries.increment(method, url, error=e, _pool=self, | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/urllib3/util/retry.py", line 399, in increment | |
| raise MaxRetryError(_pool, url, error or ResponseError(cause)) | |
| urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='api.coinlore.net', port=443): Max retries exceeded with url: /api/ticker/?id=67 (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x7ffab4ae1ee0>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')) | |
| During handling of the above exception, another exception occurred: | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 258, in updatePrices | |
| response = requests.get(f"https://api.coinlore.net/api/ticker/?id=67") | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/api.py", line 75, in get | |
| return request('get', url, params=params, **kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/api.py", line 60, in request | |
| return session.request(method=method, url=url, **kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/sessions.py", line 533, in request | |
| resp = self.send(prep, **send_kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/sessions.py", line 646, in send | |
| r = adapter.send(request, **kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/adapters.py", line 516, in send | |
| raise ConnectionError(e, request=request) | |
| requests.exceptions.ConnectionError: HTTPSConnectionPool(host='api.coinlore.net', port=443): Max retries exceeded with url: /api/ticker/?id=67 (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x7ffab4ae1ee0>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-13 12:09:39 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 259, in updatePrices | |
| price = response.json() | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/models.py", line 897, in json | |
| return complexjson.loads(self.text, **kwargs) | |
| File "/usr/lib/python3.8/json/__init__.py", line 357, in loads | |
| return _default_decoder.decode(s) | |
| File "/usr/lib/python3.8/json/decoder.py", line 337, in decode | |
| obj, end = self.raw_decode(s, idx=_w(s, 0).end()) | |
| File "/usr/lib/python3.8/json/decoder.py", line 355, in raw_decode | |
| raise JSONDecodeError("Expecting value", s, err.value) from None | |
| json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0) | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-14 13:49:39 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 259, in updatePrices | |
| price = response.json() | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/models.py", line 897, in json | |
| return complexjson.loads(self.text, **kwargs) | |
| File "/usr/lib/python3.8/json/__init__.py", line 357, in loads | |
| return _default_decoder.decode(s) | |
| File "/usr/lib/python3.8/json/decoder.py", line 337, in decode | |
| obj, end = self.raw_decode(s, idx=_w(s, 0).end()) | |
| File "/usr/lib/python3.8/json/decoder.py", line 355, in raw_decode | |
| raise JSONDecodeError("Expecting value", s, err.value) from None | |
| json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Run time of job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-15 16:39:07 UTC)" was missed by 0:00:04.911833 | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-15 21:49:07 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 259, in updatePrices | |
| price = response.json() | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/requests/models.py", line 897, in json | |
| return complexjson.loads(self.text, **kwargs) | |
| File "/usr/lib/python3.8/json/__init__.py", line 357, in loads | |
| return _default_decoder.decode(s) | |
| File "/usr/lib/python3.8/json/decoder.py", line 337, in decode | |
| obj, end = self.raw_decode(s, idx=_w(s, 0).end()) | |
| File "/usr/lib/python3.8/json/decoder.py", line 355, in raw_decode | |
| raise JSONDecodeError("Expecting value", s, err.value) from None | |
| json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Running on 0.0.0.0:5017 over http (CTRL + C to quit) | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-20 18:20:50 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 254, in updatePrices | |
| prices['BTCUSD'] = price['bitcoin']['usd'] | |
| KeyError: 'bitcoin' | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2023-12-31 00:10:50 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 254, in updatePrices | |
| prices['BTCUSD'] = price['bitcoin']['usd'] | |
| KeyError: 'bitcoin' | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2024-01-10 03:00:50 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 254, in updatePrices | |
| prices['BTCUSD'] = price['bitcoin']['usd'] | |
| KeyError: 'bitcoin' | |
| [2024-01-10 14:57:28,583] ERROR in app: Exception on request GET /api/v2/transactionDetails/16e836ceb973447a5fd71e969d7d4cde23330547a855731003c7fc53c86937e4 | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1524, in handle_request | |
| return await self.full_dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1546, in full_dispatch_request | |
| result = await self.handle_user_exception(error) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 957, in handle_user_exception | |
| raise error | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1544, in full_dispatch_request | |
| result = await self.dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1592, in dispatch_request | |
| return await handler(**request_.view_args) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 2365, in transactiondetails1 | |
| txhash_txs = fetch_swap_contract_transactions(contractName, contractAddress, transactionHash) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 548, in fetch_swap_contract_transactions | |
| c.execute(query) | |
| sqlite3.OperationalError: no such column: t2.transactionSubType | |
| [2024-01-10 14:57:45,008] ERROR in app: Exception on request GET /api/v2/transactionDetails/16e836ceb973447a5fd71e969d7d4cde23330547a855731003c7fc53c86937e4 | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1524, in handle_request | |
| return await self.full_dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1546, in full_dispatch_request | |
| result = await self.handle_user_exception(error) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 957, in handle_user_exception | |
| raise error | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1544, in full_dispatch_request | |
| result = await self.dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1592, in dispatch_request | |
| return await handler(**request_.view_args) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 2365, in transactiondetails1 | |
| txhash_txs = fetch_swap_contract_transactions(contractName, contractAddress, transactionHash) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 548, in fetch_swap_contract_transactions | |
| c.execute(query) | |
| sqlite3.OperationalError: no such column: t2.transactionSubType | |
| [2024-01-10 14:57:52,538] ERROR in app: Exception on request GET /api/v2/transactionDetails/70ec29292f025b5f108bcd17f74619857482da46fc9cb750c78bc3bd9ea601d9 | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1524, in handle_request | |
| return await self.full_dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1546, in full_dispatch_request | |
| result = await self.handle_user_exception(error) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 957, in handle_user_exception | |
| raise error | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1544, in full_dispatch_request | |
| result = await self.dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1592, in dispatch_request | |
| return await handler(**request_.view_args) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 2365, in transactiondetails1 | |
| txhash_txs = fetch_swap_contract_transactions(contractName, contractAddress, transactionHash) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 548, in fetch_swap_contract_transactions | |
| c.execute(query) | |
| sqlite3.OperationalError: no such column: t2.transactionSubType | |
| Job "updatePrices (trigger: interval[0:10:00], next run at: 2024-01-10 15:10:50 UTC)" raised an exception | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| retval = job.func(*job.args, **job.kwargs) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 254, in updatePrices | |
| prices['BTCUSD'] = price['bitcoin']['usd'] | |
| KeyError: 'bitcoin' | |
| [2024-01-11 14:44:09,975] ERROR in app: Exception on request GET /api/v2/transactionDetails/70ec29292f025b5f108bcd17f74619857482da46fc9cb750c78bc3bd9ea601d9 | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1524, in handle_request | |
| return await self.full_dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1546, in full_dispatch_request | |
| result = await self.handle_user_exception(error) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 957, in handle_user_exception | |
| raise error | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1544, in full_dispatch_request | |
| result = await self.dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1592, in dispatch_request | |
| return await handler(**request_.view_args) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 2365, in transactiondetails1 | |
| txhash_txs = fetch_swap_contract_transactions(contractName, contractAddress, transactionHash) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 548, in fetch_swap_contract_transactions | |
| c.execute(query) | |
| sqlite3.OperationalError: no such column: t2.transactionSubType | |
| [2024-01-12 06:09:07,423] ERROR in app: Exception on request GET /api/v2/transactionDetails/70ec29292f025b5f108bcd17f74619857482da46fc9cb750c78bc3bd9ea601d9 | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1524, in handle_request | |
| return await self.full_dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1546, in full_dispatch_request | |
| result = await self.handle_user_exception(error) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 957, in handle_user_exception | |
| raise error | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1544, in full_dispatch_request | |
| result = await self.dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1592, in dispatch_request | |
| return await handler(**request_.view_args) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 2365, in transactiondetails1 | |
| txhash_txs = fetch_swap_contract_transactions(contractName, contractAddress, transactionHash) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 548, in fetch_swap_contract_transactions | |
| c.execute(query) | |
| sqlite3.OperationalError: no such column: t2.transactionSubType | |
| [2024-01-12 06:16:01,646] ERROR in app: Exception on request GET /api/v2/transactionDetails/70ec29292f025b5f108bcd17f74619857482da46fc9cb750c78bc3bd9ea601d9 | |
| Traceback (most recent call last): | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1524, in handle_request | |
| return await self.full_dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1546, in full_dispatch_request | |
| result = await self.handle_user_exception(error) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 957, in handle_user_exception | |
| raise error | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1544, in full_dispatch_request | |
| result = await self.dispatch_request(request_context) | |
| File "/home/production/deployed/ranchimallflo-api-live/py3/lib/python3.8/site-packages/quart/app.py", line 1592, in dispatch_request | |
| return await handler(**request_.view_args) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 2365, in transactiondetails1 | |
| txhash_txs = fetch_swap_contract_transactions(contractName, contractAddress, transactionHash) | |
| File "/home/production/deployed/ranchimallflo-api-blockbook-rescan/ranchimallflo_api.py", line 548, in fetch_swap_contract_transactions | |
| c.execute(query) | |
| sqlite3.OperationalError: no such column: t2.transactionSubType |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment