Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-3935

SQL query runs into timeout with large file with many repetitions

    XMLWordPrintable

Details

    • Critical
    • Fix for deadlock problem when syncing repetitions.

    Description

      This is the query, that run into timeout

       

      4592365 U1189 10.100.18.125:57402 DB1189 Query   148893 Sending data                     UPDATE LEK_segments s, LEK_segment_data d
              SET s.isRepeated = s.isRepeated       		1
              WHERE d.originalMd5 IN (
                  SELECT originalMd5
                  FROM LEK_segment_data
                  WHERE taskGuid = '{b4a2dcb9-ee45-44de-b37a-78731c66dd23}'
                    AND originalMd5 != 'd41d8cd98f00b204e9800998ecf8427e'
                    AND autoStateId NOT IN (16)
                    AND name = "source"
                  GROUP BY originalMd5 HAVING count(segmentId) > 1
              )
              AND s.id = d.segmentId AND d.taskGuid = '{b4a2dcb9-ee45-44de-b37a-78731c66dd23}'         

      Please see the file TMX-as-translatable-file_(problem-tmx)_result_20240418_de-de_en-us.zip

      as example file in nextcloud fileexchange

       

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. TRANSLATE-3850 SSO via OpenID: Define if IDP should be able to remove rights

          • Done
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. TRANSLATE-3833 repetitions of blocked segments should not be treated as repetitions

          • Done
          mentioned in

          Page Loading...

          Activity

            People

              aleksandar Aleksandar Mitrev
              marcmittag Marc Mittag [Administrator]
              Thomas Lauria
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: