Postgres on AZURE Unhandled rejection TimeoutError

2020-04-21 04:45发布

I have a database postgres on azure, whith General Purpose, 2 vCore(s), 100 GB.

at this moment, when i do a simple request to database, database answer me lot of times with message:

Unhandled rejection TimeoutError: ResourceRequest timed out
at ResourceRequest._fireTimeout (/Project/development/TFS-git/RAILES/railes-backend-api-pt-0317/node_modules/sequelize/node_modules/generic-pool/lib/ResourceRequest.js:62:17)
at Timeout.bound (/Project/development/****/*****/*********/node_modules/sequelize/node_modules/generic-pool/lib/ResourceRequest.js:8:15)
at ontimeout (timers.js:458:11)
at tryOnTimeout (timers.js:296:5)
at Timer.listOnTimeout (timers.js:259:5)

i'm using nodejs, "pg": "7.5.0", "pg-hstore": "^2.3.2", "sequelize": "4.41.0",

i also tryed to scale database to 32 cores, but CPU is more than 95% in both cases.

my pool: pool: { max: 5, min: 0, acquire: 10000, idle: 5, evict: 8 },

in some cases, the connection give-me a timeout with 2 minuts.

any idea?

0条回答
登录 后发表回答