Ramsai•8mo ago

Build error while migration

Hi team , I am using M1 processor and I am facing bulid errors while migration. I am facing different migration errors for different versions. The build is working fine for intel processors in MacBook , would there be any different configuration for different processors? The zitadel config we are using is:

  zitadel:
    restart: "always"
    image: "ghcr.io/zitadel/zitadel:v2.58.0"
    command: "start-from-init --config /config.yaml --config /secrets.yaml --steps /init-steps.yaml --masterkey h9tyO3xu9Qr5ygDhkMgc44x0j3tWHjPL --tlsMode disabled"
    ports:
      - "4455:4455"
    volumes:
      - "./zitadel/config.yaml:/config.yaml:ro"
      - "./zitadel/secrets.yaml:/secrets.yaml:ro"
      - "./zitadel/init-steps.yaml:/init-steps.yaml:ro"
    depends_on:
      - postgres
    networks:
      - xxxxx

  zitadel:
    restart: "always"
    image: "ghcr.io/zitadel/zitadel:v2.58.0"
    command: "start-from-init --config /config.yaml --config /secrets.yaml --steps /init-steps.yaml --masterkey h9tyO3xu9Qr5ygDhkMgc44x0j3tWHjPL --tlsMode disabled"
    ports:
      - "4455:4455"
    volumes:
      - "./zitadel/config.yaml:/config.yaml:ro"
      - "./zitadel/secrets.yaml:/secrets.yaml:ro"
      - "./zitadel/init-steps.yaml:/init-steps.yaml:ro"
    depends_on:
      - postgres
    networks:
      - xxxxx

One of the error that I received is

zitadel-1   | time="2025-01-31T06:53:36Z" level=error msg="migration failed" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:68" error="ERROR: syntax error at or near \"(\" (SQLSTATE 42601)" name=02_assets
postgres-1  |     CREATE TABLE system.assets (
postgres-1  |         instance_id TEXT,
postgres-1  |         asset_type TEXT,
postgres-1  |         resource_owner TEXT,
postgres-1  |         name TEXT,
postgres-1  |         content_type TEXT,
postgres-1  |         hash TEXT GENERATED ALWAYS AS (md5(data)) STORED,
postgres-1  |         data BYTEA,
postgres-1  |         updated_at TIMESTAMPTZ,
postgres-1  |
postgres-1  |         PRIMARY KEY (instance_id, resource_owner, name)
postgres-1  |     );

zitadel-1   | time="2025-01-31T06:53:36Z" level=error msg="migration failed" caller="/home/runner/work/zitadel/zitadel/internal/migration/migration.go:68" error="ERROR: syntax error at or near \"(\" (SQLSTATE 42601)" name=02_assets
postgres-1  |     CREATE TABLE system.assets (
postgres-1  |         instance_id TEXT,
postgres-1  |         asset_type TEXT,
postgres-1  |         resource_owner TEXT,
postgres-1  |         name TEXT,
postgres-1  |         content_type TEXT,
postgres-1  |         hash TEXT GENERATED ALWAYS AS (md5(data)) STORED,
postgres-1  |         data BYTEA,
postgres-1  |         updated_at TIMESTAMPTZ,
postgres-1  |
postgres-1  |         PRIMARY KEY (instance_id, resource_owner, name)
postgres-1  |     );

1 Reply

RamsaiOP•8mo ago

Hi, I upgraded the docker image version from 11.7-alpine to 14.2-alpine and the migration works fine. Thanks!

Build error while migration

Did you find this page helpful?