上班坐下来没多久,接同事电话说有两台mysql服务器无法访问,其中这两台服务器是mycat服务器+MySQL服务器,具体处理过程如下:
一、错误信息
错误信息01:
INFO | jvm 3 | 2018/05/10 10:00:54 | 2018-05-10 10:00:54,406 [INFO ][$_NIOREACTOR-3-RW] close connection,reason:Bad: java.lang.OutOfMemoryError: Unable to acquire 131072 bytes of memory, got 0 ,MySQLConnection [id=6173, lastTime=1525917654 250, user=username, schema=database10, old shema=database10, borrowed=true, fromSlaveDB=true, threadId=42067, charset=utf8, txIsolation=3, autocommit=true, attachment=dn10{SELECT * INFO | jvm 3 | 2018/05/10 10:00:54 | FROM cu_link INFO | jvm 3 | 2018/05/10 10:00:54 | WHERE (customer_id = 1964 INFO | jvm 3 | 2018/05/10 10:00:54 | OR customer_link_id = 1964) INFO | jvm 3 | 2018/05/10 10:00:54 | AND state = 1 INFO | jvm 3 | 2018/05/10 10:00:54 | AND company_id = '3BD' INFO | jvm 3 | 2018/05/10 10:00:54 | LIMIT 100000000}, respHandler=io.mycat.backend.mysql.nio.handler.MultiNodeQueryH andler@530d01dc, host=xx.xx.xx.xx, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false] (io.mycat.net. AbstractConnection:AbstractConnection.java:508) INFO | jvm 3 | 2018/05/10 10:00:54 | 2018-05-10 10:00:54,407 [ERROR][$_NIOREACTOR-3-RW] caught err: java.lang.OutOfM emoryError: Unable to acquire 131072 bytes of memory, got 0 INFO | jvm 3 | 2018/05/10 10:00:54 | at io.mycat.memory.unsafe.memory.mm.MemoryConsumer.allocateLongArray(Memor yConsumer.java:92) INFO | jvm 3 | 2018/05