What I did to fix the issue was to run PowerShell command to detach and reattach the content database as describe im MS technet article:
To detach content database:
To attach content database:
" -DatabaseServer " " -WebApplication http://SiteName
I am not sure why doing this action from Central Administration page created the issue in the first place, but from now on, I will start using PowerShell to administer SharePoint 2010.