Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14885

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '131'

    Details

      Description

      Why this specific value of ABSTRACT_VALUE_TABLE (DTYPE) is a problem? This is stored without problems in oracle 12c.

      Exception:
      Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '131' for key 'PRIMARY'
      Error Code: 1062
      Call: INSERT INTO ABSTRACT_VALUE_TABLE (ID, PRODUCT, SERVER_VALUE_COMMENT, DTYPE) VALUES (?, ?, ?, ?)
      bind => [4 parameters bound]
      Query: InsertObjectQuery(CSipSimple_G8141-26/r2457)
      at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl$1.handleException(EntityManagerSetupImpl.java:696)
      at org.eclipse.persistence.transaction.AbstractSynchronizationListener.handleException(AbstractSynchronizationListener.java:275)
      at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:170)
      at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
      at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99)
      at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:141)
      at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548)
      at com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:249)
      at com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:231)
      at com.sun.jts.CosTransactions.CurrentImpl.commit(CurrentImpl.java:622)
      at com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:331)
      ... 14 more

      Log:
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, PRODUCT, SERVER_VALUE_COMMENT, DTYPE) VALUES (131, 132, NULL, 'SERVER_VALUE_TABLE')

      42 Query SELECT 1
      42 Query ROLLBACK
      42 Query set autocommit=1
      42 Query SELECT t1.ID, t1.USER_ID FROM ABSTRACT_REGISTRAR_ENTITY_TABLE t0, ADDRESS_OF_RECORD_TABLE t1 WHERE ((t0.USER_NAME = 'gijane') AND ((t0.ID = t1.USER_ID) AND (t0.DTYPE = 'USER_TABLE')))
      42 Query set autocommit=0
      42 Query UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 50 WHERE SEQ_NAME = 'SEQ_GEN'
      42 Query SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
      42 Query INSERT INTO DIALOG_ID_TABLE (ID, TO_TAG_VALUE, VALUE) VALUES (106, 'sV0E', 7533510171044703200)
      42 Query INSERT INTO CALL_SESSION_TABLE (ID) VALUES (105)
      42 Query INSERT INTO CONTACT_SESSION_TABLE (ID, ACTIVE_SESSION, REGISTER_EXPIRE_DATE) VALUES (102, 0, '2018-01-07 11:25:44')
      42 Query INSERT INTO CALL_SESSION_HOLDER_TABLE (ID, CONTACT_SESSION_ID, CALL_SESSION, DIALOG_ID) VALUES (104, 102, 105, 106)
      42 Query INSERT INTO CONTACT_SESSION_ID_TABLE (ID, PORT, SCHEME, SOURCE_IP_OR_HOSTNAME, TRANSPORT_PROTOCOL_TYPE, CONTACT_SESSION_ID_USER_ID) VALUES (103, 40382, 191, '10.1.10.100', 2, 'gijane')
      42 Query INSERT INTO CONTACT_SESSION_HOLDER_TABLE (ID, ADDRESS_OF_RECORD_ID, CONTACT_SESSION, CONTACT_SESSION_ID) VALUES (101, 1, 102, 103)
      42 Query UPDATE CALL_SESSION_HOLDER_TABLE SET CONTACT_SESSION_ID = 102 WHERE (ID = 104)
      42 Query UPDATE CONTACT_SESSION_HOLDER_TABLE SET ADDRESS_OF_RECORD_ID = 1 WHERE (ID = 101)
      42 Query UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 50 WHERE SEQ_NAME = 'SEQ_GEN'
      42 Query SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
      42 Query INSERT INTO DIALOG_ID_TABLE (ID, TO_TAG_VALUE, VALUE) VALUES (107, 'sV0E', 7533510171044703200)
      42 Query UPDATE ABSTRACT_REGISTRAR_ENTITY_TABLE SET NONCE_TIMESTAMP = '2018-01-07', NONCES_ISSUED = 1, STORED_NONCE = '76d9b6d113c1e57752edb3d600e312de' WHERE (ID = 3)
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, PROTOCOL_VERSION_SCHEME_TOKEN, PROTOCOL_VERSION_SIP_SCHEME, PROTOCOL_VERSION_VERSION, DTYPE) VALUES (150, NULL, 191, 2.0, 'PROTOCOL_VERSION_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, PROTOCOL_VERSION_SCHEME_TOKEN, PROTOCOL_VERSION_SIP_SCHEME, PROTOCOL_VERSION_VERSION, DTYPE) VALUES (113, NULL, 191, 2.0, 'PROTOCOL_VERSION_TABLE')
      42 Query INSERT INTO ABSTRACT_STARTLINE_TABLE (ID, STATUS_LINE_CODE, STATUS_LINE_MESSAGE, PROTOCOL_VERSION, DTYPE) VALUES (149, 401, 'Unauthorized', 150, 'STATUS_LINE_TABLE')
      42 Query INSERT INTO TRANSACTION_TABLE (ID) VALUES (110)
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (135, NULL, '10.1.10.100', NULL, NULL, 40382, 191, NULL, 'gijane', NULL, NULL, 'CONTACT_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (141, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'FROM_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (123, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'FROM_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (155, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'FROM_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (178, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'FROM_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (114, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, NULL, NULL, NULL, 'REQUEST_LINE_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (142, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, NULL, NULL, NULL, 'REQUEST_LINE_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (120, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, NULL, NULL, NULL, 'ROUTE_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (167, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'TO_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (126, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'TO_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (145, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'TO_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, ADDR_SPEC_FRAGMENT, HOST, ADDR_SPEC_OPAQUE, PASSWORD, PORT, URI_SCHEME_TYPE, URI_SCHEME_STRING, USER_NAME, ADDR_SPEC_ABS_PATH, ADDR_SPEC_QUERY, DTYPE) VALUES (181, NULL, '10.1.10.203', NULL, NULL, NULL, 191, NULL, 'gijane', NULL, NULL, 'TO_URI_TABLE')
      42 Query INSERT INTO ABSTRACT_STARTLINE_TABLE (ID, REQUEST_LINE_METHOD, PROTOCOL_VERSION, REQUEST_LINE_URI, DTYPE) VALUES (112, 0, 113, 114, 'REQUEST_LINE_TABLE')
      42 Query INSERT INTO ABSTRACT_MESSAGE_TABLE (ID, UNKNOWNSIPHEADER, PART, START_LINE, DTYPE) VALUES (111, 0, NULL, 112, 'REGISTER_EMPTY_PART_TABLE')
      42 Query INSERT INTO ABSTRACT_MESSAGE_TABLE (ID, UNKNOWNSIPHEADER, PART, START_LINE, DTYPE) VALUES (148, 0, NULL, 149, 'SIP401_UNAUTHORIZED_EMPTY_PART_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (163, 'ALLOW_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (137, 'ALLOW_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CSEC_METHOD, CSEC_NUMBER, DTYPE) VALUES (158, 0, 34718, 'CSEQ_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CSEC_METHOD, CSEC_NUMBER, DTYPE) VALUES (139, 0, 34718, 'CSEQ_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CSEC_METHOD, CSEC_NUMBER, DTYPE) VALUES (129, 0, 34718, 'CSEQ_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CSEC_METHOD, CSEC_NUMBER, DTYPE) VALUES (176, 0, 34718, 'CSEQ_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, CALL_ID_VALUE_DOMAIN, CALL_ID_VALUE_VALUE, DTYPE) VALUES (157, NULL, '1TKyNzFNbUxXFeqcRHlV3OJdzNsinlfm', 'CALL_ID_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, CALL_ID_VALUE_DOMAIN, CALL_ID_VALUE_VALUE, DTYPE) VALUES (128, NULL, '1TKyNzFNbUxXFeqcRHlV3OJdzNsinlfm', 'CALL_ID_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CALL_ID_VALUE, DTYPE) VALUES (156, 157, 'CALL_ID_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CALL_ID_VALUE, DTYPE) VALUES (127, 128, 'CALL_ID_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CONTACT_STAR, DTYPE) VALUES (133, NULL, 'CONTACT_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CONTENT_LENGTH_VALUE, DTYPE) VALUES (164, 0, 'CONTENT_LENGTH_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, CONTENT_LENGTH_VALUE, DTYPE) VALUES (138, 0, 'CONTENT_LENGTH_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, EXPIRES_INFO, DTYPE) VALUES (136, 900, 'EXPIRES_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, EXPIRES_INFO, DTYPE) VALUES (162, 900, 'EXPIRES_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, ABSTRACT_HEADER_NAME_ADDR_SPEC_URI_PARAMS_TABLE_DISPLAY_NAME, URI_ID, DTYPE) VALUES (177, NULL, 178, 'FROM_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, ABSTRACT_HEADER_NAME_ADDR_SPEC_URI_PARAMS_TABLE_DISPLAY_NAME, URI_ID, DTYPE) VALUES (140, NULL, 141, 'FROM_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, ABSTRACT_HEADER_NAME_ADDR_SPEC_URI_PARAMS_TABLE_DISPLAY_NAME, URI_ID, DTYPE) VALUES (122, NULL, 123, 'FROM_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, ABSTRACT_HEADER_NAME_ADDR_SPEC_URI_PARAMS_TABLE_DISPLAY_NAME, URI_ID, DTYPE) VALUES (154, NULL, 155, 'FROM_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, MAX_FORWARDS_VALUE, DTYPE) VALUES (121, 70, 'MAX_FORWARDS_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (118, 'ROUTE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, DISPLAYNAME, FIELDVALUE_URI, DTYPE) VALUES (166, NULL, 167, 'TO_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, DISPLAYNAME, FIELDVALUE_URI, DTYPE) VALUES (144, NULL, 145, 'TO_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, DISPLAYNAME, FIELDVALUE_URI, DTYPE) VALUES (180, NULL, 181, 'TO_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, DISPLAYNAME, FIELDVALUE_URI, DTYPE) VALUES (125, NULL, 126, 'TO_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, TO_VALUE, DTYPE) VALUES (179, 180, 'TO_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, TO_VALUE, DTYPE) VALUES (165, 166, 'TO_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, TO_VALUE, DTYPE) VALUES (124, 125, 'TO_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, TO_VALUE, DTYPE) VALUES (143, 144, 'TO_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (130, 'USER_AGENT_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (159, 'USER_AGENT_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (115, 'VIA_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (151, 'VIA_TABLE')
      42 Query INSERT INTO ABSTRACT_HEADER_FIELD_TABLE (ID, DTYPE) VALUES (168, 'WWW_AUTHENTICATE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, AUTH_SCHEME, DTYPE) VALUES (169, 'Digest', 'AUTHENTICATE_VALUE_TABLE')
      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, DISPLAYNAME, FIELDVALUE_URI, DTYPE) VALUES (134, NULL, 135, 'CONTACT_VALUE_TABLE')

      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, DISPLAYNAME, FIELDVALUE_URI, DTYPE) VALUES (119, NULL, 120, 'ROUTE_VALUE_TABLE')

      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, PRODUCT_VALUE, PRODUCT_VERSION, DTYPE) VALUES (132, 'CSipSimple_G8141-26', 'r2457', 'PRODUCT_TABLE')

      42 Query INSERT INTO ABSTRACT_FIELD_VALUE_PART_TABLE (ID, PRODUCT_VALUE, PRODUCT_VERSION, DTYPE) VALUES (161, 'CSipSimple_G8141-26', 'r2457', 'PRODUCT_TABLE')

      42 Query INSERT INTO ABSTRACT_VALUE_TABLE (ID, PRODUCT, SERVER_VALUE_COMMENT, DTYPE) VALUES (131, 132, NULL, 'SERVER_VALUE_TABLE')

      42 Query SELECT 1

      42 Query ROLLBACK

      42 Query set autocommit=1

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              trondarild.tobiassen@gmail.com Trond Arild Lode Tobiassen Heidelberg
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: