Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-7442

When creating index ACT_IDX_JOB_HANDLER a warning is emitted on sqlserver

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.7.0, 7.6.3, 7.7.0-alpha2
    • Component/s: engine
    • Labels:

      Description

      Steps to reproduce:

      1. add a job to the ACT_RU_JOB database table
      2. create ACT_IDX_JOB_HANDLER index

      Problem:
      The following warning is emitted:

      Code: 1945 SQL State: 01000 — Warning! The maximum key length is 900 bytes. The index 'ACT_IDX_JOB_HANDLER' has maximum length of 8510 bytes. For some combination of large values, the insert/update operation will fail.
      

      Hint:
      The warning is not emitted when the table ACT_RU_JOB is empty and the index is created.

        Activity

        Hide
        svetlana.dorokhova Svetlana Dorokhova added a comment -

        Index is used by the engine when removing obsolete StartTimer during deployments and when removing EventSubscription.
        Both of this cases are not critical in terms of performance -> decision was made to remove the index for SQL Server case.

        Show
        svetlana.dorokhova Svetlana Dorokhova added a comment - Index is used by the engine when removing obsolete StartTimer during deployments and when removing EventSubscription. Both of this cases are not critical in terms of performance -> decision was made to remove the index for SQL Server case.
        Hide
        svetlana.dorokhova Svetlana Dorokhova added a comment -

        FYI commit ecdce38 has wrong commit message, it is actually related with CAM-7366.

        Show
        svetlana.dorokhova Svetlana Dorokhova added a comment - FYI commit ecdce38 has wrong commit message, it is actually related with CAM-7366 .

          People

          • Assignee:
            roman.smirnov Smirnov Roman
            Reporter:
            roman.smirnov Smirnov Roman
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development