fix(affiliate): Use DB transaction for username generation; add more stats for update… (backport #2579)

fix(affiliate): Use DB transaction for username generation; add more stats for update… (backport #2579) #4132