Existence and non-existence results for the SU(3) singular Toda system on compact surfaces