Uploaded image for project: 'Spring Integration'
  1. Spring Integration
  2. INT-3181

DuplicateKeyException using INT_CHANNEL_MESSAGE on MySQL 5.1

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Complete
    • Affects Version/s: 2.2.6
    • Fix Version/s: 3.0 RC1
    • Component/s: Documentation, JDBC Support
    • Labels:
    • Environment:
      MySQL 5.1
      Spring 2.2.6
      MySqlChannelMessageStoreQueryProvider

      Description

      I have adapter that moves one message from one queue into another.
      Although this situation could be avoided, it is part of my app now.

      I am getting errors:

      removeMessageFromGroup - Message with id 'c08a1075-87e5-3e10-a282-84ae1c746dff-2b738bee-05d8-4c94-aafe-f66' was not deleted.
      
      DuplicateKeyException: PreparedStatementCallback; SQL [INSERT into INT_CHANNEL_MESSAGE(MESSAGE_ID, GROUP_KEY, REGION, CREATED_DATE, MESSAGE_BYTES) values (?, ?, ?, ?, ?)]; Duplicate entry 'c08a1075-87e5-3e10-a282-84ae1c746dff-2b738bee-05d8-4c94-aafe-f66' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'c08a1075-87e5-3e10-a282-84ae1c746dff-2b738bee-05d8-4c94-aafe-f66' for key 'PRIMARY'
      

        Attachments

          Activity

            People

            Assignee:
            abilan Artem Bilan
            Reporter:
            ilka Ilya Kazakevich
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: