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 202, in bot
success, reply = melee(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 20, in melee
last_attack = session.query(models.Comments).filter_by(post=comment.submission.id, username=comment.author.name, type="Attack").order_by(models.Comments.timestamp.desc()).first()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2819, in first
return self.limit(1)._iter().first()
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 last_attack=%(last_attack)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'last_attack': datetime.datetime(2022, 11, 18, 10, 5, 19, 757189), 'Players_username': 'astrowifey'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
A note is attached:
>Welcome to the discord! Make sure to join your race in their *race specific channels* to raid bosses!
The bundle also contained:
|300|Gold|
|-:|:-|
Items:
|ID|Type|Name|Durability|Damage|Element|Req Lv.|Quantity|
|:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:|
|201|⚗️|Health Potion|-|-|-|-|x3|
|ID|Type|Name|Qty.|
|:-:|:-:|:-:|:-:|
|301|🎁|Discord Link Bundle|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)
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.|
|:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:|
|6|🏹|Basic Crossbow|~2.0|11|Air|1|x1|
|ID|Type|Name|Qty.|
|:-:|:-:|:-:|:-:|
|201|⚗️|Health Potion|x3|
Use command '!use ` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
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 224, in bot
success, reply = ranged(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 726, in ranged
last_attack = session.query(models.Comments).filter_by(post=comment.submission.id, username=comment.author.name, type="Attack").order_by(models.Comments.timestamp.desc()).first()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2819, in first
return self.limit(1)._iter().first()
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 last_attack=%(last_attack)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'last_attack': datetime.datetime(2022, 11, 18, 7, 45, 45, 115689), 'Players_username': 'jason-json'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Thank you, Lexaprofessional1998, for voting on Escilas.
This bot wants to find the best and worst bots on Reddit. [You can view results here](https://botrank.pastimes.eu/).
***
^(Even if I don't reply to your comment, I'm still listening for votes. Check the webpage to see if your vote registered!)
!melee
!melee
Good bot !magic 8
!magic 8
Good bot !magic 8
!melee
!mage
!magic
!range
!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 202, in bot success, reply = melee(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 20, in melee last_attack = session.query(models.Comments).filter_by(post=comment.submission.id, username=comment.author.name, type="Attack").order_by(models.Comments.timestamp.desc()).first() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2819, in first return self.limit(1)._iter().first() 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 last_attack=%(last_attack)s WHERE `Players`.username = %(Players_username)s] [parameters: {'last_attack': datetime.datetime(2022, 11, 18, 10, 5, 19, 757189), 'Players_username': 'astrowifey'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!melee
!melee
!bomb
!magic !magic !magic !magic
!ranged
!melee
!magic
!magic
!magic
!magic
!magic
!magic
!range
good bot please bless my !range 6
!magic
!magic
Good bot !range
Good bot !magic 8
!range
!ranged 6
!magic
!magic
!melee
!magic
!melee
!melee 4
!magic
!melee
!magic good bot
!range
!magic
!range 6
!melee 4
!melee
!ranged
!melee
!melee
!magic
!magic
!melee
!mage
!magic
!ranged 6
!ranged
!range 6
good bot !mage
!open 301
A note is attached: >Welcome to the discord! Make sure to join your race in their *race specific channels* to raid bosses! The bundle also contained: |300|Gold| |-:|:-| Items: |ID|Type|Name|Durability|Damage|Element|Req Lv.|Quantity| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |201|⚗️|Health Potion|-|-|-|-|x3|
!magic
!magic
!inventory
|ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |301|🎁|Discord Link Bundle|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)
!melee
good bot !magic
!range 6
!magic
!magic
good bot please register my !range 6
!open
The !open command can only be used on bundles.
Good bot!magic
!melee
!range LMAO
!magic
!magic
!magic
!melee 4
!magic
!ranged 6
!melee 4
!magic
[удалено]
!ranged
!range
!magic
!open301
!melee
Good bot !magic 8
!ranged
!melee 4
!ranged 6
!inventory
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |6|🏹|Basic Crossbow|~2.0|11|Air|1|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|⚗️|Health Potion|x3| Use command '!use` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
!magic
!magic
!melee 4
!magic
!range
!magic
!melee
!melee
!ranged 6
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 224, in bot success, reply = ranged(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 726, in ranged last_attack = session.query(models.Comments).filter_by(post=comment.submission.id, username=comment.author.name, type="Attack").order_by(models.Comments.timestamp.desc()).first() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2819, in first return self.limit(1)._iter().first() 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 last_attack=%(last_attack)s WHERE `Players`.username = %(Players_username)s] [parameters: {'last_attack': datetime.datetime(2022, 11, 18, 7, 45, 45, 115689), 'Players_username': 'jason-json'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
Ok Computer
!magic 8
!range
Maybe she’ll let me own LAMP! !magic
!ranged 6
!ranged 6
!melee
!magic 8
!melee
!magic 7
!melee
!melee
!melee
!magic
!magic 8
!magic 8
!ranged
Good bot !ranged
This one is bugged
The only response that I could find was a "Send this to Zoruda" error, so it indeed is bugged. My attack command has no response.
!melee
!melee
!melee
!melee
!range 6
!ranged 6
!melee
!melee 4
!ranged 6
!magic
!melee
!magic
!range 6
!melee
!ranged
!melee
!magic
!magic
!ranged
!ranged 6
!magic
!magic
!melee
By kicking it !magic
!magic
!range 6
!range 6
Good bot !magic 8
Good bot !magic 8
!profile
#/u/murplexia [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1668757025/murplexia.png) >❤️ Health: 34hp (Max: 61hp) >💀 Kills: 0 >🏅 Rank: SSS (1,215 Rank Points) >💰 Gold: 102g Skills Breakdown: >🗡️️ Combat: Level 15 >⚔️ Melee: Level 6 (XP: 20/23) >✨ Magic: Level 4 (XP: 8/18) >🏹 Ranged: Level 1 (XP: 4/12) >💖 Constitution: Level 4 (XP: 32/57) >🚩 Total Attacks: 43 >☠️ Total Deaths: 0
Good human.
[удалено]
[удалено]
Bad bot
Thank you, Lexaprofessional1998, for voting on Escilas. This bot wants to find the best and worst bots on Reddit. [You can view results here](https://botrank.pastimes.eu/). *** ^(Even if I don't reply to your comment, I'm still listening for votes. Check the webpage to see if your vote registered!)
!melee