Admin -> Data Models keeps throwing 504 Gateway Error

When I try to go into Data Models (Admin Settings -> Data Models) after loading a while it throws an 504 Error

Diagnostigs

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.11+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.11",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.11+9",
    "os.name": "Linux",
    "os.version": "5.8.0-1038-aws",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  },
  "metabase-info": {
    "databases": [
      "redshift",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.13"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.1"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-07-24",
      "tag": "v0.46.6.2",
      "branch": "patch-google-sso-button",
      "hash": "a4c740a"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Logs output:

[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 16.6 ms (5 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (105 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 21.2 ms (9 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (105 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/database/2 200 7.7 ms (3 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (2 idle, 0 queued) (107 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/database 200 7.1 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (107 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/database 200 6.9 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (107 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/database 200 70.6 ms (10 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (2 idle, 0 queued) (107 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:52:23+00:00 DEBUG metabase.server.middleware.log GET /api/search 200 98.0 ms (3 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (107 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:53:40+00:00 DEBUG metabase.server.middleware.log GET /api/database/2/metadata 200 1.3 mins (2,079 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (3 idle, 0 queued) (106 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:53:40+00:00 DEBUG metabase.server.middleware.log GET /api/database/2/metadata null 1.3 mins (2,079 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (106 total active threads) Queries in flight: 0 (0 queued)
[931a8b4d-5c46-4ff9-929c-b104c73b6ee8] 2024-03-04T14:53:40+00:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.

try moving to a newer version. The error is that your reverse proxy is cutting the connection as the page takes a lot to return

1 Like