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

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-4029.
---------------------------------
    Resolution: Done


> 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
>         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
(v7.2.2#72004)