RS Index Handler got regionserver.MultiVersionConcurrencyControl: STUCK

Hello all, Any ideas how to avoid situations like this: Jul 18 01:55:30 prod005 hbase[227531]: 2019-07-18 01:55:30,042 WARN [RpcServer.Index.handler=4,queue=0,port=60020] regionserver.MultiVersionConcurrencyControl: STUCK: MultiVersionConcurrencyControl{readPoint=55042096,

Using Secondary index hint for many to many relationship model

Hi, We have a table with with parented and childid combination as unique. We have to query it sometimes with parent id and sometimes with child id. So we have secondary index(global index) on child id. As we don’t want to store all the fields again in the secondary index , we wanted to use