odata 4 error

[cute u]

my log is below:

11:24:46,755 WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (Worker63_QueryProcessorQueue1139) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@34baf6bd[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@417e7c15 connection handles=1 lastUse=1509327849616 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2c5fd5ae pool internal context=SemaphoreArrayListManagedConnectionPool@5a968807[pool=JD_UDB_MDB] xaResource=LocalXAResourceImpl@2e0995f3[connectionListener=34baf6bd connectionManager=36c1bdee warned=false currentXid=null productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/JD_UDB_MDB] txSync=null]: java.sql.SQLRecoverableException: IO Error: Connection timed out (Read failed)

11:24:46,764 WARN  [org.teiid.CONNECTOR] (Worker63_QueryProcessorQueue1139) Connector worker process failed for atomic-request=h6WMo0rlS29i.0.30.321: org.teiid.translator.jdbc.JDBCExecutionException: 17002 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."A1" AS c_0, g_0."U_ID" AS c_1 FROM "UDB_MDB"."UD_MAPPED_ICS" g_0 WHERE g_0."U_ID" >= 1400000000 AND g_0."U_ID" <= 1499999999 ORDER BY c_0]

[Steven Hawkins]

The exception doesn't appear related to odata.  If you issue a similar query directly over Teiid JDBC/ODBC does making the source connection also time out?

[cute u]

in jdbc there is no error,

[Steven Hawkins]

Can you provide more of the logs?  There is very little that would be different about the odata path vs. Teiid JDBC - in fact about the only thing that could be significantly different is if a transaction is started.

[cute u]

This is the log

09:55:36,085 ERROR [org.teiid.ODATA] (http-0.0.0.0:8180-14) TEIID16052 Unable to process odata request due to: TEIID31138 Cannot add batch to invalidated cache group "2,139".  Check prior logs to see if there was an error persisting a batch.: org.teiid.core.TeiidComponentException: TEIID31138 Cannot add batch to invalidated cache group "2,139".  Check prior logs to see if there was an error persisting a batch.

  at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.createManagedBatch(BufferManagerImpl.java:237)

  at org.teiid.common.buffer.TupleBuffer.saveBatch(TupleBuffer.java:250)

  at org.teiid.common.buffer.TupleBuffer.addTuple(TupleBuffer.java:183)

  at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:277)

  at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:197)

  at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112)

  at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206)

  at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:635)

  at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285)

  at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290)

  at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154)

  at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)

  at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)

  at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)

  at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)

  at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)

  at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:306)

  at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:238)

  at sun.reflect.GeneratedMethodAccessor267.invoke(Unknown Source) [:1.8.0_144]

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_144]

  at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_144]

  at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.teiid.jboss.TransportService$2.invoke(TransportService.java:241)

  at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)

  at sun.reflect.GeneratedMethodAccessor267.invoke(Unknown Source) [:1.8.0_144]

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_144]

  at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_144]

  at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:205)

  at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_144]

  at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

  at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264)

  at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:203)

  at com.sun.proxy.$Proxy20.executeRequest(Unknown Source)

  at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:688)

  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:554)

  at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:260)

  at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73)

  at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:234) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:349) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:172) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)

  at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)

  at org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)

  at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)

  at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:66)

  at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.11.6_3-redhat-3.jar:8.12.11.6_3-redhat-3]

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2]

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]

  at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_144]

[Steven Hawkins]

That should be mostly unrelated to the connection exception.  There would also be an earlier exception that caused the cache group to be invalidated - out of disk space, serialization issue, etc.  Do you see anything further back in the log?

[cute u]

this is the log file

[Steven Hawkins]

The preceding message is the cause of the batch error:

09:55:35,282 ERROR [org.teiid.BUFFER_MGR] (FileStore Worker6) TEIID30016 Error transferring block 12,488,127 of cache group 2,139 to storage  Max buffer space of 53,687,091,200 bytes has been exceed with an allocation of 16,384 bytes for a total of 53,687,115,776.  The current operation will be aborted.

By default Teiid is configured with a 50 GB file storage limit.  So you'll next need to determine if more storage space should be given, or if that is well beyond what you expect Teiid to consume - this space is used by all temporary work, materialized views / temp tables, cached results, etc. that spills to disk.

[cute u]

ok,i will set more storage space for teiid on the server,but how to update the default 50GB on teiid

[Steven Hawkins]

That is under the settings for the buffer manager.  If you are using the standalone deployment, you can just edit the standalone-teiid.xml otherwise you would use the cli.  See Memory Management · Teiid Documentation

You would issue something like:

/subsystem=teiid:write-attribute(name=buffer-service-max-buffer-space,value=100000)

Where value is in megabytes and a restart will be required.

[cute u]

Thanks for all of your help,I will try it