Get error Error while initializing

[peteryang1756]

I try to delopy logto on Render and get this error,How to fix it

    (node:17) ExperimentalWarning: Importing JSON modules is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
index    error Error while initializing app:
index    error Error: timeout expired
    at Timeout._onTimeout (/etc/logto/node_modules/.pnpm/[email protected]/node_modules/pg/lib/client.js:106:28)
    at listOnTimeout (node:internal/timers:573:17)
    at process.processTimers (node:internal/timers:514:7)

[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

[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]

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.

Thanks for the information. Sorry for not being able to reply earlier.
A contribution PR is always welcomed. Follow the contribution guidelines and let us know if you need any help.

[luis815]

If it's OK, I essentially implemented the change mentioned above. Raised PR #6674

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.