Updating app-ci #2145
Unanswered
PrieserMax
asked this question in
Self-hosting question
Updating app-ci
#2145
Replies: 1 comment
-
Does no one know a solution? |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
My original version was v4.36.8
I tried directly upgrading to v4.45.1, got a server error. Now I upgraded manually through every version and get an error when upgrading from v4.38.3 to v4.39.0
Those are the container logs before updating:
`b2e0964d6f74 simplelogin/app-ci:v4.38.3 "python job_runner.py" 1 second ago Up 1 second 7777/tcp sl-job-runner
root@domainredacted:~# docker container logs b2e0964d6f74
Python-dotenv could not parse statement starting at line 185
07581eabcf6d simplelogin/app-ci:v4.38.3 "python email_handle…" 2 seconds ago Up 2 seconds 7777/tcp, 127.0.0.1:20381->20381/tcp sl-email
root@domainredacted:~# docker container logs 07581eabcf6d
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Symbol 'mailbox_or_url' is unreachable
Symbol 'url' is unreachable
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Symbol 'mailbox_or_url' is unreachable
Symbol 'mailbox' is unreachable
Symbol 'url' is unreachable
Symbol 'angle_addr' is unreachable
Symbol 'name_addr' is unreachable
Symbol 'phrase' is unreachable
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Symbol 'mailbox_or_url' is unreachable
Symbol 'mailbox' is unreachable
Symbol 'addr_spec' is unreachable
Symbol 'angle_addr' is unreachable
Symbol 'name_addr' is unreachable
Symbol 'phrase' is unreachable
Symbol 'local_part' is unreachable
Symbol 'domain' is unreachable
Symbol 'quoted_string' is unreachable
Symbol 'domain_literal' is unreachable
Symbol 'quoted_string_text' is unreachable
Symbol 'domain_literal_text' is unreachable
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Python-dotenv could not parse statement starting at line 185
a637ba67a431 simplelogin/app-ci:v4.38.3 "gunicorn wsgi:app -…" 3 seconds ago Up 3 seconds 127.0.0.1:7777->7777/tcp sl-app
root@domainredacted:~# docker container logs a637ba67a431
[2024-07-07 18:55:06 +0000] [1] [INFO] Starting gunicorn 20.0.4
[2024-07-07 18:55:06 +0000] [1] [INFO] Listening at: http://0.0.0.0:7777 (1)
[2024-07-07 18:55:06 +0000] [1] [INFO] Using worker: sync
[2024-07-07 18:55:06 +0000] [7] [INFO] Booting worker with pid: 7
[2024-07-07 18:55:06 +0000] [6] [INFO] Booting worker with pid: 6
Python-dotenv could not parse statement starting at line 185
Container logs after updating:
`c85925e5a248 simplelogin/app-ci:v4.39.0 "python job_runner.py"
root@domainreacted:~# sudo docker container logs c85925e5a248
Python-dotenv could not parse statement starting at line 185
ff86a6e4a5fa simplelogin/app-ci:v4.39.0 "python email_handle…" 4 seconds ago Up 3 seconds 7777/tcp, 127.0.0.1:20381->20381/tcp sl-email
root@domainreacted:~# sudo docker container logs ff86a6e4a5fa
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Symbol 'mailbox_or_url' is unreachable
Symbol 'url' is unreachable
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Symbol 'mailbox_or_url' is unreachable
Symbol 'mailbox' is unreachable
Symbol 'url' is unreachable
Symbol 'angle_addr' is unreachable
Symbol 'name_addr' is unreachable
Symbol 'phrase' is unreachable
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Symbol 'mailbox_or_url' is unreachable
Symbol 'mailbox' is unreachable
Symbol 'addr_spec' is unreachable
Symbol 'angle_addr' is unreachable
Symbol 'name_addr' is unreachable
Symbol 'phrase' is unreachable
Symbol 'local_part' is unreachable
Symbol 'domain' is unreachable
Symbol 'quoted_string' is unreachable
Symbol 'domain_literal' is unreachable
Symbol 'quoted_string_text' is unreachable
Symbol 'domain_literal_text' is unreachable
Symbol 'mailbox_or_url_list' is unreachable
Symbol 'delim' is unreachable
Python-dotenv could not parse statement starting at line 185
0aa20933c5b9 simplelogin/app-ci:v4.39.0 "gunicorn wsgi:app -…" 5 seconds ago Up 4 seconds 127.0.0.1:7777->7777/tcp sl-app
root@domainreacted:~# sudo docker container logs 0aa20933c5b9
[2024-07-07 18:47:20 +0000] [1] [INFO] Starting gunicorn 20.0.4
[2024-07-07 18:47:20 +0000] [1] [INFO] Listening at: http://0.0.0.0:7777 (1)
[2024-07-07 18:47:20 +0000] [1] [INFO] Using worker: sync
[2024-07-07 18:47:20 +0000] [6] [INFO] Booting worker with pid: 6
[2024-07-07 18:47:20 +0000] [7] [INFO] Booting worker with pid: 7
[SQL: SELECT count(*) AS count_1
FROM (SELECT alias.id AS alias_id, alias.created_at AS alias_created_at, alias.updated_at AS alias_updated_at, alias.user_id AS alias_user_id, alias.email AS alias_email, alias.name AS alias_name, alias.enabled AS alias_enabled, alias.custom_domain_id AS alias_custom_domain_id, alias.automatic_creation AS alias_automatic_creation, alias.directory_id AS alias_directory_id, alias.note AS alias_note, alias.mailbox_id AS alias_mailbox_id, alias.disable_pgp AS alias_disable_pgp, alias.cannot_be_disabled AS alias_cannot_be_disabled, alias.disable_email_spoofing_check AS alias_disable_email_spoofing_check, alias.batch_import_id AS alias_batch_import_id, alias.original_owner_id AS alias_original_owner_id, alias.pinned AS alias_pinned, alias.transfer_token AS alias_transfer_token, alias.transfer_token_expiration AS alias_transfer_token_expiration, alias.hibp_last_check AS alias_hibp_last_check, alias.ts_vector AS alias_ts_vector, alias.last_email_log_id AS alias_last_email_log_id
FROM alias
WHERE alias.user_id = %(user_id_1)s) AS anon_1]
[parameters: {'user_id_1': 1}]
(Background on this error at: http://sqlalche.me/e/13/f405)
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column alias.last_email_log_id does not exist
LINE 2: ...p_last_check, alias.ts_vector AS alias_ts_vector, alias.last...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.10/site-packages/flask_login/utils.py", line 272, in decorated_view
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/flask_limiter/extension.py", line 702, in __inner
return obj(*a, **k)
File "/usr/local/lib/python3.10/site-packages/flask_limiter/extension.py", line 702, in __inner
return obj(*a, **k)
File "/code/app/parallel_limiter.py", line 50, in decorated
return f(*args, **kwargs)
File "/code/app/dashboard/views/index.py", line 174, in index
stats = get_stats(current_user)
File "/code/app/dashboard/views/index.py", line 32, in get_stats
nb_alias = Alias.filter_by(user_id=user.id).count()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3803, in count
return self.from_self(col).scalar()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3523, in scalar
ret = self.one()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3490, in one
ret = self.one_or_none()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none
ret = list(self)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3535, in iter
return self._execute_and_instances(context)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self.handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1510, in handle_dbapi_exception
util.raise(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 182, in raise
raise exception
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column alias.last_email_log_id does not exist
LINE 2: ...p_last_check, alias.ts_vector AS alias_ts_vector, alias.last...
^
[SQL: SELECT count(*) AS count_1
FROM (SELECT alias.id AS alias_id, alias.created_at AS alias_created_at, alias.updated_at AS alias_updated_at, alias.user_id AS alias_user_id, alias.email AS alias_email, alias.name AS alias_name, alias.enabled AS alias_enabled, alias.custom_domain_id AS alias_custom_domain_id, alias.automatic_creation AS alias_automatic_creation, alias.directory_id AS alias_directory_id, alias.note AS alias_note, alias.mailbox_id AS alias_mailbox_id, alias.disable_pgp AS alias_disable_pgp, alias.cannot_be_disabled AS alias_cannot_be_disabled, alias.disable_email_spoofing_check AS alias_disable_email_spoofing_check, alias.batch_import_id AS alias_batch_import_id, alias.original_owner_id AS alias_original_owner_id, alias.pinned AS alias_pinned, alias.transfer_token AS alias_transfer_token, alias.transfer_token_expiration AS alias_transfer_token_expiration, alias.hibp_last_check AS alias_hibp_last_check, alias.ts_vector AS alias_ts_vector, alias.last_email_log_id AS alias_last_email_log_id
FROM alias
WHERE alias.user_id = %(user_id_1)s) AS anon_1]
[parameters: {'user_id_1': 1}]
(Background on this error at: http://sqlalche.me/e/13/f405)
2024-07-07 18:47:48,286 - SL - DEBUG - 10 - "/code/server.py:284" - after_request() - - 10.0.0.1 GET /dashboard/ ImmutableMultiDict([]) 500, takes 0.03312802314758301`
Beta Was this translation helpful? Give feedback.
All reactions