docker container dev 1.4.4-beta.25 crash on start #2592

xloooolx · 2024-07-25T23:52:01Z

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:
after start container crash

I get this error

[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:    0
User GID:    0
───────────────────────────────────────
Linuxserver.io version: v1.4.4-beta.25-ls618
Build-date: 2024-07-25T06:33:58+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
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)
Connection to localhost (127.0.0.1) 6767 port [tcp/*] succeeded!
[ls.io-init] done.

and from PostgreSQL

2024-07-25 23:34:48.848 UTC [4264] ERROR:  column table_languages_profiles.tag does not exist at character 268
2024-07-25 23:34:48.848 UTC [4264] STATEMENT:  SELECT table_languages_profiles."profileId", table_languages_profiles.cutoff, table_languages_profiles."originalFormat", table_languages_profiles.items, table_languages_profiles.name, table_languages_profiles."mustContain", table_languages_profiles."mustNotContain", table_languages_profiles.tag 
	FROM table_languages_profiles 
	WHERE table_languages_profiles."profileId" = 1

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Software (please complete the following information):

Bazarr: [1.4.4-beta.25]
Radarr version [ 5.9.0.8962]
Sonarr version [4.0.8.1929]
OS: [docker]

Additional context
Add any other context about the problem here.

The text was updated successfully, but these errors were encountered:

bakerboy448 · 2024-07-27T11:14:34Z

PG version?

bakerboy448 · 2024-07-27T11:16:19Z

Additional logs from this missing tags column - but different bazarr error - running pg16

https://gist.github.com/bakerboy448/cabc5fcdb1be576d35aecc4f41ec5e6b

@xloooolx - possible postgresql to run to fix to add the column and get moving; worked for me: https://gist.github.com/bakerboy448/f3023d9a9d854ba55db68da1c2606b3d

anderson-oki · 2024-08-01T08:11:52Z

it seems flask migrations are running but none are being applied when i tested with pg14, pg15 and pg16. I'm not sure what is the issue yet.

@xloooolx @bakerboy448 Can you check the table alembic_versions and see what is the content?

bakerboy448 · 2024-08-01T14:29:56Z

452dd0f0b578
"452dd0f0b578"

xloooolx · 2024-08-02T02:08:18Z

PG version?

14

Additional logs from this missing tags column - but different bazarr error - running pg16

https://gist.github.com/bakerboy448/cabc5fcdb1be576d35aecc4f41ec5e6b

@xloooolx - possible postgresql to run to fix to add the column and get moving; worked for me: https://gist.github.com/bakerboy448/f3023d9a9d854ba55db68da1c2606b3d

I added the column, and it works like a charm, thank you.

it seems flask migrations are running but none are being applied when i tested with pg14, pg15 and pg16. I'm not sure what is the issue yet.

@xloooolx @bakerboy448 Can you check the table alembic_versions and see what is the content?

452dd0f0b578

dracossan · 2024-08-03T02:59:32Z

Hi , same issue:
linuxserver/docker-bazarr#139

I simply delete database for now and restart from scratch for temporary fixe.

But now getting this new one:

`[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(
2024-08-03 10:46:15,734 - root (7fe0cb44eb38) : INFO (signalr_client:122) - BAZARR trying to connect to Sonarr SignalR feed...
2024-08-03 10:46:15,737 - root (7fe0cb23cb38) : INFO (signalr_client:189) - BAZARR trying to connect to Radarr SignalR feed...
2024-08-03 10:46:15,737 - root (7fe0f4a1db28) : INFO (server:79) - BAZARR is started and waiting for request on http://0.0.0.0:6767
2024-08-03 10:46:15,750 - root (7fe0caf29b38) : INFO (signalr_client:217) - BAZARR SignalR client for Radarr is connected and waiting for events.
2024-08-03 10:46:15,754 - root (7fe0cb23cb38) : INFO (signalr_client:150) - BAZARR SignalR client for Sonarr is connected and waiting for events.`

anderson-oki · 2024-08-04T12:32:07Z

It will be fixed on the upcoming beta.

anderson-oki added the investigating label Aug 1, 2024

anderson-oki mentioned this issue Aug 3, 2024

Fixed postgresql migrations not applied #2601

Merged

dracossan mentioned this issue Aug 3, 2024

[BUG] Bazarr crash on start sqlalchemy issue linuxserver/docker-bazarr#139

Closed

1 task

anderson-oki closed this as completed Aug 4, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

docker container dev 1.4.4-beta.25 crash on start #2592

docker container dev 1.4.4-beta.25 crash on start #2592

xloooolx commented Jul 25, 2024

bakerboy448 commented Jul 27, 2024

bakerboy448 commented Jul 27, 2024

anderson-oki commented Aug 1, 2024 •

edited

Loading

bakerboy448 commented Aug 1, 2024 •

edited

Loading

xloooolx commented Aug 2, 2024

dracossan commented Aug 3, 2024 •

edited

Loading

anderson-oki commented Aug 4, 2024

docker container dev 1.4.4-beta.25 crash on start #2592

docker container dev 1.4.4-beta.25 crash on start #2592

Comments

xloooolx commented Jul 25, 2024

bakerboy448 commented Jul 27, 2024

bakerboy448 commented Jul 27, 2024

anderson-oki commented Aug 1, 2024 • edited Loading

bakerboy448 commented Aug 1, 2024 • edited Loading

xloooolx commented Aug 2, 2024

dracossan commented Aug 3, 2024 • edited Loading

anderson-oki commented Aug 4, 2024

anderson-oki commented Aug 1, 2024 •

edited

Loading

bakerboy448 commented Aug 1, 2024 •

edited

Loading

dracossan commented Aug 3, 2024 •

edited

Loading