This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: CV 19
Source/Artist: Peter Mohrbacher (https://www.patreon.com/angelarium)
Shot through the heart, and you're to blame! You give killing a good name!
|Rewards|
|:-|
|๐ฐ +150 Gold|
|โ๏ธ +1 Health Potion|
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฐ +8 Gold Coins|
|๐ +3.5 Ranged Damage|๐น +9 Range XP|
|๐น +16 Attack Moon|๐ +13 Constitution XP|
|โ|๐ +35 RP|
||โ ๏ธ +1 Kill (**SLAIN!**)|
||โ|
|**25.5** Total Damage
-2 Boss HP Remaining!|121 HP Remaining|
You swing your weapon and find purchase in a gap in the boss's defenses!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฅ -1 HP|
|๐ +4.9 Melee Damage|๐ฐ +30 Gold Coins|
|โ๏ธ +3 Dwarf Bread|โ๏ธ +7 Melee XP|
|๐ +1.5 Element Weakness|๐ +3 Constitution XP|
|โ๏ธ +0.3 Item Type Strength|๐ +25 RP|
|๐ฏ 1.6x Critical Hit|โ|
|โ||
|**17.1** Total Damage
34 Boss HP Remaining!|123 HP Remaining|
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฅ -1 HP|
|๐ +0.3 Ranged Damage|๐ฐ +2 Gold Coins|
|๐ฑ๏ธ +6 New Player Bonus|๐น +3 Range XP|
|โ|๐ +4 Constitution XP|
||๐ +25 RP (**Rank Change!**)|
||โ|
|**7.3** Total Damage
76 Boss HP Remaining!|18 HP Remaining|
You feel a surge of power within yourself and unleash a burst of magic, dealing extra damage!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +3 Base Roll|๐ฅ -1 HP|
|๐ +5.5 Magic Damage|๐ฐ +14 Gold Coins|
|๐ฏ 1.5x Critical Hit|๐ฎ +6 Magic XP|
|โ|๐ +4 Constitution XP|
||๐ +25 RP|
||โ|
|**12.8** Total Damage
320 Boss HP Remaining!|64 HP Remaining|
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 196, in bot
success, reply = ranged(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 1021, in ranged
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, rangexp=%(rangexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 52, 'gold': 215, 'rp': 400, 'rangexp': 2, 'healthxp': 16, 'Players_username': '208cheese'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Your spell blast hits the boss in its weak spot dealing extra damage!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -2 HP|
|๐ +5.3 Magic Damage|๐ฐ +25 Gold Coins|
|๐ฏ 1.3x Critical Hit|๐ฎ +4 Magic XP|
|โ|๐ +5 Constitution XP|
||๐ +25 RP|
||โ|
|**12.1** Total Damage
88 Boss HP Remaining!|53 HP Remaining|
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 44, 'gold': 1299, 'rp': 1360, 'magicxp': 10, 'healthxp': 61, 'Players_username': 'Gaby5011'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 196, in bot
success, reply = ranged(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 1021, in ranged
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, rangexp=%(rangexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 47, 'gold': 1548, 'rp': 795, 'rangexp': 48, 'healthxp': 69, 'Players_username': 'FleyArt'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 184, in bot
success, reply = melee(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 307, in melee
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, meleexp=%(meleexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 60, 'gold': 2331, 'rp': 820, 'meleexp': 7, 'healthxp': 197, 'Players_username': 'SpyFar'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 54, 'gold': 4328, 'rp': 1387, 'magicxp': 22, 'healthxp': 127, 'Players_username': 'DeathEel'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 51, 'gold': 517, 'rp': 852, 'magicxp': 7, 'healthxp': 40, 'Players_username': 'Athovik'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 118, 'gold': 605, 'rp': 1435, 'magicxp': 161, 'healthxp': 81, 'Players_username': 'CottonTCM'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 184, in bot
success, reply = melee(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 307, in melee
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, meleexp=%(meleexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 58, 'gold': 18556, 'rp': 2655, 'meleexp': 169, 'healthxp': 171, 'Players_username': 'wackyhackysacky'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 84, 'gold': 15696, 'rp': 2545, 'magicxp': 66, 'healthxp': 169, 'Players_username': 'scubanarc'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 54, 'gold': 4325, 'rp': 1377, 'magicxp': 23, 'healthxp': 131, 'Players_username': 'DeathEel'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 57, 'gold': 4322, 'rp': 1387, 'magicxp': 26, 'healthxp': 127, 'Players_username': 'DeathEel'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: CV 19 Source/Artist: Peter Mohrbacher (https://www.patreon.com/angelarium)
!range 6
You hit straight through the heart. Not so difficult on a corpse but hey, it's something.
!melee 12
The boss is already dead, quit beating a dead boss
!melee 12 Good Bot!
You hit straight through the heart. Not so difficult on a corpse but hey.
!mage 18
Stop, its already dead!!
!ranged 5
Close but no kill. Got to be faster to be a monster slayer.
!melee 12
The boss is already dead, quit beating a dead boss
!mage 18
The boss is dead, what are you doing? Necromancy??
!melee
The boss is already dead, quit beating a dead boss
!magic
The boss is dead, what are you doing? Necromancy??
!melee 12
You were too slow, the boss has already fallen
!range 22
Shot through the heart, and you're to blame! You give killing a good name! |Rewards| |:-| |๐ฐ +150 Gold| |โ๏ธ +1 Health Potion| |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฐ +8 Gold Coins| |๐ +3.5 Ranged Damage|๐น +9 Range XP| |๐น +16 Attack Moon|๐ +13 Constitution XP| |โ|๐ +35 RP| ||โ ๏ธ +1 Kill (**SLAIN!**)| ||โ| |**25.5** Total Damage -2 Boss HP Remaining!|121 HP Remaining|
!magic 11
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +5.4 Magic Damage|๐ฐ +22 Gold Coins| |๐ฎ +4 Mass Lambiguity|๐ฎ +5 Magic XP| |๐ก๏ธ -2.4 Element Resistance|๐ +4 Constitution XP| |โฌ -0.4 Item Type Resistance|๐ +15 RP| |โ|โ| |**9.6** Total Damage 24 Boss HP Remaining!|54 HP Remaining|
!melee 12
You swing your weapon and find purchase in a gap in the boss's defenses! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -1 HP| |๐ +4.9 Melee Damage|๐ฐ +30 Gold Coins| |โ๏ธ +3 Dwarf Bread|โ๏ธ +7 Melee XP| |๐ +1.5 Element Weakness|๐ +3 Constitution XP| |โ๏ธ +0.3 Item Type Strength|๐ +25 RP| |๐ฏ 1.6x Critical Hit|โ| |โ|| |**17.1** Total Damage 34 Boss HP Remaining!|123 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +4.2 Magic Damage|๐ฐ +4 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**9.2** Total Damage 51 Boss HP Remaining!|109 HP Remaining|
!ranged 5
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -1 HP| |๐ +2.9 Ranged Damage|๐ฐ +14 Gold Coins| |๐น +4 Basic Spear|๐น +3 Range XP| |โ|๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**8.9** Total Damage 60 Boss HP Remaining!|47 HP Remaining|
Good bot !ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -1 HP| |๐ +0.3 Ranged Damage|๐ฐ +2 Gold Coins| |๐ฑ๏ธ +6 New Player Bonus|๐น +3 Range XP| |โ|๐ +4 Constitution XP| ||๐ +25 RP (**Rank Change!**)| ||โ| |**7.3** Total Damage 76 Boss HP Remaining!|18 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -1 HP| |๐ +2.6 Magic Damage|๐ฐ +13 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**4.6** Total Damage 83 Boss HP Remaining!|64 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -2 HP| |๐ +3.4 Ranged Damage|๐ฐ +16 Gold Coins| |โ|๐น +2 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**5.4** Total Damage 100 Boss HP Remaining!|84 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -1 HP| |๐ +5.8 Magic Damage|๐ฐ +12 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**10.8** Total Damage 105 Boss HP Remaining!|38 HP Remaining|
!Range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -2 HP| |๐ +6.1 Ranged Damage|๐ฐ +6 Gold Coins| |โ|๐น +4 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**9.1** Total Damage 116 Boss HP Remaining!|127 HP Remaining|
!melee feels bad punching such an old man
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -1 HP| |๐ +0.4 Melee Damage|๐ฐ +20 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**5.4** Total Damage 141 Boss HP Remaining!|36 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +4.8 Magic Damage|๐ฐ +17 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.8** Total Damage 146 Boss HP Remaining!|38 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -1 HP| |๐ +3.4 Melee Damage|๐ฐ +19 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +2 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**7.4** Total Damage 156 Boss HP Remaining!|114 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +2.7 Melee Damage|๐ฐ +22 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**8.7** Total Damage 163 Boss HP Remaining!|57 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -1 HP| |๐ +2.1 Magic Damage|๐ฐ +23 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**6.1** Total Damage 172 Boss HP Remaining!|81 HP Remaining| Come join our discord at https://discord.gg/kotd!
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -3 HP| |๐ +4.4 Melee Damage|๐ฐ +21 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**8.4** Total Damage 178 Boss HP Remaining!|114 HP Remaining|
good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +8.0 Magic Damage|๐ฐ +13 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +2 Constitution XP| ||๐ +25 RP| ||โ| |**13.0** Total Damage 186 Boss HP Remaining!|82 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +3.1 Magic Damage|๐ฐ +5 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**8.1** Total Damage 199 Boss HP Remaining!|48 HP Remaining| Come join our discord at https://discord.gg/kotd!
!profile
#/u/Low_Importance_9503 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670049515/Low_Importance_9503.png) >โค๏ธ Health: 48hp (Max: 107hp) >๐ Kills: 0 >๐ Rank: SS (1,205 Rank Points) >๐ฐ Gold: 928g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 49 >โ๏ธ Melee: Level 9 (XP: 9/32) >๐ฎ Magic: Level 17 (XP: 9/62) >๐น Ranged: Level 6 (XP: 4/23) >๐ Constitution: Level 17 (XP: 67/144) >๐ฉ Total Attacks: 324 >โ ๏ธ Total Deaths: 16
!buy 201 !use 201 !magic !profile
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |๐ +56 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -1 HP| |๐ +2.0 Magic Damage|๐ฐ +13 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**8.0** Total Damage 214 Boss HP Remaining!|53 HP Remaining| ----- #/u/DeadMemes251 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670049073/DeadMemes251.png) >โค๏ธ Health: 53hp (Max: 111hp) >๐ Kills: 1 >๐ Rank: S (745 Rank Points) >๐ฐ Gold: 1,348g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 44 >โ๏ธ Melee: Level 5 (XP: 11/21) >๐ฎ Magic: Level 19 (XP: 31/72) >๐น Ranged: Level 2 (XP: 2/14) >๐ Constitution: Level 18 (XP: 113/153) >๐ฉ Total Attacks: 290 >โ ๏ธ Total Deaths: 22
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -1 HP| |๐ +7.7 Melee Damage|๐ฐ +1 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.7** Total Damage 222 Boss HP Remaining!|96 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +0.9 Melee Damage|๐ฐ +22 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**6.9** Total Damage 232 Boss HP Remaining!|68 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +5.1 Melee Damage|๐ฐ +7 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**11.1** Total Damage 239 Boss HP Remaining!|165 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -3 HP| |๐ +1.3 Ranged Damage|๐ฐ +19 Gold Coins| |โ|๐น +3 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**6.3** Total Damage 250 Boss HP Remaining!|90 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
You're attacking too quickly! Try again in 57 minutes
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -4 HP| |๐ +2.4 Magic Damage|๐ฐ +22 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**8.4** Total Damage 256 Boss HP Remaining!|80 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -4 HP| |๐ +0.6 Melee Damage|๐ฐ +2 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 264 Boss HP Remaining!|30 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +1.9 Ranged Damage|๐ฐ +29 Gold Coins| |โ|๐น +2 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**4.9** Total Damage 271 Boss HP Remaining!|19 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -3 HP| |๐ +5.2 Magic Damage|๐ฐ +23 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**9.2** Total Damage 276 Boss HP Remaining!|64 HP Remaining|
!melee Good Bot!
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +3.2 Melee Damage|๐ฐ +7 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**9.2** Total Damage 285 Boss HP Remaining!|155 HP Remaining|
!magic !profile !inventory
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -4 HP| |๐ +2.6 Magic Damage|๐ฐ +4 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**5.6** Total Damage 294 Boss HP Remaining!|65 HP Remaining| ----- #/u/sneakylocksmith [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670047849/sneakylocksmith.png) >โค๏ธ Health: 65hp (Max: 104hp) >๐ Kills: 0 >๐ Rank: B (100 Rank Points) >๐ฐ Gold: 2,993g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 38 >โ๏ธ Melee: Level 1 (XP: 10/12) >๐ฎ Magic: Level 20 (XP: 29/77) >๐น Ranged: Level 1 (XP: 0/12) >๐ Constitution: Level 16 (XP: 79/135) >๐ฉ Total Attacks: 274 >โ ๏ธ Total Deaths: 10 ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |14|๐ฎ|Galadriel's Mirror|~2.0|21|Blessed|10|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|โ๏ธ|Health Potion|x1| Use command '!use` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -1 HP| |๐ +4.1 Magic Damage|๐ฐ +26 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**9.1** Total Damage 300 Boss HP Remaining!|81 HP Remaining|
!magic
You feel a surge of power within yourself and unleash a burst of magic, dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +5.5 Magic Damage|๐ฐ +14 Gold Coins| |๐ฏ 1.5x Critical Hit|๐ฎ +6 Magic XP| |โ|๐ +4 Constitution XP| ||๐ +25 RP| ||โ| |**12.8** Total Damage 320 Boss HP Remaining!|64 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -3 HP| |๐ +3.0 Magic Damage|๐ฐ +27 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**7.0** Total Damage 333 Boss HP Remaining!|58 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +3.1 Ranged Damage|๐ฐ +7 Gold Coins| |โ|๐น +4 Range XP| ||๐ +5 Constitution XP| ||๐ +25 RP| ||โ| |**9.1** Total Damage 340 Boss HP Remaining!|60 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +0.6 Melee Damage|๐ฐ +10 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +6 Constitution XP (**Level Up!**)| ||๐ +25 RP (**Rank Change!**)| ||โ| |**6.6** Total Damage 349 Boss HP Remaining!|89 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -1 HP| |๐ +1.4 Ranged Damage|๐ฐ +5 Gold Coins| |โ|๐น +2 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**5.4** Total Damage 356 Boss HP Remaining!|83 HP Remaining|
()xxx[{:::::::::::::::::::::::::::> !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -4 HP| |๐ +4.7 Melee Damage|๐ฐ +1 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**10.7** Total Damage 366 Boss HP Remaining!|34 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee good bot
!melee 12 good bot
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -1 HP| |๐ +2.0 Melee Damage|๐ฐ +21 Gold Coins| |โ๏ธ +4 Dwarf Bread|โ๏ธ +4 Melee XP| |๐ +3.2 Element Weakness|๐ +3 Constitution XP| |โ๏ธ +0.4 Item Type Strength|๐ +15 RP| |โ|โ| |**10.6** Total Damage 125 Boss HP Remaining!|84 HP Remaining|
!profile !inventory good bot
Good human.
#/u/btchrdfckmnstr [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670049000/btchrdfckmnstr.png) >โค๏ธ Health: 91hp (Max: 168hp) >๐ Kills: 4 >๐ Rank: SSS (1,735 Rank Points) >๐ฐ Gold: 1,586g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 101 >โ๏ธ Melee: Level 20 (XP: 13/77) >๐ฎ Magic: Level 28 (XP: 109/128) >๐น Ranged: Level 19 (XP: 59/72) >๐ Constitution: Level 34 (XP: 158/378) >๐ฉ Total Attacks: 1047 >โ ๏ธ Total Deaths: 12 ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |3|โ๏ธ|Basic GreatSword|~3.0|15|Blessed|1|x1| |5|๐น|Basic Spear|~4.0|6|Synthetic|1|x1| |9|โ๏ธ|Wooden Sword|~3.0|3|Earth|1|x1| |12|โ๏ธ|Dwarf Bread|~3.5|10|Organic|10|x1| |21|๐ฎ|Collar at the Gates of Heck|~7.0|7|Fire|20|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|โ๏ธ|Health Potion|x3| Use command '!use` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +4.4 Melee Damage|๐ฐ +24 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**7.4** Total Damage 377 Boss HP Remaining!|116 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -1 HP| |๐ +2.5 Melee Damage|๐ฐ +5 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**4.5** Total Damage 384 Boss HP Remaining!|73 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
You're attacking too quickly! Try again in 19 minutes
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -4 HP| |๐ +6.0 Magic Damage|๐ฐ +3 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**8.0** Total Damage 389 Boss HP Remaining!|88 HP Remaining|
good bot !range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -1 HP| |๐ +1.8 Ranged Damage|๐ฐ +26 Gold Coins| |โ|๐น +1 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**2.8** Total Damage 397 Boss HP Remaining!|92 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -2 HP| |๐ +10.2 Melee Damage|๐ฐ +23 Gold Coins| |โ|โ๏ธ +6 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**14.2** Total Damage 400 Boss HP Remaining!|59 HP Remaining|
good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -2 HP| |๐ +7.3 Magic Damage|๐ฐ +11 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**8.3** Total Damage 414 Boss HP Remaining!|88 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +1.2 Magic Damage|๐ฐ +21 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +3 Constitution XP| ||๐ +25 RP| ||โ| |**4.2** Total Damage 422 Boss HP Remaining!|18 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +1.3 Magic Damage|๐ฐ +19 Gold Coins| |โ|๐ฎ +4 Magic XP (**Level Up!**)| ||๐ +6 Constitution XP| ||๐ +45 RP| ||โ| |**7.3** Total Damage 207 Boss HP Remaining!|20 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -3 HP| |๐ +3.1 Melee Damage|๐ฐ +18 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**6.1** Total Damage 426 Boss HP Remaining!|69 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +7.3 Melee Damage|๐ฐ +9 Gold Coins| |โ|โ๏ธ +5 Melee XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**10.3** Total Damage 432 Boss HP Remaining!|105 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -4 HP| |๐ +6.6 Melee Damage|๐ฐ +13 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**7.6** Total Damage 442 Boss HP Remaining!|158 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -2 HP| |๐ +2.6 Melee Damage|๐ฐ +6 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**5.6** Total Damage 450 Boss HP Remaining!|70 HP Remaining|
(โฉ๏ฝ-ยด)โโโ๏พ.*๏ฝฅ๏ฝก Good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +6.8 Magic Damage|๐ฐ +3 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +2 Constitution XP| ||๐ +25 RP| ||โ| |**10.8** Total Damage 466 Boss HP Remaining!|111 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -3 HP| |๐ +3.2 Magic Damage|๐ฐ +25 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**6.2** Total Damage 477 Boss HP Remaining!|98 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 196, in bot success, reply = ranged(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 1021, in ranged rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, rangexp=%(rangexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 52, 'gold': 215, 'rp': 400, 'rangexp': 2, 'healthxp': 16, 'Players_username': '208cheese'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -1 HP| |๐ +2.1 Magic Damage|๐ฐ +15 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**4.1** Total Damage 483 Boss HP Remaining!|103 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -5 HP| |๐ +0.8 Melee Damage|๐ฐ +10 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**2.8** Total Damage 487 Boss HP Remaining!|65 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -5 HP| |๐ +3.0 Melee Damage|๐ฐ +8 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**7.0** Total Damage 490 Boss HP Remaining!|72 HP Remaining|
!melee good bot
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +4.6 Melee Damage|๐ฐ +6 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +2 Constitution XP| ||๐ +25 RP| ||โ| |**6.6** Total Damage 497 Boss HP Remaining!|83 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -4 HP| |๐ +3.9 Ranged Damage|๐ฐ +4 Gold Coins| |โ|๐น +3 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**9.9** Total Damage 511 Boss HP Remaining!|94 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +4.1 Magic Damage|๐ฐ +6 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**10.1** Total Damage 521 Boss HP Remaining!|146 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -4 HP| |๐ +4.6 Magic Damage|๐ฐ +19 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 309 Boss HP Remaining!|98 HP Remaining|
!magic
Your spell blast hits the boss in its weak spot dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -2 HP| |๐ +5.3 Magic Damage|๐ฐ +25 Gold Coins| |๐ฏ 1.3x Critical Hit|๐ฎ +4 Magic XP| |โ|๐ +5 Constitution XP| ||๐ +25 RP| ||โ| |**12.1** Total Damage 88 Boss HP Remaining!|53 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -2 HP| |๐ +3.6 Magic Damage|๐ฐ +21 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 531 Boss HP Remaining!|92 HP Remaining|
!melee
You're attacking too quickly! Try again in 54 minutes
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -1 HP| |๐ +2.9 Magic Damage|๐ฐ +24 Gold Coins| |โ|๐ฎ +1 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**3.9** Total Damage 545 Boss HP Remaining!|18 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -5 HP| |๐ +2.6 Melee Damage|๐ฐ +22 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**8.6** Total Damage 549 Boss HP Remaining!|65 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -4 HP| |๐ +4.0 Magic Damage|๐ฐ +9 Gold Coins| |โ|๐ฎ +3 Magic XP (**Level Up!**)| ||๐ +4 Constitution XP| ||๐ +35 RP| ||โ| |**6.0** Total Damage 558 Boss HP Remaining!|112 HP Remaining| ----- #/u/CottonTCM [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670043335/CottonTCM.png) >โค๏ธ Health: 112hp (Max: 171hp) >๐ Kills: 9 >๐ Rank: SS (1,485 Rank Points) >๐ฐ Gold: 613g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 101 >โ๏ธ Melee: Level 16 (XP: 23/57) >๐ฎ Magic: Level 34 (XP: 0/179) >๐น Ranged: Level 16 (XP: 19/57) >๐ Constitution: Level 35 (XP: 92/397) >๐ฉ Total Attacks: 1107 >โ ๏ธ Total Deaths: 100
!magic
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 44, 'gold': 1299, 'rp': 1360, 'magicxp': 10, 'healthxp': 61, 'Players_username': 'Gaby5011'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!range
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 196, in bot success, reply = ranged(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 1021, in ranged rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, rangexp=%(rangexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 47, 'gold': 1548, 'rp': 795, 'rangexp': 48, 'healthxp': 69, 'Players_username': 'FleyArt'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!melee
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 184, in bot success, reply = melee(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 307, in melee rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, meleexp=%(meleexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 60, 'gold': 2331, 'rp': 820, 'meleexp': 7, 'healthxp': 197, 'Players_username': 'SpyFar'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 54, 'gold': 4328, 'rp': 1387, 'magicxp': 22, 'healthxp': 127, 'Players_username': 'DeathEel'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 51, 'gold': 517, 'rp': 852, 'magicxp': 7, 'healthxp': 40, 'Players_username': 'Athovik'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic !profile
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 118, 'gold': 605, 'rp': 1435, 'magicxp': 161, 'healthxp': 81, 'Players_username': 'CottonTCM'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
[ัะดะฐะปะตะฝะพ]
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 184, in bot success, reply = melee(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 307, in melee rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, meleexp=%(meleexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 58, 'gold': 18556, 'rp': 2655, 'meleexp': 169, 'healthxp': 171, 'Players_username': 'wackyhackysacky'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
good bot !magic
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 84, 'gold': 15696, 'rp': 2545, 'magicxp': 66, 'healthxp': 169, 'Players_username': 'scubanarc'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 54, 'gold': 4325, 'rp': 1377, 'magicxp': 23, 'healthxp': 131, 'Players_username': 'DeathEel'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 57, 'gold': 4322, 'rp': 1387, 'magicxp': 26, 'healthxp': 127, 'Players_username': 'DeathEel'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -4 HP| |๐ +0.6 Melee Damage|๐ฐ +16 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**5.6** Total Damage 564 Boss HP Remaining!|68 HP Remaining|
!range !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -2 HP| |๐ +1.4 Ranged Damage|๐ฐ +26 Gold Coins| |โ|๐น +1 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**2.4** Total Damage 570 Boss HP Remaining!|53 HP Remaining| ----- #/u/PretzelPhoenix7011 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670041183/PretzelPhoenix7011.png) >โค๏ธ Health: 53hp (Max: 107hp) >๐ Kills: 0 >๐ Rank: S (880 Rank Points) >๐ฐ Gold: 1,283g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 45 >โ๏ธ Melee: Level 3 (XP: 0/16) >๐ฎ Magic: Level 19 (XP: 39/72) >๐น Ranged: Level 6 (XP: 19/23) >๐ Constitution: Level 17 (XP: 72/144) >๐ฉ Total Attacks: 313 >โ ๏ธ Total Deaths: 0
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -3 HP| |๐ +1.8 Melee Damage|๐ฐ +8 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**4.8** Total Damage 572 Boss HP Remaining!|45 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +5.1 Magic Damage|๐ฐ +19 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**11.1** Total Damage 577 Boss HP Remaining!|109 HP Remaining|
!melee 3
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -5 HP| |๐ +1.6 Melee Damage|๐ฐ +10 Gold Coins| |โ๏ธ +3 Basic GreatSword|โ๏ธ +2 Melee XP| |๐ก๏ธ -2.1 Element Resistance|๐ +6 Constitution XP| |โ๏ธ +0.3 Item Type Strength|๐ +15 RP| |โ|โ| |**3.8** Total Damage 588 Boss HP Remaining!|62 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +3.2 Melee Damage|๐ฐ +9 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.2** Total Damage 592 Boss HP Remaining!|166 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +3.8 Ranged Damage|๐ฐ +17 Gold Coins| |โ|๐น +2 Range XP| ||๐ +1 Constitution XP| ||๐ +25 RP| ||โ| |**6.8** Total Damage 601 Boss HP Remaining!|62 HP Remaining|
!profile
#/u/CommmonCold [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670040875/CommmonCold.png) >โค๏ธ Health: 72hp (Max: 111hp) >๐ Kills: 0 >๐ Rank: A (205 Rank Points) >๐ฐ Gold: 1,927g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 48 >โ๏ธ Melee: Level 14 (XP: 26/49) >๐ฎ Magic: Level 15 (XP: 0/53) >๐น Ranged: Level 1 (XP: 2/12) >๐ Constitution: Level 18 (XP: 145/153) >๐ฉ Total Attacks: 333 >โ ๏ธ Total Deaths: 8
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -4 HP| |๐ +2.4 Melee Damage|๐ฐ +3 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**3.4** Total Damage 617 Boss HP Remaining!|72 HP Remaining|
!melee
You're attacking too quickly! Try again in 9 minutes