My exception is:
[23:59:57.825] ERROR: select directus_users.id, directus_users.role, directus_roles.admin_access, directus_roles.app_access from directus_users left join directus_roles on directus_users.role = directus_roles.id where directus_users.token = ‘ItEJV-iGnUH_cFiaXM9Oy8bNvH2S1dbk’ and status = ‘active’ limit 1 - read ECONNRESET
err: {
“type”: “Error”,
“message”: “select directus_users.id, directus_users.role, directus_roles.admin_access, directus_roles.app_access from directus_users left join directus_roles on directus_users.role = directus_roles.id where directus_users.token = ‘ItEJV-iGnUH_cFiaXM9Oy8bNvH2S1dbk’ and status = ‘active’ limit 1 - read ECONNRESET”,
“stack”:
Error: read ECONNRESET
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
at Protocol._enqueue (/directus/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/directus/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:198:25)
at /directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/dialects/mysql/index.js:132:18
at new Promise ()
at Client_MySQL._query (/directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/dialects/mysql/index.js:126:12)
at executeQuery (/directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
at Client_MySQL.query (/directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/client.js:146:12)
at Runner.query (/directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/execution/runner.js:123:36)
at ensureConnectionCallback (/directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:13:17)
at Runner.ensureConnection (/directus/node_modules/.pnpm/knex@2.4.2_mysql@2.18.1_pg@8.10.0_sqlite3@5.1.6_tedious@15.1.3/node_modules/knex/lib/execution/runner.js:300:20)
“errno”: -104,
“code”: “ECONNRESET”,
“syscall”: “read”,
“fatal”: true
}
my setting is:
DB_POOL__idleTimeoutMillis:500