[JBoss JIRA] (TEIIDSB-70) Example takes too long to start
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-70?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIIDSB-70.
-----------------------------------
Resolution: Done
Upping the cpu limit on my local system consistently brings the app up in about a minute (from the first spring log to the last). With the old limit the app would routinely fail readiness and liveliness probes and therefore take several start attempts.
We should probably also consider making the initial probe delays longer (as long as we have metadata loading at start time).
> Example takes too long to start
> -------------------------------
>
> Key: TEIIDSB-70
> URL: https://issues.jboss.org/browse/TEIIDSB-70
> Project: Teiid Spring Boot
> Issue Type: Quality Risk
> Components: examples
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 1.1.0
>
>
> We are setting the container cpu limit very low. We should probably follow the syndesis integration template: https://github.com/syndesisio/syndesis/blob/720dbc5e32b200299535bcfe0cafb...
> Also it appears that the deployment strategy resource limits are not being used, but that's a non-issue currently.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIIDSB-69) The example fails to deploy
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-69?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIIDSB-69.
-----------------------------------
Fix Version/s: 1.1.0
Resolution: Done
The example is now forced to use the same name as the image with the deployment config. This means that the label will include -SNAPSHOT if we're on a snapshot version.
Another way to address this would be to see how the deploymentconfig could be slimmed down such that the image references would be auto-generated.
> The example fails to deploy
> ---------------------------
>
> Key: TEIIDSB-69
> URL: https://issues.jboss.org/browse/TEIIDSB-69
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: examples
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 1.1.0
>
>
> Starting with a fresh install of minishift using 3.10 or 3.11 and running the rdbms example, it won't come up and a manual deployment will show:
> Reason: cannot trigger a deployment for "rdbms-example" because it contains unresolved images
> This appears to be because the deployment config references teiid-dataservice/rdbms-example:1.1.0-SNAPSHOT, but only latest exists.
> This is due to the last commit that updated the versions. Apparently fabric8 will not create a label based upon a snapshot version.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIID-5720) PSQL client fails to report the metadata
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5720:
---------------------------------------
> This used to work
It would be related to the widenComparisonToString property - although this is a somewhat different case that it was intended to address.
This is asymmetrically with an IN predicate - char_col in ('') will fail, but '' in (char_col) is allowed to succeed. Using equality criteria either direction fails. So that inconsistency needs to be addressed at a minimum.
The expected behavior from a pg perspective is to treat comparing '' to a blank fixed char as equal. We need to make a special allowance in the resolver logic to accept the implicit conversion of '' to ' ' char(1).
> PSQL client fails to report the metadata
> ----------------------------------------
>
> Key: TEIID-5720
> URL: https://issues.jboss.org/browse/TEIID-5720
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Major
>
> When using psql client and issuing the "\dt" command I see this exception instead of returning the table names.
> {code}
> WARN: TEIID30020 Processing exception for request grF9mx6fyMfD.1 'TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.'. Originally QueryResolverException ResolverUtil.java:230.
> org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.
> at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:230)
> at org.teiid.query.resolver.util.ResolverVisitor.resolveSetCriteria(ResolverVisitor.java:1203)
> at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:294)
> at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:229)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:345)
> at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135)
> at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:231)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:244)
> at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:66)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:178)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:120)
> at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:282)
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:418)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:834)
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIID-5720) PSQL client fails to report the metadata
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5720:
-------------------------------------
This used to work, I used it many times before. I issued a \dt call, which lists the available tables. I did not check with WildFly version.
> PSQL client fails to report the metadata
> ----------------------------------------
>
> Key: TEIID-5720
> URL: https://issues.jboss.org/browse/TEIID-5720
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Major
>
> When using psql client and issuing the "\dt" command I see this exception instead of returning the table names.
> {code}
> WARN: TEIID30020 Processing exception for request grF9mx6fyMfD.1 'TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.'. Originally QueryResolverException ResolverUtil.java:230.
> org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.
> at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:230)
> at org.teiid.query.resolver.util.ResolverVisitor.resolveSetCriteria(ResolverVisitor.java:1203)
> at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:294)
> at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:229)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:345)
> at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135)
> at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:231)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:244)
> at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:66)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:178)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:120)
> at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:282)
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:418)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:834)
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIID-5720) PSQL client fails to report the metadata
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5720:
---------------------------------------
Can you provide more context? What query is this happening on? Are there other issues - given that we haven't specifically targeted psql for support it's likely that there could be other issues.
It looks like this would occur with char_col in ('')
char for Teiid is effectively char(1). The complaint is based upon the conversion of '' to char is ' ', which is different than '', so it doesn't think that the implicit conversion is valid. Probably the best thing to do would be to avoid the char type - but that is being used on several of the pg_catalog columns.
> PSQL client fails to report the metadata
> ----------------------------------------
>
> Key: TEIID-5720
> URL: https://issues.jboss.org/browse/TEIID-5720
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Major
>
> When using psql client and issuing the "\dt" command I see this exception instead of returning the table names.
> {code}
> WARN: TEIID30020 Processing exception for request grF9mx6fyMfD.1 'TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.'. Originally QueryResolverException ResolverUtil.java:230.
> org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.
> at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:230)
> at org.teiid.query.resolver.util.ResolverVisitor.resolveSetCriteria(ResolverVisitor.java:1203)
> at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:294)
> at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:229)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:345)
> at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135)
> at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:231)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:244)
> at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:66)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:178)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:120)
> at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:282)
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:418)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:834)
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months
[JBoss JIRA] (TEIIDSB-69) The example fails to deploy
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-69?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIIDSB-69:
-------------------------------------
Van created the stable branch that should point to the non-snapshot versions
> The example fails to deploy
> ---------------------------
>
> Key: TEIIDSB-69
> URL: https://issues.jboss.org/browse/TEIIDSB-69
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: examples
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
>
> Starting with a fresh install of minishift using 3.10 or 3.11 and running the rdbms example, it won't come up and a manual deployment will show:
> Reason: cannot trigger a deployment for "rdbms-example" because it contains unresolved images
> This appears to be because the deployment config references teiid-dataservice/rdbms-example:1.1.0-SNAPSHOT, but only latest exists.
> This is due to the last commit that updated the versions. Apparently fabric8 will not create a label based upon a snapshot version.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 8 months