Chunk Error

  • Resolved Steven Ray

    (@steveneray)


    4 months, 2 weeks ago

    Greetings, for last few versions, I consistently encounter a migration error that prohibits the continued use of Duplicator. I have no caches, redirects or firewalls active when creating the archive. I noticed other users have the same failed message when searching Google for same error.  I have since deleted the domain where there is no way around this error. From the log...

    failed processing data replacement: Chunk error, message: Duplicate entry 'https://www.xxxxx.com/' for key 'wp_abj404_spelling_cache.url'[/home/xxxxx/public_html/dup-installer/classes/class.engine.php|461],
    wait 5 seconds and retry.

    CHUNK ACTION: CURRENT [search_replace][wp_abj404_spelling_cache][0]
    CHUNK ACTION: CURRENT [search_replace][wp_abj404_spelling_cache][1]
    CHUNK ACTION: CURRENT [search_replace][wp_abj404_spelling_cache][2]
    CHUNK ACTION: CURRENT [search_replace][wp_abj404_spelling_cache][3]
    CHUNK ACTION: CURRENT [search_replace][wp_abj404_spelling_cache][4]
    DB QUERY [ERROR][/home/xxxxx/public_html/dup-installer/classes/database/class.db.php:686] MSG: Duplicate entry 'https://www.xxxxx.com/' for key 'wp_abj404_spelling_cache.url'
    SQL: UPDATE     wp_abj404_spelling_cache SET url = "https://www.xxxxx.com/" WHERE id = "67838"
    TRACE[1] CLASS___: DUPX_DB::mysqli_query FILE: /home/xxxxx/public_html/dup-installer/classes/class.engine.php[644]
    TRACE[2] CLASS___: DUPX_UpdateEngine::evaluateRow FILE: /home/xxxxx/public_html/dup-installer/classes/class.engine.php[462]
    TRACE[3] CLASS___: DUPX_UpdateEngine::evaluatePagedRows FILE: /home/xxxxx/public_html/dup-installer/classes/class.engine.php[378]
    TRACE[4] CLASS___: DUPX_UpdateEngine::evaluateTableRows FILE: /home/xxxxx/public_html/dup-installer/src/Core/Deploy/Chunk/SiteUpdateChunkManager.php[77]
    TRACE[5] CLASS___: Duplicator\Installer\Core\Deploy\Chunk\SiteUpdateChunkManager->action FILE: /home/xxxxx/public_html/dup-installer/libs/Chunking/ChunkingManager.php[126]
    TRACE[6] CLASS___: Duplicator\Libs\Chunking\ChunkingManager->start FILE: /home/xxxxx/public_html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php[118]
    TRACE[7] CLASS___: DUPX_S3_Funcs->updateWebsite FILE: /home/xxxxx/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php[233]
    TRACE[8] CLASS___: DUPX_Ctrl_ajax::actions FILE: /home/xxxxx/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php[110]
    TRACE[9] CLASS___: DUPX_Ctrl_ajax::controller FILE: /home/xxxxx/public_html/dup-installer/main.installer.php[47]

    EXCEPTION ERROR: Chunk error, message: Duplicate entry 'https://www.xxxxx.com/' for key 'wp_abj404_spelling_cache.url'[/home/xxxxx/public_html/dup-installer/classes/class.engine.php|461][CODE:0]
    FILE:/home/xxxxx/public_html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php[129]
    TRACE: 0 /home/xxxxx/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php(233): DUPX_S3_Funcs->updateWebsite() 1 /home/xxxxx/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php(110): DUPX_Ctrl_ajax::actions('webupdate') 2 /home/xxxxx/public_html/dup-installer/main.installer.php(47): DUPX_Ctrl_ajax::controller() 3 {main}

    AJAX ACTION [webupdate] FAIL, MESSAGE: Chunk error, message: Duplicate entry 'https://www.xxxxx.com/' for key 'wp_abj404_spelling_cache.url'[/home/xxxxx/public_html/dup-installer/classes/class.engine.php|461]

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

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

    (@mohammedeisa)

    Hello @steveneray,

    Thanks for reaching out to us and please accept our apologies for the late reply. We lost this topic somehow.

    I understand that you couldn’t restore your backup and you got the error:
    failed processing data replacement: Chunk error, message: Duplicate entry ‘https://www.xxxxx.com/’ for key ‘wp_abj404_spelling_cache.url'[/home/xxxxx/public_html/dup-installer/classes/class.engine.php|461],

    The error is triggered while the installer was executing this database query:
    DB QUERY [ERROR][/home/xxxxx/public_html/dup-installer/classes/database/class.db.php:686] MSG: Duplicate entry ‘https://www.xxxxx.com/’ for key ‘wp_abj404_spelling_cache.url’
    SQL: UPDATE wp_abj404_spelling_cache SET url = “https://www.xxxxx.com/” WHERE id = “67838”

    The reason why this error is triggered is source website database has duplicate entries for the column url in the database table wp_abj404_spelling_cache while the destination database doesn’t accept duplicate entries for the keys of the database tables.

    To resolve this error, please go to the source database and remove the duplicates in the URL column in the table wp_abj404_spelling_cache.

    You may start by removing the row with the ID=67838 in the database table wp_abj404_spelling_cache.

    I hope this helps.

    Thanks!

    Thread Starter Steven Ray

    (@steveneray)

    Thanks, @mohammedeisa, for digging through this error for me.

    I wasn’t trying to restore from a backup, instead I was migrating from one domain to another as outlined.

    Yes, I was aware that there was a duplication in the database. The error message was clear on that detail.

    wp_abj404 is related to the 404 Solution plugin that still doesn’t work well after many updates. It’s removal along with cleaning the database of orphans using Advanced Database Cleaner PRO allowed me to achieve the migration without any direct MySQL editing.

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.