dynamobi/dynamobi — Issue #552: [FRG-320] When statement containing a UDX invocation is cancelled, UDX producer thread is left hanging around
Author: dynamobi-build
Created: 2011-12-30 03:34:57+00:00
State: open
Labels: FRG, Runtime

[reporter="jvs", created="Sat, 17 May 2008 21:40:35 -0500 (GMT-05:00)"]
Execute the script below, and once the select is sleeping, use Control-C from sqlline to cancel. (Or use client/server and use another client to kill_stmt.) Then dump threads, and you'll see the UDX producer daemon thread still hanging around.

create schema udftest;

set schema 'udftest';

set path 'udftest';

create function ramp(n int)

returns table(i int)

language java

parameter style system defined java

no sql

external name 'class net.sf.farrago.test.FarragoTestUDR.ramp';

select sys_boot.mgmt.sleep(50000)

from table(ramp(10000000));