nodejs 1
[MariaDB / Node.js] retrieve connection from pool timeout after ์—๋Ÿฌ

MariaDB + Node.js + express.js ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ API์„œ๋ฒ„ - DB์„œ๋ฒ„๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์—ˆ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ ํ•œ ๋ฒˆ์”ฉ API ์„œ๋ฒ„์—์„œ DB์„œ๋ฒ„๋กœ query๋ฅผ ์ „๋‹ฌํ•˜์ง€ ๋ชปํ•˜๋Š” ํ˜„์ƒ์ด ๋ฐœ์ƒํ–ˆ๋‹ค. conn = await pool.getConnection(); pool.getConnection์—์„œ 10์ดˆ๋™์•ˆ connection์„ ๋ฐ˜ํ™˜ํ•˜์ง€ ์•Š์•˜๊ณ , ์ด ์‹œ๊ฐ„์ด ์„ค์ •๋˜์–ด์žˆ๋Š” acquireTimeout์„ ๋„˜์–ด๊ฐ€์„œ ์—๋Ÿฌ๋ฅผ ๋„์šฐ๋Š” ๊ฒƒ์ด์—ˆ๋‹ค. pool.on("acquire", (conn) => { console.log(`acquire ${conn.threadId} has been acquire in pool`); console.log("acquire pool.activeConnections()", pool.acti..
Programming 2021.05.30
1
๋”๋ณด๊ธฐ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”