A man with a lengthy criminal record killed six adults and two young children before taking his own life in what a Canadian police chief called a “senseless mass murder”.