RikiBorders / Goose

A responsive multi-purpose Discord Bot
0 stars 0 forks source link

[bug] #23

Open RikiBorders opened 7 months ago

RikiBorders commented 7 months ago

hmmm there seems to be some type of bug with making database requests to a database that is currently shut down. (supabase-related). This sends the bot into an error loop that eventually terminates the instance itself. Full logs in comment below:

RikiBorders commented 7 months ago

Waiting for logs...

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] self.trivia_question_pool = self.database_manager.fetch_trivia_questions()

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/services/database_manager_class.py", line 21, in fetch_trivia_questions

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] response = self.client.table('trivia').select("*").execute()

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/postgrest/_sync/request_builder.py", line 57, in execute

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] r = self.session.request(

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 814, in request

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] return self.send(request, auth=auth, follow_redirects=follow_redirects)

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 901, in send

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] response = self._send_handling_auth(

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 929, in _send_handling_auth

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] response = self._send_handling_redirects(

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 966, in _send_handling_redirects

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] response = self._send_single_request(request)

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 1002, in _send_single_request

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] response = transport.handle_request(request)

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_transports/default.py", line 217, in handle_request

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] with map_httpcore_exceptions():

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/contextlib.py", line 153, in exit

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] self.gen.throw(typ, value, traceback)

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_transports/default.py", line 77, in map_httpcore_exceptions

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] raise mapped_exc(message) from exc

2024-02-24T21:07:16.437 app[3287eedf112685] den [info] httpx.ConnectError: [Errno -2] Name or service not known

2024-02-24T21:07:17.046 app[3287eedf112685] den [info] INFO Main child exited normally with code: 1

2024-02-24T21:07:17.046 app[3287eedf112685] den [info] INFO Starting clean up.

2024-02-24T21:07:17.048 app[3287eedf112685] den [info] WARN hallpass exited, pid: 306, status: signal: 15 (SIGTERM)

2024-02-24T21:07:17.053 app[3287eedf112685] den [info] 2024/02/24 21:07:17 listening on [fdaa:1:4bd7:a7b:d827:3726:542b:2]:22 (DNS: [fdaa::3]:53)

2024-02-24T21:07:18.048 app[3287eedf112685] den [info] [ 3.285319] reboot: Restarting system

2024-02-24T21:07:18.221 runner[3287eedf112685] den [info] machine did not have a restart policy, defaulting to restart

2024-02-24T21:07:48.293 app[3287eedf112685] den [info] [ 0.038744] PCI: Fatal: No config space access function found

2024-02-24T21:07:48.508 app[3287eedf112685] den [info] INFO Starting init (commit: 15238e9)...

2024-02-24T21:07:48.526 app[3287eedf112685] den [info] INFO Preparing to run: /bin/sh -c python bot.py as root

2024-02-24T21:07:48.534 app[3287eedf112685] den [info] INFO [fly api proxy] listening at /.fly/api

2024-02-24T21:07:48.551 app[3287eedf112685] den [info] 2024/02/24 21:07:48 listening on [fdaa:1:4bd7:a7b:d827:3726:542b:2]:22 (DNS: [fdaa::3]:53)

2024-02-24T21:07:48.573 runner[3287eedf112685] den [info] Machine started in 454ms

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] Traceback (most recent call last):

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_exceptions.py", line 10, in map_exceptions

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] yield

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_backends/sync.py", line 100, in connect_tcp

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] sock = socket.create_connection(

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/socket.py", line 824, in create_connection

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] for res in getaddrinfo(host, port, 0, SOCK_STREAM):

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/socket.py", line 955, in getaddrinfo

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] for res in _socket.getaddrinfo(host, port, family, type, proto, flags):

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] socket.gaierror: [Errno -2] Name or service not known

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] The above exception was the direct cause of the following exception:

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] Traceback (most recent call last):

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_transports/default.py", line 60, in map_httpcore_exceptions

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] yield

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_transports/default.py", line 218, in handle_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] resp = self._pool.handle_request(req)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_sync/connection_pool.py", line 262, in handle_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] raise exc

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_sync/connection_pool.py", line 245, in handle_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] response = connection.handle_request(request)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_sync/connection.py", line 92, in handle_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] raise exc

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_sync/connection.py", line 69, in handle_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] stream = self._connect(request)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_sync/connection.py", line 117, in _connect

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] stream = self._network_backend.connect_tcp(**kwargs)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_backends/sync.py", line 99, in connect_tcp

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] with map_exceptions(exc_map):

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/contextlib.py", line 153, in exit

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] self.gen.throw(typ, value, traceback)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpcore/_exceptions.py", line 14, in map_exceptions

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] raise to_exc(exc) from exc

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] httpcore.ConnectError: [Errno -2] Name or service not known

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] The above exception was the direct cause of the following exception:

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] Traceback (most recent call last):

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "//bot.py", line 32, in

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] bot_instance = GooseBot(client)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/GooseBot.py", line 45, in init

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] self.trivia_question_pool = self.database_manager.fetch_trivia_questions()

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/services/database_manager_class.py", line 21, in fetch_trivia_questions

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] response = self.client.table('trivia').select("*").execute()

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/postgrest/_sync/request_builder.py", line 57, in execute

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] r = self.session.request(

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 814, in request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] return self.send(request, auth=auth, follow_redirects=follow_redirects)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 901, in send

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] response = self._send_handling_auth(

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 929, in _send_handling_auth

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] response = self._send_handling_redirects(

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 966, in _send_handling_redirects

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] response = self._send_single_request(request)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_client.py", line 1002, in _send_single_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] response = transport.handle_request(request)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_transports/default.py", line 217, in handle_request

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] with map_httpcore_exceptions():

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/contextlib.py", line 153, in exit

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] self.gen.throw(typ, value, traceback)

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] File "/usr/local/lib/python3.10/site-packages/httpx/_transports/default.py", line 77, in map_httpcore_exceptions

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] raise mapped_exc(message) from exc

2024-02-24T21:07:49.857 app[3287eedf112685] den [info] httpx.ConnectError: [Errno -2] Name or service not known

2024-02-24T21:07:50.539 app[3287eedf112685] den [info] INFO Main child exited normally with code: 1

2024-02-24T21:07:50.539 app[3287eedf112685] den [info] INFO Starting clean up.

2024-02-24T21:07:50.540 app[3287eedf112685] den [info] WARN hallpass exited, pid: 306, status: signal: 15 (SIGTERM)

2024-02-24T21:07:50.542 app[3287eedf112685] den [info] 2024/02/24 21:07:50 listening on [fdaa:1:4bd7:a7b:d827:3726:542b:2]:22 (DNS: [fdaa::3]:53)

2024-02-24T21:07:51.537 app[3287eedf112685] den [info] [ 3.279588] reboot: Restarting system

2024-02-24T21:07:51.693 runner[3287eedf112685] den [info] machine has reached its max restart count (10)