I saw a table crash message.
Thank you. After looking through numerous logs, I can confirm that this would indeed appear to have been the root cause of the problem. The table became corrupt and SMF wouldnt 'talk' with the database and causing processes to lock. Hence why a database repair alone wouldnt work. Should all be sorted now.
Thank you those who took the time to contact to advise me there was a problem.