0

I am getting this exception continuously  only on one environment and for other environment not getting even single exception.  not getting exact root cause.  Did anyone encounter similar problems? {"level":"ERROR","message":"JdbcDataStore::execRetrieveQuery failed with SQLState: 08006, error code: 0, message: An I/O error occurred while sending to the backend.","message_ts":"2023-06-19T06:40:49.388Z","prefix":"ConnectionBus_Retrieve","stacktrace":["org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.","\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:383)","\tat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)","\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)","\tat org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)","\tat org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177)","\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)","\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)","\tat com.mendix.connectionbus.connections.jdbc.RetrieveQueryExecutor.$anonfun$execRetrieveQuery$1(RetrieveQueryExecutor.scala:29)","\tat com.mendix.connectionbus.connections.jdbc.RetrieveQueryExecutor.withStatement(RetrieveQueryExecutor.scala:71)","\tat com.mendix.connectionbus.connections.jdbc.RetrieveQueryExecutor.execRetrieveQuery(RetrieveQueryExecutor.scala:24)","\tat com.mendix.connectionbus.connections.jdbc.implementations.postgresql.PostgreSqlRetrieveQueryExecutor.execRetrieveQuery(PostgreSqlRetrieveQueryExecutor.scala:30)","\tat com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.scala:149)","\tat com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.scala:114)","\tat com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForLocal(QueryRequestExecutor.scala:102)","\tat com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:34)","\tat com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:35)","\tat scala.Option.map(Option.scala:242)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:32)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:26)","\tat scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:118)","\tat scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:105)","\tat scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:26)","\tat com.mendix.connectionbus.retrieve.GetRequestHandler.doOtherRequests(GetRequestHandler.scala:69)","\tat com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.scala:29)","\tat com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:30)","\tat com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.scala:470)","\tat com.mendix.modules.queue.TaskQueue.claimTasks(TaskQueue.scala:273)","\tat com.mendix.modules.queue.TaskQueue.$anonfun$acquire$1(TaskQueue.scala:131)","\tat com.mendix.logging.impl.LogManager.suppressLogMessagesInThreadBelow(LogManager.java:52)","\tat com.mendix.modules.queue.TaskQueue.acquire(TaskQueue.scala:114)","\tat com.mendix.modules.queue.TaskDispatcher.acquireTasks(TaskDispatcher.scala:177)","\tat com.mendix.modules.queue.TaskDispatcher.poll(TaskDispatcher.scala:147)","\tat com.mendix.modules.queue.TaskDispatcher.$anonfun$pollThread$1(TaskDispatcher.scala:44)","\tat java.base/java.lang.Thread.run(Unknown Source)","Caused by: ","java.net.SocketException: Connection reset","\tat java.base/java.net.SocketInputStream.read(Unknown Source)","\tat java.base/java.net.SocketInputStream.read(Unknown Source)","\tat org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)","\tat org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)","\tat org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)","\tat org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)","\tat org.postgresql.core.PGStream.receiveChar(PGStream.java:453)","\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2120)","\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2099)","\tat org.postgresql.core.v3.QueryExecutorImpl.flushIfDeadlockRisk(QueryExecutorImpl.java:1456)","\tat org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1481)","\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:348)","\tat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)","\tat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)","\tat org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)","\tat org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177)","\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)","\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)","\tat com.mendix.connectionbus.connections.jdbc.RetrieveQueryExecutor.$anonfun$execRetrieveQuery$1(RetrieveQueryExecutor.scala:29)","\tat com.mendix.connectionbus.connections.jdbc.RetrieveQueryExecutor.withStatement(RetrieveQueryExecutor.scala:71)","\tat com.mendix.connectionbus.connections.jdbc.RetrieveQueryExecutor.execRetrieveQuery(RetrieveQueryExecutor.scala:24)","\tat com.mendix.connectionbus.connections.jdbc.implementations.postgresql.PostgreSqlRetrieveQueryExecutor.execRetrieveQuery(PostgreSqlRetrieveQueryExecutor.scala:30)","\tat com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.scala:149)","\tat com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.scala:114)","\tat com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForLocal(QueryRequestExecutor.scala:102)","\tat com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:34)","\tat com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:35)","\tat scala.Option.map(Option.scala:242)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:32)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:26)","\tat scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:118)","\tat scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:105)","\tat scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35)","\tat com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:26)","\tat com.mendix.connectionbus.retrieve.GetRequestHandler.doOtherRequests(GetRequestHandler.scala:69)","\tat com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.scala:29)","\tat com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:30)","\tat com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.scala:470)","\tat com.mendix.modules.queue.TaskQueue.claimTasks(TaskQueue.scala:273)","\tat com.mendix.modules.queue.TaskQueue.$anonfun$acquire$1(TaskQueue.scala:131)","\tat com.mendix.logging.impl.LogManager.suppressLogMessagesInThreadBelow(LogManager.java:52)","\tat com.mendix.modules.queue.TaskQueue.acquire(TaskQueue.scala:114)","\tat com.mendix.modules.queue.TaskDispatcher.acquireTasks(TaskDispatcher.scala:177)","\tat com.mendix.modules.queue.TaskDispatcher.poll(TaskDispatcher.scala:147)","\tat com.mendix.modules.queue.TaskDispatcher.$anonfun$pollThread$1(TaskDispatcher.scala:44)","\tat java.base/java.lang.Thread.run(Unknown Source)"],"system_nt":412136664808605}

asked 2023-06-19

1 answers