Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Cannot allocate memory for the buffer pool in SafeSync for Enterprise (SSFE)

    • Updated:
    • 5 Jan 2017
    • Product/Version:
    • SafeSync for Enterprise 3.1
    • SafeSync for Enterprise 3.2
    • Platform:
    • iOS 9.2
Summary

When the number of your end user is increasing, the original memory decreases. When you check mySQL log under /var/log/mysql/error.log, the following message shows:

2016-11-22 08:32:53 14506 [Note] InnoDB: Initializing buffer pool, size = 512.0M
InnoDB: mmap(549453824 bytes) failed; errno 12
2016-11-22 08:32:53 14506 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2016-11-22 08:32:53 14506 [ERROR] Plugin 'InnoDB' init function returned error.
2016-11-22 08:32:53 14506 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-11-22 08:32:53 14506 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-11-22 08:32:53 14506 [ERROR] Aborting
Details
Public

The error occurs because the server has insufficient memory to allocate for MySQL process.

To resolve the issue:

  1. Add memory to the machine by either adding a physical ram or increasing the memory size from hypervisor.
  2. Run the following command to check the swap:

    sudo swapon -s

    It shows one swap entry if the swap is enabled.
    Filename                Type        Size    Used    Priority
    /dev/mapper/single--installer--vg-swap_1 partition  8384508 0   -1

    If it is disabled, run the following to enable swap:

    sudo grep swap /etc/fstab | awk '{print $1}' | xargs swapon

  3. Reduce the allocation size of MySQL buffer pool from 512 MB to 64 MB.

    sudo sed -i '/innodb_buffer_pool_size/c\innodb_buffer_pool_size = 64M' /etc/mysql/conf.d/safesync.cnf

  4. Restart MySQL service.

    sudo service mysql restart

Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1116427
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.