com.mirth.connect.donkey.server.data.DonkeyDaoException

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

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

  • To reproduce, blast messages at a channel with source queueing turned on and let messages queue up on the source. Then go to the message browser and remove results. This error should appear after at least a few tries. {noformat} ERROR 2014-12-03 10:29:31,148 [Thread-23] com.mirth.connect.donkey.server.channel.Channel: An error occurred in channel TCP Listener 1 (57bd25e4-1142-4f3d-86be-490e57dad496) while processing message ID 1578 from the source queue com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:507) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:102) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:74) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:56) at com.mirth.connect.donkey.server.channel.Channel.process(Channel.java:1604) at com.mirth.connect.donkey.server.channel.Channel.processSourceQueue(Channel.java:1738) at com.mirth.connect.donkey.server.channel.Channel.run(Channel.java:1725) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "d_mcm3_pkey" Detail: Key (message_id, metadata_id)=(1578, 0) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) 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.executeUpdate(AbstractJdbc2Statement.java:365) at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:504) ... 7 more {noformat}
    via by Brent Moen,
  • To reproduce, blast messages at a channel with source queueing turned on and let messages queue up on the source. Then go to the message browser and remove results. This error should appear after at least a few tries. {noformat} ERROR 2014-12-03 10:29:31,148 [Thread-23] com.mirth.connect.donkey.server.channel.Channel: An error occurred in channel TCP Listener 1 (57bd25e4-1142-4f3d-86be-490e57dad496) while processing message ID 1578 from the source queue com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:507) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:102) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:74) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:56) at com.mirth.connect.donkey.server.channel.Channel.process(Channel.java:1604) at com.mirth.connect.donkey.server.channel.Channel.processSourceQueue(Channel.java:1738) at com.mirth.connect.donkey.server.channel.Channel.run(Channel.java:1725) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "d_mcm3_pkey" Detail: Key (message_id, metadata_id)=(1578, 0) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) 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.executeUpdate(AbstractJdbc2Statement.java:365) at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:504) ... 7 more {noformat}
    via by Brent Moen,
  • Hibernate JoinColumn Error on not null constraint
    via by Unknown author,
  • GitHub comment 38#63986297
    via GitHub by pogster
    ,
    • com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:507) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:102) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:74) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:56) at com.mirth.connect.donkey.server.channel.Channel.process(Channel.java:1604) at com.mirth.connect.donkey.server.channel.Channel.processSourceQueue(Channel.java:1738) at com.mirth.connect.donkey.server.channel.Channel.run(Channel.java:1725) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "d_mcm3_pkey" Detail: Key (message_id, metadata_id)=(1578, 0) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) 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.executeUpdate(AbstractJdbc2Statement.java:365) at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:504) ... 7 more

    Users with the same issue

    silexsilex
    5 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    jokesterjokester
    2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    92 more bugmates