Welcome! Log In Create A New Profile

Advanced

drizzle-nginx-module error body missing?

October 16, 2011 01:00AM
Hey nginx list, it's been awhile. This question is directed at agentzh and chaoslawful.

I'm using nginx drizzle to insert to a table. I have a unique key constraint on the table. When I try to insert and violate the unique constraint, I get a 500 from the nginx location doing the mysql query, but no response body or headers to pass on to my client indicating what the mysql error was. I can easily check for the 500 in the location calling the mysql location, but I'd like to pass on the error code to the actual client with some useful error information and not mask any further 500's.

The json-ified output of a successful insert has an errcode field:
{"errcode":0,"insert_id":1,"affected_rows":1}

, but an actual error returns an empty body. Is there no way to grab the error relating to my failed insert? Any suggestions?


Here's the error log:
2011/10/16 04:08:53 [error] 2847#0: *60 failed to send query: 17 (1062): Duplicate entry '2-200-6094279b20' for key 'id_versions' while sending query to drizzle upstream, client: 10.102.17.232, server: , request: "POST http://foo/v1/publish HTTP/1.1", subrequest: "/mysql", upstream: "drizzle://10.102.17.232:3306", host: "foo"

Here's the location:
location /mysql {
internal;
drizzle_pass mysqldb;
drizzle_module_header off;
set_unescape_uri $mysql_query $query_string;
drizzle_query $mysql_query;
rds_json on;
}


Here's the query I'm sending lua and proven via ngx.say(query)
INSERT INTO published SET packages_id=(SELECT id FROM packages WHERE name='infra-package'), sha='6094279b2033a9dfa8bd38cadffeb9d274657936', version='200', path='678459e1ce';

location /addpackage {
internal;
content_by_lua "

local query = <bunch of query building code>

local res = ngx.location.capture('/mysql', { args = query} )
ngx.say(res.status..query)
ngx.say(res.status)

}

ngx_openresty/1.0.6.22

configure
arguments:
--prefix=/usr/local/encap/nginx-resty-1.0.6.22/nginx
--add-module=../ngx_devel_kit-0.2.17
--add-module=../echo-nginx-module-0.37rc4
--add-module=../xss-nginx-module-0.03rc3
--add-module=../set-misc-nginx-module-0.22rc2
--add-module=../form-input-nginx-module-0.07rc5
--add-module=../encrypted-session-nginx-module-0.01
--add-module=../drizzle-nginx-module-0.1.1
--add-module=../ngx_lua-0.3.1rc8
--add-module=../headers-more-nginx-module-0.16rc2
--add-module=../srcache-nginx-module-0.12
--add-module=../array-var-nginx-module-0.03rc1
--add-module=../memc-nginx-module-0.12
--add-module=../redis2-nginx-module-0.07
--add-module=../upstream-keepalive-nginx-module-0.3
--add-module=../auth-request-nginx-module-0.2
--add-module=../rds-json-nginx-module-0.12rc5
--add-module=../rds-csv-nginx-module-0.03
--add-module=/foursquare/david/src/third-party/nginx-gridfs
--add-module=/foursquare/david/src/third-party/nginx_upload_module-2.2.0
--with-http_ssl_module
Subject Author Posted

drizzle-nginx-module error body missing?

dannynoonan October 16, 2011 01:00AM

Re: drizzle-nginx-module error body missing?

agentzh October 16, 2011 01:14AM

Re: drizzle-nginx-module error body missing?

dannynoonan October 16, 2011 01:24AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 64
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready