cris
cris•7mo ago

Can't start zitadel >= 2.66.0 with cockroach 23.2.0

With a simple docker compose configuration Zitadel fails to start with this error Error: unknown function: eventstore.commands_to_events() (SQLSTATE 42883)
1 Reply
cris
crisOP•7mo ago
To reproduce try use this docker compose file 
version: '3.6'
services:
  database:
    image: cockroachdb/cockroach:v23.2.0
    container_name: 'asset-api-cockroach-testing'
    command: 'start-single-node --insecure'
    tmpfs: /cockroach/cockroach-data
    ports:
      - '26257:26257'

  zitadel:
    image: ghcr.io/zitadel/zitadel:v2.66.0
    command: 'start-from-init --masterkey "Qxzla55HoVcuSny4dctMmtpCxpTeATLD" --tlsMode disabled'
    user: root
    volumes:
      - ./resources/auth:/machinekey
    environment:
      - ZITADEL_EXTERNALPORT=8081
      - ZITADEL_LOG_LEVEL=debug
      - ZITADEL_DATABASE_COCKROACH_HOST=database
      - ZITADEL_DATABASE_COCKROACH_DATABASE=zitadel
      - ZITADEL_EXTERNALSECURE=false
    container_name: 'asset-api-zitadel-testing'
    ports:
      - '8081:8080'
version: '3.6'
services:
  database:
    image: cockroachdb/cockroach:v23.2.0
    container_name: 'asset-api-cockroach-testing'
    command: 'start-single-node --insecure'
    tmpfs: /cockroach/cockroach-data
    ports:
      - '26257:26257'

  zitadel:
    image: ghcr.io/zitadel/zitadel:v2.66.0
    command: 'start-from-init --masterkey "Qxzla55HoVcuSny4dctMmtpCxpTeATLD" --tlsMode disabled'
    user: root
    volumes:
      - ./resources/auth:/machinekey
    environment:
      - ZITADEL_EXTERNALPORT=8081
      - ZITADEL_LOG_LEVEL=debug
      - ZITADEL_DATABASE_COCKROACH_HOST=database
      - ZITADEL_DATABASE_COCKROACH_DATABASE=zitadel
      - ZITADEL_EXTERNALSECURE=false
    container_name: 'asset-api-zitadel-testing'
    ports:
      - '8081:8080'
this should be the output: Zitadel fails to start. This is the log: 
time="2025-02-13T17:28:07Z" level=info msg="initialization started" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:75"
time="2025-02-13T17:28:07Z" level=debug msg="failed to get oid for command type" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/v3/eventstore.go:118" error="no rows in result set"
time="2025-02-13T17:28:07Z" level=info msg="verify user" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_user.go:40" username=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify database" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_database.go:40" database=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify grant" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_grant.go:35" database=zitadel user=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify settings" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_settings.go:41" database=zitadel user=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify zitadel" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:86" database=zitadel
time="2025-02-13T17:28:07Z" level=debug msg="failed to get oid for command type" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/v3/eventstore.go:118" error="no rows in result set"
time="2025-02-13T17:28:07Z" level=info msg="verify system" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:47"
time="2025-02-13T17:28:07Z" level=info msg="initialization started" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:75"
time="2025-02-13T17:28:07Z" level=debug msg="failed to get oid for command type" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/v3/eventstore.go:118" error="no rows in result set"
time="2025-02-13T17:28:07Z" level=info msg="verify user" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_user.go:40" username=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify database" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_database.go:40" database=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify grant" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_grant.go:35" database=zitadel user=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify settings" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_settings.go:41" database=zitadel user=zitadel
time="2025-02-13T17:28:07Z" level=info msg="verify zitadel" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:86" database=zitadel
time="2025-02-13T17:28:07Z" level=debug msg="failed to get oid for command type" caller="/home/runner/work/zitadel/zitadel/internal/eventstore/v3/eventstore.go:118" error="no rows in result set"
time="2025-02-13T17:28:07Z" level=info msg="verify system" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:47"
time="2025-02-13T17:28:07Z" level=info msg="verify encryption keys" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:52"
time="2025-02-13T17:28:07Z" level=info msg="verify projections" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:57"
time="2025-02-13T17:28:07Z" level=info msg="verify eventstore" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:62"
time="2025-02-13T17:28:07Z" level=info msg="verify events tables" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:67"
time="2025-02-13T17:28:07Z" level=fatal msg="unable to initialize ZITADEL" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:71" error="ERROR: unknown function: eventstore.commands_to_events() (SQLSTATE 42883)"
time="2025-02-13T17:28:07Z" level=info msg="verify encryption keys" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:52"
time="2025-02-13T17:28:07Z" level=info msg="verify projections" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:57"
time="2025-02-13T17:28:07Z" level=info msg="verify eventstore" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:62"
time="2025-02-13T17:28:07Z" level=info msg="verify events tables" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:67"
time="2025-02-13T17:28:07Z" level=fatal msg="unable to initialize ZITADEL" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:71" error="ERROR: unknown function: eventstore.commands_to_events() (SQLSTATE 42883)"

Did you find this page helpful?