Re: Error : 'Out of Memory' : encountered while accessing mysql procedure from JBoss Application

[Murtaza Doctor]

Hi Andrew / Peter,

Now, this error is not occuring through application after the fixing the privilege access for the said procedure.
But we are consistently receiving the error 'Out of Memory' during the restore of database.

Following errors are seen in the mysqlerr.log during the mysqldump restore:
---------------
130830 16:10:12 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 2464320 bytes)
130830 16:10:12 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
---------------

Please assist in resolving this error. Thanks.