Not able to start container after update anymore - sqlite no such column: users.default_vehicle_id

[pbuzdygan]

Container is not starting. In logs there is direct info what happened:

Logs:

2026-04-20 05:54:13 (Background on this error at: https://sqlalche.me/e/20/e3q8)
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [21] [INFO] Worker exiting (pid: 21)
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [22] [ERROR] Exception in worker process
2026-04-20 05:54:13 Traceback (most recent call last):
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
2026-04-20 05:54:13 self.dialect.do_execute(
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
2026-04-20 05:54:13 cursor.execute(statement, parameters)
2026-04-20 05:54:13 sqlite3.OperationalError: no such column: users.default_vehicle_id
2026-04-20 05:54:13
2026-04-20 05:54:13 The above exception was the direct cause of the following exception:
2026-04-20 05:54:13
2026-04-20 05:54:13 Traceback (most recent call last):
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/arbiter.py", line 713, in spawn_worker
2026-04-20 05:54:13 worker.init_process()
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/workers/gthread.py", line 240, in init_process
2026-04-20 05:54:13 super().init_process()
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/workers/base.py", line 136, in init_process
2026-04-20 05:54:13 self.load_wsgi()
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/workers/base.py", line 148, in load_wsgi
2026-04-20 05:54:13 self.wsgi = self.app.wsgi()
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/app/base.py", line 66, in wsgi
2026-04-20 05:54:13 self.callable = self.load()
2026-04-20 05:54:13 ^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/app/wsgiapp.py", line 57, in load
2026-04-20 05:54:13 return self.load_wsgiapp()
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/app/wsgiapp.py", line 47, in load_wsgiapp
2026-04-20 05:54:13 return util.import_app(self.app_uri)
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/gunicorn/util.py", line 377, in import_app
2026-04-20 05:54:13 mod = importlib.import_module(module)
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/importlib/init.py", line 90, in import_module
2026-04-20 05:54:13 return _bootstrap._gcd_import(name[level:], package, level)
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "", line 1387, in _gcd_import
2026-04-20 05:54:13 File "", line 1360, in _find_and_load
2026-04-20 05:54:13 File "", line 1331, in _find_and_load_unlocked
2026-04-20 05:54:13 File "", line 935, in _load_unlocked
2026-04-20 05:54:13 File "", line 999, in exec_module
2026-04-20 05:54:13 File "", line 488, in _call_with_frames_removed
2026-04-20 05:54:13 File "/app/run.py", line 4, in
2026-04-20 05:54:13 app = create_app()
2026-04-20 05:54:13 ^^^^^^^^^^^^
2026-04-20 05:54:13 File "/app/app/init.py", line 254, in create_app
2026-04-20 05:54:13 if User.query.count() == 0:
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/query.py", line 3153, in count
2026-04-20 05:54:13 self._legacy_from_self(col).enable_eagerloads(False).scalar()
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/query.py", line 2842, in scalar
2026-04-20 05:54:13 ret = self.one()
2026-04-20 05:54:13 ^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/query.py", line 2815, in one
2026-04-20 05:54:13 return self._iter().one() # type: ignore
2026-04-20 05:54:13 ^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/query.py", line 2864, in _iter
2026-04-20 05:54:13 result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2351, in execute
2026-04-20 05:54:13 return self._execute_internal(
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal
2026-04-20 05:54:13 result: Result[Any] = compile_state_cls.orm_execute_statement(
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement
2026-04-20 05:54:13 result = conn.execute(
2026-04-20 05:54:13 ^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
2026-04-20 05:54:13 return meth(
2026-04-20 05:54:13 ^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection
2026-04-20 05:54:13 return connection._execute_clauseelement(
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
2026-04-20 05:54:13 ret = self._execute_context(
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
2026-04-20 05:54:13 return self._exec_single_context(
2026-04-20 05:54:13 ^^^^^^^^^^^^^^^^^^^^^^^^^^
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
2026-04-20 05:54:13 self._handle_dbapi_exception(
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception
2026-04-20 05:54:13 raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
2026-04-20 05:54:13 self.dialect.do_execute(
2026-04-20 05:54:13 File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
2026-04-20 05:54:13 cursor.execute(statement, parameters)
2026-04-20 05:54:13 sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: users.default_vehicle_id
2026-04-20 05:54:13 [SQL: SELECT count() AS count_1
2026-04-20 05:54:13 FROM (SELECT users.id AS users_id, users.username AS users_username, users.email AS users_email, users.password_hash AS users_password_hash, users.is_admin AS users_is_admin, users.created_at AS users_created_at, users.language AS users_language, users.distance_unit AS users_distance_unit, users.volume_unit AS users_volume_unit, users.consumption_unit AS users_consumption_unit, users.currency AS users_currency, users.dark_mode AS users_dark_mode, users.date_format AS users_date_format, users.email_reminders AS users_email_reminders, users.reminder_days_before AS users_reminder_days_before, users.notification_method AS users_notification_method, users.webhook_url AS users_webhook_url, users.ntfy_topic AS users_ntfy_topic, users.pushover_user_key AS users_pushover_user_key, users.password_reset_token AS users_password_reset_token, users.password_reset_expires AS users_password_reset_expires, users.api_key AS users_api_key, users.api_key_created_at AS users_api_key_created_at, users.start_page AS users_start_page, users.default_vehicle_id AS users_default_vehicle_id, users.show_menu_vehicles AS users_show_menu_vehicles, users.show_menu_fuel AS users_show_menu_fuel, users.show_menu_expenses AS users_show_menu_expenses, users.show_menu_reminders AS users_show_menu_reminders, users.show_menu_maintenance AS users_show_menu_maintenance, users.show_menu_recurring AS users_show_menu_recurring, users.show_menu_documents AS users_show_menu_documents, users.show_menu_stations AS users_show_menu_stations, users.show_menu_trips AS users_show_menu_trips, users.show_menu_charging AS users_show_menu_charging, users.show_quick_entry AS users_show_quick_entry
2026-04-20 05:54:13 FROM users) AS anon_1]
2026-04-20 05:54:13 (Background on this error at: https://sqlalche.me/e/20/e3q8)
2026-04-20 05:54:13 (sqlite3.OperationalError) no such column: users.default_vehicle_id
2026-04-20 05:54:13 [SQL: SELECT count() AS count_1
2026-04-20 05:54:13 FROM (SELECT users.id AS users_id, users.username AS users_username, users.email AS users_email, users.password_hash AS users_password_hash, users.is_admin AS users_is_admin, users.created_at AS users_created_at, users.language AS users_language, users.distance_unit AS users_distance_unit, users.volume_unit AS users_volume_unit, users.consumption_unit AS users_consumption_unit, users.currency AS users_currency, users.dark_mode AS users_dark_mode, users.date_format AS users_date_format, users.email_reminders AS users_email_reminders, users.reminder_days_before AS users_reminder_days_before, users.notification_method AS users_notification_method, users.webhook_url AS users_webhook_url, users.ntfy_topic AS users_ntfy_topic, users.pushover_user_key AS users_pushover_user_key, users.password_reset_token AS users_password_reset_token, users.password_reset_expires AS users_password_reset_expires, users.api_key AS users_api_key, users.api_key_created_at AS users_api_key_created_at, users.start_page AS users_start_page, users.default_vehicle_id AS users_default_vehicle_id, users.show_menu_vehicles AS users_show_menu_vehicles, users.show_menu_fuel AS users_show_menu_fuel, users.show_menu_expenses AS users_show_menu_expenses, users.show_menu_reminders AS users_show_menu_reminders, users.show_menu_maintenance AS users_show_menu_maintenance, users.show_menu_recurring AS users_show_menu_recurring, users.show_menu_documents AS users_show_menu_documents, users.show_menu_stations AS users_show_menu_stations, users.show_menu_trips AS users_show_menu_trips, users.show_menu_charging AS users_show_menu_charging, users.show_quick_entry AS users_show_quick_entry
2026-04-20 05:54:13 FROM users) AS anon_1]
2026-04-20 05:54:13 (Background on this error at: https://sqlalche.me/e/20/e3q8)
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [22] [INFO] Worker exiting (pid: 22)
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [1] [ERROR] Worker (pid:21) exited with code 3.
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [1] [INFO] Worker (pid:22) was sent SIGTERM!
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [1] [ERROR] Shutting down: Master
2026-04-20 05:54:13 [2026-04-20 03:54:13 +0000] [1] [ERROR] Reason: Worker failed to boot.

[burgatshow]

Duplicate of #132

[dannymcc]

Fixed in v0.18.1 — same root cause as #132.

Databases created before Flask-Migrate was introduced had an empty alembic_version table, which caused flask db upgrade to replay migrations from scratch and fail on a duplicate odometer_unit column. The migration that adds users.default_vehicle_id therefore never ran, producing the no such column: users.default_vehicle_id error you reported.

v0.18.1 makes the existing migrations idempotent, adds an alembic bootstrap step that stamps the correct revision for pre-migration databases, and keeps a manual safety-net that adds default_vehicle_id if alembic state can't be recovered. No manual steps required — pulling ghcr.io/dannymcc/may:v0.18.1 (or :latest) should get your container booting again. Closing — please reopen if it doesn't resolve things on your side.