Get error Error while initializing

[peteryang1756]

Get error Error while initializing

[filipdjokic]

We've also encountered the same timeout error during app initialization with v1.16.0, v1.17.0 and v1.18.0.

After some investigation, we managed to resolve it by adding the connectionTimeout configuration parameter to the createPoolByEnv function:

const createPoolByEnv = async (
  databaseDsn: string,
  mockDatabaseConnection: boolean,
  poolSize?: number,
  connectionTimeout?: number
) => {
  // Database connection is disabled in unit test environment
  if (mockDatabaseConnection) {
    return createMockPool({ query: async () => createMockQueryResult([]) });
  }

  assert(parseDsn(databaseDsn).databaseName, new Error('Database name is required'));

  return createPool(databaseDsn, {
    interceptors: createInterceptorsPreset(),
    maximumPoolSize: poolSize,
    connectionTimeout: connectionTimeout,
  });
};

Additionally, we've added an environment variable named DATABASE_CONNECTION_TIMEOUT, which if unset will have the default value of 10_000 (in our case setting it to 30_000 resolved the issue).
This way, the environment variable will remain optional, allowing people to adjust this setting if needed.

Is this something you would consider including in the next release? Happy to contribute and help with the implementation.

[charIeszhao]

It seems you have issues connecting to the database. Can you share your config?

[peteryang1756]

It seems you have issues connecting to the database. Can you share your config?

This is my db config
DB_URL=postgres://postgres.woefiqksuduiihlynziwdydegh:[email protected]:6543/postgres