ALTER TABLE with CHECK CONSTRAINTS gives "Out of Memory" error even table is empty and just created. Also, already confirmed that there is enough memory on the instance.

I am getting the error "ERROR 1041 (HY000): Out of memory." on creating check constraints. Also for any ALTER table command the same error is being thrown. please help in understanding and resolving the issue.