Announcement

Collapse
No announcement yet.

duplicate key value violates unique constraint "d_mcm6_pkey"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • duplicate key value violates unique constraint "d_mcm6_pkey"

    Suddenly today we are getting the following error from Mirth Connect.
    Mirth Connect Server 3.8.0
    Built on May 22, 2019
    Java version: 1.8.0_181


    [2019-10-07 07:45:29,703] ERROR (com.mirth.connect.donkey.server.channel.Destinati onChain:148): Error processing destination processVXU-V04 for channel <erased>.
    com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: Failed to insert connector message meta data
    at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. insertMetaData(JdbcDao.java:717)
    at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.executeTasks(BufferedDao.java:115)
    at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.commit(BufferedDao.java:85)
    at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.commit(BufferedDao.java:72)
    at com.mirth.connect.donkey.server.channel.Destinatio nConnector.afterSend(DestinationConnector.java:941 )
    at com.mirth.connect.donkey.server.channel.Destinatio nConnector.process(DestinationConnector.java:526)
    at com.mirth.connect.donkey.server.channel.Destinatio nChain.doCall(DestinationChain.java:121)
    at com.mirth.connect.donkey.server.channel.Destinatio nChain.call(DestinationChain.java:63)
    at com.mirth.connect.donkey.server.channel.Channel.pr ocess(Channel.java:1759)
    at com.mirth.connect.donkey.server.channel.Channel.di spatchRawMessage(Channel.java:1221)
    at com.mirth.connect.donkey.server.channel.SourceConn ector.dispatchRawMessage(SourceConnector.java:192)
    at com.mirth.connect.server.controllers.DonkeyEngineC ontroller.dispatchRawMessage(DonkeyEngineControlle r.java:1091)
    at com.mirth.connect.server.controllers.DonkeyMessage Controller.reprocessMessages(DonkeyMessageControll er.java:443)
    at com.mirth.connect.server.api.servlets.MessageServl et$1.run(MessageServlet.java:214)
    at java.lang.Thread.run(Thread.java:745)Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "d_mcm6_pkey" Detail: Key (message_id, metadata_id)=(13577874, 1) already exists.
    at org.postgresql.core.v3.QueryExecutorImpl.receiveEr rorResponse(QueryExecutorImpl.java:2455)
    at org.postgresql.core.v3.QueryExecutorImpl.processRe sults(QueryExecutorImpl.java:2155)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(Q ueryExecutorImpl.java:288)
    at org.postgresql.jdbc.PgStatement.executeInternal(Pg Statement.java:430)
    at org.postgresql.jdbc.PgStatement.execute(PgStatemen t.java:356)
    at org.postgresql.jdbc.PgPreparedStatement.executeWit hFlags(PgPreparedStatement.java:168)
    at org.postgresql.jdbc.PgPreparedStatement.executeUpd ate(PgPreparedStatement.java:135)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.exec uteUpdate(ProxyPreparedStatement.java:61)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatemen t.executeUpdate(HikariProxyPreparedStatement.java)
    at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. insertMetaData(JdbcDao.java:714)
    ... 14 more

  • #2
    is this http://www.mirthcorp.com/community/i...wse/MIRTH-3541?

    Meaning were you removing messages?
    Mirth 3.8.0 / PostgreSQL 11 / Ubuntu 18.04
    Diridium Technologies, Inc.
    https://diridium.com

    Comment


    • #3
      Yes.

      Comment

      Working...
      X