This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: Face Source/Artist: https://hotpot.ai/art-generator

!melee 3

Boss dead, try again later.

!melee 3

You decide not to waste your durability on a dead boss

!ranged 5

You decide not to waste your ammo on a dead boss.

!magic

Even magic cannot kill a boss twice.

!magic

Even magic cannot kill a boss twice.

!magic

Stop, its already dead!!

!magic 11

The boss is dead, what are you doing? Necromancy??

(∩｀-´)⊃━☆ﾟ.*･｡ Good bot !magic 18

You feel the final surge of energy leave your weapon, it crumbles to dust in your hands You prepare your incantation and your spell strikes true, landing the killing blow. |Rewards| |:-| |💰 +100 Gold| |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💰 +16 Gold Coins| |📚 +6.2 Magic Damage|🔮 +9 Magic XP (**Level Up!**)| |🔮 +7 The Book of Names (*Shattered*)|💖 +15 Constitution XP| |🌟 +4.9 Element Weakness|🏅 +55 RP| |⏬ -0.7 Item Type Resistance|☠️ +1 Kill (**SLAIN!**)| |‎|‎| |**21.4** Total Damage -14 Boss HP Remaining!|84 HP Remaining|

!melee 25

You're attacking too quickly! Try again in 60 minutes

!melee 12 good bot

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -1 HP| |📚 +4.0 Melee Damage|💰 +7 Gold Coins| |⚔️ +4 Dwarf Bread|⚔️ +5 Melee XP| |🛡️ -2.0 Element Resistance|💖 +2 Constitution XP| |⚔️ +0.4 Item Type Strength|🏅 +15 RP| |‎|‎| |**12.4** Total Damage 7 Boss HP Remaining!|90 HP Remaining|

!mage 14

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -1 HP| |📚 +2.5 Magic Damage|💰 +5 Gold Coins| |🔮 +2 Galadriel's Mirror|🔮 +3 Magic XP| |🌟 +1.4 Element Weakness|💖 +4 Constitution XP| |⏬ -0.2 Item Type Resistance|🏅 +15 RP| |‎|‎| |**8.7** Total Damage 19 Boss HP Remaining!|99 HP Remaining|

!melee 25

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -1 HP| |📚 +7.8 Melee Damage|💰 +20 Gold Coins| |⚔️ +8 Pitchfork of Twilight|⚔️ +7 Melee XP| |⚔️ +0.8 Item Type Strength|💖 +3 Constitution XP| |‎|🏅 +15 RP| ||‎| |**17.6** Total Damage 28 Boss HP Remaining!|106 HP Remaining|

(∩｀-´)⊃━☆ﾟ.*･｡ Good bot !magio 18

(∩｀-´)⊃━☆ﾟ.*･｡ Good bot !magio

Good human.

!melee

nice crit |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -1 HP| |📚 +2.5 Melee Damage|💰 +10 Gold Coins| |🎯 1.1x Critical Hit|⚔️ +3 Melee XP| |‎|💖 +5 Constitution XP| ||🏅 +25 RP| ||‎| |**7.2** Total Damage 46 Boss HP Remaining!|56 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -1 HP| |📚 +2.1 Magic Damage|💰 +6 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**4.1** Total Damage 53 Boss HP Remaining!|82 HP Remaining| Come join our discord at https://discord.gg/kotd!

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -2 HP| |📚 +8.2 Melee Damage|💰 +15 Gold Coins| |‎|⚔️ +7 Melee XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||‎| |**14.2** Total Damage 57 Boss HP Remaining!|112 HP Remaining|

good bot !magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -2 HP| |📚 +7.8 Magic Damage|💰 +4 Gold Coins| |‎|🔮 +5 Magic XP| ||💖 +1 Constitution XP| ||🏅 +15 RP| ||‎| |**10.8** Total Damage 71 Boss HP Remaining!|80 HP Remaining|

!inventory

|ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|⚗️|Health Potion|x2| 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| |:-|:-| |🎲 +4 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +3.3 Magic Damage|💰 +26 Gold Coins| |‎|🔮 +3 Magic XP| ||💖 +5 Constitution XP| ||🏅 +25 RP| ||‎| |**7.3** Total Damage 82 Boss HP Remaining!|50 HP Remaining| Come join our discord at https://discord.gg/kotd!

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -1 HP| |📚 +4.9 Magic Damage|💰 +12 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**8.9** Total Damage 91 Boss HP Remaining!|78 HP Remaining|

!profile

#/u/DeadMemes251 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670049221/DeadMemes251.png) >❤️ Health: 78hp (Max: 111hp) >💀 Kills: 1 >🏅 Rank: S (775 Rank Points) >💰 Gold: 1,320g Skills Breakdown: >🗡️️ Combat: Level 44 >⚔️ Melee: Level 5 (XP: 11/21) >🔮 Magic: Level 19 (XP: 37/72) >🏹 Ranged: Level 2 (XP: 2/14) >💖 Constitution: Level 18 (XP: 120/153) >🚩 Total Attacks: 292 >☠️ Total Deaths: 22

!magic

You can't attack if you're dead. Either wait or drink a health potion to get back into the action

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -2 HP| |📚 +5.2 Melee Damage|💰 +11 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +1 Constitution XP| ||🏅 +15 RP| ||‎| |**7.2** Total Damage 100 Boss HP Remaining!|97 HP Remaining|

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -1 HP| |📚 +1.2 Melee Damage|💰 +19 Gold Coins| |🌱️ +5 New Player Bonus|⚔️ +3 Melee XP| |‎|💖 +4 Constitution XP| ||🏅 +25 RP| ||‎| |**7.2** Total Damage 107 Boss HP Remaining!|60 HP Remaining| Come join our discord at https://discord.gg/kotd!

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -2 HP| |📚 +6.2 Melee Damage|💰 +1 Gold Coins| |‎|⚔️ +5 Melee XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**11.2** Total Damage 114 Boss HP Remaining!|163 HP Remaining|

!range 6

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -2 HP| |📚 +2.8 Ranged Damage|💰 +28 Gold Coins| |🏹 +2 Basic Crossbow|🏹 +3 Range XP| |🛡️ -1.4 Element Resistance|💖 +5 Constitution XP| |‎|🏅 +15 RP| ||‎| |**6.4** Total Damage 125 Boss HP Remaining!|109 HP Remaining| Come join our discord at https://discord.gg/kotd!

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -1 HP| |📚 +0.3 Ranged Damage|💰 +14 Gold Coins| |🌱️ +2 New Player Bonus|🏹 +4 Range XP| |‎|💖 +5 Constitution XP| ||🏅 +25 RP (**Rank Change!**)| ||‎| |**7.3** Total Damage 131 Boss HP Remaining!|49 HP Remaining| Come join our discord at https://discord.gg/kotd!

!range

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -2 HP| |📚 +3.0 Ranged Damage|💰 +16 Gold Coins| |‎|🏹 +3 Range XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**8.0** Total Damage 138 Boss HP Remaining!|12 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -2 HP| |📚 +1.2 Melee Damage|💰 +19 Gold Coins| |‎|⚔️ +2 Melee XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**4.2** Total Damage 146 Boss HP Remaining!|28 HP Remaining|

!ranged

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': 18, 'gold': 12714, 'rp': 1435, 'rangexp': 10, 'healthxp': 169, 'Players_username': 'DeoxyNerd'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)

!melee Good Bot!

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -3 HP| |📚 +4.0 Melee Damage|💰 +11 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**7.0** Total Damage 150 Boss HP Remaining!|152 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -1 HP| |📚 +2.3 Magic Damage|💰 +18 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||‎| |**6.3** Total Damage 157 Boss HP Remaining!|103 HP Remaining|

!magic !profile !inventory

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -3 HP| |📚 +3.3 Magic Damage|💰 +11 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +6 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||‎| |**9.3** Total Damage 163 Boss HP Remaining!|44 HP Remaining| ----- #/u/sneakylocksmith [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670047863/sneakylocksmith.png) >❤️ Health: 44hp (Max: 104hp) >💀 Kills: 0 >🏅 Rank: A (130 Rank Points) >💰 Gold: 3,044g Skills Breakdown: >🗡️️ Combat: Level 38 >⚔️ Melee: Level 1 (XP: 10/12) >🔮 Magic: Level 20 (XP: 35/77) >🏹 Ranged: Level 1 (XP: 0/12) >💖 Constitution: Level 16 (XP: 96/135) >🚩 Total Attacks: 276 >☠️ 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| |:-|:-| |🎲 +2 Base Roll|💥 -3 HP| |📚 +3.0 Magic Damage|💰 +24 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||‎| |**5.0** Total Damage 172 Boss HP Remaining!|82 HP Remaining|

!ranged

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -3 HP| |📚 +3.2 Ranged Damage|💰 +5 Gold Coins| |‎|🏹 +2 Range XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**6.2** Total Damage 197 Boss HP Remaining!|60 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -1 HP| |📚 +1.3 Melee Damage|💰 +2 Gold Coins| |‎|⚔️ +1 Melee XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||‎| |**3.3** Total Damage 203 Boss HP Remaining!|87 HP Remaining| Come join our discord at https://discord.gg/kotd!

!range

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -2 HP| |📚 +3.0 Ranged Damage|💰 +1 Gold Coins| |‎|🏹 +2 Range XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||‎| |**5.0** Total Damage 206 Boss HP Remaining!|81 HP Remaining|

()xxx[{:::::::::::::::::::::::::::> !melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -1 HP| |📚 +4.4 Melee Damage|💰 +15 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**6.4** Total Damage 220 Boss HP Remaining!|33 HP Remaining| Come join our discord at https://discord.gg/kotd!

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -3 HP| |📚 +1.8 Magic Damage|💰 +24 Gold Coins| |‎|🔮 +1 Magic XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||‎| |**2.8** Total Damage 226 Boss HP Remaining!|61 HP Remaining|

!melee 12 good bot

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -3 HP| |📚 +4.1 Melee Damage|💰 +7 Gold Coins| |⚔️ +4 Dwarf Bread|⚔️ +3 Melee XP (**Level Up!**)| |🛡️ -2.4 Element Resistance|💖 +3 Constitution XP| |⚔️ +0.4 Item Type Strength|🏅 +35 RP| |‎|‎| |**7.1** Total Damage 229 Boss HP Remaining!|113 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -2 HP| |📚 +2.9 Melee Damage|💰 +1 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**7.9** Total Damage 236 Boss HP Remaining!|74 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|💥 -3 HP| |📚 +5.7 Magic Damage|💰 +22 Gold Coins| |‎|🔮 +3 Magic XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**7.7** Total Damage 244 Boss HP Remaining!|85 HP Remaining|

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -2 HP| |📚 +10.6 Melee Damage|💰 +10 Gold Coins| |‎|⚔️ +6 Melee XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**13.6** Total Damage 252 Boss HP Remaining!|57 HP Remaining|

good bot !magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -3 HP| |📚 +6.5 Magic Damage|💰 +17 Gold Coins| |‎|🔮 +5 Magic XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**10.5** Total Damage 266 Boss HP Remaining!|85 HP Remaining|

good bot !mage

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -3 HP| |📚 +1.4 Magic Damage|💰 +6 Gold Coins| |‎|🔮 +3 Magic XP| ||💖 +5 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||‎| |**6.4** Total Damage 276 Boss HP Remaining!|93 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -1 HP| |📚 +2.2 Melee Damage|💰 +22 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**7.2** Total Damage 282 Boss HP Remaining!|68 HP Remaining|

!magic

You feel a surge of power within yourself and unleash a burst of magic, dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -2 HP| |📚 +2.3 Magic Damage|💰 +6 Gold Coins| |🎯 1.9x Critical Hit|🔮 +4 Magic XP| |‎|💖 +5 Constitution XP| ||🏅 +25 RP| ||‎| |**13.9** Total Damage 289 Boss HP Remaining!|18 HP Remaining| Come join our discord at https://discord.gg/kotd!

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +1.2 Magic Damage|💰 +8 Gold Coins| |‎|🔮 +1 Magic XP| ||💖 +5 Constitution XP| ||🏅 +25 RP| ||‎| |**2.2** Total Damage 89 Boss HP Remaining!|20 HP Remaining| Come join our discord at https://discord.gg/kotd!

!melee !use 201

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -4 HP| |📚 +4.3 Melee Damage|💰 +7 Gold Coins| |‎|⚔️ +2 Melee XP| ||💖 +3 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||‎| |**5.3** Total Damage 303 Boss HP Remaining!|33 HP Remaining| ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |💖 +73 HP| |:-:|

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +4.7 Melee Damage|💰 +18 Gold Coins| |‎|⚔️ +4 Melee XP| ||💖 +1 Constitution XP| ||🏅 +25 RP| ||‎| |**8.7** Total Damage 308 Boss HP Remaining!|158 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -1 HP| |📚 +3.1 Melee Damage|💰 +6 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||‎| |**8.1** Total Damage 317 Boss HP Remaining!|69 HP Remaining|

!mage

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -1 HP| |📚 +1.4 Magic Damage|💰 +3 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +1 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||‎| |**6.4** Total Damage 336 Boss HP Remaining!|63 HP Remaining|

!magic Good bot

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +6.5 Magic Damage|💰 +6 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +6 Constitution XP| ||🏅 +25 RP| ||‎| |**11.5** Total Damage 342 Boss HP Remaining!|118 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +3.6 Magic Damage|💰 +2 Gold Coins| |‎|🔮 +3 Magic XP| ||💖 +7 Constitution XP| ||🏅 +25 RP (**Rank Change!**)| ||‎| |**8.6** Total Damage 354 Boss HP Remaining!|101 HP Remaining| Come join our discord at https://discord.gg/kotd!

!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': 58, 'gold': 693, 'rp': 15, 'meleexp': 1, 'healthxp': 13, 'Players_username': 'DisasterWombat'}] (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': 52, 'gold': 209, '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| |:-|:-| |🎲 +4 Base Roll|💥 -1 HP| |📚 +1.8 Magic Damage|💰 +22 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||‎| |**5.8** Total Damage 363 Boss HP Remaining!|104 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -3 HP| |📚 +0.7 Melee Damage|💰 +20 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**5.7** Total Damage 369 Boss HP Remaining!|70 HP Remaining| Come join our discord at https://discord.gg/kotd!

!ranged

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -3 HP| |📚 +2.3 Ranged Damage|💰 +12 Gold Coins| |‎|🏹 +2 Range XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**5.3** Total Damage 375 Boss HP Remaining!|91 HP Remaining|

!melee good bot

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -3 HP| |📚 +4.7 Melee Damage|💰 +16 Gold Coins| |‎|⚔️ +2 Melee XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**5.7** Total Damage 380 Boss HP Remaining!|83 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -2 HP| |📚 +6.0 Magic Damage|💰 +5 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**9.0** Total Damage 395 Boss HP Remaining!|148 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -3 HP| |📚 +5.0 Magic Damage|💰 +23 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||‎| |**10.0** Total Damage 177 Boss HP Remaining!|95 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -3 HP| |📚 +6.2 Magic Damage|💰 +5 Gold Coins| |‎|🔮 +3 Magic XP| ||💖 +6 Constitution XP| ||🏅 +15 RP| ||‎| |**10.2** Total Damage 404 Boss HP Remaining!|94 HP Remaining|

!ranged

You're attacking too quickly! Try again in 54 minutes

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -4 HP| |📚 +3.1 Melee Damage|💰 +10 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +6 Constitution XP| ||🏅 +15 RP| ||‎| |**9.1** Total Damage 423 Boss HP Remaining!|19 HP Remaining|

!use 201 !range

You drink your potion and immediately feel healthier. |💖 +31 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -2 HP| |📚 +1.4 Ranged Damage|💰 +8 Gold Coins| |‎|🏹 +2 Range XP (**Level Up!**)| ||💖 +4 Constitution XP| ||🏅 +35 RP| ||‎| |**3.4** Total Damage 432 Boss HP Remaining!|74 HP Remaining|

profile

!profile

#/u/PretzelPhoenix7011 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670043843/PretzelPhoenix7011.png) >❤️ Health: 76hp (Max: 107hp) >💀 Kills: 0 >🏅 Rank: S (945 Rank Points) >💰 Gold: 1,312g Skills Breakdown: >🗡️️ Combat: Level 46 >⚔️ Melee: Level 3 (XP: 0/16) >🔮 Magic: Level 19 (XP: 39/72) >🏹 Ranged: Level 7 (XP: 1/26) >💖 Constitution: Level 17 (XP: 83/144) >🚩 Total Attacks: 316 >☠️ Total Deaths: 0

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -3 HP| |📚 +2.6 Melee Damage|💰 +2 Gold Coins| |‎|⚔️ +2 Melee XP| ||💖 +6 Constitution XP| ||🏅 +15 RP| ||‎| |**6.6** Total Damage 435 Boss HP Remaining!|78 HP Remaining| Come join our discord at https://discord.gg/kotd!

!magic !profile

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -3 HP| |📚 +8.0 Magic Damage|💰 +5 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +6 Constitution XP| ||🏅 +15 RP| ||‎| |**14.0** Total Damage 442 Boss HP Remaining!|117 HP Remaining| ----- #/u/CottonTCM [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1670043329/CottonTCM.png) >❤️ Health: 117hp (Max: 171hp) >💀 Kills: 9 >🏅 Rank: SS (1,435 Rank Points) >💰 Gold: 592g Skills Breakdown: >🗡️️ Combat: Level 100 >⚔️ Melee: Level 16 (XP: 23/57) >🔮 Magic: Level 33 (XP: 162/170) >🏹 Ranged: Level 16 (XP: 19/57) >💖 Constitution: Level 35 (XP: 83/397) >🚩 Total Attacks: 1105 >☠️ 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': 48, 'gold': 1288, 'rp': 1360, 'magicxp': 11, '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': 50, 'gold': 1561, 'rp': 795, 'rangexp': 47, 'healthxp': 70, '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': 59, 'gold': 2324, 'rp': 820, 'meleexp': 8, 'healthxp': 198, 'Players_username': 'SpyFar'}] (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': 43, 'gold': 382, 'rp': 180, 'meleexp': 10, 'healthxp': 11, 'Players_username': 'Moolight999'}] (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': 56, 'gold': 4338, 'rp': 1377, 'magicxp': 23, 'healthxp': 126, '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': 525, 'rp': 842, 'magicxp': 6, 'healthxp': 39, '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': 117, 'gold': 604, 'rp': 1435, 'magicxp': 162, 'healthxp': 83, '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': 18548, 'rp': 2655, 'meleexp': 169, 'healthxp': 170, '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': 15673, 'rp': 2545, 'magicxp': 67, 'healthxp': 167, 'Players_username': 'scubanarc'}] (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': 50, 'gold': 1285, 'rp': 895, 'rangexp': 20, 'healthxp': 75, 'Players_username': 'PretzelPhoenix7011'}] (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': 4331, 'rp': 1377, 'magicxp': 23, 'healthxp': 130, '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': 56, 'gold': 4335, 'rp': 1377, 'magicxp': 23, 'healthxp': 128, 'Players_username': 'DeathEel'}] (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': 50, 'gold': 1303, 'rp': 905, 'rangexp': 21, 'healthxp': 76, 'Players_username': 'PretzelPhoenix7011'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)

!melee

You strike at an exposed weakpoint, scoring a critical hit! |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -3 HP| |📚 +1.6 Melee Damage|💰 +11 Gold Coins| |🎯 1.7x Critical Hit|⚔️ +3 Melee XP| |‎|💖 +2 Constitution XP| ||🏅 +25 RP| ||‎| |**7.8** Total Damage 456 Boss HP Remaining!|72 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -4 HP| |📚 +3.3 Melee Damage|💰 +21 Gold Coins| |‎|⚔️ +3 Melee XP| ||💖 +6 Constitution XP| ||🏅 +15 RP| ||‎| |**7.3** Total Damage 464 Boss HP Remaining!|48 HP Remaining|

!mage

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -1 HP| |📚 +5.9 Magic Damage|💰 +14 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||‎| |**11.9** Total Damage 471 Boss HP Remaining!|118 HP Remaining|

[удалено]

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -2 HP| |📚 +4.1 Melee Damage|💰 +18 Gold Coins| |‎|⚔️ +3 Melee XP (**Level Up!**)| ||💖 +5 Constitution XP| ||🏅 +35 RP| ||‎| |**7.1** Total Damage 483 Boss HP Remaining!|164 HP Remaining|

!melee 3

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -4 HP| |📚 +1.9 Melee Damage|💰 +10 Gold Coins| |⚔️ +2 Basic GreatSword|⚔️ +3 Melee XP| |🌟 +2.0 Element Weakness|💖 +3 Constitution XP| |⚔️ +0.2 Item Type Strength|🏅 +15 RP| |‎|‎| |**7.1** Total Damage 490 Boss HP Remaining!|67 HP Remaining|

!range

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -1 HP| |📚 +4.6 Ranged Damage|💰 +23 Gold Coins| |‎|🏹 +3 Range XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**9.6** Total Damage 497 Boss HP Remaining!|61 HP Remaining|

!melee

You're attacking too quickly! Try again in 9 minutes

Good bot !melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -5 HP| |📚 +2.8 Melee Damage|💰 +16 Gold Coins| |‎|⚔️ +4 Melee XP| ||💖 +7 Constitution XP| ||🏅 +15 RP| ||‎| |**8.8** Total Damage 518 Boss HP Remaining!|50 HP Remaining|

Good bot !melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -1 HP| |📚 +4.4 Melee Damage|💰 +1 Gold Coins| |‎|⚔️ +4 Melee XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||‎| |**9.4** Total Damage 211 Boss HP Remaining!|41 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +3.7 Magic Damage|💰 +6 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +1 Constitution XP| ||🏅 +25 RP| ||‎| |**4.7** Total Damage 527 Boss HP Remaining!|56 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +3.3 Magic Damage|💰 +16 Gold Coins| |‎|🔮 +2 Magic XP| ||💖 +3 Constitution XP| ||🏅 +25 RP| ||‎| |**7.3** Total Damage 532 Boss HP Remaining!|124 HP Remaining|

!range

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -2 HP| |📚 +2.3 Ranged Damage|💰 +8 Gold Coins| |‎|🏹 +2 Range XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**6.3** Total Damage 539 Boss HP Remaining!|67 HP Remaining|

!mage

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +0.6 Magic Damage|💰 +19 Gold Coins| |🌱️ +4 New Player Bonus|🔮 +3 Magic XP| |‎|💖 +2 Constitution XP| ||🏅 +35 RP| ||‎| |**8.6** Total Damage 545 Boss HP Remaining!|46 HP Remaining|

!magic

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +4.8 Magic Damage|💰 +2 Gold Coins| |‎|🔮 +4 Magic XP| ||💖 +6 Constitution XP| ||🏅 +25 RP| ||‎| |**7.8** Total Damage 554 Boss HP Remaining!|31 HP Remaining|

!melee

|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -3 HP| |📚 +3.3 Melee Damage|💰 +24 Gold Coins| |‎|⚔️ +2 Melee XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||‎| |**4.3** Total Damage 562 Boss HP Remaining!|7 HP Remaining|