show error "mysqli::mysqli(): (08S01/1047): Unknown command"

[hanky cheng]

Hi all

I have run Mysql proxy 0.8.2 with mysql 5.5.25 read-write server. But very Strange case that I get error "Unknown command" when I have insert record into DB via proxy but no error direct access read-write server. Here is proxy log as below:


2012-06-12 17:51:52: (message) chassis-unix-daemon.c:136: [angel] we try to keep PID=2530 alive
2012-06-12 17:51:52: (debug) chassis-unix-daemon.c:157: waiting for 2530
2012-06-12 17:51:52: (debug) chassis-unix-daemon.c:121: we are the child: 2530
2012-06-12 17:51:52: (message) mysql-proxy 0.8.2 started
2012-06-12 17:51:52: (debug) max open file-descriptors = 1024
2012-06-12 17:51:52: (message) proxy listening on port 192.168.1.20:3306
2012-06-12 17:51:52: (message) added read/write backend: 192.168.1.21
2012-06-12 17:51:52: (message) added read-only backend: 192.168.1.22
2012-06-12 17:52:04: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2012-06-12 17:59:36: (debug) last message repeated 29 times
2012-06-12 17:59:36: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2012-06-12 18:03:38: (debug) last message repeated 8 times
2012-06-12 18:03:38: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2012-06-12 18:06:59: (debug) last message repeated 22 times
2012-06-12 18:06:59: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2012-06-12 18:14:58: (message) chassis-unix-daemon.c:136: [angel] we try to keep PID=2591 alive
2012-06-12 18:14:58: (debug) chassis-unix-daemon.c:157: waiting for 2591
2012-06-12 18:14:58: (debug) chassis-unix-daemon.c:121: we are the child: 2591
2012-06-12 18:14:58: (message) mysql-proxy 0.8.2 started
2012-06-12 18:14:58: (debug) max open file-descriptors = 1024
2012-06-12 18:14:58: (message) proxy listening on port 192.168.1.20:3306
2012-06-12 18:14:58: (message) added read/write backend: 192.168.1.21
2012-06-12 18:14:58: (message) added read-only backend: 192.168.1.22
2012-06-12 18:15:08: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2012-06-12 18:26:07: (message) chassis-unix-daemon.c:136: [angel] we try to keep PID=2627 alive
2012-06-12 18:26:07: (debug) chassis-unix-daemon.c:157: waiting for 2627
2012-06-12 18:26:07: (debug) chassis-unix-daemon.c:121: we are the child: 2627
2012-06-12 18:26:07: (message) mysql-proxy 0.8.2 started
2012-06-12 18:26:07: (debug) max open file-descriptors = 1024
2012-06-12 18:26:07: (message) proxy listening on port 192.168.1.20:3306
2012-06-12 18:26:07: (message) added read/write backend: 192.168.1.21
2012-06-12 18:26:07: (message) added read-only backend: 192.168.1.22
2012-06-12 18:26:18: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2012-06-12 18:26:58: (message) chassis-unix-daemon.c:136: [angel] we try to keep PID=2644 alive
2012-06-12 18:26:58: (debug) chassis-unix-daemon.c:157: waiting for 2644
2012-06-12 18:26:58: (debug) chassis-unix-daemon.c:121: we are the child: 2644
2012-06-12 18:26:58: (message) mysql-proxy 0.8.2 started
2012-06-12 18:26:58: (debug) max open file-descriptors = 1024
2012-06-12 18:26:58: (message) proxy listening on port 192.168.1.20:3306
2012-06-12 18:26:58: (message) added read/write backend: 192.168.1.21
2012-06-12 18:26:58: (message) added read-only backend: 192.168.1.22

anyone can help?
Tks!