[JBoss JIRA] (TEIID-5238) Issue in the example while running through Docker
by Arvind Gopinath (JIRA)
[ https://issues.jboss.org/browse/TEIID-5238?page=com.atlassian.jira.plugin... ]
Arvind Gopinath closed TEIID-5238.
----------------------------------
All good. Thank you
> Issue in the example while running through Docker
> --------------------------------------------------
>
> Key: TEIID-5238
> URL: https://issues.jboss.org/browse/TEIID-5238
> Project: Teiid
> Issue Type: Feature Request
> Components: WildFly Swarm
> Reporter: Arvind Gopinath
> Assignee: Steven Hawkins
> Labels: Swarm, Teiid, wildfy
>
> When I run the below example, without docker it works fine. But when I try the same through docker, i am getting below error message. Please advise and appreciate all the help.
> https://github.com/teiid/wildfly-swarm-teiid-examples/tree/master/vdb-dat...
> Error-
> C:\projects\teiid-examples>docker run -p 31000:31000 vdb-datafederation-swarm
> C:\projects\teiid-examples>docker run -p 31000:31000 vdb-datafederation-swarm
> 2018-01-30 23:39:47,310 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Logging - STABLE org.wildfly.swarm:logging:2017.6.0
> 2018-01-30 23:39:47,319 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: JCA - STABLE org.wildfly.swarm:jca:2017.6.0
> 2018-01-30 23:39:47,320 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Datasources - STABLE org.wildfly.swarm:datasources:2017.6.0
> 2018-01-30 23:39:47,321 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: JMX - STABLE org.wildfly.swarm:jmx:2017.6.0
> 2018-01-30 23:39:47,321 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Resource Adapters - STABLE org.wildfly.swarm:resource-adapters:2017.6.0
> 2018-01-30 23:39:47,322 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Infinispan - STABLE org.wildfly.swarm:infinispan:2017.6.0
> 2018-01-30 23:39:47,322 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Remoting - STABLE org.wildfly.swarm:remoting:2017.6.0
> 2018-01-30 23:39:47,322 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Teiid - STABLE org.wildfly.swarm:teiid:2017.6.0
> 2018-01-30 23:39:47,323 INFO [org.wildfly.swarm] (main) WFSWARM0013: Installed fraction: Transactions - STABLE org.wildfly.swarm:transactions:2017.6.0
> 2018-01-30 23:39:49,081 INFO [org.wildfly.swarm.jmx] (main) JMX not configured for remote access
> 2018-01-30 23:39:49,124 INFO [org.wildfly.swarm.datasources] (main) WFSWARM1003: Auto-detected JDBC driver for h2
> 2018-01-30 23:39:49,147 INFO [org.wildfly.swarm.datasources] (main) WFSWARM1003: Auto-detected JDBC driver for teiid
> 2018-01-30 23:39:49,482 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.7.Final
> 2018-01-30 23:39:49,538 INFO [org.jboss.as] (MSC service thread 1-1) WFLYSRV0049: WildFly Swarm 2017.6.0 (WildFly Core 2.2.1.Final) starting
> 2018-01-30 23:39:49,573 INFO [org.wildfly.swarm] (MSC service thread 1-1) WFSWARM0019: Install MSC service for command line args: []
> 2018-01-30 23:39:51,225 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 18) WFLYNAM0001: Activating Naming Subsystem
> 2018-01-30 23:39:51,235 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 23) WFLYCLINF0001: Activating Infinispan subsystem.
> 2018-01-30 23:39:51,227 INFO [org.jboss.as.security] (ServerService Thread Pool -- 20) WFLYSEC0002: Activating Security Subsystem
> 2018-01-30 23:39:51,229 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 24) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique.
> 2018-01-30 23:39:51,266 INFO [org.wildfly.extension.io] (ServerService Thread Pool -- 22) WFLYIO001: Worker 'default' has auto-configured to 4 core threads with 32 task threads based on your 2 available processors
> 2018-01-30 23:39:51,293 INFO [org.xnio] (MSC service thread 1-3) XNIO version 3.4.3.Final
> 2018-01-30 23:39:51,302 INFO [org.jboss.as.security] (MSC service thread 1-1) WFLYSEC0001: Current PicketBox version=4.9.6.Final
> 2018-01-30 23:39:51,356 INFO [org.xnio.nio] (MSC service thread 1-3) XNIO NIO Implementation Version 3.4.3.Final
> 2018-01-30 23:39:51,365 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 21) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.4)
> 2018-01-30 23:39:51,421 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 21) WFLYJCA0005: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 10.0)
> 2018-01-30 23:39:51,443 INFO [org.jboss.as.connector] (MSC service thread 1-4) WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.3.4.Final)
> 2018-01-30 23:39:51,577 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0018: Started Driver service with driver-name = h2
> 2018-01-30 23:39:51,610 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0018: Started Driver service with driver-name = teiid
> 2018-01-30 23:39:51,609 INFO [org.jboss.as.naming] (MSC service thread 1-3) WFLYNAM0003: Starting Naming Service
> 2018-01-30 23:39:51,636 INFO [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 4.0.21.Final
> 2018-01-30 23:39:51,949 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) WFLYJCA0001: Bound data source [java:jboss/datasources/accounts-ds]
> 2018-01-30 23:39:53,772 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/tmp/module-jar6903489841680264781.jar_d/modules/org/jboss/teiid/resource-adapter/file/main/
> 2018-01-30 23:39:53,838 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/tmp/module-jar6903489841680264781.jar_d/modules/org/jboss/teiid/resource-adapter/file/main/
> 2018-01-30 23:39:53,856 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020018: Enabling <validate-on-match> for java:/marketdata-file
> 2018-01-30 23:39:53,870 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 16) TEIID50006 Teiid translator "h2" added.
> 2018-01-30 23:39:53,871 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-1) WFLYJCA0007: Registered connection factory java:/marketdata-file
> 2018-01-30 23:39:53,885 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/tmp/module-jar6903489841680264781.jar_d/modules/org/jboss/teiid/resource-adapter/file/main/
> 2018-01-30 23:39:53,889 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-4) WFLYJCA0002: Bound JCA ConnectionFactory [java:/marketdata-file]
> 2018-01-30 23:39:53,904 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 16) TEIID50006 Teiid translator "file" added.
> 2018-01-30 23:39:54,060 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-1) ISPN000128: Infinispan version: Infinispan 'Chakra' 8.2.4.Final
> 2018-01-30 23:39:54,346 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 30) WFLYCLINF0002: Started resultset cache from teiid-cache container
> 2018-01-30 23:39:54,354 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 28) WFLYCLINF0002: Started preparedplan cache from teiid-cache container
> 2018-01-30 23:39:54,357 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 29) WFLYCLINF0002: Started resultset-repl cache from teiid-cache container
> 2018-01-30 23:39:54,393 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50001 Teiid Engine 9.2.0.Final Started = Tue Jan 30 23:39:54 UTC 2018
> 2018-01-at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1919) to start service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.
> transporat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.lang.Thread.run(Thread.java:748)or$Worker.run(ThreadPoolExecutor.java:617)
> Caused bat sun.nio.ch.Net.bind0(Native Method)family unavailable
> at sun.nio.ch.Net.bind(Net.java:425)
> at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)java:223)
> at io.netty.channel.AbstractChannel$AbstractUnsafe.bind(AbstractChannel.java:485)el.java:125)
> at io.netty.channel.AbstractChannelHandlerContext.invokeBind(AbstractChannelHandlerContext.java:440)
> at io.netty.channel.DefaultChannelPipeline.bind(DefaultChannelPipeline.java:903)text.java:425)
> at io.netty.bootstrap.AbstractBootstrap$2.run(AbstractBootstrap.java:348)
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)ks(SingleThreadEventExecutor.java:358)
> ... 1 morey.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)
> 2018-01-30 23:39:54,563 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
> ("subsystem" => "teiid"),
> ("transport" => "jdbc")
> ]) - failure description: {
> "WFLYCTL0080: Failed services" => {"jboss.teiid.transport.jdbc" => "org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> Caused by: java.net.SocketException: Protocol family unavailable"},
> "WFLYCTL0412: Required services that are not installed:" => ["jboss.teiid.transport.jdbc"],
> "WFLYCTL0180: Services with missing/unavailable dependencies" => undefined
> }
> 2018-01-30 23:39:54,613 INFO [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
> WFLYCTL0186: Services which failed to start: service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> 2018-01-30 23:39:54,684 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: WildFly Swarm 2017.6.0 (WildFly Core 2.2.1.Final) started (with errors) in 5229ms - Started 212 of 317 services (1 services failed or missing dependencies, 170 services are lazy, passive or on-demand)
> 2018-01-30 23:39:54,703 ERROR [stderr] (main) java.lang.reflect.InvocationTargetException
> 2018-01-30 23:39:54,704 ERROR [stderr] (main) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2018-01-30 23:39:54,704 ERROR [stderr] (main) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 2018-01-30 23:39:54,704 ERROR [stderr] (main) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 2018-01-30 23:39:54,705 ERROR [stderr] (main) at java.lang.reflect.Method.invoke(Method.java:498)
> 2018-01-30 23:39:54,705 ERROR [stderr] (main) at org.wildfly.swarm.bootstrap.MainInvoker.invoke(MainInvoker.java:39)
> 2018-01-30 23:39:54,705 ERROR [stderr] (main) at org.wildfly.swarm.bootstrap.Main.run(Main.java:46)
> 2018-01-30 23:39:54,706 ERROR [stderr] (main) at org.wildfly.swarm.bootstrap.Main.main(Main.java:37)
> 2018-01-30 23:39:54,706 ERROR [stderr] (main) Caused by: java.lang.RuntimeException: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> 2018-01-30 23:39:54,707 ERROR [stderr] (main) at org.wildfly.swarm.spi.api.ClassLoading.withTCCL(ClassLoading.java:45)
> 2018-01-30 23:39:54,707 ERROR [stderr] (main) at org.wildfly.swarm.container.runtime.ServerBootstrapImpl.bootstrap(ServerBootstrapImpl.java:113)
> 2018-01-30 23:39:54,707 ERROR [stderr] (main) at org.wildfly.swarm.Swarm.start(Swarm.java:369)
> 2018-01-30 23:39:54,708 ERROR [stderr] (main) at com.scentre.teiid.examples.Main.main(Main.java:46)
> 2018-01-30 23:39:54,709 ERROR [stderr] (main) ... 7 more
> 2018-01-30 23:39:54,709 ERROR [stderr] (main) Caused by: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> 2018-01-30 23:39:54,709 ERROR [stderr] (main) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1919)
> 2018-01-30 23:39:54,709 ERROR [stderr] (main) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 2018-01-30 23:39:54,710 ERROR [stderr] (main) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 2018-01-30 23:39:54,710 ERROR [stderr] (main) at java.lang.Thread.run(Thread.java:748)
> 2018-01-30 23:39:54,710 ERROR [stderr] (main) Caused by: java.net.SocketException: Protocol family unavailable
> 2018-01-30 23:39:54,710 ERROR [stderr] (main) at sun.nio.ch.Net.bind0(Native Method)
> 2018-01-30 23:39:54,712 ERROR [stderr] (main) at sun.nio.ch.Net.bind(Net.java:433)
> 2018-01-30 23:39:54,713 ERROR [stderr] (main) at sun.nio.ch.Net.bind(Net.java:425)
> 2018-01-30 23:39:54,713 ERROR [stderr] (main) at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
> 2018-01-30 23:39:54,713 ERROR [stderr] (main) at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
> 2018-01-30 23:39:54,713 ERROR [stderr] (main) at io.netty.channel.socket.nio.NioServerSocketChannel.doBind(NioServerSocketChannel.java:125)
> 2018-01-30 23:39:54,714 ERROR [stderr] (main) at io.netty.channel.AbstractChannel$AbstractUnsafe.bind(AbstractChannel.java:485)
> 2018-01-30 23:39:54,714 ERROR [stderr] (main) at io.netty.channel.DefaultChannelPipeline$HeadContext.bind(DefaultChannelPipeline.java:1089)
> 2018-01-30 23:39:54,714 ERROR [stderr] (main) at io.netty.channel.AbstractChannelHandlerContext.invokeBind(AbstractChannelHandlerContext.java:440)
> 2018-01-30 23:39:54,714 ERROR [stderr] (main) at io.netty.channel.AbstractChannelHandlerContext.bind(AbstractChannelHandlerContext.java:425)
> 2018-01-30 23:39:54,714 ERROR [stderr] (main) at io.netty.channel.DefaultChannelPipeline.bind(DefaultChannelPipeline.java:903)
> 2018-01-30 23:39:54,715 ERROR [stderr] (main) at io.netty.channel.AbstractChannel.bind(AbstractChannel.java:198)
> 2018-01-30 23:39:54,718 ERROR [stderr] (main) at io.netty.bootstrap.AbstractBootstrap$2.run(AbstractBootstrap.java:348)
> 2018-01-30 23:39:54,718 ERROR [stderr] (main) at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:358)
> 2018-01-30 23:39:54,718 ERROR [stderr] (main) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)
> 2018-01-30 23:39:54,718 ERROR [stderr] (main) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)
> 2018-01-30 23:39:54,719 ERROR [stderr] (main) ... 1 more
> 2018-01-30 23:39:54,719 ERROR [stderr] (main) Exception in thread "main" java.lang.reflect.InvocationTargetException
> 2018-01-30 23:39:54,719 ERROR [stderr] (main) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2018-01-30 23:39:54,719 ERROR [stderr] (main) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 2018-01-30 23:39:54,720 ERROR [stderr] (main) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 2018-01-30 23:39:54,720 ERROR [stderr] (main) at java.lang.reflect.Method.invoke(Method.java:498)
> 2018-01-30 23:39:54,720 ERROR [stderr] (main) at org.wildfly.swarm.bootstrap.MainInvoker.invoke(MainInvoker.java:39)
> 2018-01-30 23:39:54,720 ERROR [stderr] (main) at org.wildfly.swarm.bootstrap.Main.run(Main.java:46)
> 2018-01-30 23:39:54,720 ERROR [stderr] (main) at org.wildfly.swarm.bootstrap.Main.main(Main.java:37)
> 2018-01-30 23:39:54,721 ERROR [stderr] (main) Caused by: java.lang.RuntimeException: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> 2018-01-30 23:39:54,721 ERROR [stderr] (main) at org.wildfly.swarm.spi.api.ClassLoading.withTCCL(ClassLoading.java:45)
> 2018-01-30 23:39:54,721 ERROR [stderr] (main) at org.wildfly.swarm.container.runtime.ServerBootstrapImpl.bootstrap(ServerBootstrapImpl.java:113)
> 2018-01-30 23:39:54,726 ERROR [stderr] (main) at org.wildfly.swarm.Swarm.start(Swarm.java:369)
> 2018-01-30 23:39:54,726 ERROR [stderr] (main) at com.scentre.teiid.examples.Main.main(Main.java:46)
> 2018-01-30 23:39:54,726 ERROR [stderr] (main) ... 7 more
> 2018-01-30 23:39:54,726 ERROR [stderr] (main) Caused by: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> 2018-01-30 23:39:54,727 ERROR [stderr] (main) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1919)
> 2018-01-30 23:39:54,727 ERROR [stderr] (main) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> 2018-01-30 23:39:54,727 ERROR [stderr] (main) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> 2018-01-30 23:39:54,727 ERROR [stderr] (main) at java.lang.Thread.run(Thread.java:748)
> 2018-01-30 23:39:54,727 ERROR [stderr] (main) Caused by: java.net.SocketException: Protocol family unavailable
> 2018-01-30 23:39:54,728 ERROR [stderr] (main) at sun.nio.ch.Net.bind0(Native Method)
> 2018-01-30 23:39:54,728 ERROR [stderr] (main) at sun.nio.ch.Net.bind(Net.java:433)
> 2018-01-30 23:39:54,728 ERROR [stderr] (main) at sun.nio.ch.Net.bind(Net.java:425)
> 2018-01-30 23:39:54,728 ERROR [stderr] (main) at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
> 2018-01-30 23:39:54,728 ERROR [stderr] (main) at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
> 2018-01-30 23:39:54,728 ERROR [stderr] (main) at io.netty.channel.socket.nio.NioServerSocketChannel.doBind(NioServerSocketChannel.java:125)
> 2018-01-30 23:39:54,729 ERROR [stderr] (main) at io.netty.channel.AbstractChannel$AbstractUnsafe.bind(AbstractChannel.java:485)
> 2018-01-30 23:39:54,729 ERROR [stderr] (main) at io.netty.channel.DefaultChannelPipeline$HeadContext.bind(DefaultChannelPipeline.java:1089)
> 2018-01-30 23:39:54,729 ERROR [stderr] (main) at io.netty.channel.AbstractChannelHandlerContext.invokeBind(AbstractChannelHandlerContext.java:440)
> 2018-01-30 23:39:54,729 ERROR [stderr] (main) at io.netty.channel.AbstractChannelHandlerContext.bind(AbstractChannelHandlerContext.java:425)
> 2018-01-30 23:39:54,729 ERROR [stderr] (main) at io.netty.channel.DefaultChannelPipeline.bind(DefaultChannelPipeline.java:903)
> 2018-01-30 23:39:54,730 ERROR [stderr] (main) at io.netty.channel.AbstractChannel.bind(AbstractChannel.java:198)
> 2018-01-30 23:39:54,730 ERROR [stderr] (main) at io.netty.bootstrap.AbstractBootstrap$2.run(AbstractBootstrap.java:348)
> 2018-01-30 23:39:54,730 ERROR [stderr] (main) at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:358)
> 2018-01-30 23:39:54,730 ERROR [stderr] (main) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)
> 2018-01-30 23:39:54,730 ERROR [stderr] (main) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)
> 2018-01-30 23:39:54,730 ERROR [stderr] (main) ... 1 more
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5265) AssertionError: Batch not found in storage
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5265?page=com.atlassian.jira.plugin... ]
Work on TEIID-5265 started by Steven Hawkins.
---------------------------------------------
> AssertionError: Batch not found in storage
> ------------------------------------------
>
> Key: TEIID-5265
> URL: https://issues.jboss.org/browse/TEIID-5265
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 10.1
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
>
> While executing the following query:
> {code:sql}
> insert into rep149_cci(PatientID,age,Orig,Upd,agepointsO,agepointsU,AMI,CHF,PVD,CVD,DEM,CPD,PUD,MLD,SLD,DNC,DWC,HEM,RED,MAL,MST,HIV)
> select cci.patientid as patientid,cci.age as age,cci.orig as orig,cci.upd as upd,cci.agepointso as agepointso,cci.agepointsu as agepointsu,
> cci.charlson_ami as ami,cci.charlson_chf as chf,cci.charlson_pvd as pvd,cci.charlson_cvd as cvd,cci.charlson_dem as dem,cci.charlson_cpd as cpd,cci.charlson_pud as pud,
> cci.charlson_mld as mld,cci.charlson_sld as sld,cci.charlson_dnc as dnc,cci.charlson_dwc as dwc,cci.charlson_hem as hem,cci.charlson_red as red,cci.charlson_mal as mal,
> cci.charlson_mst as mst,cci.charlson_hiv as hiv
> from rep149_cohort gd
> join izisviews.pr_calculate_cci cci on
> cci.patientid_in = gd.patientid;
> {code}
> rep149_cci is defined as
> {code:sql}
> create foreign temporary table rep149_cci(
> PatientID integer not null,
> age bigdecimal,
> Orig long,
> Upd long,
> agepointsO integer,
> agepointsU integer,
> AMI integer,
> CHF integer,
> PVD integer,
> CVD integer,
> DEM integer,
> CPD integer,
> PUD integer,
> MLD integer,
> SLD integer,
> DNC integer,
> DWC integer,
> HEM integer,
> RED integer,
> MAL integer,
> MST integer,
> HIV integer,
> primary key(patientid)
> )OPTIONS (UPDATABLE true) on tmptables;
> {code}
> pr_calculate_cci is a virtual procedure. (I can't however share this code for confidentiality reasons).
> {code:sql}
> CREATE VIRTUAL PROCEDURE pr_calculate_cci(patientid_in integer)
> RETURNS (
> PatientID integer,
> age bigdecimal,
> Orig long,
> Upd long,
> agepointsO integer,
> agepointsU integer,
> AMI integer,
> CHF integer,
> PherVascDis integer,
> CerebVascDis integer,
> Dement integer,
> ChrPulmDis integer,
> PeptUlcer integer,
> MildLivDis integer,
> SevLivDis integer,
> DiabetesNoCompl integer,
> DiabetesWithCompl integer,
> HemiPara integer,
> RenalDis integer,
> Malign integer,
> Metastase integer,
> HIV_AIDS integer
> )
> AS
> BEGIN
> ...
> END
> {code}
> There are a few error reports like this one:
> 2018-02-23 08:33:05,478 ERROR [org.teiid.BUFFER_MGR] (Worker291_QueryProcessorQueue571476) mh0bsTIbs7qY TEIID30001 Max block number exceeded by object 1,366,497 from group 5,068,016. It is a Batch of 1797 rows of [Ljava.lang.String;@10953478. The estimated size was 172,528, but the actual size was 14,410. Increase the maxStorageObjectSize to support larger storage objects. Alternatively you could make the processor batch size smaller.
> The final stack trace is:
> 2018-02-23 08:33:05,539 ERROR [org.teiid.PROCESSOR] (Worker291_QueryProcessorQueue571476) mh0bsTIbs7qY TEIID30019 Unexpected exception for request mh0bsTIbs7qY.90: java.lang.AssertionError: Batch not found in storage 5067771
> at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:382)
> at org.teiid.common.buffer.SPage.getValues(SPage.java:234)
> at org.teiid.common.buffer.SPage.search(SPage.java:135)
> at org.teiid.common.buffer.STree.find(STree.java:247)
> at org.teiid.common.buffer.STree.insert(STree.java:295)
> at org.teiid.query.processor.relational.WindowFunctionProjectNode.saveValues(WindowFunctionProjectNode.java:419)
> at org.teiid.query.processor.relational.WindowFunctionProjectNode.buildResults(WindowFunctionProjectNode.java:380)
> at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:229)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirectInternal(UnionAllNode.java:165)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:138)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:100)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:207)
> at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:154)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5265) AssertionError: Batch not found in storage
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-5265?page=com.atlassian.jira.plugin... ]
Bram Gadeyne commented on TEIID-5265:
-------------------------------------
possibly related to TEIID-4324
> AssertionError: Batch not found in storage
> ------------------------------------------
>
> Key: TEIID-5265
> URL: https://issues.jboss.org/browse/TEIID-5265
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 10.1
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
>
> While executing the following query:
> {code:sql}
> insert into rep149_cci(PatientID,age,Orig,Upd,agepointsO,agepointsU,AMI,CHF,PVD,CVD,DEM,CPD,PUD,MLD,SLD,DNC,DWC,HEM,RED,MAL,MST,HIV)
> select cci.patientid as patientid,cci.age as age,cci.orig as orig,cci.upd as upd,cci.agepointso as agepointso,cci.agepointsu as agepointsu,
> cci.charlson_ami as ami,cci.charlson_chf as chf,cci.charlson_pvd as pvd,cci.charlson_cvd as cvd,cci.charlson_dem as dem,cci.charlson_cpd as cpd,cci.charlson_pud as pud,
> cci.charlson_mld as mld,cci.charlson_sld as sld,cci.charlson_dnc as dnc,cci.charlson_dwc as dwc,cci.charlson_hem as hem,cci.charlson_red as red,cci.charlson_mal as mal,
> cci.charlson_mst as mst,cci.charlson_hiv as hiv
> from rep149_cohort gd
> join izisviews.pr_calculate_cci cci on
> cci.patientid_in = gd.patientid;
> {code}
> rep149_cci is defined as
> {code:sql}
> create foreign temporary table rep149_cci(
> PatientID integer not null,
> age bigdecimal,
> Orig long,
> Upd long,
> agepointsO integer,
> agepointsU integer,
> AMI integer,
> CHF integer,
> PVD integer,
> CVD integer,
> DEM integer,
> CPD integer,
> PUD integer,
> MLD integer,
> SLD integer,
> DNC integer,
> DWC integer,
> HEM integer,
> RED integer,
> MAL integer,
> MST integer,
> HIV integer,
> primary key(patientid)
> )OPTIONS (UPDATABLE true) on tmptables;
> {code}
> pr_calculate_cci is a virtual procedure. (I can't however share this code for confidentiality reasons).
> {code:sql}
> CREATE VIRTUAL PROCEDURE pr_calculate_cci(patientid_in integer)
> RETURNS (
> PatientID integer,
> age bigdecimal,
> Orig long,
> Upd long,
> agepointsO integer,
> agepointsU integer,
> AMI integer,
> CHF integer,
> PherVascDis integer,
> CerebVascDis integer,
> Dement integer,
> ChrPulmDis integer,
> PeptUlcer integer,
> MildLivDis integer,
> SevLivDis integer,
> DiabetesNoCompl integer,
> DiabetesWithCompl integer,
> HemiPara integer,
> RenalDis integer,
> Malign integer,
> Metastase integer,
> HIV_AIDS integer
> )
> AS
> BEGIN
> ...
> END
> {code}
> There are a few error reports like this one:
> 2018-02-23 08:33:05,478 ERROR [org.teiid.BUFFER_MGR] (Worker291_QueryProcessorQueue571476) mh0bsTIbs7qY TEIID30001 Max block number exceeded by object 1,366,497 from group 5,068,016. It is a Batch of 1797 rows of [Ljava.lang.String;@10953478. The estimated size was 172,528, but the actual size was 14,410. Increase the maxStorageObjectSize to support larger storage objects. Alternatively you could make the processor batch size smaller.
> The final stack trace is:
> 2018-02-23 08:33:05,539 ERROR [org.teiid.PROCESSOR] (Worker291_QueryProcessorQueue571476) mh0bsTIbs7qY TEIID30019 Unexpected exception for request mh0bsTIbs7qY.90: java.lang.AssertionError: Batch not found in storage 5067771
> at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:382)
> at org.teiid.common.buffer.SPage.getValues(SPage.java:234)
> at org.teiid.common.buffer.SPage.search(SPage.java:135)
> at org.teiid.common.buffer.STree.find(STree.java:247)
> at org.teiid.common.buffer.STree.insert(STree.java:295)
> at org.teiid.query.processor.relational.WindowFunctionProjectNode.saveValues(WindowFunctionProjectNode.java:419)
> at org.teiid.query.processor.relational.WindowFunctionProjectNode.buildResults(WindowFunctionProjectNode.java:380)
> at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:229)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirectInternal(UnionAllNode.java:165)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:138)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:100)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:207)
> at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:154)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5265) AssertionError: Batch not found in storage
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-5265:
-----------------------------------
Summary: AssertionError: Batch not found in storage
Key: TEIID-5265
URL: https://issues.jboss.org/browse/TEIID-5265
Project: Teiid
Issue Type: Bug
Affects Versions: 10.1
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
While executing the following query:
{code:sql}
insert into rep149_cci(PatientID,age,Orig,Upd,agepointsO,agepointsU,AMI,CHF,PVD,CVD,DEM,CPD,PUD,MLD,SLD,DNC,DWC,HEM,RED,MAL,MST,HIV)
select cci.patientid as patientid,cci.age as age,cci.orig as orig,cci.upd as upd,cci.agepointso as agepointso,cci.agepointsu as agepointsu,
cci.charlson_ami as ami,cci.charlson_chf as chf,cci.charlson_pvd as pvd,cci.charlson_cvd as cvd,cci.charlson_dem as dem,cci.charlson_cpd as cpd,cci.charlson_pud as pud,
cci.charlson_mld as mld,cci.charlson_sld as sld,cci.charlson_dnc as dnc,cci.charlson_dwc as dwc,cci.charlson_hem as hem,cci.charlson_red as red,cci.charlson_mal as mal,
cci.charlson_mst as mst,cci.charlson_hiv as hiv
from rep149_cohort gd
join izisviews.pr_calculate_cci cci on
cci.patientid_in = gd.patientid;
{code}
rep149_cci is defined as
{code:sql}
create foreign temporary table rep149_cci(
PatientID integer not null,
age bigdecimal,
Orig long,
Upd long,
agepointsO integer,
agepointsU integer,
AMI integer,
CHF integer,
PVD integer,
CVD integer,
DEM integer,
CPD integer,
PUD integer,
MLD integer,
SLD integer,
DNC integer,
DWC integer,
HEM integer,
RED integer,
MAL integer,
MST integer,
HIV integer,
primary key(patientid)
)OPTIONS (UPDATABLE true) on tmptables;
{code}
pr_calculate_cci is a virtual procedure. (I can't however share this code for confidentiality reasons).
{code:sql}
CREATE VIRTUAL PROCEDURE pr_calculate_cci(patientid_in integer)
RETURNS (
PatientID integer,
age bigdecimal,
Orig long,
Upd long,
agepointsO integer,
agepointsU integer,
AMI integer,
CHF integer,
PherVascDis integer,
CerebVascDis integer,
Dement integer,
ChrPulmDis integer,
PeptUlcer integer,
MildLivDis integer,
SevLivDis integer,
DiabetesNoCompl integer,
DiabetesWithCompl integer,
HemiPara integer,
RenalDis integer,
Malign integer,
Metastase integer,
HIV_AIDS integer
)
AS
BEGIN
...
END
{code}
There are a few error reports like this one:
2018-02-23 08:33:05,478 ERROR [org.teiid.BUFFER_MGR] (Worker291_QueryProcessorQueue571476) mh0bsTIbs7qY TEIID30001 Max block number exceeded by object 1,366,497 from group 5,068,016. It is a Batch of 1797 rows of [Ljava.lang.String;@10953478. The estimated size was 172,528, but the actual size was 14,410. Increase the maxStorageObjectSize to support larger storage objects. Alternatively you could make the processor batch size smaller.
The final stack trace is:
2018-02-23 08:33:05,539 ERROR [org.teiid.PROCESSOR] (Worker291_QueryProcessorQueue571476) mh0bsTIbs7qY TEIID30019 Unexpected exception for request mh0bsTIbs7qY.90: java.lang.AssertionError: Batch not found in storage 5067771
at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:382)
at org.teiid.common.buffer.SPage.getValues(SPage.java:234)
at org.teiid.common.buffer.SPage.search(SPage.java:135)
at org.teiid.common.buffer.STree.find(STree.java:247)
at org.teiid.common.buffer.STree.insert(STree.java:295)
at org.teiid.query.processor.relational.WindowFunctionProjectNode.saveValues(WindowFunctionProjectNode.java:419)
at org.teiid.query.processor.relational.WindowFunctionProjectNode.buildResults(WindowFunctionProjectNode.java:380)
at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:229)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirectInternal(UnionAllNode.java:165)
at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:138)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:100)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:207)
at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:154)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5261) Add example for Teiid WildFly Swarm
by Arvind Gopinath (JIRA)
[ https://issues.jboss.org/browse/TEIID-5261?page=com.atlassian.jira.plugin... ]
Arvind Gopinath edited comment on TEIID-5261 at 2/22/18 10:52 PM:
------------------------------------------------------------------
Thank you very much.
I have verified with our code and everything works superb.
Also I verified with custome jdbc driver and it is also working perfectly.
Thank you once again [~rareddy]
was (Author: arvindo):
Thank you very much.
I have verified with our code and everything works superb.
Also I verified with customer jdbc driver and it is also working perfectly.
Thank you once again [~rareddy]
> Add example for Teiid WildFly Swarm
> -----------------------------------
>
> Key: TEIID-5261
> URL: https://issues.jboss.org/browse/TEIID-5261
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Arvind Gopinath
> Assignee: Ramesh Reddy
> Priority: Minor
> Attachments: Errorlogs.txt, Main.java, pom.xml
>
>
> The virtual View construction happens with Annotations using Teiid Spring Boot.
> Without annotations, it will be value added if Teiid Spring Boot supports VDB.
> Referring below example to implement the same using Spring Boot -
> https://github.com/teiid/wildfly-swarm-teiid-examples/tree/master/vdb-dat...
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month