PSQLException: This statement has been closed

0
Sometimes I get the following exception (it doesn't happen all the time, but rather frequently), does anyone have an idea what could cause this? I have tried to Google the error, but the results I get do not help me. I am running Mendix 6.6.0 in the standard Mendix cloud.   Oct 13 11:45:21.741 127.0.0.1 tr10000: ERROR - ActionManager: Exception in execution of monitored action '{"name":"Module.MicroflowName","type":"Microflow"}' (execution id: 9c621bb1-0a2a-4309-b24e-e20dc0a3fb69, execution type: CLIENT_ASYNC_MONITORED) Oct 13 11:45:21.749 127.0.0.1 tr10000: ERROR - ActionManager: (1/111) com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): Oct 13 11:45:21.749 127.0.0.1 tr10000: ERROR - ActionManager: (2/111) IdentifierGetRequest: Object types: [Module.Entity] Oct 13 11:45:21.750 127.0.0.1 tr10000: ERROR - ActionManager: (3/111) at Module.MicroflowName2 (RetrieveFromCache : 'Retrieve Entity by $Account/Association') Oct 13 11:45:21.750 127.0.0.1 tr10000: ERROR - ActionManager: (4/111) at Module.MicroflowName (SubMicroflow : 'MicroflowName2') Oct 13 11:45:21.750 127.0.0.1 tr10000: ERROR - ActionManager: (5/111) Oct 13 11:45:21.750 127.0.0.1 tr10000: ERROR - ActionManager: (6/111) Advanced stacktrace: Oct 13 11:45:21.750 127.0.0.1 tr10000: ERROR - ActionManager: (7/111) at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:143) Oct 13 11:45:21.750 127.0.0.1 tr10000: ERROR - ActionManager: (8/111) Oct 13 11:45:21.751 127.0.0.1 tr10000: ERROR - ActionManager: (9/111) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): Oct 13 11:45:21.751 127.0.0.1 tr10000: ERROR - ActionManager: (10/111) IdentifierGetRequest: Object types: [Module.Entity] Oct 13 11:45:21.751 127.0.0.1 tr10000: ERROR - ActionManager: (11/111) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Oct 13 11:45:21.751 127.0.0.1 tr10000: ERROR - ActionManager: (12/111) Oct 13 11:45:21.751 127.0.0.1 tr10000: ERROR - ActionManager: (13/111) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): Oct 13 11:45:21.751 127.0.0.1 tr10000: ERROR - ActionManager: (14/111) IdentifierGetRequest: Object types: [Module.Entity] Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (15/111) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (16/111) Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (17/111) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (18/111) IdentifierGetRequest: Object types: [Module.Entity] Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (19/111) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (20/111) Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (21/111) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): Oct 13 11:45:21.752 127.0.0.1 tr10000: ERROR - ActionManager: (22/111) IdentifierGetRequest: Object types: [Module.Entity] Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (23/111) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (24/111) Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (25/111) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (26/111) IdentifierGetRequest: Object types: [Module.Entity] Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (27/111) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:46) Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (28/111) Oct 13 11:45:21.753 127.0.0.1 tr10000: ERROR - ActionManager: (29/111) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 55000, Error Code: 0) Oct 13 11:45:21.754 127.0.0.1 tr10000: ERROR - ActionManager: (30/111) at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.getCorrectException(JDBCDataStore.java:1203) Oct 13 11:45:21.754 127.0.0.1 tr10000: ERROR - ActionManager: (31/111) Oct 13 11:45:21.754 127.0.0.1 tr10000: ERROR - ActionManager: (32/111) Caused by: org.postgresql.util.PSQLException: This statement has been closed. Oct 13 11:45:21.754 127.0.0.1 tr10000: ERROR - ActionManager: (33/111) at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:893) Oct 13 11:45:21.754 127.0.0.1 tr10000: ERROR - ActionManager: (34/111) at org.postgresql.jdbc.PgStatement.getMaxRows(PgStatement.java:479) Oct 13 11:45:21.754 127.0.0.1 tr10000: ERROR - ActionManager: (35/111) at org.postgresql.jdbc.PgStatement.createResultSet(PgStatement.java:181) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (36/111) at org.postgresql.jdbc.PgStatement$StatementResultHandler.handleResultRows(PgStatement.java:231) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (37/111) at org.postgresql.core.v3.QueryExecutorImpl$1.handleResultRows(QueryExecutorImpl.java:398) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (38/111) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1947) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (39/111) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (40/111) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (41/111) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321) Oct 13 11:45:21.755 127.0.0.1 tr10000: ERROR - ActionManager: (42/111) at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:284) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (43/111) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (44/111) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (45/111) at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQuery(JDBCDataStore.java:308) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (46/111) at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQueries(JDBCDataStore.java:203) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (47/111) at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:168) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (48/111) at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:157) Oct 13 11:45:21.756 127.0.0.1 tr10000: ERROR - ActionManager: (49/111) at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229) Oct 13 11:45:21.757 127.0.0.1 tr10000: ERROR - ActionManager: (50/111) at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196) Oct 13 11:45:21.757 127.0.0.1 tr10000: ERROR - ActionManager: (51/111) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:78) Oct 13 11:45:21.757 127.0.0.1 tr10000: ERROR - ActionManager: (52/111) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:62) Oct 13 11:45:21.757 127.0.0.1 tr10000: ERROR - ActionManager: (53/111) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:41) Oct 13 11:45:21.757 127.0.0.1 tr10000: ERROR - ActionManager: (54/111) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:449) Oct 13 11:45:21.757 127.0.0.1 tr10000: ERROR - ActionManager: (55/111) at com.mendix.core.action.user.Retriever$class.retrieveFromDatabase(Retriever.scala:32) Oct 13 11:45:21.758 127.0.0.1 tr10000: ERROR - ActionManager: (56/111) at com.mendix.core.action.user.RetrieveIdAction.retrieveFromDatabase(RetrieveIdAction.scala:9) Oct 13 11:45:21.758 127.0.0.1 tr10000: ERROR - ActionManager: (57/111) at com.mendix.core.action.user.RetrieveIdAction.retrieveFromDatabase(RetrieveIdAction.scala:32) Oct 13 11:45:21.758 127.0.0.1 tr10000: ERROR - ActionManager: (58/111) at com.mendix.core.action.user.RetrieveIdAction.executeAction(RetrieveIdAction.scala:27) Oct 13 11:45:21.760 127.0.0.1 tr10000: ERROR - ActionManager: (59/111) at com.mendix.core.action.user.RetrieveIdAction.executeAction(RetrieveIdAction.scala:9) Oct 13 11:45:21.760 127.0.0.1 tr10000: ERROR - ActionManager: (60/111) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) Oct 13 11:45:21.760 127.0.0.1 tr10000: ERROR - ActionManager: (61/111) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) Oct 13 11:45:21.760 127.0.0.1 tr10000: ERROR - ActionManager: (62/111) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (63/111) at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (64/111) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (65/111) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (66/111) at com.mendix.core.component.InternalCore.retrieveId(InternalCore.java:921) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (67/111) at com.mendix.core.action.user.RetrieveByPathAction.retrieveFromSameSide(RetrieveByPathAction.scala:49) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (68/111) at com.mendix.core.action.user.RetrieveByPathAction.executeAction(RetrieveByPathAction.scala:41) Oct 13 11:45:21.761 127.0.0.1 tr10000: ERROR - ActionManager: (69/111) at com.mendix.core.action.user.RetrieveByPathAction.executeAction(RetrieveByPathAction.scala:12) Oct 13 11:45:21.762 127.0.0.1 tr10000: ERROR - ActionManager: (70/111) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) Oct 13 11:45:21.762 127.0.0.1 tr10000: ERROR - ActionManager: (71/111) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) Oct 13 11:45:21.762 127.0.0.1 tr10000: ERROR - ActionManager: (72/111) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) Oct 13 11:45:21.762 127.0.0.1 tr10000: ERROR - ActionManager: (73/111) at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168) Oct 13 11:45:21.763 127.0.0.1 tr10000: ERROR - ActionManager: (74/111) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) Oct 13 11:45:21.763 127.0.0.1 tr10000: ERROR - ActionManager: (75/111) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) Oct 13 11:45:21.763 127.0.0.1 tr10000: ERROR - ActionManager: (76/111) at com.mendix.core.component.InternalCore.retrieveByPath(InternalCore.java:900) Oct 13 11:45:21.763 127.0.0.1 tr10000: ERROR - ActionManager: (77/111) at com.mendix.modules.microflowengine.actions.mxobject.RetrieveFromCacheAction.execute(RetrieveAction.scala:38) Oct 13 11:45:21.763 127.0.0.1 tr10000: ERROR - ActionManager: (78/111) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) Oct 13 11:45:21.763 127.0.0.1 tr10000: ERROR - ActionManager: (79/111) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:192) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (80/111) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:149) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (81/111) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (82/111) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (83/111) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (84/111) at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (85/111) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) Oct 13 11:45:21.764 127.0.0.1 tr10000: ERROR - ActionManager: (86/111) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (87/111) at com.mendix.core.component.InternalCore.executeSync(InternalCore.java:459) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (88/111) at com.mendix.modules.microflowengine.actions.SubMicroflowAction.execute(SubMicroflowAction.scala:43) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (89/111) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (90/111) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:192) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (91/111) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:149) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (92/111) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) Oct 13 11:45:21.765 127.0.0.1 tr10000: ERROR - ActionManager: (93/111) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) Oct 13 11:45:21.766 127.0.0.1 tr10000: ERROR - ActionManager: (94/111) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) Oct 13 11:45:21.766 127.0.0.1 tr10000: ERROR - ActionManager: (95/111) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:14) Oct 13 11:45:21.766 127.0.0.1 tr10000: ERROR - ActionManager: (96/111) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:144) Oct 13 11:45:21.766 127.0.0.1 tr10000: ERROR - ActionManager: (97/111) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) Oct 13 11:45:21.766 127.0.0.1 tr10000: ERROR - ActionManager: (98/111) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:146) Oct 13 11:45:21.766 127.0.0.1 tr10000: ERROR - ActionManager: (99/111) at scala.util.Try$.apply(Try.scala:192) Oct 13 11:45:21.767 127.0.0.1 tr10000: ERROR - ActionManager: (100/111) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:140) Oct 13 11:45:21.767 127.0.0.1 tr10000: ERROR - ActionManager: (101/111) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) Oct 13 11:45:21.767 127.0.0.1 tr10000: ERROR - ActionManager: (102/111) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:136) Oct 13 11:45:21.767 127.0.0.1 tr10000: ERROR - ActionManager: (103/111) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) Oct 13 11:45:21.767 127.0.0.1 tr10000: ERROR - ActionManager: (104/111) at akka.actor.ActorCell.invoke(ActorCell.scala:487) Oct 13 11:45:21.767 127.0.0.1 tr10000: ERROR - ActionManager: (105/111) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) Oct 13 11:45:21.768 127.0.0.1 tr10000: ERROR - ActionManager: (106/111) at akka.dispatch.Mailbox.run(Mailbox.scala:220) Oct 13 11:45:21.768 127.0.0.1 tr10000: ERROR - ActionManager: (107/111) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) Oct 13 11:45:21.768 127.0.0.1 tr10000: ERROR - ActionManager: (108/111) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) Oct 13 11:45:21.768 127.0.0.1 tr10000: ERROR - ActionManager: (109/111) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) Oct 13 11:45:21.768 127.0.0.1 tr10000: ERROR - ActionManager: (110/111) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) Oct 13 11:45:21.768 127.0.0.1 tr10000: ERROR - ActionManager: (111/111) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)  
asked
2 answers
1

I found this discussion when I encountered the same problem. It happens when we execute a microflow in the background. One thing we did that seems to solve the issue is to set the boolean attribute for 'executeInTransaction' of 'Core.executeAsync()' to 'true'. Hope this helps someone!

answered
0

Hmm... SQL State: 55000.  Googling that error brings up some issues with Postgres, which you probably have no control over.  Also have you looked at this post:

https://forum.mendix.com/link/questions/431

 

Similar error, but caused by out of memory. HTH

answered