Skip to main content

IC90206: CONCURRENT INSERTS FAIL WITH UNIQUE CONSTRAINT VIOLATION DUE TO FALSE LOCK CONFLICTS


Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A large number of concurrent INSERT operations
    might generate false lock conflicts.
    The transaction fails with the error 'SOLID Database Error
    10033: Primary key unique constraint violation.'
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM solidDB V7.0 Fix Pack 5.                      *
    ****************************************************************
    

Problem conclusion

  • Fix is included in IBM solidDB V7.0 Fix Pack 5. To reduce
    the probability of conflicting lock names, the solidDB server
    now uses 64-bit lock names instead of 32-bit names.
    Additionally, the lock name generation methods have been
    modified.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90206

  • Reported component name

    SOLIDDB-DB2/IDS

  • Reported component ID

    5724V1700

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-14

  • Closed date

    2013-03-01

  • Last modified date

    2013-03-01

  • APAR is sysrouted FROM one or more of the following:

    IC89381

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SOLIDDB-DB2/IDS

  • Fixed component ID

    5724V1700

Applicable component levels

  • R650 PSY

       UP

  • R700 PSY

       UP

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

IBM solidDB


Software version:
700


Reference #:
IC90206


Modified date:
2013-03-01

Translate my page

Content navigation