[teiid-issues] [JBoss JIRA] Resolved: (TEIID-936) Query never returns from processing

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-936.
----------------------------------

    Fix Version/s: 7.0
       Resolution: Done


Timeslice expiration was throwing just a blocked exception, which was not picked up appropriately by the requestworkitem.

> Query never returns from processing
> -----------------------------------
>
>                 Key: TEIID-936
>                 URL: https://jira.jboss.org/jira/browse/TEIID-936
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.0
>         Environment: fedora 12, Teiid build 1/19/2010, OpenJDK Server VM (build 14.0-b16, mixed mode)
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>             Fix For: 7.0
>
>         Attachments: TextMetadataTesting.zip, TpcrTest.vdb
>
>
> I'm executing TPCR Query #16. It processes correctly, and very quickly, in Designer, which is using an older Teiid query engine. The current Teiid, running via AdminShell, never returns from this query. Both are using the same VDB.
> Two tables are involved PART (200,000 rows) and PARTSUPP (800,000 rows). The output will contain 18,314 rows.
> The transformation query is:
> SELECT 
> 		P_BRAND, P_TYPE, P_SIZE, COUNT(DISTINCT PS_SUPPKEY) AS supplier_cnt 
> FROM 
> 		TPCR.PARTSUPP, TPCR.PART 
> WHERE 
> 		(P_PARTKEY = PS_PARTKEY) AND (P_BRAND <> 'Brand#45') AND (P_TYPE NOT LIKE 'MEDIUM POLISHED%') AND (P_SIZE IN (49, 14, 23, 45, 19, 3, 36, 9)) AND (PS_SUPPKEY NOT IN (SELECT S_SUPPKEY FROM TPCR.SUPPLIER WHERE S_COMMENT LIKE '%Customer%Complaints%')) 
> GROUP BY P_BRAND, P_TYPE, P_SIZE
> The query being executed is: select * from vTpcr.Q16 ORDER BY supplier_cnt desc, p_brand, p_type, p_size
> I have tried to execute shorter version of the transformation query in AdminShell to no avail. This query: SELECT P_BRAND, P_TYPE, P_SIZE FROM TPCR.PARTSUPP, TPCR.PART WHERE (P_PARTKEY = PS_PARTKEY) AND (P_BRAND <> 'Brand#45') AND (P_TYPE NOT LIKE 'MEDIUM POLISHED%'); did not return in a reasonable time. 
> Teiid seems to use a fair percentage of the CPU for a while, then usage drops to ~0.1%

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira