AnsweredAssumed Answered

Upgrade from 13.0 to 13.1

Question asked by lukas.jezek on Sep 13, 2013
Latest reply on Sep 16, 2013 by Suman Pramanik
Hello,

I have a problem with upgrade in preupgrade step when executing action "delete duplicate rows from cmn_sec_groups" this step is running quite a long time. I also analyze if it is running or what the DB is doing. DB is executing this query: delete from CMN_SEC_GROUPS where rowid not in (select MIN(rowid) from CMN_SEC_GROUPS group by GROUP_CODE,PRINCIPAL_TYPE,PRINCIPAL_ID) . It consumes most CPU time, execution on DB level. But when I run select query with same condition then it returnes 0 rows. So there is nothing to delete....Table cmn_sec_users has 300k rows so the time of running this query is long. Performance of DB was fine until running this query. Upgrade is waiting to finish this request.

Do you have any idea. I also attach screenshots of it.
Thank you

Outcomes