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