15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for deployment-scanner subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for ee subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for ejb3 subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for infinispan subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for jaxrs subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for jca subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for jdr subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for jmx subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for jpa subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for jsf subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for mail subsystem RUNTIME stage boot operations 15:08:13,379 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for naming subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for pojo subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for remoting subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for resource-adapters subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for sar subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for security subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for threads subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for transactions subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for web subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for webservices subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for weld subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for modeshape subsystem RUNTIME stage boot operations 15:08:13,380 DEBUG [org.jboss.as.controller.management-operation] (Controller Boot Thread) Committed transaction for teiid subsystem RUNTIME stage boot operations 15:08:13,415 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management 15:08:13,415 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990 15:08:13,415 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss Red Hat JBoss Data Virtualization 6.2.0 (AS 7.5.0.Final-redhat-21) started in 19412ms - Started 1891 of 1937 services (210 services are lazy, passive or on-demand) 15:08:40,686 INFO [org.teiid.PLANNER] (Worker0_QueryProcessorQueue0) ============================================================================ USER COMMAND: SELECT BQT1.smallA.CharValue FROM BQT1.smallA WHERE BQT1.smallA.CharValue < '1' ---------------------------------------------------------------------------- OPTIMIZE: SELECT BQT1.smallA.CharValue FROM BQT1.smallA WHERE BQT1.smallA.CharValue < '1' ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT BQT1.smallA.CharValue FROM BQT1.smallA WHERE BQT1.smallA.CharValue < '1' CANONICAL PLAN: Project(groups=[BQT1.smallA], props={PROJECT_COLS=[BQT1.smallA.CharValue]}) Select(groups=[BQT1.smallA], props={SELECT_CRITERIA=BQT1.smallA.CharValue < '1'}) Source(groups=[BQT1.smallA], props={NESTED_COMMAND=SELECT c.intKey, c.intNum, c.doubleNum, c.objectValue, c.bigDecimalValue AS expr5, c.bigIntegerValue AS expr6, c.charValue AS expr7, c.stringNum, c.stringKey, c.floatNum, c.longNum, c.timeValue, c.shortValue AS expr13, c.byteNum AS expr14, c.timeStampValue AS expr15, c.booleanValue, c.dateValue FROM smallARemotecache AS c, SYMBOL_MAP={BQT1.smallA.IntKey=c.intKey, BQT1.smallA.IntNum=c.intNum, BQT1.smallA.DoubleNum=c.doubleNum, BQT1.smallA.ObjectValue=c.objectValue, BQT1.smallA.BigDecimalValue=c.bigDecimalValue, BQT1.smallA.BigIntegerValue=c.bigIntegerValue, BQT1.smallA.CharValue=c.charValue, BQT1.smallA.StringNum=c.stringNum, BQT1.smallA.StringKey=c.stringKey, BQT1.smallA.FloatNum=c.floatNum, BQT1.smallA.LongNum=c.longNum, BQT1.smallA.TimeValue=c.timeValue, BQT1.smallA.ShortValue=c.shortValue, BQT1.smallA.ByteNum=c.byteNum, BQT1.smallA.TimeStampValue=c.timeStampValue, BQT1.smallA.booleanValue=c.booleanValue, BQT1.smallA.DateValue=c.dateValue}}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.intKey, c.intNum, c.doubleNum, c.objectValue, c.bigDecimalValue AS expr5, c.bigIntegerValue AS expr6, c.charValue AS expr7, c.stringNum, c.stringKey, c.floatNum, c.longNum, c.timeValue, c.shortValue AS expr13, c.byteNum AS expr14, c.timeStampValue AS expr15, c.booleanValue, c.dateValue]}) Source(groups=[smallARemotecache AS c]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[BQT1.smallA], props={PROJECT_COLS=[BQT1.smallA.CharValue]}) Select(groups=[BQT1.smallA], props={SELECT_CRITERIA=BQT1.smallA.CharValue < '1'}) Source(groups=[BQT1.smallA], props={NESTED_COMMAND=SELECT c.intKey, c.intNum, c.doubleNum, c.objectValue, c.bigDecimalValue AS expr5, c.bigIntegerValue AS expr6, c.charValue AS expr7, c.stringNum, c.stringKey, c.floatNum, c.longNum, c.timeValue, c.shortValue AS expr13, c.byteNum AS expr14, c.timeStampValue AS expr15, c.booleanValue, c.dateValue FROM smallARemotecache AS c, SYMBOL_MAP={BQT1.smallA.IntKey=c.intKey, BQT1.smallA.IntNum=c.intNum, BQT1.smallA.DoubleNum=c.doubleNum, BQT1.smallA.ObjectValue=c.objectValue, BQT1.smallA.BigDecimalValue=c.bigDecimalValue, BQT1.smallA.BigIntegerValue=c.bigIntegerValue, BQT1.smallA.CharValue=c.charValue, BQT1.smallA.StringNum=c.stringNum, BQT1.smallA.StringKey=c.stringKey, BQT1.smallA.FloatNum=c.floatNum, BQT1.smallA.LongNum=c.longNum, BQT1.smallA.TimeValue=c.timeValue, BQT1.smallA.ShortValue=c.shortValue, BQT1.smallA.ByteNum=c.byteNum, BQT1.smallA.TimeStampValue=c.timeStampValue, BQT1.smallA.booleanValue=c.booleanValue, BQT1.smallA.DateValue=c.dateValue}}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.intKey, c.intNum, c.doubleNum, c.objectValue, c.bigDecimalValue AS expr5, c.bigIntegerValue AS expr6, c.charValue AS expr7, c.stringNum, c.stringKey, c.floatNum, c.longNum, c.timeValue, c.shortValue AS expr13, c.byteNum AS expr14, c.timeStampValue AS expr15, c.booleanValue, c.dateValue]}) Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000}) Source(groups=[smallARemotecache AS c]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[BQT1.smallA], props={PROJECT_COLS=[BQT1.smallA.CharValue], OUTPUT_COLS=[BQT1.smallA.CharValue]}) Select(groups=[BQT1.smallA], props={SELECT_CRITERIA=BQT1.smallA.CharValue < '1', OUTPUT_COLS=[BQT1.smallA.CharValue]}) Source(groups=[BQT1.smallA], props={NESTED_COMMAND=SELECT c.intKey, c.intNum, c.doubleNum, c.objectValue, c.bigDecimalValue AS expr5, c.bigIntegerValue AS expr6, c.charValue AS expr7, c.stringNum, c.stringKey, c.floatNum, c.longNum, c.timeValue, c.shortValue AS expr13, c.byteNum AS expr14, c.timeStampValue AS expr15, c.booleanValue, c.dateValue FROM smallARemotecache AS c, SYMBOL_MAP={BQT1.smallA.CharValue=c.charValue}, OUTPUT_COLS=[BQT1.smallA.CharValue]}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS expr7], OUTPUT_COLS=[c.charValue AS expr7]}) Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=[c.charValue]}) Source(groups=[smallARemotecache AS c], props={OUTPUT_COLS=[c.charValue]}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[BQT1.smallA]) Select(groups=[BQT1.smallA], props={SELECT_CRITERIA=BQT1.smallA.CharValue < '1', OUTPUT_COLS=[BQT1.smallA.CharValue], IS_PHANTOM=true}) Source(groups=[BQT1.smallA], props={NESTED_COMMAND=SELECT c.intKey, c.intNum, c.doubleNum, c.objectValue, c.bigDecimalValue AS expr5, c.bigIntegerValue AS expr6, c.charValue AS expr7, c.stringNum, c.stringKey, c.floatNum, c.longNum, c.timeValue, c.shortValue AS expr13, c.byteNum AS expr14, c.timeStampValue AS expr15, c.booleanValue, c.dateValue FROM smallARemotecache AS c, SYMBOL_MAP={BQT1.smallA.CharValue=c.charValue}, OUTPUT_COLS=[BQT1.smallA.CharValue]}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS expr7], OUTPUT_COLS=[c.charValue AS expr7]}) Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=[c.charValue]}) Select(groups=[smallARemotecache AS c], props={SELECT_CRITERIA=c.charValue < '1'}) Source(groups=[smallARemotecache AS c], props={OUTPUT_COLS=[c.charValue]}) ============================================================================ EXECUTING MergeVirtual AFTER: Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS CharValue], OUTPUT_COLS=[BQT1.smallA.CharValue]}) Select(groups=[smallARemotecache AS c], props={SELECT_CRITERIA=c.charValue < '1', OUTPUT_COLS=[BQT1.smallA.CharValue], IS_PHANTOM=true}) Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=[c.charValue]}) Select(groups=[smallARemotecache AS c]) Source(groups=[smallARemotecache AS c]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS CharValue], OUTPUT_COLS=null}) Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=null}) Select(groups=[smallARemotecache AS c], props={SELECT_CRITERIA=c.charValue < '1', OUTPUT_COLS=null}) Source(groups=[smallARemotecache AS c], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=null}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS CharValue], OUTPUT_COLS=null}) Select(groups=[smallARemotecache AS c], props={SELECT_CRITERIA=c.charValue < '1', OUTPUT_COLS=null}) Source(groups=[smallARemotecache AS c]) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=[c.charValue AS CharValue]}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS CharValue], OUTPUT_COLS=[c.charValue AS CharValue]}) Select(groups=[smallARemotecache AS c], props={SELECT_CRITERIA=c.charValue < '1', OUTPUT_COLS=[c.charValue]}) Source(groups=[smallARemotecache AS c], props={OUTPUT_COLS=[c.charValue]}) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=[c.charValue AS CharValue], EST_CARDINALITY=-1.0}) Project(groups=[smallARemotecache AS c], props={PROJECT_COLS=[c.charValue AS CharValue], OUTPUT_COLS=[c.charValue AS CharValue], EST_CARDINALITY=-1.0}) Select(groups=[smallARemotecache AS c], props={SELECT_CRITERIA=c.charValue < '1', OUTPUT_COLS=[c.charValue], EST_CARDINALITY=-1.0}) Source(groups=[smallARemotecache AS c], props={OUTPUT_COLS=[c.charValue], EST_COL_STATS={c.charValue=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Access(groups=[smallARemotecache AS c]) Project(groups=[smallARemotecache AS c]) Select(groups=[smallARemotecache AS c]) Source(groups=[smallARemotecache AS c]) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[smallARemotecache AS c]) Project(groups=[smallARemotecache AS c]) Select(groups=[smallARemotecache AS c]) Source(groups=[smallARemotecache AS c]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[smallARemotecache AS c], props={SOURCE_HINT=null, MODEL_ID=Schema name=SmallAs, nameInSource=null, uuid=tid:263d03789ab0-e62f0f79-00000000, OUTPUT_COLS=[c.charValue AS CharValue], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT c.charValue AS CharValue FROM smallARemotecache AS c WHERE c.charValue < '1'}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[c.charValue AS CharValue] SELECT g_0.charValue FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.charValue < '1' ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[c.charValue AS CharValue] SELECT g_0.charValue FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.charValue < '1' ============================================================================ 15:08:40,707 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (Worker1_QueryProcessorQueue1) Register pool: SemaphoreArrayListManagedConnectionPool@722418a8[pool=infinispan-remote-cache] (interval=1800000) 15:08:40,707 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker1_QueryProcessorQueue1) infinispan-remote-cache: getConnection(null, null) [0/20] 15:08:40,709 DEBUG [org.jboss.modules] (Worker1_QueryProcessorQueue1) Module org.jboss.qe.jdg_remote.pojo:main defined by local module loader @2196fffc (finder: local module finder @40800a9e (roots: /home/felias/prace/repos/jbossqe-eds-functional/functional/modules,/home/felias/prace/repos/jbossqe-eds-functional/functional/modules/system/layers/dv,/home/felias/prace/repos/jbossqe-eds-functional/functional/modules/system/layers/base)) 15:08:40,723 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) === Using RemoteCacheManager (loaded by serverlist) === 15:08:40,758 DEBUG [org.infinispan.protostream.impl.SerializationContextImpl] (Worker1_QueryProcessorQueue1) Registering proto files : [org/infinispan/protostream/message-wrapping.proto] 15:08:40,775 DEBUG [org.infinispan.protostream.impl.SerializationContextImpl] (Worker1_QueryProcessorQueue1) Registering file descriptor : fileName=org/infinispan/protostream/message-wrapping.proto types=[org.infinispan.protostream.WrappedMessage] 15:08:41,220 DEBUG [org.infinispan.client.hotrod.impl.transport.tcp.TcpTransportFactory] (Worker1_QueryProcessorQueue1) Statically configured servers: [dvqe01.mw.lab.eng.bos.redhat.com/10.16.91.70:11322] 15:08:41,220 DEBUG [org.infinispan.client.hotrod.impl.transport.tcp.TcpTransportFactory] (Worker1_QueryProcessorQueue1) Load balancer class: org.infinispan.client.hotrod.impl.transport.tcp.RoundRobinBalancingStrategy 15:08:41,221 DEBUG [org.infinispan.client.hotrod.impl.transport.tcp.TcpTransportFactory] (Worker1_QueryProcessorQueue1) Tcp no delay = true; client socket timeout = 60000 ms; connect timeout = 60000 ms 15:08:41,548 INFO [org.infinispan.client.hotrod.RemoteCacheManager] (Worker1_QueryProcessorQueue1) ISPN004021