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:
One of the error that I received is
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:
- xxxxxOne 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 | );
