web stats
duplicate key value violates unique constraint "d_mcm6_pkey" - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-07-2019, 05:54 PM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 955
StickyBandit is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 10-08-2019, 12:50 PM
pacmano pacmano is offline
OBX.3 Kenobi
 
Join Date: Oct 2009
Location: Texas
Posts: 117
pacmano is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 10-08-2019, 04:21 PM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 955
StickyBandit is on a distinguished road
Default

Yes.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 04:28 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation