coolify icon indicating copy to clipboard operation
coolify copied to clipboard

[Bug]: All deployments with health check fail: column "health_check_start_interval" of relation "applications" does not exist

Open luckydonald opened this issue 8 months ago • 2 comments

Error Message and Logs

// ... NORMAL BUILD OUTPUT ...
// .......

2025-Mar-26 03:38:11.323677
Oops something is not okay, are you okay? 😢
2025-Mar-26 03:38:11.334143
SQLSTATE[42703]: Undefined column: 7 ERROR:  column "health_check_start_interval" of relation "applications" does not exist
2025-Mar-26 03:38:11.334143
LINE 1: update "applications" set "health_check_start_interval" = $1...
2025-Mar-26 03:38:11.334143
^ (Connection: pgsql, SQL: update "applications" set "health_check_start_interval" = 5, "updated_at" = 2025-03-26 03:38:11 where "id" = 34)
2025-Mar-26 03:38:11.339590
Deployment failed. Removing the new version of your application.

Steps to Reproduce

  1. Deploy a docker image based git project with a health check configured in docker-compose.
  2. ???
  3. it fails, even if that exact code did build successfully before

Example Repository URL

No response

Coolify Version

https://github.com/coollabsio/coolify/releases/tag/v4.0.0-beta.399

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

PRETTY_NAME="Ubuntu 22.04.5 LTS" NAME="Ubuntu" VERSION_ID="22.04" VERSION="22.04.5 LTS (Jammy Jellyfish)" VERSION_CODENAME=jammy ID=ubuntu ID_LIKE=debian HOME_URL="https://www.ubuntu.com/" SUPPORT_URL="https://help.ubuntu.com/" BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/" PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy" UBUNTU_CODENAME=jammy

Additional Information

No response

luckydonald avatar Mar 26 '25 03:03 luckydonald

@luckydonald a bug was just fixed regarding parsing healthchecks, looking at it, it turns out when fixing this bug, old code was uncommented, which shouldn't be there

https://github.com/coollabsio/coolify/blob/6c17d45c400449f9136c5f428caa0554b9652da9/app/Models/Application.php#L1545-L1546

djsisson avatar Mar 26 '25 10:03 djsisson

The workaround seems to enable the manual healthcheck, i.e. overwriting the detected one, which fits your analysis.

luckydonald avatar Mar 29 '25 10:03 luckydonald

This will be fixed in the upcoming version.

andrasbacsai avatar Mar 31 '25 13:03 andrasbacsai