[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_11":-5},"routes/user.$name.replies",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":16},"replies",[34],"user",{"_20":21,"_13":14,"_22":23,"_24":14,"_25":26,"_27":28,"_29":30,"_31":16,"_32":33},"loginname","MinStenve","page",1,"limit",50,"total","id","11442","avatar_url","https://avatars3.githubusercontent.com/u/5523418?v=4","githubUsername","create_at","2014-01-18 07:58:37.64","score",20,"topic_count",3,"reply_count","is_star",false,{"_20":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":33,"_47":33,"_31":48,"_49":50,"_25":51,"_52":53},"37451","author_id","24645","tab","ask","content","egg项目使用egg-sequelize作为orm框架，该项目使用的mysql数据库和另外一个项目在一起，只是库不同而已，另外一个项目在做压力测试的时候将数据库cpu使用率提高到150%，持续时间挺长的。后来发现egg项目这边请求数据库老是超时，即使mysql数据库恢复正常之后，依然超时，重启egg项目之后才恢复正常，感觉就是连接池里的连接全部失效了而没有释放。想问问大家有没有遇到同样的问题，下面是错误信息和sequelize插件的配置：\r\n```\r\n2018-10-25 09:01:22,923 ERROR 15972 Fatal error: ResourceRequest timed out, ctx: {\"request\":{\"method\":\"POST\",\"url\":\"/dcc/v1/quota/get\",\"header\":{\"host\":\"dccs.bw-xt.com\",\"x-real-ip\":\"XXX\",\"x-forwarded-for\":\"XXX\",\"connection\":\"close\",\"content-length\":\"176\",\"user-agent\":\"Needs Clouds Client 5.0\",\"accept\":\"*/*\",\"content-type\":\"application/json;charset=utf-8\"}},\"response\":{\"status\":404,\"message\":\"Not Found\",\"header\":{\"vary\":\"Origin\"}},\"app\":{\"env\":\"prod\",\"name\":\"needs_dccs\",\"baseDir\":\"/srv/www/vhosts/Needs_Dccs\",\"subdomainOffset\":2,\"config\":\"\",\"controller\":\"\",\"httpclient\":\"\",\"loggers\":\"\",\"middlewares\":\"\",\"router\":\"\",\"serviceClasses\":\"\"},\"originalUrl\":\"/dcc/v1/quota/get\",\"req\":\"\",\"res\":\"\",\"socket\":\"\"}\r\n2018-10-25 09:01:31,620 ERROR 15996 [-/127.0.0.1/-/30005ms POST /dcc/v1/quota/get] nodejs.TimeoutError: ResourceRequest timed out\r\n at ResourceRequest._fireTimeout (/srv/www/vhosts/Needs_Dccs/node_modules/generic-pool/lib/ResourceRequest.js:62:17)\r\n at Timeout.bound (/srv/www/vhosts/Needs_Dccs/node_modules/generic-pool/lib/ResourceRequest.js:8:15)\r\n at ontimeout (timers.js:427:11)\r\n at tryOnTimeout (timers.js:289:5)\r\n at listOnTimeout (timers.js:252:5)\r\n at Timer.processTimers (timers.js:212:10)\r\nname: \"TimeoutError\"\r\n```\r\n```\r\nsequelize: {\r\n dialect: 'mysql',\r\n database: 'database',\r\n username: 'root',\r\n password: 'password',\r\n timezone: '+08:00',\r\n host: '127.0.0.1',\r\n port: '3306',\r\n loggerLevel: 'debug',\r\n dialectOptions: {\r\n supportBigNumbers: true,\r\n bigNumberStrings: true\r\n },\r\n define: {\r\n freezeTableName: true,\r\n charset: 'utf8',\r\n dialectOptions: {\r\n collate: 'utf8_general_ci'\r\n },\r\n timestamps: false\r\n },\r\n pool: {\r\n max: 5,\r\n min: 0,\r\n acquire: 30000,\r\n idle: 10000\r\n }\r\n },\r\n```","title","egg-sequelize连接池不能释放问题","last_reply_at","2019-04-01 03:51:56.244","good","top",2,"visit_count",6353,"2018-10-25 01:31:58.696","author",{"_13":54,"_22":55},"zhangmingfeng","https://avatars1.githubusercontent.com/u/16733816?v=4"]