[JBoss JIRA] (TEIID-4029) After terminating long running queries remains CPU load > 100% on JBoss java process
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4029?page=com.atlassian.jira.plugin...
]
Kylin Soong updated TEIID-4029:
-------------------------------
Attachment: Case01593403.java
highcpu-vdb.xml
It seems we can reproduce via Embedded, the Batch Processing are suspicious,
{code}
java.lang.Thread.State: RUNNABLE
at
org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:256)
at
org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
at
org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89)
at
org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:405)
at
org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:336)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136)
{code}
it always keep the cpu, never release the process thread.
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, 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)
3683
days inactive
3683
days old
0 comments
1 participants
tags (0)
participants (1)
-
Kylin Soong (JIRA)