Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Database srror after upgrade from 1.5.10 to 1.5.11 #1725

Open
2 tasks done
thelittlefireman opened this issue Nov 18, 2024 · 1 comment
Open
2 tasks done

[BUG] Database srror after upgrade from 1.5.10 to 1.5.11 #1725

thelittlefireman opened this issue Nov 18, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@thelittlefireman
Copy link
Contributor

thelittlefireman commented Nov 18, 2024 •
edited
Loading

What happened?

After upgrade from 1.5.10 to 1.5.11 i've got a lot of database errors.

How to reproduce?

upgrade from 1.5.10 to 1.5.11

Configuration file(s) (yaml or .env)

No response

Relevant log output

Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:25 +0000] [GENERATOR] [34] [⚠️ ] - Database version (error) is different from Bunkerweb version (1.5.11), migrating ...
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:25 +0000] [GENERATOR] [34] [⚠️ ] - Table "bw_cli_commands" already exists, dropping it to make room for the new one
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:25 +0000] [GENERATOR] [34] [⚠️ ] - Table "bw_plugins" already exists, dropping it to make room for the new one
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: /usr/share/bunkerweb/db/Database.py:274: SAWarning: transaction already deassociated from connection
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   session.rollback()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:25 +0000] [GENERATOR] [34] [❌] - Exception while executing config saver : Traceback (most recent call last):
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     self.dialect.do_execute(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/default.py", line 941, in do_execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     cursor.execute(statement, parameters)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 153, in execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     result = self._query(query)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 322, in _query
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     conn.query(q)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 563, in query
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 825, in _read_query_result
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     result.read()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 1199, in read
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     first_packet = self.connection._read_packet()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 775, in _read_packet
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     packet.raise_for_error()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/protocol.py", line 219, in raise_for_error
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     err.raise_mysql_exception(self._data)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/err.py", line 150, in raise_mysql_exception
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     raise errorclass(errno, errval)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: pymysql.err.OperationalError: (3730, "Cannot drop table 'bw_plugins_error' referenced by a foreign key constraint 'bw_settings_error_ibfk_1' on table 'bw_settings_error'.")
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: The above exception was the direct cause of the following exception:
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: Traceback (most recent call last):
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/gen/save_config.py", line 302, in <module>
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     ret, err = db.init_tables(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:                ^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/db/Database.py", line 699, in init_tables
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     session.execute(text(f"DROP TABLE {table_name}_{db_version_id}"))
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/scoping.py", line 778, in execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     return self._proxied.execute(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/session.py", line 2362, in execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     return self._execute_internal(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/session.py", line 2256, in _execute_internal
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     result = conn.execute(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1418, in execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     return meth(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:            ^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     return connection._execute_clauseelement(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     ret = self._execute_context(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:           ^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1846, in _execute_context
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     return self._exec_single_context(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     self._handle_dbapi_exception(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     self.dialect.do_execute(
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/default.py", line 941, in do_execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     cursor.execute(statement, parameters)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 153, in execute
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     result = self._query(query)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 322, in _query
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     conn.query(q)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 563, in query
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 825, in _read_query_result
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     result.read()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 1199, in read
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     first_packet = self.connection._read_packet()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 775, in _read_packet
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     packet.raise_for_error()
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/protocol.py", line 219, in raise_for_error
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     err.raise_mysql_exception(self._data)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/err.py", line 150, in raise_mysql_exception
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]:     raise errorclass(errno, errval)
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (3730, "Cannot drop table 'bw_plugins_error' referenced by a foreign key constraint 'bw_settings_error_ibfk_1' on table 'bw_settings_error'.")
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: [SQL: DROP TABLE bw_plugins_error]
Nov 18 23:39:25 172.16.1.1 ba333321ce29[26671]: (Background on this error at: https://sqlalche.me/e/20/e3q8)
Nov 18 23:39:26 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:26 +0000] [SCHEDULER] [21] [❌] - Config saver failed, configuration will not work as expected...

Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:32 +0000] [JOBS.DOWNLOAD-PLUGINS] [92] [❌] - Exception while installing plugin(s) from https://github.com/bunkerity/bunkerweb-plugins/archive/refs/tags/v1.6.zip :
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: Traceback (most recent call last):
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     self.dialect.do_execute(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/default.py", line 941, in do_execute
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     cursor.execute(statement, parameters)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 153, in execute
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result = self._query(query)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 322, in _query
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     conn.query(q)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 563, in query
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 825, in _read_query_result
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result.read()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 1199, in read
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     first_packet = self.connection._read_packet()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 775, in _read_packet
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     packet.raise_for_error()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/protocol.py", line 219, in raise_for_error
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     err.raise_mysql_exception(self._data)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/err.py", line 150, in raise_mysql_exception
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     raise errorclass(errno, errval)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: pymysql.err.ProgrammingError: (1146, "Table 'db.bw_cli_commands' doesn't exist")
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: The above exception was the direct cause of the following exception:
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: Traceback (most recent call last):
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/core/misc/jobs/download-plugins.py", line 159, in <module>
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     if install_plugin(plugin_path.parent, db):
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/core/misc/jobs/download-plugins.py", line 64, in install_plugin
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     for plugin in db.get_plugins(_type="external"):
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/db/Database.py", line 2407, in get_plugins
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     for command in session.query(BwcliCommands).with_entities(BwcliCommands.name, BwcliCommands.file_name).filter_by(plugin_id=plugin.id):
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/query.py", line 2813, in __iter__
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result = self._iter()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/query.py", line 2827, in _iter
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                                                   ^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/session.py", line 2362, in execute
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     return self._execute_internal(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/session.py", line 2247, in _execute_internal
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result: Result[Any] = compile_state_cls.orm_execute_statement(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result = conn.execute(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1418, in execute
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     return meth(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:            ^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     return connection._execute_clauseelement(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     ret = self._execute_context(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:           ^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1846, in _execute_context
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     return self._exec_single_context(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     self._handle_dbapi_exception(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     self.dialect.do_execute(
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/default.py", line 941, in do_execute
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     cursor.execute(statement, parameters)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 153, in execute
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result = self._query(query)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 322, in _query
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     conn.query(q)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 563, in query
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 825, in _read_query_result
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     result.read()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 1199, in read
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     first_packet = self.connection._read_packet()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 775, in _read_packet
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     packet.raise_for_error()
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/protocol.py", line 219, in raise_for_error
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     err.raise_mysql_exception(self._data)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/err.py", line 150, in raise_mysql_exception
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]:     raise errorclass(errno, errval)
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'db.bw_cli_commands' doesn't exist")
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: [SQL: SELECT bw_cli_commands.name AS bw_cli_commands_name, bw_cli_commands.file_name AS bw_cli_commands_file_name 
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: FROM bw_cli_commands 
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: WHERE bw_cli_commands.plugin_id = %(plugin_id_1)s]
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: [parameters: {'plugin_id_1': 'clamav'}]
Nov 18 23:39:32 172.16.1.1 ba333321ce29[26671]: (Background on this error at: https://sqlalche.me/e/20/f405)

...

[2024-11-18 22:39:47 +0000] [JOBS.DOWNLOAD-PLUGINS] [183] [ℹ️ ] - Downloading external plugins from https://github.com/bunkerity/bunkerweb-plugins/archive/refs/tags/v1.6.zip...
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: /usr/share/bunkerweb/db/Database.py:274: SAWarning: transaction already deassociated from connection
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   session.rollback()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:39:48 +0000] [JOBS.DOWNLOAD-PLUGINS] [183] [❌] - Exception while installing plugin(s) from https://github.com/bunkerity/bunkerweb-plugins/archive/refs/tags/v1.6.zip :
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: Traceback (most recent call last):
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     self.dialect.do_execute(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/default.py", line 941, in do_execute
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     cursor.execute(statement, parameters)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 153, in execute
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result = self._query(query)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 322, in _query
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     conn.query(q)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 563, in query
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 825, in _read_query_result
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result.read()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 1199, in read
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     first_packet = self.connection._read_packet()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 775, in _read_packet
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     packet.raise_for_error()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/protocol.py", line 219, in raise_for_error
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     err.raise_mysql_exception(self._data)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/err.py", line 150, in raise_mysql_exception
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     raise errorclass(errno, errval)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: pymysql.err.ProgrammingError: (1146, "Table 'db.bw_cli_commands' doesn't exist")
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: The above exception was the direct cause of the following exception:
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: Traceback (most recent call last):
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/core/misc/jobs/download-plugins.py", line 159, in <module>
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     if install_plugin(plugin_path.parent, db):
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/core/misc/jobs/download-plugins.py", line 64, in install_plugin
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     for plugin in db.get_plugins(_type="external"):
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/db/Database.py", line 2407, in get_plugins
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     for command in session.query(BwcliCommands).with_entities(BwcliCommands.name, BwcliCommands.file_name).filter_by(plugin_id=plugin.id):
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/query.py", line 2813, in __iter__
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result = self._iter()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/query.py", line 2827, in _iter
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                                                   ^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/session.py", line 2362, in execute
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     return self._execute_internal(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/session.py", line 2247, in _execute_internal
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result: Result[Any] = compile_state_cls.orm_execute_statement(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result = conn.execute(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1418, in execute
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     return meth(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:            ^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     return connection._execute_clauseelement(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     ret = self._execute_context(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:           ^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1846, in _execute_context
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     return self._exec_single_context(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     self._handle_dbapi_exception(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     self.dialect.do_execute(
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/sqlalchemy/engine/default.py", line 941, in do_execute
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     cursor.execute(statement, parameters)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 153, in execute
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result = self._query(query)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:              ^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/cursors.py", line 322, in _query
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     conn.query(q)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 563, in query
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 825, in _read_query_result
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     result.read()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 1199, in read
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     first_packet = self.connection._read_packet()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/connections.py", line 775, in _read_packet
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     packet.raise_for_error()
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/protocol.py", line 219, in raise_for_error
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     err.raise_mysql_exception(self._data)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:   File "/usr/share/bunkerweb/deps/python/pymysql/err.py", line 150, in raise_mysql_exception
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]:     raise errorclass(errno, errval)
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'db.bw_cli_commands' doesn't exist")
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: [SQL: SELECT bw_cli_commands.name AS bw_cli_commands_name, bw_cli_commands.file_name AS bw_cli_commands_file_name 
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: FROM bw_cli_commands 
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: WHERE bw_cli_commands.plugin_id = %(plugin_id_1)s]
Nov 18 23:39:48 172.16.1.1 ba333321ce29[26671]: [parameters: {'plugin_id_1': 'clamav'}]

...
Nov 18 23:40:11 172.16.1.1 ba333321ce29[26671]: [2024-11-18 22:40:11 +0000] [SCHEDULER] [21] [❌] - An error occurred when setting the changes to checked in the database : (pymysql.err.OperationalError) (1054, "Unknown column 'bw_metadata.non_draft_services' in 'field list'")
Nov 18 23:40:11 172.16.1.1 ba333321ce29[26671]: [SQL: SELECT bw_metadata.id AS bw_metadata_id, bw_metadata.is_initialized AS bw_metadata_is_initialized, bw_metadata.is_pro AS bw_metadata_is_pro, bw_metadata.pro_license AS bw_metadata_pro_license, bw_metadata.pro_expire AS bw_metadata_pro_expire, bw_metadata.pro_status AS bw_metadata_pro_status, bw_metadata.pro_services AS bw_metadata_pro_services, bw_metadata.non_draft_services AS bw_metadata_non_draft_services, bw_metadata.pro_overlapped AS bw_metadata_pro_overlapped, bw_metadata.last_pro_check AS bw_metadata_last_pro_check, bw_metadata.first_config_saved AS bw_metadata_first_config_saved, bw_metadata.autoconf_loaded AS bw_metadata_autoconf_loaded, bw_metadata.scheduler_first_start AS bw_metadata_scheduler_first_start, bw_metadata.custom_configs_changed AS bw_metadata_custom_configs_changed, bw_metadata.last_custom_configs_change AS bw_metadata_last_custom_configs_change, bw_metadata.external_plugins_changed AS bw_metadata_external_plugins_changed, bw_metadata.last_external_plugins_change AS bw_metadata_last_external_plugins_change, bw_metadata.pro_plugins_changed AS bw_metadata_pro_plugins_changed, bw_metadata.last_pro_plugins_change AS bw_metadata_last_pro_plugins_change, bw_metadata.instances_changed AS bw_metadata_instances_changed, bw_metadata.last_instances_change AS bw_metadata_last_instances_change, bw_metadata.failover AS bw_metadata_failover, bw_metadata.integration AS bw_metadata_integration, bw_metadata.version AS bw_metadata_version 
Nov 18 23:40:11 172.16.1.1 ba333321ce29[26671]: FROM bw_metadata 
Nov 18 23:40:11 172.16.1.1 ba333321ce29[26671]: WHERE bw_metadata.id = %(pk_1)s]
Nov 18 23:40:11 172.16.1.1 ba333321ce29[26671]: [parameters: {'pk_1': 1}]
Nov 18 23:40:11 172.16.1.1 ba333321ce29[26671]: (Background on this error at: https://sqlalche.me/e/20/e3q8)

BunkerWeb version

1.5.11

What integration are you using?

Docker

Linux distribution (if applicable)

No response

Removed private data

  • I have removed all private data from the configuration file and the logs

Code of Conduct

  • I agree to follow this project's Code of Conduct
@thelittlefireman thelittlefireman added the bug Something isn't working label Nov 18, 2024
@TheophileDiot
Copy link
Member

Hi @thelittlefireman, thank you for opening this issue.
I couldn't reproduce the bug, can you elaborate a bit more on the configuration you had before the upgrade, etc? Thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@thelittlefireman @TheophileDiot