Error on DB Backup

  • Resolved SheerHeartAttack

    (@sheerheartattack)


    10 years, 9 months ago

    When I try to create a DB backup through this plugin, I get the following error:

    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 31122351 bytes) in ~/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-backup.php on line 64

    I also have a different plugin that makes backups, and when I go to that plugin in the WP dashboard I see the following error:

    mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table '[prefix]_aiowps_global_meta' at row: 0

    So the error does seem to be stemming from AIOWPS. Increasing my overall WP memory limit doesn’t help. I’ve contacted my server and they believe this is a limit set within this plugin. Is there anything I can change to increase the memory limit? Or maybe decrease the size of this table?

    Thank you!

    https://ww.wp.xz.cn/plugins/all-in-one-wp-security-and-firewall/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    10 years, 9 months ago

    Hi, if you increase your website memory to lets say 256 MB you won’t run into the above error and your WordPress website will run better. Try that and see how you go.

    Regards

    Thread Starter SheerHeartAttack

    (@sheerheartattack)

    10 years, 9 months ago

    Yes, I already did that — it was increased to 1024mb with no change. Still got the error.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    10 years, 9 months ago

    Hi you have plenty of memory so that is definitely not the problem. However you might want to speak to your host in regards to the following error…

    Got packet bigger than ‘max_allowed_packet’

    Your host will have to increase the following max_allowed_packet in the Server.

    Thread Starter SheerHeartAttack

    (@sheerheartattack)

    10 years, 9 months ago

    Yup, we tried that. The max_allowed_packet size is set to 500M and 512M for mysqldump but we’re still getting this error.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    10 years, 9 months ago

    Can you disable all your other plugins except this one. Try and create another backup.

    Plugin Contributor wpsolutions

    (@wpsolutions)

    10 years, 9 months ago

    I’ve contacted my server and they believe this is a limit set within this plugin.

    No that’s not true. The AIOWPS doesn’t set any limits for memory.

    Yes, I already did that — it was increased to 1024mb with no change

    If you are still getting the memory exhausted error then obviously the memory increase is not being applied correctly.
    Where did they set the increased memory_limit?
    Perhaps there are multiple areas on your server where this value is being defined??

    Thread Starter SheerHeartAttack

    (@sheerheartattack)

    10 years, 9 months ago

    The memory limit is set within wp-config.php. Is there anywhere else I can look for a separate setting?

    My other backup plugin seems to be working now, so I don’t understand why this one wouldn’t be.

    I would prefer not to disable all other plugins since we don’t have a separate testing site, only the live one.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    10 years, 9 months ago

    Hi did you speak to your host about this memory issue?

    Thread Starter SheerHeartAttack

    (@sheerheartattack)

    10 years, 9 months ago

    Yes, as I noted above.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    10 years, 9 months ago

    In regards to your comment above.

    The memory limit is set within wp-config.php. Is there anywhere else I can look for a separate setting?

    The memory limit also needs for the server to allow your website to utilize that amount of memory.

    If you still get the same error message then a server setting might need some attention.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    10 years, 3 months ago

    I am marking this thread as resolved. No reply in 5 months.

    Thank you

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Error on DB Backup’ is closed to new replies.