The general manager of Manchester's Co-op Live arena, Gary Roden, has resigned following the cancellation of comedian Peter Kay's opening shows and last-minute ticket cancellations for the venue's first test event.