DBShield icon indicating copy to clipboard operation
DBShield copied to clipboard

DBShield run into i/o timeout when receiving response from mysql 5.7 as backend server

Open qiwihui opened this issue 8 years ago • 1 comments

When test against MySQL 5.7 as backend server, DBShield failed into i/o timeout when read packets fromserver. But the server did send back packets to DBShield. But this doesn't recurrent for Mysql 5.5 or 5.6. I am not quit sure about it. Please help.

debug log:

2017/10/19 17:18:13 [INFO]  Config file: /path/to/dbshield.yml
2017/10/19 17:18:13 [INFO]  Listening: 0.0.0.0:13307
2017/10/19 17:18:13 [INFO]  Backend: mysql (10.10.10.57:3306)
2017/10/19 17:18:13 [INFO]  Protect: false
2017/10/19 17:18:13 [INFO]  Web interface on https://127.0.0.1:8070/
2017/10/19 17:18:20 [DEBUG] Connected from: 127.0.0.1:56552
2017/10/19 17:18:20 [DEBUG] Connected to: 10.10.10.57:3306
2017/10/19 17:18:20 [DEBUG] SSL connection
2017/10/19 17:18:20 [DEBUG] Client handshake done
2017/10/19 17:18:20 [DEBUG] Server handshake done
2017/10/19 17:18:20 [DEBUG] Username: root
2017/10/19 17:18:20 [DEBUG] Database: mysql_native_password
2017/10/19 17:18:20 [DEBUG] SSL bit: true
2017/10/19 17:18:20 [DEBUG] Query: show databases
2017/10/19 17:18:20 [DEBUG] action: learning
2017/10/19 17:18:20 [WARN]  data recevied: Kdefinformation_schemSCHEMATSCHEMATDatabase
                                                                                            SCHEMA_NAME
                                                                                !information_schemamysqlperformance_schemasys"
2017/10/19 17:18:30 [WARN]  read tcp 10.2.1.5:56553->10.10.10.57:3306: i/o timeout
2017/10/19 17:18:54 [DEBUG] Connected from: 127.0.0.1:56593
2017/10/19 17:18:54 [DEBUG] Connected to: 10.10.10.57:3306
2017/10/19 17:18:54 [DEBUG] SSL connection
2017/10/19 17:18:54 [DEBUG] Client handshake done
2017/10/19 17:18:54 [DEBUG] Server handshake done
2017/10/19 17:18:54 [DEBUG] Username: root
2017/10/19 17:18:54 [DEBUG] Database: mysql_native_password
2017/10/19 17:18:54 [DEBUG] SSL bit: true
2017/10/19 17:18:54 [DEBUG] Query: select * from first where name<1719
2017/10/19 17:18:54 [DEBUG] action: learning
2017/10/19 17:18:54 [WARN]  data recevied: #3D000No database selected
2017/10/19 17:19:04 [WARN]  read tcp 10.2.1.5:56594->10.10.10.57:3306: i/o timeout

env

DBShield Version: 1.0.0-beta4

$ go version
go version go1.9.1 darwin/amd64

$ mysql --version
mysql  Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using  EditLine wrapper

qiwihui avatar Oct 19 '17 10:10 qiwihui

I'm having the same problem. any idea?

tfxrdz avatar Nov 12 '17 20:11 tfxrdz