com.mirth.connect.plugins.datapruner.DataPrunerException

com.mirth.connect.util.MessageExporter$MessageExportException: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: Ran out of memory retrieving query results.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4

  • via Mirth Project by Daniel Svanstedt, 1 year ago
    com.mirth.connect.util.MessageExporter$MessageExportException: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: Ran out of memory retrieving query results.
  • via Mirth Project by Daniel Svanstedt, 9 months ago
    com.mirth.connect.util.MessageExporter$MessageExportException: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: Ran out of memory retrieving query results.
  • Stack trace

    • com.mirth.connect.plugins.datapruner.DataPrunerException: com.mirth.connect.util.MessageExporter$MessageExportException: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: Ran out of memory retrieving query results. at com.mirth.connect.plugins.datapruner.DataPruner.archiveAndGetIdsToPrune(DataPruner.java:553) at com.mirth.connect.plugins.datapruner.DataPruner.pruneChannel(DataPruner.java:429) at com.mirth.connect.plugins.datapruner.DataPruner.run(DataPruner.java:301) at java.lang.Thread.run(Thread.java:745) Caused by: com.mirth.connect.util.MessageExporter$MessageExportException: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: Ran out of memory retrieving query results. at com.mirth.connect.plugins.datapruner.DataPruner.archiveAndGetIdsToPrune(DataPruner.java:537) ... 3 more Caused by: com.mirth.connect.donkey.server.data.DonkeyDaoException: org.postgresql.util.PSQLException: Ran out of memory retrieving query results. at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.getMessageContent(JdbcDao.java:2031) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.getConnectorMessageFromResultSet(JdbcDao.java:1993) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.getConnectorMessages(JdbcDao.java:1452) at com.mirth.connect.plugins.datapruner.DataPruner.getMessagesForArchive(DataPruner.java:579) at com.mirth.connect.plugins.datapruner.DataPruner.archiveAndGetIdsToPrune(DataPruner.java:515) ... 3 more Caused by: org.postgresql.util.PSQLException: Ran out of memory retrieving query results. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1898) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.getMessageContent(JdbcDao.java:2015) ... 7 more Caused by: java.lang.OutOfMemoryError: Java heap space ERROR 2014-12-15 00:09:20,166 [Thread-564] com.mirth.connect.plugins.datapruner.DataPruner: Failed to prune messages for channel CDM to Mirth Results - OLD (c547bf4b-ccb2-4da9-a976-65a8653bcd52). Attempts remaining: 2. com.mirth.connect.plugins.datapruner.DataPrunerException: com.mirth.connect.util.MessageExporter$MessageExportException: Failed to export message: Could not write to "file:///folders/archive/messages/2014-12-15-00-00-00/.c547bf4b-ccb2-4da9-a976-65a8653bcd52/2014-02-28 11:55:53.819.hl7" because it is currently in use. at com.mirth.connect.plugins.datapruner.DataPruner.archiveAndGetIdsToPrune(DataPruner.java:553) ... 3 more Caused by: com.mirth.connect.util.MessageExporter$MessageExportException: Failed to export message: Could not write to "file:///folders/archive/messages/2014-12-15-00-00-00/.c547bf4b-ccb2-4da9-a976-65a8653bcd52/2014-02-28 11:55:53.819.hl7" because it is currently in use. at com.mirth.connect.plugins.datapruner.DataPruner.archiveAndGetIdsToPrune(DataPruner.java:527) ... 3 more Caused by: org.apache.commons.vfs2.FileSystemException: Could not write to "file:///folders/archive/messages/2014-12-15-00-00-00/.c547bf4b-ccb2-4da9-a976-65a8653bcd52/2014-02-28 11:55:53.819.hl7" because it is currently in use. at org.apache.commons.vfs2.provider.DefaultFileContent.getOutputStream(DefaultFileContent.java:457) at com.mirth.connect.util.messagewriter.MessageWriterVfs.write(MessageWriterVfs.java:142) at com.mirth.connect.util.messagewriter.MessageWriterArchive.write(MessageWriterArchive.java:52) at com.mirth.connect.plugins.datapruner.DataPruner.archiveAndGetIdsToPrune(DataPruner.java:521) ... 3 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.