Adding a new group takes a long time to complete


Description

Adding a new group takes a long time to complete.

Release or Environment


Quebec Patch 1 Hot Fix 1

Quebec Patch 1 Hot Fix 1a

Quebec Patch 1 Hot Fix 2a

Quebec Patch 2 Hot Fix 1

Quebec Patch 2 Hot Fix 2

Cause


1) The cause of the slowness is because when you add a group it is also querying and extracting all of the active groups.

Sample Log:

021-04-20 05:54:04 (827) Default-thread-15 0C5C100B1B2BE010FC91653B234BCB1B txid=ed2e58cb1bab [0:00:00.011] Compacting large row block (file.write: sys_user_grmember 10000 rows 160000 saveSize)

2021-04-20 05:54:04 (845) Default-thread-15 0C5C100B1B2BE010FC91653B234BCB1B txid=ed2e58cb1bab [0:00:00.011] Compacting large row block (file.write: sys_user_grmember 10000 rows 160000 saveSize)
2021-04-20 05:54:04 (864) Default-thread-15 0C5C100B1B2BE010FC91653B234BCB1B txid=ed2e58cb1bab [0:00:00.011] Compacting large row block (file.write: sys_user_grmember 10000 rows 160000 saveSize)
2021-04-20 05:54:04 (884) Default-thread-15 0C5C100B1B2BE010FC91653B234BCB1B txid=ed2e58cb1bab [0:00:00.012] Compacting large row block (file.write: sys_user_grmember 10000 rows 160000 saveSize)
2021-04-20 05:54:04 (891) Default-thread-15 0C5C100B1B2BE010FC91653B234BCB1B txid=ed2e58cb1bab WARNING *** WARNING *** Large Table: Table handling an extremely large result set: 1597869
Query that got us here is: TABLENAME = sys_user_grmember ENCODED_QUERY = active=true



2) The root cause of the large data extraction is a product defect documented on PRB1483187

Resolution


1) The only workaround is that when you add another group and the timer banner pops up----> click the cancel button to cancel the transaction. It should still add the group even after you click cancel, since you will be cancelling the unnecessary data extraction of all active groups.

2) The permanent fix is targeted for the below releases:

a) Rome 

b) Quebec Patch 3

c) Quebec Patch 2 Hot Fix 3