Closed HungryHowies closed 2 months ago
New version 2.59 and new instance. I have received the same errors.
root@zitadel007:/usr/local/bin# zitadel init --config /usr/local/bin/defaults-new.yaml INFO[0000] initialization started caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:75" INFO[0000] verify user caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_user.go:39" username=zitadel INFO[0000] verify database caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_database.go:39" database=zitadel INFO[0000] verify grant caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_grant.go:34" database=zitadel user=zitadel INFO[0000] verify zitadel caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:78" database=zitadel INFO[0000] verify system caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:39" INFO[0000] verify encryption keys caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:44" INFO[0000] verify projections caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:49" INFO[0000] verify eventstore caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:54" INFO[0000] verify events tables caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:59" INFO[0000] verify system sequence caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:64" INFO[0000] verify unique constraints caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:69" root@zitadel007:/usr/local/bin# zitadel setup --for-mirror --config /usr/local/bin/defaults-new.yaml --masterkey "MasterkeyNeedsToHave32Characters" --tlsMode external INFO[0000] setup started caller="/home/runner/work/zitadel/zitadel/cmd/setup/setup.go:99" INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=14_events_push INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=14_events_push INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=01_tables INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=01_tables INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=02_assets INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=02_assets INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=28_add_search_table INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=28_add_search_table INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=31_add_aggregate_index_to_fields INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=31_add_aggregate_index_to_fields INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=03_default_instance INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=03_default_instance INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=05_last_failed INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=05_last_failed INFO[0000] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=06_resource_owner_columns INFO[0000] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=06_resource_owner_columns INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=07_logstore INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=07_logstore INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=08_auth_token_indexes INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=08_auth_token_indexes INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=12_auth_users_otp_columns INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=12_auth_users_otp_columns INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=13_fix_quota_constraints INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=13_fix_quota_constraints INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=15_current_projection_state INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=01_new_failed_events.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=02_fe_from_projections.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=03_fe_from_adminapi.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=04_fe_from_auth.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=05_current_states.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=06_cs_from_projections.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=07_cs_from_adminapi.sql migration=15_current_projection_state INFO[0001] execute statement caller="/home/runner/work/zitadel/zitadel/cmd/setup/15.go:34" file=08_cs_from_auth.sql migration=15_current_projection_state INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=16_unique_constraint_lower INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=16_unique_constraint_lower INFO[0001] unique constraints updated caller="/home/runner/work/zitadel/zitadel/cmd/setup/16.go:28" count=0 INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=17_add_offset_col_to_current_states INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=17_add_offset_col_to_current_states INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=19_add_current_sequences_index INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=19_add_current_sequences_index INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=20_add_by_user_index_on_session INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=20_add_by_user_index_on_session INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=22_active_instance_events_index INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=22_active_instance_events_index INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=23_correct_global_unique_constraints INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=23_correct_global_unique_constraints INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=24_add_actor_col_to_auth_tokens INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=24_add_actor_col_to_auth_tokens INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=26_auth_users3 INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=26_auth_users3 INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=29_init_fields_for_project_grant INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=29_init_fields_for_project_grant INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=30_fill_fields_for_org_domain_verified INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=30_fill_fields_for_org_domain_verified INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=config_change INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=config_change INFO[0001] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=projection_tables INFO[0001] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=projection_tables INFO[0002] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=18_add_lower_fields_to_login_names INFO[0002] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=18_add_lower_fields_to_login_names INFO[0002] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=21_add_block_field_to_limits INFO[0002] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=21_add_block_field_to_limits INFO[0002] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=25_user13_add_lower_fields_to_verified_email INFO[0002] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=25_user13_add_lower_fields_to_verified_email INFO[0002] verify migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:43" name=26_idp_templates6_add_saml_name_id_format INFO[0002] starting migration caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:66" name=26_idp_templates6_add_saml_name_id_format root@zitadel007:/usr/local/bin# zitadel mirror --system --replace --config /usr/local/bin/config.yaml --masterkey "MasterkeyNeedsToHave32Characters" --tlsMode external INFO[0000] assets migrated caller="/home/runner/work/zitadel/zitadel/cmd/mirror/system.go:92" count=1 took=7.542882ms INFO[0000] encryption keys migrated caller="/home/runner/work/zitadel/zitadel/cmd/mirror/system.go:138" count=10 took=9.448775ms INFO[0000] auth requests migrated caller="/home/runner/work/zitadel/zitadel/cmd/mirror/auth.go:90" count=0 took=3.599704ms INFO[0000] start event migration caller="/home/runner/work/zitadel/zitadel/cmd/mirror/event_store.go:97" from=0 to=1.7241951146522135e+18 INFO[0000] events migrated caller="/home/runner/work/zitadel/zitadel/cmd/mirror/event_store.go:180" count=134 took=50.66129ms INFO[0000] unique constraints migrated caller="/home/runner/work/zitadel/zitadel/cmd/mirror/event_store.go:249" count=20 took=4.713636ms INFO[0000] start projections caller="/home/runner/work/zitadel/zitadel/cmd/mirror/projections.go:255" instance=281350385145218244 WARN[0001] missing translation args="map[ChangeDate:2024-08-20 17:44:59.075266 -0500 CDT CreationDate:2024-08-20 17:44:59.075266 -0500 CDT DisplayName:ZITADEL Admin FirstName:ZITADEL LastEmail:zitadel-admin@zitadel.zitadel007.hungry-howard.com LastName:Admin LastPhone: LoginNames:[zitadel-admin@zitadel.zitadel007.hungry-howard.com] NickName: PreferredLoginName:zitadel-admin@zitadel.zitadel007.hungry-howard.com UserName:zitadel-admin@zitadel.zitadel007.hungry-howard.com VerifiedEmail:zitadel-admin@zitadel.zitadel007.hungry-howard.com VerifiedPhone:]" caller="/home/runner/work/zitadel/zitadel/internal/i18n/translator.go:161" error="message \"PasswordChange.Footer\" not found in language \"en\"" id=PasswordChange.Footer ERRO[0001] statement execution failed caller="/home/runner/work/zitadel/zitadel/internal/eventstore/handler/v2/handler.go:626" error="ID=QUERY-fwofw Message=Errors.SMTPConfig.NotFound Parent=(sql: no rows in result set)" projection=projections.notifications INFO[0001] projections done caller="/home/runner/work/zitadel/zitadel/cmd/mirror/projections.go:285" instance=281350385145218244 INFO[0001] projections executed caller="/home/runner/work/zitadel/zitadel/cmd/mirror/projections.go:250" took=395.534208ms INFO[0001] unequal count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:55" dest=0 diff=-5 source=5 table=eventstore.fields INFO[0001] unequal count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:55" dest=0 diff=-1 source=1 table=projections.locks INFO[0001] unequal count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:55" dest=65 diff=-2 source=67 table=projections.current_states ERRO[0001] unexpected query error caller="/home/runner/work/zitadel/zitadel/internal/database/database.go:88" error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" ERRO[0001] unable to count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:108" db=zitadel error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" table=projections.instances ERRO[0001] unexpected query error caller="/home/runner/work/zitadel/zitadel/internal/database/database.go:88" error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" ERRO[0001] unable to count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:108" db=zitadel error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" table=projections.instances ERRO[0001] unexpected query error caller="/home/runner/work/zitadel/zitadel/internal/database/database.go:88" error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" ERRO[0001] unable to count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:108" db=zitadel error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" table=projections.system_features ERRO[0001] unexpected query error caller="/home/runner/work/zitadel/zitadel/internal/database/database.go:88" error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" ERRO[0001] unable to count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:108" db=zitadel error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" table=projections.system_features ERRO[0001] unexpected query error caller="/home/runner/work/zitadel/zitadel/internal/database/database.go:88" error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" ERRO[0001] unable to count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:108" db=zitadel error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" table=system.encryption_keys ERRO[0001] unexpected query error caller="/home/runner/work/zitadel/zitadel/internal/database/database.go:88" error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" ERRO[0001] unable to count caller="/home/runner/work/zitadel/zitadel/cmd/mirror/verify.go:108" db=zitadel error="ERROR: column \"instance_id\" does not exist (SQLSTATE 42703)" table=system.encryption_keys
New version 2.59 and new instance. I have received the same errors.