| Summary: | After terminating long running queries remains CPU load > 100% on JBoss java process | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Colin Mondesir <cmondesi> | ||||
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Filip Elias <felias> | ||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.2.0 | CC: | aszczucz, blafond, jdurani, jolee, mbaluch, thauser, vhalbert | ||||
| Target Milestone: | ER1 | Flags: | jdurani:
needinfo?
(vhalbert) |
||||
| Target Release: | 6.3.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2016-08-24 11:47:10 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Attachments: |
|
||||||
Is this issue fixed in 6.3.0? I can see that last commit in JIRA is "Revert". |
Created attachment 1133821 [details] reproducer 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%