Hi @assanjie
Did you check the exception.log and system.log of magento ?
did you find something in the log which can relate to the error ?
this issue can be related to `1213 Deadlock found when trying to get lock`
check this on gitHub https://github.com/magento/magento2/issues/8933
If my answer is helpful click Kudos & Accept as Solution
Thank you