[JBoss JIRA] (TEIID-4815) How could I debug JDV memory allocation properly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4815?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4815.
-----------------------------------
Resolution: Done
Marking as done based upon the doc note.
https://teiid.gitbooks.io/documents/content/admin/Diagnosing_Issues.html already generally describes memory issues with drivers and that heap analysis should be used when diagnosing out of memory issues.
> How could I debug JDV memory allocation properly
> ------------------------------------------------
>
> Key: TEIID-4815
> URL: https://issues.jboss.org/browse/TEIID-4815
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Rafael Coutinho
> Assignee: Steven Hawkins
> Attachments: Screenshot from 2017-03-17 17-54-24.png, Screenshot from 2017-03-17 18-14-50.png
>
>
> We hare having trouble with memory allocation on our JDV server (using Red Hat JBoss Data Virtualization - Version 6.3.0) for some reason memory gets allocated but never released.
> For simple queries memory increases just a little, however when we make complex joins etc, we are seeing scenarios with 20GB+ allocated heap.
> I wonder if there is any inspection tool for debugging what is consuming it in JDV.
> Our main datasource is an Oracle DS, but we do have a MariaDB being used too.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4815) How could I debug JDV memory allocation properly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4815?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4815:
----------------------------------
Fix Version/s: 9.3
> How could I debug JDV memory allocation properly
> ------------------------------------------------
>
> Key: TEIID-4815
> URL: https://issues.jboss.org/browse/TEIID-4815
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Rafael Coutinho
> Assignee: Steven Hawkins
> Fix For: 9.3
>
> Attachments: Screenshot from 2017-03-17 17-54-24.png, Screenshot from 2017-03-17 18-14-50.png
>
>
> We hare having trouble with memory allocation on our JDV server (using Red Hat JBoss Data Virtualization - Version 6.3.0) for some reason memory gets allocated but never released.
> For simple queries memory increases just a little, however when we make complex joins etc, we are seeing scenarios with 20GB+ allocated heap.
> I wonder if there is any inspection tool for debugging what is consuming it in JDV.
> Our main datasource is an Oracle DS, but we do have a MariaDB being used too.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4815) How could I debug JDV memory allocation properly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4815?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4815:
----------------------------------
Issue Type: Quality Risk (was: Feature Request)
> How could I debug JDV memory allocation properly
> ------------------------------------------------
>
> Key: TEIID-4815
> URL: https://issues.jboss.org/browse/TEIID-4815
> Project: Teiid
> Issue Type: Quality Risk
> Reporter: Rafael Coutinho
> Assignee: Steven Hawkins
> Fix For: 9.3
>
> Attachments: Screenshot from 2017-03-17 17-54-24.png, Screenshot from 2017-03-17 18-14-50.png
>
>
> We hare having trouble with memory allocation on our JDV server (using Red Hat JBoss Data Virtualization - Version 6.3.0) for some reason memory gets allocated but never released.
> For simple queries memory increases just a little, however when we make complex joins etc, we are seeing scenarios with 20GB+ allocated heap.
> I wonder if there is any inspection tool for debugging what is consuming it in JDV.
> Our main datasource is an Oracle DS, but we do have a MariaDB being used too.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4824) Add unique id as a configuration property in the Google Resource adapter
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-4824:
--------------------------------------
Summary: Add unique id as a configuration property in the Google Resource adapter
Key: TEIID-4824
URL: https://issues.jboss.org/browse/TEIID-4824
Project: Teiid
Issue Type: Enhancement
Affects Versions: 8.12.8.6_3
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Currently, only the google spreadsheet name can be used in the Google Resource adapter instead of the unique id of the document. If there is more than one document with same name in multiple folders the wrong file may be picked up by the resource adapter. Is it possible to use unique document ID instead of spreadsheet name for google data source
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4823) joining 2 procedures results in QueryPlannerException: TEIID30275 Join region with unsatisfied access patterns cannot be satisfied by the join criteria
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-4823?page=com.atlassian.jira.plugin... ]
Bram Gadeyne commented on TEIID-4823:
-------------------------------------
Added plan1 for the first query and plan2 for the second query (which results in the error).
> joining 2 procedures results in QueryPlannerException: TEIID30275 Join region with unsatisfied access patterns cannot be satisfied by the join criteria
> --------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-4823
> URL: https://issues.jboss.org/browse/TEIID-4823
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.1.4
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Attachments: plan1.txt, plan2.txt
>
>
> I have a query like this where I join a regular table with a virtual procedure.
>
> {code:sql}
> select gd.patientid, ip.production
> from prod_P_GeneralData gd
> join pr_patient_in_production ip on ip.patientid = gd.patientid
> where gd.status = 1;
> {code}
>
> This works fine and returns 58 rows with no null values. The pr_patient_in_production procedure has 1 input parameter called patientid (integer) and one output parameter called production (boolean)
>
> Adding a second procedure call results in an excepion:
>
> {code:sql}
> select gd.patientid, lrs.datetime, lrs.varvalue as phtype
> from prod_P_GeneralData gd
> join pr_patient_in_production ip on ip.patientid = gd.patientid
> join pr_retrieve_labres lrs on
> lrs.patientid_in = gd.patientid
> and lrs.production = ip.production
> and lrs.resultgroup_in = 'pH-type'
> and lrs.varvalue = 1
> where gd.status = 1
> order by lrs.datetime, lrs.entertime desc
> {code}
>
> This pr_retrieve_labres procedure has patientid_in (integer), production (boolean) and resultgroup_in(string) as input parameters and also some output parameters.
>
> The exception is: Error: TEIID30275 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30275 Join region with unsatisfied access patterns cannot be satisfied by the join criteria, Access patterns: [[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], [Access Pattern: Unsatisfied [lrs.production, lrs.patientid_in] History [[lrs.patientid_in, lrs.production, lrs.resultgroup_in]]]]
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months