[HAWQ-1135] MADlib: Raising exception leads to database connection termination.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0.0-incubating
• Component/s: Core
• Assignee: Hubert Zhang
• Reporter: Ming Li
• Created: 02/Nov/16 02:11
• Updated: 18/Feb/17 05:27
• Resolved: 22/Dec/16 06:36

Description

MADlib tests on HAWQ 2.0 Nightly builds fails due to server terminating it's connection. The failed tests are testing for bad input by returning an exception on specific user inputs. These exceptions are raised cleanly in other platforms including HAWQ 2.0 and all Greenplum DBs.
Reproduction Steps
Install MADlib using the RPM and HAWQ install script.
Run attached script (called hawq_2.0.1_test.sql)
Current error message is
{{
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
}}
Expected error is
{{
ERROR: spiexceptions.InvalidParameterValue: Function "madlib.lmf_igd_transition(double precision[],integer,integer,double precision,double precision[],integer,integer,integer,double precision,double precision)": Invalid type conversion. Null where not expected.
}}

Issue Links

• links to: GitHub Pull Request #994