Sting himself took to social media to share news of the gig's cancellation with fans, after the city's mayor expressed concerns it should be postponed