[JBoss JIRA] (TEIID-5185) JDBC client intermittently hangs when processing multi-batch result sets from VIPped Teiid server
by Krum Bakalsky (JIRA)
[ https://issues.jboss.org/browse/TEIID-5185?page=com.atlassian.jira.plugin... ]
Krum Bakalsky commented on TEIID-5185:
--------------------------------------
Hi Steven,
I remember the result set size was somewhere between 90K and 130K rows, roughly speaking.
Our load balancers are Cisco ACE, if I am not mistaken. Also, I don't think they're configured with any stickiness. Number of back-end hosts behind them is 4.
I will try to ping colleagues that are chasing this problem to get the latest status.
If we can't extract more meaningful context and details around the problem, I'd propose to close this JIRA, it's been a while already.
Cheers,
Krum.
> JDBC client intermittently hangs when processing multi-batch result sets from VIPped Teiid server
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-5185
> URL: https://issues.jboss.org/browse/TEIID-5185
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver, Server
> Affects Versions: 9.3.4
> Environment: JDBC client was run through Apache JMeter, on a 64-bit Windows 7 Enterprise SP1 machine, using 64-bit JDK 8;
> Teiid Server runs on Linux.
> Reporter: Krum Bakalsky
> Assignee: Steven Hawkins
> Fix For: 10.2
>
>
> We have a server-side application that is powered by Teiid version 9.3.4, and that exposes a Teiid JDBC endpoint to its clients.
> A couple of app instances are configured to sit behind a VIP load balancer, that works on the TCP level.
> We have been experiencing intermittently following problem, when we run Teiid 9.3.4 client to execute multi-batch queries to the server:
> * client successfully fetches few batches from server;
> * client hangs and its thread blocks on waiting for the next batch to be delivered on the network;
> * after 1 hour client throws exceptions that Socket is closed.
> When building up the JDBC connection URL the client refers directly to the server's VIP, and does not list particular server hosts:
> jdbc:teiid:<Application>@mm://<VIP's DNS name>:<port>
> Client thread's call stack:
> {code}
> "Thread Group 1-1" #41 prio=6 os_prio=0 tid=0x000000005e03a800 nid=0x17bc runnable [0x00000000623ae000]
> java.lang.Thread.State: RUNNABLE
> at java.net.SocketInputStream.socketRead0(Native Method)
> at java.net.SocketInputStream.socketRead(Unknown Source)
> at java.net.SocketInputStream.read(Unknown Source)
> at java.net.SocketInputStream.read(Unknown Source)
> at java.io.BufferedInputStream.fill(Unknown Source)
> at java.io.BufferedInputStream.read(Unknown Source)
> - locked <0x00000000f5f32420> (a org.teiid.core.util.AccessibleBufferedInputStream)
> at java.io.DataInputStream.readInt(Unknown Source)
> at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
> at java.io.ObjectInputStream.readObject(Unknown Source)
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:324)
> at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy21.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:427)
> at org.teiid.jdbc.ResultSetImpl.getResults(ResultSetImpl.java:449)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:382)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:227)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:142)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:253)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:510)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:259)
> at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
> at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.getStringFromResultSet(AbstractJDBCTestElement.java:535)
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.execute(AbstractJDBCTestElement.java:174)
> at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:84)
> at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:491)
> at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:425)
> at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:254)
> at java.lang.Thread.run(Unknown Source)
> Locked ownable synchronizers:
> - None
> {code}
> Client side exception after 1 hour:
> {code}
> 2017-12-19 13:17:07,160 WARN o.a.j.p.j.AbstractJDBCTestElement: Error closing ResultSet
> org.teiid.jdbc.TeiidSQLException: TEIID20013 java.net.SocketException: Socket closed
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:168) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.apache.commons.dbcp2.DelegatingResultSet.close(DelegatingResultSet.java:170) ~[commons-dbcp2-2.1.1.jar:2.1.1]
> at org.apache.commons.dbcp2.DelegatingResultSet.close(DelegatingResultSet.java:170) ~[commons-dbcp2-2.1.1.jar:2.1.1]
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.close(AbstractJDBCTestElement.java:607) [ApacheJMeter_jdbc.jar:3.2 r1790748]
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.execute(AbstractJDBCTestElement.java:176) [ApacheJMeter_jdbc.jar:3.2 r1790748]
> at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:84) [ApacheJMeter_jdbc.jar:3.2 r1790748]
> at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:491) [ApacheJMeter_core.jar:3.2 r1790748]
> at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:425) [ApacheJMeter_core.jar:3.2 r1790748]
> at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:254) [ApacheJMeter_core.jar:3.2 r1790748]
> at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]
> Caused by: org.teiid.core.TeiidComponentException: TEIID20013 java.net.SocketException: Socket closed
> at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:65) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:445) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20013 java.net.SocketException: Socket closed
> at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:217) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_121]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy21.send(Unknown Source) ~[?:?]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:433) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> Caused by: java.util.concurrent.ExecutionException: java.net.SocketException: Socket closed
> at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:104) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:99) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:214) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_121]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy21.send(Unknown Source) ~[?:?]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:433) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> Caused by: java.net.SocketException: Socket closed
> at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_121]
> at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_121]
> at java.io.DataOutputStream.write(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.core.util.MultiArrayOutputStream.writeTo(MultiArrayOutputStream.java:94) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.netty.handler.codec.serialization.ObjectEncoderOutputStream.writeObjectOverride(ObjectEncoderOutputStream.java:70) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at java.io.ObjectOutputStream.writeObject(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.write(OioOjbectChannelFactory.java:136) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:213) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_121]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy21.send(Unknown Source) ~[?:?]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:433) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> {code}
> Server-side log excerpt, after raising logger levels to Debug:
> {code}
> 2017-12-15 12:00:45.625 [NIO36 ] DEBUG - processing message:MessageHolder: key=550774 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 2017-12-15 12:00:47.730 [ocessorQueue14017479] DEBUG - send message: MessageHolder: key=550774 contents=ResultsMessage rowCount=256 finalRow=-1
> 2017-12-15 12:00:47.737 [NIO36 ] DEBUG - processing message:MessageHolder: key=550776 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:47.738 [ocessorQueue14017553] DEBUG - send message: MessageHolder: key=550776 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:47.755 [NIO36 ] DEBUG - processing message:MessageHolder: key=550777 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:47.756 [ocessorQueue14017554] DEBUG - send message: MessageHolder: key=550777 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:48.389 [NIO36 ] DEBUG - processing message:MessageHolder: key=550778 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:48.389 [ocessorQueue14017556] DEBUG - send message: MessageHolder: key=550778 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:48.825 [NIO36 ] DEBUG - processing message:MessageHolder: key=550779 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:48.826 [ocessorQueue14017557] DEBUG - send message: MessageHolder: key=550779 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:48.932 [NIO36 ] DEBUG - processing message:MessageHolder: key=550780 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:48.933 [ocessorQueue14017558] DEBUG - send message: MessageHolder: key=550780 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:02:18.386 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:05:55.327 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:09:29.545 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:13:08.903 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:16:41.864 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:20:16.875 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:23:57.860 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:27:30.273 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:31:07.795 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:34:46.439 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:38:23.325 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:41:59.227 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:45:35.526 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:49:14.088 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:52:46.177 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:56:24.407 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 13:00:03.109 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 13:00:52.143 [NIO36 ] DEBUG - TEIID40114 Unhandled exception, closing client instance: Connection reset by peer
> java.io.IOException: Connection reset by peer
> at sun.nio.ch.FileDispatcherImpl.read0(Native Method)
> at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)
> at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)
> at sun.nio.ch.IOUtil.read(IOUtil.java:192)
> at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)
> at io.netty.buffer.UnpooledUnsafeDirectByteBuf.setBytes(UnpooledUnsafeDirectByteBuf.java:447)
> at io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:880)
> at io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:242)
> at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:119)
> at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)
> at java.lang.Thread.run(Thread.java:745)
> 2017-12-15 13:00:52.143 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 13:03:34.811 [NIO36 ] DEBUG - Channel closed
> {code}
> Legend:
> * 'Channel closed' is logged from org.teiid.transport.SSLAwareChannelHandler class, and its channelInactive method;
> * 'MessageHolder' logs are from org.teiid.net.socket.Message;
> * the log lines that contain rowCount, finalRow, etc. are coming from org.teiid.transport.SocketClientInstance.
> The problem is rarely reproducible, but it happens a few times every day, while running the JMeter tests full day.
> We are also running JMeter in a scenario where the client is referring directly to a server URL, therefore skipping the VIP. We haven't been able to reproduce the problem in this setting so far, which suggests that the issue has something to do with the VIP setup.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5205) Infinispan hotrod translator timeout on UPDATE
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5205?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5205:
------------------------------------------------
Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1532644|https://bugzilla.redhat.com/show_bug.cgi?id=1532644] from ON_QA to VERIFIED
> Infinispan hotrod translator timeout on UPDATE
> ----------------------------------------------
>
> Key: TEIID-5205
> URL: https://issues.jboss.org/browse/TEIID-5205
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Priority: Blocker
> Fix For: 8.12.x-6.4
>
>
> I encounter timeout issue when performing UPDATE operation using Infinispan Hotrod translator.
> For query
> {code:sql}
> UPDATE SmallA SET IntKey = 100 WHERE StringKey = '1'
> {code}
> with cache filled with:
> {code:sql}
> INSERT INTO SmallA (IntKey, StringKey, IntNum, StringNum, FloatNum, LongNum, DoubleNum, ByteNum, DateValue, TimeValue, TimestampValue, BooleanValue, CharValue, ShortValue, BigIntegerValue, BigDecimalValue, ObjectValue) VALUES
> (1, '1', 1, '1', convert(1.01, float), 1, convert(-1.001, double), convert(1, byte), {d '1111-11-11'}, {t '01:01:01'}, {ts '1111-11-11 01:01:01'}, true, convert('1', char), convert(1, short), 1, 1.01, '1'),
> (2, '2', 2, '2', convert(2.02, float), 2, convert(-2.002, double), convert(2, byte), {d '2222-12-22'}, {t '02:02:02'}, {ts '2222-12-22 02:02:02'}, false, convert('2', char), convert(2, short), 2, 2.02, '2')
> {code}
> results in ARJUNA timeout after 5 minutes:
> {code}
> 14:44:45,068 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for TX 0:ffff0a2804a2:45f23ecc:5a54c5e8:f in state RUN
> 14:44:45,070 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012095: Abort of action id 0:ffff0a2804a2:45f23ecc:5a54c5e8:f invoked while multiple threads active within it.
> 14:44:45,071 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012108: CheckedAction::check - atomic action 0:ffff0a2804a2:45f23ecc:5a54c5e8:f aborting with 1 threads active!
> 14:44:45,072 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff0a2804a2:45f23ecc:5a54c5e8:f
> {code}
> and the query hangs.
> Interestingly, the changes get promoted to the cache. Just the query doesn't return.
> Command log for the update query:
> {code}
> 14:39:45,304 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue10) yl6LbuQEyWKk START DATA SRC COMMAND: startTime=2018-01-09 14:39:45.304 requestID=yl6LbuQEyWKk.3 sourceCommandID=2 executionID=5 txID=TransactionImple < ac, BasicAction: 0:ffff0a2804a2:45f23ecc:5a54c5e8:f status: ActionStatus.RUNNING > modelName=Source translatorName=infinispan-hotrod sessionID=yl6LbuQEyWKk principal=user@teiid-security sql=UPDATE Source.SmallA SET IntKey = 100, IntNum = 1, StringNum = '1', FloatNum = 1.01, LongNum = 1, DoubleNum = -1.001, ByteNum = 1, DateValue = '1111-11-11', TimeValue = '01:01:01', TimestampValue = '1111-11-11 01:01:01.0', BooleanValue = TRUE, CharValue = '1', ShortValue = 1, BigIntegerValue = '1', BigDecimalValue = '1.01', ObjectValue = '1' WHERE StringKey = '1'
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5238) Issue in the example while running through Docker
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5238?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5238:
-------------------------------------
[~arvindo] Sorry all of the wildfly-swarm-examples we have are no longer valid as there were major changes with framework. All good, but I did not have a chance to re-work examples. I will try to write one, please add JIRA for that
You can see a sample add here https://github.com/rareddy/teiid-komodo/tree/master/server/komodo-rest
> 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)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5238) Issue in the example while running through Docker
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5238?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-5238.
---------------------------------
Resolution: Rejected
> 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)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5240) Add functionality for operators ILIKE / IREGEXP / RLIKE to Oracle translator
by Marc Shirley (JIRA)
Marc Shirley created TEIID-5240:
-----------------------------------
Summary: Add functionality for operators ILIKE / IREGEXP / RLIKE to Oracle translator
Key: TEIID-5240
URL: https://issues.jboss.org/browse/TEIID-5240
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors
Affects Versions: 8.12.12.6_3
Reporter: Marc Shirley
Assignee: Steven Hawkins
Request to add operations ILIKE / IREGEXP / RLIKE to the Oracle translator similar to what was added in TEIID-4711 for Impala.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5239) Add functionality for operators ILIKE / IREGEXP / RLIKE to Redshift translator
by Marc Shirley (JIRA)
Marc Shirley created TEIID-5239:
-----------------------------------
Summary: Add functionality for operators ILIKE / IREGEXP / RLIKE to Redshift translator
Key: TEIID-5239
URL: https://issues.jboss.org/browse/TEIID-5239
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors
Affects Versions: 8.12.12.6_3
Reporter: Marc Shirley
Assignee: Steven Hawkins
Request to add operations ILIKE / IREGEXP / RLIKE to the Redshift translator similar to what was added in TEIID-4711 for Impala.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5238) Issue in the example while running through Docker
by Arvind Gopinath (JIRA)
Arvind Gopinath created TEIID-5238:
--------------------------------------
Summary: 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
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)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5237) Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5237?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5237:
-------------------------------------
[~shawkins] I doubt if Mongo supports $in mixed types, it would take some investigation. I believe it is a slippery slope having single type with multiple data types. Sure we can scan more records and fail at the beginning.
> Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
> -------------------------------------------------------------------------------------------
>
> Key: TEIID-5237
> URL: https://issues.jboss.org/browse/TEIID-5237
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.3
> Environment: TEIID Embedded Server 8.12.3
> Datasource DB - MongoDB 3.4
> Java 1.7.0_71
> Reporter: Andriy G
> Assignee: Steven Hawkins
>
> Issue to search for values using IN operator against MongoDB document containing field values both string and integer. Resultset simply filters out INTEGER values that stored in that field
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5237) Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5237?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5237:
---------------------------------------
[~rareddy] I don't see anything in the translator logic that looks like it would handle this scenario - it seems straight forward that a $in is being built with string values. There's no support for convert nor does there seem to be an alternative name in source that would allow this. Do you think we should just add a doc note about the searchability workaround? On the import side it looks like scanning stops at the first document instance, so the logic won't detect type conflicts there currently. There is some accounting of this in the couchbase translator that we could do here as well.
> Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
> -------------------------------------------------------------------------------------------
>
> Key: TEIID-5237
> URL: https://issues.jboss.org/browse/TEIID-5237
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.3
> Environment: TEIID Embedded Server 8.12.3
> Datasource DB - MongoDB 3.4
> Java 1.7.0_71
> Reporter: Andriy G
> Assignee: Steven Hawkins
>
> Issue to search for values using IN operator against MongoDB document containing field values both string and integer. Resultset simply filters out INTEGER values that stored in that field
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5185) JDBC client intermittently hangs when processing multi-batch result sets from VIPped Teiid server
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5185?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5185:
---------------------------------------
I have been trying to reproduce this using haproxy, but without success so far. Do you have additional details, such as the row count of the results, number of server instances, and load balancing algorithm?
Generally we'll require an algorithm that provides for sticky connections.
> JDBC client intermittently hangs when processing multi-batch result sets from VIPped Teiid server
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-5185
> URL: https://issues.jboss.org/browse/TEIID-5185
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver, Server
> Affects Versions: 9.3.4
> Environment: JDBC client was run through Apache JMeter, on a 64-bit Windows 7 Enterprise SP1 machine, using 64-bit JDK 8;
> Teiid Server runs on Linux.
> Reporter: Krum Bakalsky
> Assignee: Steven Hawkins
> Fix For: 10.2
>
>
> We have a server-side application that is powered by Teiid version 9.3.4, and that exposes a Teiid JDBC endpoint to its clients.
> A couple of app instances are configured to sit behind a VIP load balancer, that works on the TCP level.
> We have been experiencing intermittently following problem, when we run Teiid 9.3.4 client to execute multi-batch queries to the server:
> * client successfully fetches few batches from server;
> * client hangs and its thread blocks on waiting for the next batch to be delivered on the network;
> * after 1 hour client throws exceptions that Socket is closed.
> When building up the JDBC connection URL the client refers directly to the server's VIP, and does not list particular server hosts:
> jdbc:teiid:<Application>@mm://<VIP's DNS name>:<port>
> Client thread's call stack:
> {code}
> "Thread Group 1-1" #41 prio=6 os_prio=0 tid=0x000000005e03a800 nid=0x17bc runnable [0x00000000623ae000]
> java.lang.Thread.State: RUNNABLE
> at java.net.SocketInputStream.socketRead0(Native Method)
> at java.net.SocketInputStream.socketRead(Unknown Source)
> at java.net.SocketInputStream.read(Unknown Source)
> at java.net.SocketInputStream.read(Unknown Source)
> at java.io.BufferedInputStream.fill(Unknown Source)
> at java.io.BufferedInputStream.read(Unknown Source)
> - locked <0x00000000f5f32420> (a org.teiid.core.util.AccessibleBufferedInputStream)
> at java.io.DataInputStream.readInt(Unknown Source)
> at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
> at java.io.ObjectInputStream.readObject(Unknown Source)
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:324)
> at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy21.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:427)
> at org.teiid.jdbc.ResultSetImpl.getResults(ResultSetImpl.java:449)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:382)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:227)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:142)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:253)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:510)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:259)
> at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
> at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.getStringFromResultSet(AbstractJDBCTestElement.java:535)
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.execute(AbstractJDBCTestElement.java:174)
> at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:84)
> at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:491)
> at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:425)
> at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:254)
> at java.lang.Thread.run(Unknown Source)
> Locked ownable synchronizers:
> - None
> {code}
> Client side exception after 1 hour:
> {code}
> 2017-12-19 13:17:07,160 WARN o.a.j.p.j.AbstractJDBCTestElement: Error closing ResultSet
> org.teiid.jdbc.TeiidSQLException: TEIID20013 java.net.SocketException: Socket closed
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:168) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.apache.commons.dbcp2.DelegatingResultSet.close(DelegatingResultSet.java:170) ~[commons-dbcp2-2.1.1.jar:2.1.1]
> at org.apache.commons.dbcp2.DelegatingResultSet.close(DelegatingResultSet.java:170) ~[commons-dbcp2-2.1.1.jar:2.1.1]
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.close(AbstractJDBCTestElement.java:607) [ApacheJMeter_jdbc.jar:3.2 r1790748]
> at org.apache.jmeter.protocol.jdbc.AbstractJDBCTestElement.execute(AbstractJDBCTestElement.java:176) [ApacheJMeter_jdbc.jar:3.2 r1790748]
> at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:84) [ApacheJMeter_jdbc.jar:3.2 r1790748]
> at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:491) [ApacheJMeter_core.jar:3.2 r1790748]
> at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:425) [ApacheJMeter_core.jar:3.2 r1790748]
> at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:254) [ApacheJMeter_core.jar:3.2 r1790748]
> at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]
> Caused by: org.teiid.core.TeiidComponentException: TEIID20013 java.net.SocketException: Socket closed
> at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:65) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:445) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20013 java.net.SocketException: Socket closed
> at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:217) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_121]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy21.send(Unknown Source) ~[?:?]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:433) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> Caused by: java.util.concurrent.ExecutionException: java.net.SocketException: Socket closed
> at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:104) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:99) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:214) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_121]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy21.send(Unknown Source) ~[?:?]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:433) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> Caused by: java.net.SocketException: Socket closed
> at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_121]
> at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_121]
> at java.io.DataOutputStream.write(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.core.util.MultiArrayOutputStream.writeTo(MultiArrayOutputStream.java:94) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.netty.handler.codec.serialization.ObjectEncoderOutputStream.writeObjectOverride(ObjectEncoderOutputStream.java:70) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at java.io.ObjectOutputStream.writeObject(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.write(OioOjbectChannelFactory.java:136) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:213) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_121]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_121]
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy21.send(Unknown Source) ~[?:?]
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:433) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:293) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> at com.sun.proxy.$Proxy24.closeRequest(Unknown Source) ~[?:?]
> at org.teiid.jdbc.ResultSetImpl.close(ResultSetImpl.java:164) ~[teiid-9.3.4-jdbc.jar:9.3.4]
> ... 9 more
> {code}
> Server-side log excerpt, after raising logger levels to Debug:
> {code}
> 2017-12-15 12:00:45.625 [NIO36 ] DEBUG - processing message:MessageHolder: key=550774 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 2017-12-15 12:00:47.730 [ocessorQueue14017479] DEBUG - send message: MessageHolder: key=550774 contents=ResultsMessage rowCount=256 finalRow=-1
> 2017-12-15 12:00:47.737 [NIO36 ] DEBUG - processing message:MessageHolder: key=550776 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:47.738 [ocessorQueue14017553] DEBUG - send message: MessageHolder: key=550776 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:47.755 [NIO36 ] DEBUG - processing message:MessageHolder: key=550777 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:47.756 [ocessorQueue14017554] DEBUG - send message: MessageHolder: key=550777 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:48.389 [NIO36 ] DEBUG - processing message:MessageHolder: key=550778 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:48.389 [ocessorQueue14017556] DEBUG - send message: MessageHolder: key=550778 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:48.825 [NIO36 ] DEBUG - processing message:MessageHolder: key=550779 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:48.826 [ocessorQueue14017557] DEBUG - send message: MessageHolder: key=550779 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:00:48.932 [NIO36 ] DEBUG - processing message:MessageHolder: key=550780 contents=Invoke interface org.teiid.client.DQP.processCursorRequest
> 2017-12-15 12:00:48.933 [ocessorQueue14017558] DEBUG - send message: MessageHolder: key=550780 contents=ResultsMessage rowCount=2048 finalRow=-1
> 2017-12-15 12:02:18.386 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:05:55.327 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:09:29.545 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:13:08.903 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:16:41.864 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:20:16.875 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:23:57.860 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:27:30.273 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:31:07.795 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:34:46.439 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:38:23.325 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:41:59.227 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:45:35.526 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:49:14.088 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:52:46.177 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 12:56:24.407 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 13:00:03.109 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 13:00:52.143 [NIO36 ] DEBUG - TEIID40114 Unhandled exception, closing client instance: Connection reset by peer
> java.io.IOException: Connection reset by peer
> at sun.nio.ch.FileDispatcherImpl.read0(Native Method)
> at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)
> at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)
> at sun.nio.ch.IOUtil.read(IOUtil.java:192)
> at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)
> at io.netty.buffer.UnpooledUnsafeDirectByteBuf.setBytes(UnpooledUnsafeDirectByteBuf.java:447)
> at io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:880)
> at io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:242)
> at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:119)
> at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:112)
> at java.lang.Thread.run(Thread.java:745)
> 2017-12-15 13:00:52.143 [NIO36 ] DEBUG - Channel closed
> 2017-12-15 13:03:34.811 [NIO36 ] DEBUG - Channel closed
> {code}
> Legend:
> * 'Channel closed' is logged from org.teiid.transport.SSLAwareChannelHandler class, and its channelInactive method;
> * 'MessageHolder' logs are from org.teiid.net.socket.Message;
> * the log lines that contain rowCount, finalRow, etc. are coming from org.teiid.transport.SocketClientInstance.
> The problem is rarely reproducible, but it happens a few times every day, while running the JMeter tests full day.
> We are also running JMeter in a scenario where the client is referring directly to a server URL, therefore skipping the VIP. We haven't been able to reproduce the problem in this setting so far, which suggests that the issue has something to do with the VIP setup.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 10 months
- 1
- 0