search

jt-20180528 / pro_document_mycat

项目文档记录，一些技术栈预研文档
2 stars 1 forks source link

mycat连接出现，时断时连异常 #5

Open lujunGit opened 6 years ago

lujunGit commented 6 years ago

2018-07-05 18:21:20,300 [DESKTOP-1LO98I2-20881] [] [] [pool-3-thread-6] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 08S01^M 2018-07-05 18:21:20,303 [DESKTOP-1LO98I2-20881] [] [] [pool-3-thread-5] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 08S01^M 2018-07-05 18:21:20,300 [DESKTOP-1LO98I2-20881] [] [] [pool-3-thread-9] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 08S01^M 2018-07-05 18:21:20,303 [DESKTOP-1LO98I2-20881] [] [] [pool-3-thread-9] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Communications link failure

The last packet successfully received from the server was 1,010 milliseconds ago. The last packet sent successfully to the server was 1,010 milliseconds ago.^M 2018-07-05 18:21:20,300 [DESKTOP-1LO98I2-20881] [] [] [pool-3-thread-3] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 08S01^M 2018-07-05 18:21:20,303 [DESKTOP-1LO98I2-20881] [] [] [pool-3-thread-3] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Communications link failure

lujunGit commented 6 years ago

经过检查，调大了mycat执行线程为1024个，并且在连接mysql的url中添加参数autoReconnect=true之后测试暂未出现这个问题。