Uploaded image for project: 'UGENE'
  1. UGENE
  2. UGENE-7923

Crash on project filter operation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 48
    • Fix Version/s: 49
    • Component/s: None
    • Labels:
    • Affect Type:
      Userdefined

      Description

      We've got many crash reports on 48.0 version, where crash occurs on project filtering operation.

      For example, https://api.ugene.net/tools/ugenecrashes/index.php?id=25675
      Filtering project content by the "Sequence content" criterion (Running) 0
      Filtering project content by the "Sequence accession number" criterion (Running) 0
      Filtering project content by the "Annotation feature key" criterion (Running) -1

      In the log following error are present where length sql is more 13000 :
      SQL: error: Error querying database: Expression tree is too large (maximum depth 1000) in query: SELECT DISTINCT A.object, F.name FROM AnnotationTable AS A, Feature AS F, FeatureKey AS FK WHERE A.rootId = F.root AND F.id = FK.feature AND FK.value LIKE ?1 AND (A.object = ?2 OR A.object = ?3 OR A.object = ?4 OR A.object = ?5 OR A.object = ?6 OR A.object = ?7 OR A.object = ?8 OR A.object = ?9 OR A.object = ?10 OR A.object = ?11 OR A.object = ?12 OR A.object = ?13 OR A.object = ?14
      ....
      OR A.object = ?12988 OR A.object = ?12989 OR A.object = ?12990 OR A.object = ?12991 OR A.object = ?12992 OR A.object = ?12993 OR A.object = ?12994 OR A.object = ?12995 OR A.object = ?12996 OR A.object = ?12997 OR A.object = ?12998 OR A.object = ?12999 OR A.object = ?13000 OR A.object = ?13001 OR A.object = ?13002 OR A.object = ?13003 OR A.object = ?13004 OR A.object = ?13005 OR A.object = ?13006 OR A.object = ?13007 OR A.object = ?13008 ) COLLATE NOCASE

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kir Kirill Rasputin
              Reporter:
              s.samoilenko Svetlana Samoilenko
              Assigned Tester:
              Svetlana Samoilenko
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: