-
Type: Bug
-
Status: Closed
-
Priority: Critical
-
Resolution: Fixed
-
Affects Version/s: 48
-
Fix Version/s: 49
-
Component/s: None
-
Labels:
-
Affect Type:Userdefined
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
- relates to
-
UGENE-7558 Unexpected error message after some filter search
- Closed