An error in The project: The last packet successfully received from The server was 81843482 milliSeconds, The last packer send successfully to The server wes 81843482 milliSeconds and is longer than The server configured values of "wait_timeout"...


Configured in the configuration file has: spring. The datasource. MaxIdleTime=1800

Database timeOut_time is 28800,

Is not theoretically should not appear this kind of circumstance?
Database connection configuration and autoReconnect=trrue,

Is very confused, you great god can indicate the likely problems genuflect is begged

CodePudding user response:

Their top once, ah, genuflect is begged you brother

CodePudding user response:

Is your wait_timeout 28800 SEC? More than 81843482 ms is

CodePudding user response:

MaxIdleTime is JDK threadpoolexecutor keepalivetime, over corePoolSize keepalivetime refers to the total number of the current thread, free time will be more than maxIdleTime thread killed know the total number of threads for corePoolSize, you didn't see threads recycling, should be a thread total does not reach corePoolSize, only reach corePoolSize the number of threads, and taskQueue queue full will add worker thread,

https://m.aliyun.com/yunqi/ask/18064/