Content-Length: 289450 | pFad | http://github.com/coollabsio/coolify/issues/5938

73 [Bug]: instance_settings table not created on fresh install, causing 500 error · Issue #5938 · coollabsio/coolify · GitHub
Skip to content

[Bug]: instance_settings table not created on fresh install, causing 500 error #5938

Open
@Kyle6012

Description

@Kyle6012

Error Message and Logs

2025-06-05 11:19:31.901 UTC [67] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:31.942 UTC [68] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:31.942 UTC [68] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:35.519 UTC [69] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:35.519 UTC [69] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:35.611 UTC [70] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:35.611 UTC [70] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:39.096 UTC [71] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:39.096 UTC [71] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:39.237 UTC [72] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:39.237 UTC [72] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:42.728 UTC [81] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:42.728 UTC [81] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:42.872 UTC [82] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:42.872 UTC [82] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:46.370 UTC [83] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:46.370 UTC [83] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:46.484 UTC [84] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:46.484 UTC [84] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:49.979 UTC [85] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:49.979 UTC [85] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:50.187 UTC [86] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:50.187 UTC [86] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:53.630 UTC [88] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:53.630 UTC [88] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:53.810 UTC [89] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:53.810 UTC [89] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:57.256 UTC [90] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:57.256 UTC [90] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:19:57.515 UTC [91] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:19:57.515 UTC [91] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:00.980 UTC [92] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:20:00.980 UTC [92] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:01.212 UTC [93] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:20:01.212 UTC [93] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:04.861 UTC [94] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:20:04.861 UTC [94] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:05.150 UTC [95] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:20:05.150 UTC [95] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:08.559 UTC [96] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:20:08.559 UTC [96] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:08.653 UTC [97] ERROR: relation "instance_settings" does not exist at character 15
2025-06-05 11:20:08.653 UTC [97] STATEMENT: select * from "instance_settings" where "instance_settings"."id" = $1 limit 1
2025-06-05 11:20:08.905 UTC [98] ERROR: relation "instance_settings" does not exist at character 15

Steps to Reproduce

  1. Clean install Coolify using docker-compose (or official installer).

  2. Containers start, but the web interface shows:

  Oops! An Error Occurred  
  The server returned a "500 Internal Server Error".  
  1. Logs show repeated PostgreSQL errors:
  sql
  ERROR: relation "instance_settings" does not exist
  LINE 1: select * from "instance_settings" where "instance_settings"...
  Attempted Fixes (None worked)
  docker-compose down -v + docker volume prune → Reinstall

Attempted Fixes (None worked)

Manually running php artisan migrate --force → Fails with same error

Manually creating the instance_settings table → Other dependencies fail

Re-cloning the repo + full cleanup → No change

Example Repository URL

No response

Coolify Version

v4.0.0-beta.378

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Ubuntu 22.04.5 LTS

Additional Information

Database connection works (psql -U coolify succeeds).

No errors in coolify-db logs besides missing table.

Tried both manual setup and installer script.

Metadata

Metadata

Assignees

No one assigned

    Labels

    🐛 BugReported issues that need to be reproduced by the team.🔍 TriageIssues that need assessment and prioritization.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions









      ApplySandwichStrip

      pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


      --- a PPN by Garber Painting Akron. With Image Size Reduction included!

      Fetched URL: http://github.com/coollabsio/coolify/issues/5938

      Alternative Proxies:

      Alternative Proxy

      pFad Proxy

      pFad v3 Proxy

      pFad v4 Proxy