Loud-mouthed Democrat mayor crashes and burns in primary after scandal-ridden term