TARGET_PACKAGE_SHA256=cc1275e250c300fb5c16516dbebeee56cbdf51ada3a0558eaf45e7f5ec5bd6f1 >>> [vm121-source] precheck MODE=--check REPOSITORY_URL=https://github.com/DChuvelev/wg-paid-vm121.git REPO_DIR=/opt/router-ops/state/source-repositories/wg-paid-vm121 >>> [vm121-source] run VM121 git publisher through approved direct SSH >>> [vm121-git] precheck MODE=--check PROFILE=/etc/router-machine-git-source.conf PROFILE_VERSION=2 PROFILE_SHA256=7af60e3d7de8335842addc60ced35672f821fb173eaccb59a830d8aba0c606da MACHINE_ID=vm121 GIT_DIR=/root/.vm121-source.git WORK_TREE=/ BRANCH=main REMOTE_URL=git@github.com:DChuvelev/wg-paid-vm121.git LOCAL_HEAD=20dcf7ae13343c29dac49cdffb4110fc9befa6ab >>> [vm121-git] verify remote branch REMOTE_HEAD=20dcf7ae13343c29dac49cdffb4110fc9befa6ab >>> [vm121-git] build current project allowlist >>> [vm121-git] read paths already tracked by git CURRENT_ALLOWED_COUNT=65 TRACKED_COUNT=65 MANAGED_UNION_COUNT=65 >>> [vm121-git] strict path validation STRICT_PATH_VALIDATION=true >>> [vm121-git] show tracked files now missing from machine TRACKED_PATH_MISSING_COUNT=0 >>> [vm121-git] build simulated git index STAGED_CHANGE_COUNT=0 STAGED_PATHS=NONE >>> [vm121-git] validate simulated staged paths STAGED_PATH_VALIDATION=true SIMULATED_TREE_SHA=dc62e503da0ba279caefd8eecc9a90ebc06470bd SIMULATED_TREE_FILE_COUNT=65 >>> [vm121-git] high-confidence secret scan of simulated tree HIGH_CONFIDENCE_SECRET_MATCHES=0 >>> [vm121-git] keyword review scan KEYWORD_REVIEW_FILES=NONE RESULT=PASS_VM121_GIT_PUBLISH_CHECK MACHINE_ID=vm121 GIT_COMMIT=20dcf7ae13343c29dac49cdffb4110fc9befa6ab GIT_TREE=dc62e503da0ba279caefd8eecc9a90ebc06470bd GIT_FILE_COUNT=65 COMMIT_CREATED=false PUSH_PERFORMED=false VM121_RESULT=PASS_VM121_GIT_PUBLISH_CHECK VM121_COMMIT=20dcf7ae13343c29dac49cdffb4110fc9befa6ab VM121_REMOTE_COMMIT=20dcf7ae13343c29dac49cdffb4110fc9befa6ab >>> [vm121-source] clone or refresh repository on VM130 CURRENT_ORIGIN=https://github.com/DChuvelev/wg-paid-vm121.git From https://github.com/DChuvelev/wg-paid-vm121 * branch main -> FETCH_HEAD Reset branch 'main' branch 'main' set up to track 'origin/main'. Your branch is up to date with 'origin/main'. HEAD is now at 20dcf7a vm121: publish managed source 2026-09-16T07:59:04Z VM130_COMMIT=20dcf7ae13343c29dac49cdffb4110fc9befa6ab VM130_TREE=dc62e503da0ba279caefd8eecc9a90ebc06470bd VM130_FILE_COUNT=65 VM130_STATUS=CLEAN >>> [vm121-source] verify required managed paths REQUIRED_PATH_OK=etc/router-machine-git-source.conf REQUIRED_PATH_OK=usr/local/sbin/router-machine-git-publish.sh REQUIRED_PATH_OK=usr/local/sbin/router-vm121-git-publish.sh RESULT=PASS_VM130_VM121_GIT_SOURCE_CHECK VM121_COMMIT=20dcf7ae13343c29dac49cdffb4110fc9befa6ab VM130_COMMIT=20dcf7ae13343c29dac49cdffb4110fc9befa6ab VM130_TREE=dc62e503da0ba279caefd8eecc9a90ebc06470bd VM130_FILE_COUNT=65 VM121_PUSH_PERFORMED=false ARCHIVE_CREATED=false PERMANENT_HTTPS_PUBLISHED=false INFO [alembic.runtime.migration] Context impl PostgresqlImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. CHECK=WG_ACCESS_AGENT_MANUAL_START_PREREQUISITE_BEGIN WG_ACCESS_AGENT_SERVICE_LOAD_STATE=loaded CHECK=WG_ACCESS_AGENT_MANUAL_START_PREREQUISITE_PASS Traceback (most recent call last): File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.12/site-packages/psycopg/cursor.py", line 117, in execute raise ex.with_traceback(None) psycopg.errors.InvalidColumnReference: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 17: ORDER BY refs.user_id::text ^ The above exception was the direct cause of the following exception: Traceback (most recent call last): File "", line 380, in File "", line 358, in main File "", line 176, in mode_inventory File "", line 89, in assert_known_baseline File "", line 69, in baseline_counts File "", line 46, in orphan_user_ids File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2373, in execute return self._execute_internal( ^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2280, in _execute_internal result = conn.execute( ^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1421, in execute return meth( ^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1643, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2365, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.12/site-packages/psycopg/cursor.py", line 117, in execute raise ex.with_traceback(None) sqlalchemy.exc.ProgrammingError: (psycopg.errors.InvalidColumnReference) for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 17: ORDER BY refs.user_id::text ^ [SQL: WITH refs(user_id) AS ( SELECT user_id FROM access_grants UNION SELECT user_id FROM connection_slots UNION SELECT user_id FROM connection_profiles UNION SELECT user_id FROM peers UNION SELECT user_id FROM orders UNION SELECT user_id FROM subscriptions UNION SELECT user_id FROM invite_redemptions UNION SELECT user_id FROM magic_link_tokens WHERE user_id IS NOT NULL UNION SELECT user_id FROM auth_sessions ) SELECT DISTINCT refs.user_id FROM refs LEFT JOIN users u ON u.id = refs.user_id WHERE refs.user_id IS NOT NULL AND u.id IS NULL ORDER BY refs.user_id::text ] (Background on this error at: https://sqlalche.me/e/20/f405)