[BUG]engine failure: version V0.71.0

[Devika7733]

Describe the issue
I am installing Hatchet v0.71.0 using the Helm chart and encountering an error with the controller, scheduler, and gRPC components. The error is: engine failure: could not run with config: could not start olap controller: could not create table partition: could not create table partition: ERROR: function create_v1_weekly_range_partition(text, date) does not exist (SQLSTATE 42883) . I would appreciate any help with this issue.

Environment

• Engine: [ Self-hosted v0.71.0]

Expected behavior
This should work without any issue. This is a new deployment

Additional context
I am using helm chart version -0.9.2(hatchet-HA) where I have modified image tag as below to deploy latest version.

hatchet:

sharedConfig is inherited by all backend services: api, grpc, controllers, scheduler

sharedConfig:
enabled: true
serverUrl: "https://hatchet.XXXXXXXXXX/api"
serverAuthCookieDomain: "XXXXXX"
serverAuthCookieInsecure: "t"
serverAuthSetEmailVerified: "t"
serverAuthBasicAuthEnabled: "t"
grpcBroadcastAddress: "hatchet-grpc:8733"
grpcInsecure: "true"
env:
SERVER_INTERNAL_CLIENT_BASE_STRATEGY: "none"
SERVER_LOGGER_LEVEL: "error"
SERVER_LOGGER_FORMAT: "console"
DATABASE_LOGGER_LEVEL: "error"
DATABASE_LOGGER_FORMAT: "console"
SERVER_DISABLE_CLOUD_FEATURES: "true"

api:
image:
repository: "ghcr.io/hatchet-dev/hatchet/hatchet-api"
tag: "v0.71.0"
setupJob:
image:
repository: "ghcr.io/hatchet-dev/hatchet/hatchet-admin"
tag: "v0.71.0"

migrationJob:
  image:
    repository: "ghcr.io/hatchet-dev/hatchet/hatchet-migrate"
    tag: "v0.71.0"

seedJob:
  image:
    repository: "ghcr.io/hatchet-dev/hatchet/hatchet-admin"
    tag: "v0.71.0"

grpc:
image:
repository: "ghcr.io/hatchet-dev/hatchet/hatchet-engine"
tag: "v0.71.0"

controllers:
image:
repository: "ghcr.io/hatchet-dev/hatchet/hatchet-engine"
tag: "v0.71.0"
setupJob:
enabled: true
scheduler:
image:
repository: "ghcr.io/hatchet-dev/hatchet/hatchet-engine"
tag: "v0.71.0"
setupJob:
enabled: true

frontend:
enabled: true
image:
repository: "ghcr.io/hatchet-dev/hatchet/hatchet-frontend"
tag: "v0.71.0"

[mrkaye97]

hi @Devika7733 - has the migration job run successfully?