Hi all!
我遇到的问题是:drizzle无法连上mysql的问题
具体的error.log 报错为
2013/08/19 20:57:45 [emerg] 36137#0: *17 drizzle: failed to connect: 21: drizzle_state_connect:connect:Operation now in progress in upstream "127.0.0.1:3306" while connecting to upstream, client: 127.0.0.1, server: localhost, request: "GET /a HTTP/1.1", upstream: "drizzle://127.0.0.1:3306", host: "localhost:10012"
我的配置文件是:
upstream backend {
drizzle_server 127.0.0.1:3306 dbname=test password=xxx user=root protocol=mysql charset=utf8;
}
server {
server_name localhost;
# lua_code_cache off;
listen 10012;
location /a {
drizzle_query "select * from user where id =1";
drizzle_pass backend;
rds_json on;
}
location = /mysql-status {
drizzle_status;
}
}
我使用
curl http://localhost:10012/a 出现502,errorlog如上。
我curl http://localhost:10012/mysql-status 是正常的
worker process: 36137
upstream backend
active connections: 0
connection pool capacity: 0
servers: 1
peers: 1
后面上面这种打drizzle模块的没有用后,我使用lua-resty-mysql
通过这种方式去访问却可以正常使用了,我目前只知道连不上mysql,这都到底是什么原因呢,遇到这种问题,我又该如何排错呢?
我的环境是MacOSX 10.8