keepalive_get will reuse connections with state_db_connect

[cfsego]

in v1.1.0

conf is
upstream dns_backend {
drizzle_server 10.232.31.89:3306;
drizzle_keepalive max=70 mode=single overflow=ignore;
}

we find that the connection can be only used once.
and the error log says "BROKEN PIPE"

we found that the ngx_http_drizzle_keepalive_get_XXX() returns the dp with reset dp->state, so it is state_db_connect

[agentzh]

On Fri, Nov 11, 2011 at 6:04 PM, cfsego
[email protected]
wrote:

in v1.1.0

You mean nginx 1.1.0? What're your versions of libdrizzle and ngx_drizzle?

conf is
upstream dns_backend {
   drizzle_server 10.232.31.89:3306;
   drizzle_keepalive max=70 mode=single overflow=ignore;
}

we find that the connection can be only used once.
and the error log says "BROKEN PIPE"

we found that the ngx_http_drizzle_keepalive_get_XXX() returns the dp with reset dp->state, so it is state_db_connect

I don't quite follow you here. Can you elaborate? What kind of MySQL
queries are you using? And what conditions are required to reproduce
this issue? Also, showing the related parts of your error.log with
debug error log level will also be very much helpful.

Regards,
-agentzh