[HAWQ-133] core when use plpython udf

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Affects Version/s: 2.0.0.0-incubating
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Core
• Assignee: Ruilong Huo
• Reporter: Dong Li
• Created: 06/Nov/15 04:43
• Updated: 14/Jul/16 17:57
• Resolved: 14/Jul/16 17:57

Description

Run sqls below can recur the core.

CREATE PROCEDURAL LANGUAGE plpythonu;

CREATE TABLE users (
	fname text not null,
	lname text not null,
	username text,
	userid serial
	-- , PRIMARY KEY(lname, fname) 
	) DISTRIBUTED BY (userid);

INSERT INTO users (fname, lname, username) VALUES ('jane', 'doe', 'j_doe');
INSERT INTO users (fname, lname, username) VALUES ('john', 'doe', 'johnd');
INSERT INTO users (fname, lname, username) VALUES ('willem', 'doe', 'w_doe');
INSERT INTO users (fname, lname, username) VALUES ('rick', 'smith', 'slash');

CREATE FUNCTION spi_prepared_plan_test_one(a text) RETURNS text
	AS
'if not SD.has_key("myplan"):
	q = "SELECT count(*) FROM users WHERE lname = $1"
	SD["myplan"] = plpy.prepare(q, [ "text" ])
try:
	rv = plpy.execute(SD["myplan"], [a])
	return "there are " + str(rv[0]["count"]) + " " + str(a) + "s"
except Exception, ex:
	plpy.error(str(ex))
return None
'
	LANGUAGE plpythonu;

select spi_prepared_plan_test_one('doe');

select spi_prepared_plan_test_one('smith');

when execute "select spi_prepared_plan_test_one('smith');"
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

Issue Links

• is duplicated by: HAWQ-328 plsql loop three times exit abnormality
• is related to: HAWQ-412 Allocate query resource for multiple EXECUTIONs in explicit and implicit prepared statement
• is related to: MADLIB-960 Test MADlib on HAWQ 2.0 beta build