garncarz / nogamespy-vietcong

Vietcong 1 multiplayer game support
https://vietcong1.eu
GNU Affero General Public License v3.0
18 stars 2 forks source link

Refresh DB session as often as possible #8

Closed garncarz closed 6 years ago

garncarz commented 6 years ago
master_1         |     reraise(type(exception), exception, tb=exc_tb, cause=cause)
master_1         |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
master_1         |     raise value.with_traceback(tb)
master_1         |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1125, in _execute_context
master_1         |     conn = self._revalidate_connection()
master_1         |   File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 427, in _revalidate_connection
master_1         |     "Can't reconnect until invalid "
master_1         | sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQ
L: 'SELECT server.infoport AS server_infoport, server.countryname AS server_countryname, server.numplayers AS server_numplayers, server.maxplayers
AS server_maxplayers, server.dedic AS server_dedic, server.`onlineSince` AS `server_onlineSince`, server.`offlineSince` AS `server_offlineSince`, s
erver.id AS server_id, server.ip AS server_ip, server.port AS server_port, server.name AS server_name, server.map_id AS server_map_id, server.mode_
id AS server_mode_id, server.country AS server_country, server.version AS server_version, server.hradba AS server_hradba, server.password AS server
_password, server.vietnam AS server_vietnam, server.online AS server_online \nFROM server \nWHERE server.online = true'] [parameters: [{}]]
heartbeat_1      |     "Can't reconnect until invalid "
heartbeat_1      | sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQ
L: 'SELECT server.infoport AS server_infoport, server.countryname AS server_countryname, server.numplayers AS server_numplayers, server.maxplayers
AS server_maxplayers, server.dedic AS server_dedic, server.`onlineSince` AS `server_onlineSince`, server.`offlineSince` AS `server_offlineSince`, s
erver.id AS server_id, server.ip AS server_ip, server.port AS server_port, server.name AS server_name, server.map_id AS server_map_id, server.mode_
id AS server_mode_id, server.country AS server_country, server.version AS server_version, server.hradba AS server_hradba, server.password AS server
_password, server.vietnam AS server_vietnam, server.online AS server_online \nFROM server \nWHERE server.ip = %(ip_1)s AND server.infoport = %(info
port_1)s \n LIMIT %(param_1)s'] [parameters: [{}]]
garncarz commented 6 years ago

✔️ Seems to be working alright now.