1 2 3 Previous Next 35 Replies Latest reply on May 21, 2020 1:57 AM by Sidhdesh Punaskar

    Upgrade 20.02 - Incident slowness and bug ?! in SELECT

    Samo Puharic
      Share This:

      We did staged upgrade from AR 9.1.04/ ITSM 9.1.02/ PD 9.1.00 to the version 20.02 AR/ ITSM/ Smart IT.

      Before upgrade, we uninstall Smart IT/DWP from the database manually.

       

      When saving INC ticket on Status update - duration is 12-13sec what is unacceptable.

       

      By analyzing server logs we noticed 4 long running queries - which on DB side do full table scan.

       

      It seems SQL SELECT are parsed differently on 20.02 and our 9.1.04/9.1.02 PROD system. Example below for filter SRM:SWI:SetNeedsAttension_050.

       

      20.02:

      SELECT * FROM (SELECT AR_SQL_Alias$1.*, rownum as AR_RowNumber_Alias$1 FROM (SELECT T1751.C1000000048, T1751.C1000000337, T1751.C1000000338, T1751.C1000003302, T1751.C1 FROM T1751 WHERE (T1751.C179 IS NULL) ORDER BY T1751.C3 DESC, T1751.C1 ASC) AR_SQL_Alias$1) WHERE ((AR_RowNumber_Alias$1 > 0) AND (AR_RowNumber_Alias$1 < 104) AND (rownum < 104))

       

      9.1.04/9.1.02:

      SELECT * FROM (SELECT AR_SQL_Alias$1.*, rownum as AR_RowNumber_Alias$1 FROM (SELECT T1751.C1000000048, T1751.C1000000337, T1751.C1000000338, T1751.C1000003302, T1751.C1 FROM T1751 WHERE ('AGGAA5V0HJ36MAQI8OLCQHKS4GG8SW' = T1751.C179) ORDER BY T1751.C3 DESC NULLS LAST , T1751.C1 ASC NULLS FIRST ) AR_SQL_Alias$1) WHERE ((AR_RowNumber_Alias$1 > 0) AND (AR_RowNumber_Alias$1 < 104) AND (rownum < 104))

       

      We don't see the reason why filter condition $SRInstanceId$ = 'InstanceId' is parsed in two different way. It looks like a bug.

        1 2 3 Previous Next