MySQL Forums
Forum List  »  Router & Proxy

show error "mysqli::mysqli(): (08S01/1047): Unknown command"
Posted by: hanky cheng
Date: June 12, 2012 05:00AM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
show error "mysqli::mysqli(): (08S01/1047): Unknown command"
5701
June 12, 2012 05:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.