[BUG] Bazarr crash on start sqlalchemy issue #139
Comments
|
Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid. |
|
same issue: |
|
This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions. |
|
This issue is locked due to inactivity |
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Is there an existing issue for this?
Current Behavior
On the past maybe 2 or 3 latest upgrade, bazarr crash on start using postgresql backend.
System before upgrade was working fine.
Expected Behavior
dont crash
Steps To Reproduce
latest fedora server 40 os with docker swarm installed, latest dnf update
postgress14 on docker installed
configure bazarr with postgress back end.
Environment
CPU architecture
x86-64
Docker creation
Container logs
[migrations] started [migrations] no migrations found ─────────────────────────────────────── ██╗ ███████╗██╗ ██████╗ ██║ ██╔════╝██║██╔═══██╗ ██║ ███████╗██║██║ ██║ ██║ ╚════██║██║██║ ██║ ███████╗███████║██║╚██████╔╝ ╚══════╝╚══════╝╚═╝ ╚═════╝ Brought to you by linuxserver.io ─────────────────────────────────────── To support the app dev(s) visit: Bazarr: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=XHHRWXT9YB7WE&source=url To support LSIO projects visit: https://www.linuxserver.io/donate/ ─────────────────────────────────────── GID/UID ─────────────────────────────────────── User UID: 3000 User GID: 3000 ─────────────────────────────────────── Linuxserver.io version: v1.4.4-beta.27-ls619 Build-date: 2024-07-30T21:24:17+00:00 ─────────────────────────────────────── [custom-init] No custom files found, skipping... /app/bazarr/bin/bazarr/../custom_libs/subzero/language.py:165: SyntaxWarning: invalid escape sequence '\.' IETF_MATCH = ".+\.([^-.]+)(?:-[A-Za-z]+)?$" /app/bazarr/bin/bazarr/../custom_libs/subzero/language.py:166: SyntaxWarning: invalid escape sequence '\.' ENDSWITH_LANGUAGECODE_RE = re.compile("\.([^-.]{2,3})(?:-[A-Za-z]{2,})?$") /app/bazarr/bin/bazarr/../custom_libs/subzero/language.py:170: SyntaxWarning: invalid escape sequence '\.' language_match = re.match(".+\.([^\.]+)$" if not ietf Connection to localhost (127.0.0.1) 6767 port [tcp/*] succeeded! [ls.io-init] done. /app/bazarr/bin/bazarr/../libs/alembic/ddl/postgresql.py:187: UserWarning: autoincrement and existing_autoincrement only make sense for MySQL super().alter_column( Traceback (most recent call last): File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 1960, in _exec_single_context self.dialect.do_execute( File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/default.py", line 924, in do_execute cursor.execute(statement, parameters) psycopg2.errors.UndefinedColumn: column table_languages_profiles.tag does not exist LINE 1: ...tain", table_languages_profiles."originalFormat", table_lang... ^ The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/bazarr/bin/bazarr/main.py", line 52, in <module> upgrade_languages_profile_hi_values() File "/app/bazarr/bin/bazarr/app/database.py", line 508, in upgrade_languages_profile_hi_values for languages_profile in (database.execute( ^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/orm/scoping.py", line 778, in execute return self._proxied.execute( ^^^^^^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/orm/session.py", line 2306, in execute return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/orm/session.py", line 2191, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/orm/context.py", line 293, in orm_execute_statement result = conn.execute( ^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 1408, in execute return meth( ^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/sql/elements.py", line 513, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 1630, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 1839, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 1979, in _exec_single_context self._handle_dbapi_exception( File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 2335, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/base.py", line 1960, in _exec_single_context self.dialect.do_execute( File "/app/bazarr/bin/bazarr/../libs/sqlalchemy/engine/default.py", line 924, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column table_languages_profiles.tag does not exist LINE 1: ...tain", table_languages_profiles."originalFormat", table_lang... ^ [SQL: SELECT table_languages_profiles."profileId", table_languages_profiles.name, table_languages_profiles.cutoff, table_languages_profiles.items, table_languages_profiles."mustContain", table_languages_profiles."mustNotContain", table_languages_profiles."originalFormat", table_languages_profiles.tag FROM table_languages_profiles] (Background on this error at: https://sqlalche.me/e/20/f405)The text was updated successfully, but these errors were encountered: