search

soxidus / Boardgame-Bot

A Boardgame Bot for your Telegram group to plan/manage gamenights and suggest games to play.
MIT License
2 stars 0 forks source link

Error when trying to connect to auth_db #48

Closed karacolada closed 5 years ago

karacolada commented 5 years ago

Traceback (most recent call last): File "/home/karacol/.local/lib/python3.6/site-packages/telegram/ext/dispatcher.py", line 279, in process_update handler.handle_update(update, self) File "/home/karacol/.local/lib/python3.6/site-packages/telegram/ext/commandhandler.py", line 173, in handle_update return self.callback(dispatcher.bot, update, *optional_args) File "/home/karacol/git/Boardgame-Bot/src/commands.py", line 279, in spiele if check_user(update.message.chat_id): File "/home/karacol/git/Boardgame-Bot/src/database_functions.py", line 184, in check_user result_user = search_single_entry(choose_database("auth"), "users", "id", user) File "/home/karacol/git/Boardgame-Bot/src/database_functions.py", line 22, in choose_database database=config['MySQL Auth']['database'] File "/home/karacol/.local/lib/python3.6/site-packages/mysql/connector/init.py", line 179, in connect return MySQLConnection(args, kwargs) File "/home/karacol/.local/lib/python3.6/site-packages/mysql/connector/connection.py", line 95, in init self.connect(kwargs) File "/home/karacol/.local/lib/python3.6/site-packages/mysql/connector/abstracts.py", line 716, in connect self._open_connection() File "/home/karacol/.local/lib/python3.6/site-packages/mysql/connector/connection.py", line 207, in _open_connection self._do_handshake() File "/home/karacol/.local/lib/python3.6/site-packages/mysql/connector/connection.py", line 99, in _do_handshake packet = self._socket.recv() File "/home/karacol/.local/lib/python3.6/site-packages/mysql/connector/network.py", line 243, in recv_plain raise errors.InterfaceError(errno=2013) mysql.connector.errors.InterfaceError: 2013: Lost connection to MySQL server during query

karacolada commented 5 years ago

A workaround to this issue is to enter the docker container auth_db and executing ./docker-entrypoint.sh by hand. This is not ideal though.

karacolada commented 5 years ago

This only happens after a clean creation (from scratch) of auth_db. It does not happen in data_db.

karacolada commented 5 years ago

Okay, I figured this out. It takes time. Several minutes, that is. I didn't experiment too much with it, but after 10 minutes, it worked. Will adjust infrastructure/README.md accordingly.