Hi, I have an always-on task reader that reads tasks and then runs them.
Before this morning this was working fine. It was connecting to the database, running tasks, all was well.
Since this morning it has repeatedly thrown errors complaining about not being able to connect to the database hosted here:
Krammy.mysql.pythonanywhere-services.com
I am able to connect to the database in MySQL consoles. I am also able to run the task reader in a live console. It seems to only not be able to connect within my always-on task.
This is the command I am using:
/home/Krammy/.virtualenvs/myvirtualenv/bin/python3.13 -u /home/Krammy/ztk-tasks/taskreader.py
This is the error message:
Jul 8 09:58:06 Traceback (most recent call last):
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/pymysql/connections.py", line 661, in connect
Jul 8 09:58:06 sock = socket.create_connection(
Jul 8 09:58:06 (self.host, self.port), self.connect_timeout, **kwargs
Jul 8 09:58:06 )
Jul 8 09:58:06 File "/usr/local/lib/python3.13/socket.py", line 840, in create_connection
Jul 8 09:58:06 for res in getaddrinfo(host, port, 0, SOCK_STREAM):
Jul 8 09:58:06 ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jul 8 09:58:06 File "/usr/local/lib/python3.13/socket.py", line 975, in getaddrinfo
Jul 8 09:58:06 for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jul 8 09:58:06 socket.gaierror: [Errno -3] Temporary failure in name resolution
Jul 8 09:58:06 During handling of the above exception, another exception occurred:
Jul 8 09:58:06 Traceback (most recent call last):
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 143, in __init__
Jul 8 09:58:06 self._dbapi_connection = engine.raw_connection()
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 3301, in raw_connection
Jul 8 09:58:06 return self.pool.connect()
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 447, in connect
Jul 8 09:58:06 return _ConnectionFairy._checkout(self)
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 1264, in _checkout
Jul 8 09:58:06 fairy = _ConnectionRecord.checkout(pool)
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 711, in checkout
Jul 8 09:58:06 rec = pool._do_get()
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
Jul 8 09:58:06 with util.safe_reraise():
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
Jul 8 09:58:06 raise exc_value.with_traceback(exc_tb)
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/impl.py", line 175, in _do_get
Jul 8 09:58:06 return self._create_connection()
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 388, in _create_connection
Jul 8 09:58:06 return _ConnectionRecord(self)
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 673, in __init__
Jul 8 09:58:06 self.__connect()
Jul 8 09:58:06 ~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 899, in __connect
Jul 8 09:58:06 with util.safe_reraise():
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/util/langhelpers.py", line 224, in __exit__
Jul 8 09:58:06 raise exc_value.with_traceback(exc_tb)
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 895, in __connect
Jul 8 09:58:06 self.dbapi_connection = connection = pool._invoke_creator(self)
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~^^^^^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 661, in connect
Jul 8 09:58:06 return dialect.connect(*cargs, **cparams)
Jul 8 09:58:06 ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 629, in connect
Jul 8 09:58:06 return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/pymysql/connections.py", line 365, in __init__
Jul 8 09:58:06 self.connect()
Jul 8 09:58:06 ~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/pymysql/connections.py", line 723, in connect
Jul 8 09:58:06 raise exc
Jul 8 09:58:06 pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'Krammy.mysql.pythonanywhere-services.com' ([Errno -3] Temporary failure in name resolution)")
Jul 8 09:58:06 The above exception was the direct cause of the following exception:
Jul 8 09:58:06 Traceback (most recent call last):
Jul 8 09:58:06 File "/home/Krammy/ztk-tasks/taskreader.py", line 31, in <module>
Jul 8 09:58:06 init_db()
Jul 8 09:58:06 ~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/ztk-tasks/models/__init__.py", line 19, in init_db
Jul 8 09:58:06 Base.metadata.create_all(engine)
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/sql/schema.py", line 5928, in create_all
Jul 8 09:58:06 bind._run_ddl_visitor(
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~^
Jul 8 09:58:06 ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
Jul 8 09:58:06 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jul 8 09:58:06 )
Jul 8 09:58:06 ^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 3251, in _run_ddl_visitor
Jul 8 09:58:06 with self.begin() as conn:
Jul 8 09:58:06 ~~~~~~~~~~^^
Jul 8 09:58:06 File "/usr/local/lib/python3.13/contextlib.py", line 141, in __enter__
Jul 8 09:58:06 return next(self.gen)
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 3241, in begin
Jul 8 09:58:06 with self.connect() as conn:
Jul 8 09:58:06 ~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 3277, in connect
Jul 8 09:58:06 return self._connection_cls(self)
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~^^^^^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
Jul 8 09:58:06 Connection._handle_dbapi_exception_noconnection(
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
Jul 8 09:58:06 err, dialect, engine
Jul 8 09:58:06 ^^^^^^^^^^^^^^^^^^^^
Jul 8 09:58:06 )
Jul 8 09:58:06 ^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 2440, in _handle_dbapi_exception_noconnection
Jul 8 09:58:06 raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 143, in __init__
Jul 8 09:58:06 self._dbapi_connection = engine.raw_connection()
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 3301, in raw_connection
Jul 8 09:58:06 return self.pool.connect()
Jul 8 09:58:06 ~~~~~~~~~~~~~~~~~^^
Jul 8 09:58:06 File "/home/Krammy/.virtualenvs/myvirtualenv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", line 447, in connect
Jul 8 09:58:06 return _ConnectionFairy._checkout(self)
