com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data

Mirth Project | Brent Moen | 2 years ago
  1. 0

    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}

    Mirth Project | 2 years ago | Brent Moen
    com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data
  2. 0

    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}

    Mirth Project | 2 years ago | Brent Moen
    com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data
  3. 0

    column "activated" is of type integer but expression is of type boolean for Postgresql

    GitHub | 2 years ago | finmurphy
    org.postgresql.util.PSQLException: ERROR: column "activated" is of type integer but expression is of type boolean Hint: You will need to rewrite or cast the expression. Position: 193
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate JoinColumn Error on not null constraint

    Stack Overflow | 2 years ago
    org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint Detail: Failing row contains (null, null, test, dsadas, sdas, dsadsa, 500.00, 1000.00, 1500.00, 5, PRODUCT).
  6. 0

    GitHub comment 38#63986297

    GitHub | 2 years ago | pogster
    au.com.codeka.warworlds.server.data.SchemaException: Error upgrading to schema version 1

  1. silex 2 times, last 3 weeks ago
  2. silex 18 times, last 6 months ago
20 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
    6 frames
  3. HikariCP-java6
    PreparedStatementJavassistProxy.executeUpdate
    1. com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java)
    1 frame
  4. com.mirth.connect
    Channel.run
    1. com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:504)
    2. com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:102)
    3. com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:74)
    4. com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:56)
    5. com.mirth.connect.donkey.server.channel.Channel.process(Channel.java:1604)
    6. com.mirth.connect.donkey.server.channel.Channel.processSourceQueue(Channel.java:1738)
    7. com.mirth.connect.donkey.server.channel.Channel.run(Channel.java:1725)
    7 frames
  5. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame