mysql心跳检测_PXC心跳检测时报can't sure connection syn result,so close it MySQLConnection

版本：

5.5.8-mycat-1.4-RELEASE-20150901112004，

OS: ContOS 6.5

MySQL: 5.6.24-72.2-25.11-log Percona XtraDB Cluster binary (GPL) 5.6.24-25.11, Revision, wsrep_25.11(3节点)

schema.xml配置如下：

writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">

select user()

writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">

select user()

writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">

show slave status

/mycat:schema

server.xml配置如下：

druidparser

8066 9066

a

spocosy

a

18test

a

fb_console

a

football2

a

game

a

gate

a

lahai

a

win007

a

calc

a

test

a

fb_snap

a

football

a

forum

a

console

a

leixj

/mycat:server

wrapper.conf只修改了jdk的路径，其他默认，jdk版本1.7.0_60

警告日志如下：

09/14 20:39:19.282 WARN $_NIOREACTOR-4-RW -can't sure connection syn result,so close it MySQLConnection [id=4015, lastTime=1442234359270, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=4527, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@77409080], host=192.168.88.12, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@3f34b16b, writeQueue=0, modifiedSQLExecuted=false]

09/14 20:39:19.282 WARN $_NIOREACTOR-5-RW -can't sure connection syn result,so close it MySQLConnection [id=4024, lastTime=1442234359270, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=1149347, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@2fcf00aa], host=192.168.88.13, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@1c6c0838, writeQueue=0, modifiedSQLExecuted=false]

09/14 20:39:29.282 WARN $_NIOREACTOR-3-RW -can't sure connection syn result,so close it MySQLConnection [id=4022, lastTime=1442234369272, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=1149344, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@763f03c3], host=192.168.88.13, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@231033db, writeQueue=0, modifiedSQLExecuted=false]

09/14 20:39:29.283 WARN $_NIOREACTOR-2-RW -can't sure connection syn result,so close it MySQLConnection [id=4013, lastTime=1442234369272, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=4523, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@3cdd9094], host=192.168.88.12, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@7cbc80d8, writeQueue=0, modifiedSQLExecuted=false]

09/14 20:39:39.282 WARN $_NIOREACTOR-2-RW -can't sure connection syn result,so close it MySQLConnection [id=4028, lastTime=1442234379268, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=4554, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@689ac6da], host=192.168.88.12, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@72c10304, writeQueue=0, modifiedSQLExecuted=false]

09/14 20:39:39.283 WARN $_NIOREACTOR-1-RW -can't sure connection syn result,so close it MySQLConnection [id=4027, lastTime=1442234379268, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=1149381, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@97547dd], host=192.168.88.13, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@5dad3677, writeQueue=0, modifiedSQLExecuted=false]

将这个mycat的所有的文件拷贝一份，修改端口，在同一台机上面启起来，但是没有任何外来的连接请求，不报警告。