[JBoss JIRA] Created: (TEIID-1023) Chanage "MaxResultRows" Connector Property to default to "unlimited"
by Ramesh Reddy (JIRA)
Chanage "MaxResultRows" Connector Property to default to "unlimited"
--------------------------------------------------------------------
Key: TEIID-1023
URL: https://jira.jboss.org/jira/browse/TEIID-1023
Project: Teiid
Issue Type: Task
Components: Connector API
Reporter: Ramesh Reddy
Fix For: 7.0
Teiid supports a property called "MaxResultRows" in Connector
properties, which defaults to 10,000 rows. The expected behavior of this
is to throw an exception when user queries more than 10,000 rows through
this connector.
However, this default behavior seems like a exceptional condition than
normal behavior expected by user any time. This *was* designed more for
the development time aid than the runtime.
Here is an example of community user tripping over it.
http://community.jboss.org/message/532560#532560
I propose, we change the default value of this property to "-1" that
means the "MaxResultRows" will be set to "unlimited" in the default
scenario. If user requires to restrict max rows they can *explicitly*
set a value that they are comfortable with.
Note the default "unlimited" is value changed from "0" to "-1".
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 6 months
[JBoss JIRA] Created: (TEIID-465) Error message in server process log refers to binding by UUID, not name
by Paul Nittel (JIRA)
Error message in server process log refers to binding by UUID, not name
-----------------------------------------------------------------------
Key: TEIID-465
URL: https://jira.jboss.org/jira/browse/TEIID-465
Project: Teiid
Issue Type: Bug
Components: Server
Environment: RHEL 5, MetaMatrix 5.5.3
Reporter: Paul Nittel
Assignee: Steven Hawkins
While examining the MMProcess log file (NIAP CCE testing), I noticed these errors. They won't help a user/administrator since they don't refer to the connector bindings by name.
Apr 03, 2009 16:12:34.228 [SocketWorkerQueue_Worker_24|0] ERROR <DQP|0> Received exception processing request:
com.metamatrix.api.exception.MetaMatrixComponentException[0]: Cannot find service instance of type <mmuuid:6d252400-1ffb-1131-b913-ad41f8c5e080>ServiceSelectionPolicy: ROUND_ROBIN_LOCAL_SELECTION_POLICY: No services found.
at com.metamatrix.platform.service.proxy.ServiceProxy.getNextInstance(ServiceProxy.java:89)
at com.metamatrix.platform.service.proxy.SingleInvokationProxy.invoke(SingleInvokationProxy.java:49)
at $Proxy12.getConnectorID(Unknown Source)
at com.metamatrix.server.connector.comm.ConnectorResourceFinder.findResources(ConnectorResourceFinder.java:66)
at com.metamatrix.server.connector.comm.ConnectorServerConnection.selectServerInstance(ConnectorServerConnection.java:73)
at com.metamatrix.server.dqp.service.PlatformDataService.selectConnector(PlatformDataService.java:72)
at com.metamatrix.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:41)
at com.metamatrix.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:47)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.loadCapabilities(CriteriaCapabilityValidatorVisitor.java:72)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.<init>(CriteriaCapabilityValidatorVisitor.java:62)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.canPushLanguageObject(CriteriaCapabilityValidatorVisitor.java:547)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.canPushSymbol(RuleRaiseAccess.java:633)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.raiseAccessNode(RuleRaiseAccess.java:123)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.execute(RuleRaiseAccess.java:69)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:487)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:122)
at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:222)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:196)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:179)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:106)
at com.metamatrix.dqp.internal.process.Request.initProcessPlan(Request.java:790)
at com.metamatrix.dqp.internal.process.Request.generatePlan(Request.java:684)
at com.metamatrix.dqp.internal.process.Request.processRequest(Request.java:832)
at com.metamatrix.dqp.internal.process.DQPCore.processRequestMessage(DQPCore.java:304)
at com.metamatrix.dqp.internal.process.MessageHandler.process(MessageHandler.java:92)
at com.metamatrix.dqp.message.RequestMessage.process(RequestMessage.java:479)
at com.metamatrix.dqp.internal.process.MessageHandler.processMessage(MessageHandler.java:64)
at com.metamatrix.dqp.internal.process.DQPCore.process(DQPCore.java:268)
at com.metamatrix.dqp.internal.application.DQPComponent.processInternal(DQPComponent.java:119)
at com.metamatrix.dqp.internal.application.DQPComponent.access$000(DQPComponent.java:48)
at com.metamatrix.dqp.internal.application.DQPComponent$InternalServerListener.receive(DQPComponent.java:196)
at com.metamatrix.dqp.internal.application.DQPComponent.receive(DQPComponent.java:263)
at com.metamatrix.server.query.service.QueryServiceEngine.receive(QueryServiceEngine.java:498)
at com.metamatrix.common.comm.platform.server.FilteringMessageServiceAgent.receive(FilteringMessageServiceAgent.java:40)
at com.metamatrix.common.comm.platform.server.MessageFilterServiceAgent.receive(MessageFilterServiceAgent.java:81)
at com.metamatrix.platform.admin.apiimpl.RuntimeStateListenerAgent.receive(RuntimeStateListenerAgent.java:90)
at com.metamatrix.common.comm.platform.socket.SocketVMController.receive(SocketVMController.java:377)
at com.metamatrix.common.comm.platform.socket.server.ServerAsynchronousWorkItem.process(ServerAsynchronousWorkItem.java:35)
at com.metamatrix.common.comm.platform.socket.server.SocketServerWorker.process(SocketServerWorker.java:41)
at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
Caused by: ServiceSelectionPolicy: ROUND_ROBIN_LOCAL_SELECTION_POLICY: No services found.
at com.metamatrix.platform.service.proxy.RoundRobinLocalSelectionPolicy.getNextInstance(RoundRobinLocalSelectionPolicy.java:105)
at com.metamatrix.platform.service.proxy.ServiceProxy.getNextInstance(ServiceProxy.java:84)
at com.metamatrix.platform.service.proxy.SingleInvokationProxy.invoke(SingleInvokationProxy.java:49)
at $Proxy12.getConnectorID(Unknown Source)
at com.metamatrix.server.connector.comm.ConnectorResourceFinder.findResources(ConnectorResourceFinder.java:66)
at com.metamatrix.server.connector.comm.ConnectorServerConnection.selectServerInstance(ConnectorServerConnection.java:73)
at com.metamatrix.server.dqp.service.PlatformDataService.selectConnector(PlatformDataService.java:72)
at com.metamatrix.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:41)
at com.metamatrix.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:47)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.loadCapabilities(CriteriaCapabilityValidatorVisitor.java:72)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.<init>(CriteriaCapabilityValidatorVisitor.java:62)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.canPushLanguageObject(CriteriaCapabilityValidatorVisitor.java:547)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.canPushSymbol(RuleRaiseAccess.java:633)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.raiseAccessNode(RuleRaiseAccess.java:123)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.execute(RuleRaiseAccess.java:69)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:487)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:122)
at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:222)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:196)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:179)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:106)
at com.metamatrix.dqp.internal.process.Request.initProcessPlan(Request.java:790)
at com.metamatrix.dqp.internal.process.Request.generatePlan(Request.java:684)
at com.metamatrix.dqp.internal.process.Request.processRequest(Request.java:832)
at com.metamatrix.dqp.internal.process.DQPCore.processRequestMessage(DQPCore.java:304)
at com.metamatrix.dqp.internal.process.MessageHandler.process(MessageHandler.java:92)
at com.metamatrix.dqp.message.RequestMessage.process(RequestMessage.java:479)
at com.metamatrix.dqp.internal.process.MessageHandler.processMessage(MessageHandler.java:64)
at com.metamatrix.dqp.internal.process.DQPCore.process(DQPCore.java:268)
at com.metamatrix.dqp.internal.application.DQPComponent.processInternal(DQPComponent.java:119)
at com.metamatrix.dqp.internal.application.DQPComponent.access$000(DQPComponent.java:48)
at com.metamatrix.dqp.internal.application.DQPComponent$InternalServerListener.receive(DQPComponent.java:196)
at com.metamatrix.dqp.internal.application.DQPComponent.receive(DQPComponent.java:263)
at com.metamatrix.server.query.service.QueryServiceEngine.receive(QueryServiceEngine.java:498)
at com.metamatrix.common.comm.platform.server.FilteringMessageServiceAgent.receive(FilteringMessageServiceAgent.java:40)
at com.metamatrix.common.comm.platform.server.MessageFilterServiceAgent.receive(MessageFilterServiceAgent.java:81)
at com.metamatrix.platform.admin.apiimpl.RuntimeStateListenerAgent.receive(RuntimeStateListenerAgent.java:90)
at com.metamatrix.common.comm.platform.socket.SocketVMController.receive(SocketVMController.java:377)
at com.metamatrix.common.comm.platform.socket.server.ServerAsynchronousWorkItem.process(ServerAsynchronousWorkItem.java:35)
at com.metamatrix.common.comm.platform.socket.server.SocketServerWorker.process(SocketServerWorker.java:41)
at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
Apr 03, 2009 16:12:34.228 [SocketWorkerQueue_Worker_24|0.1] ERROR <com.metamatrix.core|0> Cannot find service instance of type <mmuuid:6d252400-1ffb-1131-b913-ad41f8c5e080>
Cannot find service instance of type <mmuuid:6d252400-1ffb-1131-b913-ad41f8c5e080>ServiceSelectionPolicy: ROUND_ROBIN_LOCAL_SELECTION_POLICY: No services found.
at com.metamatrix.platform.service.proxy.ServiceProxy.getNextInstance(ServiceProxy.java:89)
at com.metamatrix.platform.service.proxy.SingleInvokationProxy.invoke(SingleInvokationProxy.java:49)
at $Proxy12.getConnectorID(Unknown Source)
at com.metamatrix.server.connector.comm.ConnectorResourceFinder.findResources(ConnectorResourceFinder.java:66)
at com.metamatrix.server.connector.comm.ConnectorServerConnection.selectServerInstance(ConnectorServerConnection.java:73)
at com.metamatrix.server.dqp.service.PlatformDataService.selectConnector(PlatformDataService.java:72)
at com.metamatrix.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:41)
at com.metamatrix.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:47)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.loadCapabilities(CriteriaCapabilityValidatorVisitor.java:72)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.<init>(CriteriaCapabilityValidatorVisitor.java:62)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.canPushLanguageObject(CriteriaCapabilityValidatorVisitor.java:547)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.canPushSymbol(RuleRaiseAccess.java:633)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.raiseAccessNode(RuleRaiseAccess.java:123)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.execute(RuleRaiseAccess.java:69)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:487)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:122)
at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:222)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:196)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:179)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:106)
at com.metamatrix.dqp.internal.process.Request.initProcessPlan(Request.java:790)
at com.metamatrix.dqp.internal.process.Request.generatePlan(Request.java:684)
at com.metamatrix.dqp.internal.process.Request.processRequest(Request.java:832)
at com.metamatrix.dqp.internal.process.DQPCore.processRequestMessage(DQPCore.java:304)
at com.metamatrix.dqp.internal.process.MessageHandler.process(MessageHandler.java:92)
at com.metamatrix.dqp.message.RequestMessage.process(RequestMessage.java:479)
at com.metamatrix.dqp.internal.process.MessageHandler.processMessage(MessageHandler.java:64)
at com.metamatrix.dqp.internal.process.DQPCore.process(DQPCore.java:268)
at com.metamatrix.dqp.internal.application.DQPComponent.processInternal(DQPComponent.java:119)
at com.metamatrix.dqp.internal.application.DQPComponent.access$000(DQPComponent.java:48)
at com.metamatrix.dqp.internal.application.DQPComponent$InternalServerListener.receive(DQPComponent.java:196)
at com.metamatrix.dqp.internal.application.DQPComponent.receive(DQPComponent.java:263)
at com.metamatrix.server.query.service.QueryServiceEngine.receive(QueryServiceEngine.java:498)
at com.metamatrix.common.comm.platform.server.FilteringMessageServiceAgent.receive(FilteringMessageServiceAgent.java:40)
at com.metamatrix.common.comm.platform.server.MessageFilterServiceAgent.receive(MessageFilterServiceAgent.java:81)
at com.metamatrix.platform.admin.apiimpl.RuntimeStateListenerAgent.receive(RuntimeStateListenerAgent.java:90)
at com.metamatrix.common.comm.platform.socket.SocketVMController.receive(SocketVMController.java:377)
at com.metamatrix.common.comm.platform.socket.server.ServerAsynchronousWorkItem.process(ServerAsynchronousWorkItem.java:35)
at com.metamatrix.common.comm.platform.socket.server.SocketServerWorker.process(SocketServerWorker.java:41)
at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
Caused by: ServiceSelectionPolicy: ROUND_ROBIN_LOCAL_SELECTION_POLICY: No services found.
at com.metamatrix.platform.service.proxy.RoundRobinLocalSelectionPolicy.getNextInstance(RoundRobinLocalSelectionPolicy.java:105)
at com.metamatrix.platform.service.proxy.ServiceProxy.getNextInstance(ServiceProxy.java:84)
at com.metamatrix.platform.service.proxy.SingleInvokationProxy.invoke(SingleInvokationProxy.java:49)
at $Proxy12.getConnectorID(Unknown Source)
at com.metamatrix.server.connector.comm.ConnectorResourceFinder.findResources(ConnectorResourceFinder.java:66)
at com.metamatrix.server.connector.comm.ConnectorServerConnection.selectServerInstance(ConnectorServerConnection.java:73)
at com.metamatrix.server.dqp.service.PlatformDataService.selectConnector(PlatformDataService.java:72)
at com.metamatrix.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:41)
at com.metamatrix.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:47)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.loadCapabilities(CriteriaCapabilityValidatorVisitor.java:72)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.<init>(CriteriaCapabilityValidatorVisitor.java:62)
at com.metamatrix.query.optimizer.relational.rules.CriteriaCapabilityValidatorVisitor.canPushLanguageObject(CriteriaCapabilityValidatorVisitor.java:547)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.canPushSymbol(RuleRaiseAccess.java:633)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.raiseAccessNode(RuleRaiseAccess.java:123)
at com.metamatrix.query.optimizer.relational.rules.RuleRaiseAccess.execute(RuleRaiseAccess.java:69)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:487)
at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:122)
at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:222)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:196)
at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:179)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:106)
at com.metamatrix.dqp.internal.process.Request.initProcessPlan(Request.java:790)
at com.metamatrix.dqp.internal.process.Request.generatePlan(Request.java:684)
at com.metamatrix.dqp.internal.process.Request.processRequest(Request.java:832)
at com.metamatrix.dqp.internal.process.DQPCore.processRequestMessage(DQPCore.java:304)
at com.metamatrix.dqp.internal.process.MessageHandler.process(MessageHandler.java:92)
at com.metamatrix.dqp.message.RequestMessage.process(RequestMessage.java:479)
at com.metamatrix.dqp.internal.process.MessageHandler.processMessage(MessageHandler.java:64)
at com.metamatrix.dqp.internal.process.DQPCore.process(DQPCore.java:268)
at com.metamatrix.dqp.internal.application.DQPComponent.processInternal(DQPComponent.java:119)
at com.metamatrix.dqp.internal.application.DQPComponent.access$000(DQPComponent.java:48)
at com.metamatrix.dqp.internal.application.DQPComponent$InternalServerListener.receive(DQPComponent.java:196)
at com.metamatrix.dqp.internal.application.DQPComponent.receive(DQPComponent.java:263)
at com.metamatrix.server.query.service.QueryServiceEngine.receive(QueryServiceEngine.java:498)
at com.metamatrix.common.comm.platform.server.FilteringMessageServiceAgent.receive(FilteringMessageServiceAgent.java:40)
at com.metamatrix.common.comm.platform.server.MessageFilterServiceAgent.receive(MessageFilterServiceAgent.java:81)
at com.metamatrix.platform.admin.apiimpl.RuntimeStateListenerAgent.receive(RuntimeStateListenerAgent.java:90)
at com.metamatrix.common.comm.platform.socket.SocketVMController.receive(SocketVMController.java:377)
at com.metamatrix.common.comm.platform.socket.server.ServerAsynchronousWorkItem.process(ServerAsynchronousWorkItem.java:35)
at com.metamatrix.common.comm.platform.socket.server.SocketServerWorker.process(SocketServerWorker.java:41)
at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
Apr 03, 2009 16:12:34.269 [SocketWorkerQueue_Worker_24|0] INFO <AUDIT_ADMIN|0> Administrator [metamatrixadmin], session [2888] requesting access which requires role [Admin.ProductAdmin] to method [synchronizeSystem].
Apr 03, 2009 16:12:34.269 [SocketWorkerQueue_Worker_24|0] INFO <AUDIT_ADMIN|0> Administrator [metamatrixadmin], session [2888] granted access to method [synchronizeSystem].
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 7 months