[teiid-issues] [JBoss JIRA] (TEIID-4029) After terminating long running queries remains CPU load > 100% on JBoss java process

[Kylin Soong (JIRA)]

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

Kylin Soong updated TEIID-4029:
-------------------------------
    Attachment: heap.1
                heap.2
                heap.3
                heap.4
                heap.5


High cpu thread nid is 0x2e9f, all 5 heap are collected sequentially with a time interval.

> After terminating long running queries remains CPU load > 100% on JBoss java process
> ------------------------------------------------------------------------------------
>
>                 Key: TEIID-4029
>                 URL: https://issues.jboss.org/browse/TEIID-4029
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 8.7.4
>            Reporter: Colin Mondesir
>            Assignee: Steven Hawkins
>             Fix For: 8.12.x
>
>         Attachments: Archive.zip, Case01593403.java, heap.1, heap.2, heap.3, heap.4, heap.5, highcpu-vdb.xml
>
>
> Once the request is submitted the CPU% load on the server remains > 100% despite cancelling the request and terminating the session. The only way I have found to bring the %CPU back to "normal" is to re-start the JDV instance.
> 1. Created two files file1.csv (1M rows) and file2.csv (1M rows)
> 2. Created two source and view models and VDB
> SQL statement is a carthesion product
> 3. Deploy VDB
> 4. select * from combinedcsv from SQL scrapbook on cancelLongRunningQueries VDB
> 5. Goto admin console 
> 6. Go to the cancelLongRunningQueries VDB
> 7. Goto tab Requests and select Terminate
> 8. Goto tab Sessions and select Terminate JDBC session
> 9. CPU% load on JBoss java process remains > 100%



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)