repmgrd | value for "node_name" must contain fewer than 64 characters (current length: 67)

[owenthereal]

I'm trying to provision a Fly Postgres 16 using https://github.com/fly-apps/postgres-flex/releases/tag/v0.0.59 but got the following error:

2024-08-14T17:51:45.973 app[e784327ea630d8] iad [info] repmgrd | [2024-08-14 17:51:45] [ERROR] following errors were found in the configuration file:

2024-08-14T17:51:45.973 app[e784327ea630d8] iad [info] repmgrd | value for "node_name" must contain fewer than 64 characters (current length: 67)

2024-08-14T17:51:45.973 app[e784327ea630d8] iad [info] repmgrd | "node_name": required parameter was not found

2024-08-14T17:51:45.974 app[e784327ea630d8] iad [info] repmgrd | exit status 1

2024-08-14T17:51:45.974 app[e784327ea630d8] iad [info] repmgrd | restarting in 5s [attempt 59]

2024-08-14T17:51:46.494 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:46.493 UTC [2500] ERROR: relation "repmgr.nodes" does not exist at character 56

2024-08-14T17:51:46.494 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:46.493 UTC [2500] STATEMENT: select node_id, node_name, location, active, type from repmgr.nodes;

2024-08-14T17:51:46.495 app[e784327ea630d8] iad [info] failed post-init: failed to verify member registration: failed to resolve member role: ERROR: relation "repmgr.nodes" does not exist (SQLSTATE 42P01). Retrying...

2024-08-14T17:51:47.250 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.249 UTC [2502] ERROR: relation "repmgr.nodes" does not exist at character 56

2024-08-14T17:51:47.250 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.249 UTC [2502] STATEMENT: select node_id, node_name, location, active, type from repmgr.nodes;

2024-08-14T17:51:47.432 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.431 UTC [2504] ERROR: relation "repmgr.nodes" does not exist at character 56

2024-08-14T17:51:47.432 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.431 UTC [2504] STATEMENT: select node_id, node_name, location, active, type from repmgr.nodes;

2024-08-14T17:51:47.494 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.494 UTC [2508] ERROR: relation "repmgr.nodes" does not exist at character 56

2024-08-14T17:51:47.494 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.494 UTC [2508] STATEMENT: select node_id, node_name, location, active, type from repmgr.nodes;

2024-08-14T17:51:47.496 app[e784327ea630d8] iad [info] failed post-init: failed to verify member registration: failed to resolve member role: ERROR: relation "repmgr.nodes" does not exist (SQLSTATE 42P01). Retrying...

2024-08-14T17:51:47.513 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.512 UTC [2512] ERROR: relation "repmgr.nodes" does not exist at character 56

2024-08-14T17:51:47.513 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:47.512 UTC [2512] STATEMENT: select node_id, node_name, location, active, type from repmgr.nodes;

2024-08-14T17:51:48.495 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:48.495 UTC [2516] ERROR: relation "repmgr.nodes" does not exist at character 56

2024-08-14T17:51:48.495 app[e784327ea630d8] iad [info] postgres | 2024-08-14 17:51:48.495 UTC [2516] STATEMENT: select node_id, node_name, location, active, type from repmgr.nodes;

The error might be related to #251.

[owenthereal]

cc: @benwaffle @davissp14

[owenthereal]

The error comes from https://github.com/EnterpriseDB/repmgr/blob/d3b1ff45b0626c144db4cd1fb1f3c727ea06b2f3/configfile.c#L498

[benwaffle]

Hmm...that's not great. What's your app name? I think if you keep it under 37 characters, you should be good.

[owenthereal]

The app name is dev-a91381f1-5f36-4db9-9b10-c374bc3f7f4c. It would be nice if there is a better solution than limiting the length of the app name for things to work. We name apps using an internal uuid with a prefix.

[benwaffle]

I've reverted the PR that introduces the bug, and released a new image. v0.0.60 should be good.