Database Error: Lost connection to MySQL server during query

  • Resolved wakabayashi0827

    (@wakabayashi0827)


    1 year ago

    I have many site with UpdraftPlus, and database errors occur very frequently in only one of them.
    An example of error message is shown below.

    [28-Nov-2023 02:17:08 UTC] WordPress データベースエラー: Lost connection to MySQL server during query for query UPDATE appwp_options SET option_value = ‘File counting took a long time (82s); will attempt to cache results (memory_limit: 512M (used: 114.1M | 118.5M), estimated uncompressed bytes: 23327.2 Kb) (11月 28 11:17:08)’, autoload = ‘yes’ WHERE option_name = ‘updraft_lastmessage’ made by do_action_ref_array(‘updraft_backup_resume’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus->backup_resume, UpdraftPlus_Backup->resumable_backup_of_files, UpdraftPlus_Backup->backup_dirs, UpdraftPlus_Backup->create_zip, UpdraftPlus_Backup->make_zipfile, UpdraftPlus->log, UpdraftPlus_Options::update_updraft_option, update_option

    This site has a large amount of media files, so the backup files are divided into several files and the backup process may take a long time.

    It seems this error doesn’t always cause backup failure, but there are files which are likely to be debris of incomplete backup in “/wp-content/updraft” folder.

    Is there any idea to operate backup without this error?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Prashant Baldha

    (@pmbaldha)

    Your server admin will need to check the mysql server logs to see why the database server is timing out. Can you please contact your hosting support?

    Thread Starter wakabayashi0827

    (@wakabayashi0827)

    I contacted the hosting provider, but no log information was provided.
    Their opinion is “It took a long time to count files, so the memory limit of the server was exceeded. Setting memory limit with php.ini will help.”
    I had already set memory limit of 512M with php.ini.
    I changed the setting to 1024M.
    How do you think about this?

    Plugin Contributor Prashant Baldha

    (@pmbaldha)

    I think that you should test the backup with 1024M memory limit.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Error: Lost connection to MySQL server during query’ is closed to new replies.