[JBoss JIRA] (TEIID-4941) [RFE] Display a more informative error message when a query takes too long and times out
by Yuming Zhu (JIRA)
Yuming Zhu created TEIID-4941:
---------------------------------
Summary: [RFE] Display a more informative error message when a query takes too long and times out
Key: TEIID-4941
URL: https://issues.jboss.org/browse/TEIID-4941
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.8
Reporter: Yuming Zhu
Assignee: Steven Hawkins
Priority: Minor
This issue is from our user of RedHat internal pnt-devops Teiid.
Reality
{code:java}$ echo "SOME COMPLICATED QUERY" | psql -h virtualdb.engineering.redhat.com -p 5433 -d public
ERROR: 57014 TEIID30160 The request AXhWh34gdzbY.0 has been cancelled.
DETAIL: org.teiid.jdbc.TeiidSQLException: 57014 TEIID30160 The request AXhWh34gdzbY.0 has been cancelled.
{code}
Expected
{code:java}$ echo "SOME COMPLICATED QUERY" | psql -h virtualdb.engineering.redhat.com -p 5433 -d public
The request AXhWh34gdzbY.0 has been cancelled. The query takes too long/timed out/whatever/resources exhausted
{code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIID-4938) CLI getVDB operation domain mode - result of the operation is not in "result" element
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-4938?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-4938:
-------------------------------------
[~rareddy] It does not try to consolidate, but still, the result is in one "object". So I wonder whether we could restructure it from:
{code:plain}
{"outcome" => "success",
"result" => undefined,
"server-groups" => {...}
}
{code}
to:
{code:plain}
{"outcome" => "success",
"result" => "server-groups" => {...}
}
{code}
Or, are you saying that this is done by WildFly and you cannot affect it?
[~rareddy], [~shawkins] - I am not seeing any particular issue, it's more like UX.
> CLI getVDB operation domain mode - result of the operation is not in "result" element
> -------------------------------------------------------------------------------------
>
> Key: TEIID-4938
> URL: https://issues.jboss.org/browse/TEIID-4938
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.3, 8.12.10.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Minor
>
> If user reads status of VDB in domain mode, result of the operation is not written in the "result" attribute, but in separate attribute. Executing same operation in standalone mode, result is in "result" element.
> {code:plain|title=Domain mode result}
> [domain@localhost:9990 /] /profile=full/subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => undefined,
> "server-groups" => {"main-server-group" => {"host" => {"master" => {
> "server-one" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }},
> "server-two" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }}
> }}}}
> }
> {code}
> {code:plain|title=Standalone mode result}
> [standalone@localhost:9990 /] /subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => {...
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3862.
-----------------------------------
Resolution: Done
excel and hbase are covered.
For everything else I added a generic JDBC section instead of individually documenting hana, hsql, informix, netezza, sybase, and teradata.
odata/odata4 may need more docs under the existing ws docs, but that seems to be somewhat covered for now. We should also upgrade our hive/impala instructions.
> Documentation in kit for certain datasources missing
> ----------------------------------------------------
>
> Key: TEIID-3862
> URL: https://issues.jboss.org/browse/TEIID-3862
> Project: Teiid
> Issue Type: Quality Risk
> Components: Documentation
> Reporter: Ramesh Reddy
> Assignee: Van Halbert
> Fix For: 9.3
>
>
> The following data sources do not have documentation under
> "docs/teiid/datasources"
> where typically a standalone.xml changes and/or CLI scripts are provided.
> access
> hana
> hsql
> informix
> modeshape
> netezza
> sybase
> teradata
> excel
> hbase
> odata
> odata4
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIID-4938) CLI getVDB operation domain mode - result of the operation is not in "result" element
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4938?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4938:
---------------------------------------
Also if using the admin api in domain mode there are issues TEIID-4546 TEIID-4547 and TEIID-4551 that are not in 6.x.
> CLI getVDB operation domain mode - result of the operation is not in "result" element
> -------------------------------------------------------------------------------------
>
> Key: TEIID-4938
> URL: https://issues.jboss.org/browse/TEIID-4938
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.3, 8.12.10.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Minor
>
> If user reads status of VDB in domain mode, result of the operation is not written in the "result" attribute, but in separate attribute. Executing same operation in standalone mode, result is in "result" element.
> {code:plain|title=Domain mode result}
> [domain@localhost:9990 /] /profile=full/subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => undefined,
> "server-groups" => {"main-server-group" => {"host" => {"master" => {
> "server-one" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }},
> "server-two" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }}
> }}}}
> }
> {code}
> {code:plain|title=Standalone mode result}
> [standalone@localhost:9990 /] /subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => {...
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIID-4938) CLI getVDB operation domain mode - result of the operation is not in "result" element
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4938?page=com.atlassian.jira.plugin... ]
Ramesh Reddy edited comment on TEIID-4938 at 6/1/17 9:09 AM:
-------------------------------------------------------------
Because in domain mode, the result is defined per node basis. It does not try to consolidate the results into a unique list. This is by design, this how WildFly collates the results.
What is the issue you are seeing? Note that it is known issue that Designer does not work directly with Domain mode.
was (Author: rareddy):
Because in domain mode, the result is defined per node basis. It does not try to consolidate the results into a unique list.
> CLI getVDB operation domain mode - result of the operation is not in "result" element
> -------------------------------------------------------------------------------------
>
> Key: TEIID-4938
> URL: https://issues.jboss.org/browse/TEIID-4938
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.3, 8.12.10.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Minor
>
> If user reads status of VDB in domain mode, result of the operation is not written in the "result" attribute, but in separate attribute. Executing same operation in standalone mode, result is in "result" element.
> {code:plain|title=Domain mode result}
> [domain@localhost:9990 /] /profile=full/subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => undefined,
> "server-groups" => {"main-server-group" => {"host" => {"master" => {
> "server-one" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }},
> "server-two" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }}
> }}}}
> }
> {code}
> {code:plain|title=Standalone mode result}
> [standalone@localhost:9990 /] /subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => {...
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIID-4938) CLI getVDB operation domain mode - result of the operation is not in "result" element
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4938?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4938:
-------------------------------------
Because in domain mode, the result is defined per node basis. It does not try to consolidate the results into a unique list.
> CLI getVDB operation domain mode - result of the operation is not in "result" element
> -------------------------------------------------------------------------------------
>
> Key: TEIID-4938
> URL: https://issues.jboss.org/browse/TEIID-4938
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.3, 8.12.10.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Minor
>
> If user reads status of VDB in domain mode, result of the operation is not written in the "result" attribute, but in separate attribute. Executing same operation in standalone mode, result is in "result" element.
> {code:plain|title=Domain mode result}
> [domain@localhost:9990 /] /profile=full/subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => undefined,
> "server-groups" => {"main-server-group" => {"host" => {"master" => {
> "server-one" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }},
> "server-two" => {"response" => {
> "outcome" => "success",
> "result" => {...
> }
> }}
> }}}}
> }
> {code}
> {code:plain|title=Standalone mode result}
> [standalone@localhost:9990 /] /subsystem=teiid:get-vdb(...)
> {
> "outcome" => "success",
> "result" => {...
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIID-4939) Enhance translator auto-detect and ddl deployment
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4939?page=com.atlassian.jira.plugin... ]
Kylin Soong resolved TEIID-4939.
--------------------------------
Resolution: Done
> Enhance translator auto-detect and ddl deployment
> --------------------------------------------------
>
> Key: TEIID-4939
> URL: https://issues.jboss.org/browse/TEIID-4939
> Project: Teiid
> Issue Type: Sub-task
> Reporter: Kylin Soong
> Assignee: Kylin Soong
>
> The current translator auto-detect logic: If the translators not configured manually, all class path translator be initialize and started, this enhancement for add a check for translator mapped driver classes or mcf class exist then initialize and start.
> The current ddl deployment only support use configuration way not support via main method parameter, this enhancement add for this.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years