Database migration error

  • Resolved grenade1

    (@grenade1)


    5 years ago

    Hello,

    I cannot migrate old site to new server because of some database error:

    [STEP] [2021-03-09 12:20:15] Initializing restore process...
[INFO] [2021-03-09 12:20:17] Creating lock file
[STEP] [2021-03-09 12:20:17] Initializing download process
[SUCCESS] [2021-03-09 12:20:17] Downloading initialized
[STEP] [2021-03-09 12:20:17] Downloading remote file...
[INFO] [2021-03-09 12:20:36] Unlocking migration
[SUCCESS] [2021-03-09 12:20:36] Download completed (took: 19.264375925064s)
[STEP] [2021-03-09 12:20:36] Looking for backup manifest
[SUCCESS] [2021-03-09 12:20:36] Manifest found remote name: BM_Backup_2021-03-09_12_17_06_5411.zip
[STEP] [2021-03-09 12:20:36] Requesting restore process
[SUCCESS] [2021-03-09 12:20:40] Restore process responded
[SUCCESS] [2021-03-09 12:20:40] Locking migration process
[STEP] [2021-03-09 12:20:40] Initializing restore process
[INFO] [2021-03-09 12:20:40] Backup & Migration version: 1.0.9
[INFO] [2021-03-09 12:20:40] Site which will be restored: https://mok20.123pr.pl
[INFO] [2021-03-09 12:20:40] PHP Version: 7.4.7
[INFO] [2021-03-09 12:20:40] Web server: Apache
[INFO] [2021-03-09 12:20:40] Max execution time (in seconds): 259200
[INFO] [2021-03-09 12:20:40] Initializing custom error handler
[STEP] [2021-03-09 12:20:40] Free space checking...
[INFO] [2021-03-09 12:20:40] Checking if there is enough amount of free space
[INFO] [2021-03-09 12:20:40] Requires at least 343994776 bytes. [328.06 MB]
[INFO] [2021-03-09 12:20:40] Disk free space function is not disabled - using...
[INFO] [2021-03-09 12:20:40] Checking this path/partition: /home/users/mok20/public_html/wp-content/backup-migration/backups
[SUCCESS] [2021-03-09 12:20:40] There is 187,679.13 MB free. [183.28 GB]
[SUCCESS] [2021-03-09 12:20:40] Great! We have enough space.
[SUCCESS] [2021-03-09 12:20:40] Confirmed, there is enough space on the device, checked: 343994776 bytes.
[INFO] [2021-03-09 12:20:40] Making temporary directory
[STEP] [2021-03-09 12:20:40] Scanning archive...
[STEP] [2021-03-09 12:20:40] Smart memory calculation...
[INFO] [2021-03-09 12:20:40] There is 384 MBs of memory to use
[SUCCESS] [2021-03-09 12:20:40] Setting the safe limit to 45 MB
[STEP] [2021-03-09 12:20:40] Extracting files (this process can take some time)...
[SUCCESS] [2021-03-09 12:20:41] Files extracted...
[STEP] [2021-03-09 12:20:41] Saving wp-config file...
[SUCCESS] [2021-03-09 12:20:41] File wp-config saved
[STEP] [2021-03-09 12:20:41] Getting backup manifest...
[SUCCESS] [2021-03-09 12:20:41] Manifest loaded
[STEP] [2021-03-09 12:20:41] Restoring files...
[SUCCESS] [2021-03-09 12:20:43] Files restored
[STEP] [2021-03-09 12:20:43] Restoring database...
[INFO] [2021-03-09 12:20:43] Database size: 5.74 MB
[ERROR] [2021-03-09 12:20:47] Error message: Allowed memory size of 402653184 bytes exhausted (tried to allocate 156577224 bytes)
[ERROR] [2021-03-09 12:20:47] You can get more pieces of information in troubleshooting log file.
[ERROR] [2021-03-09 12:20:47] Something bad happened on PHP side.
[ERROR] [2021-03-09 12:20:47] Error message: Allowed memory size of 402653184 bytes exhausted (tried to allocate 156577224 bytes)
[ERROR] [2021-03-09 12:20:47] Error file/line: /home/users/mok20/public_html/wp-content/plugins/backup-backup/includes/database/manager.php|178
[STEP] [2021-03-09 12:20:47] Aborting & unlocking restore process...
[DOWNLOAD GENERATED] File downloaded on (server time): 2021-03-09 12:20:49
[DOWNLOAD GENERATED] Last update (seconds): 6 seconds ago
[DOWNLOAD GENERATED] Last update (date): 2021-03-09 12:20:43

    Btw Duplicator cound not handle it as well.

    I hope you can help me 🙂 your plugin looks nice and simple, good job!

    Yours sincerely, Peter

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support backupsupport

    (@backupsupport)

    5 years ago

    Witaj @grenade1

    Judging by your logs, it looks like your php configuration has limited memory.
    I.e. Even if we bumped it via PHP to 384 MB then lowered it to safe limit of 45 MB (of RAM). It failed – that mostly means there is hard limit in php.ini which can’t be changed or system limit.

    Very soon we will have beta version which will allow you to migrate the site using PHP CLI (currently only backups support this technique). As PHP CLI has separated configuration the issue should not exist using this technique.

    Solution for now that may work:
    Check all limitations on your server, especially your php.ini
    And bump it to something about at least 64 MB

    The other thing you can do now is PHP version switch.
    You can try freshly installed PHP 8 or PHP 7.3 the plugin was tested on
    5 GB (site) + 200 MB (database) with default PHP and Apache settings.

    Also looks like you’re using SSD/NVMe drive that should solve many timeout issues.

    Let me know what you decided to try 🙂
    I can’t tell when the beta will be ready but I hope something like today/tomorrow.

    Plugin Support backupsupport

    (@backupsupport)

    5 years ago

    As we didn’t hear any reply in last days.
    I can assume that you resolved the issue.

    Feel free to open new topic if I am wrong!
    Thank you 🙂

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

The topic ‘Database migration error’ is closed to new replies.

Tags