fix(subscription): fix drop subscription not clear cursor (#17232)

fix(subscription): fix drop subscription not clear cursor (#17232) #6054