Make DB Validation more robust? Or at least leave some tolerance?

  • Resolved sx1001

    (@sx1001)


    10 months ago

    Hi all,

    every now and then, for the same scheduled job, the DB validation fails. It’s saying something like:

    DB VALIDATION FAIL: count check table "wp_XYZ_usermeta" START: 1038464 END: 1038469 DELTA: 5 COUNT: 1038519
SQL FILE SIZE CHECK OK, SIZE: 2158625327
DB VALIDATION 1: failed to validate
Runtime error in database dump Message: DB VALIDATION 1: failed to validate

    Unfortunately, the Backup is aborted – whereas I’d like it to continue as I’d rather have a 99.9999% Backup including all files instead of No Backup at all.

    Is there a way via Hook / Filter to deactivate the DB Validation OR tell it to continue via a tolerance of accepted count-difference?

    Interestingly, the same jobs runs 3 times in a row with no Problem and then all of a sudden has this problem ?? Weird

    That would be really beneficial!

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

    (@mohammedeisa)

    Hello @sx1001,

    Thanks for reaching out to the Duplicator support.

    Unfortunately, there is no hook to skip the database scan process.

    Can you please check if switching the database engine fixes this issue?

    You can switch the database engine from Duplicator > Settings > Packages > Database Engine.

    Please let me know if this works.

    Thanks!

    Thread Starter sx1001

    (@sx1001)

    Hi @mohammedeisa,

    we changed it already – mysqldump doesn’t really work for us. so we went with PHPCode, multithreaded and Chunk size we varied.

    Yeah ok, then we will going to patch the plugin locally and make it a bit more tolerant. I really think this would be sensible. Like having a tolerance / threshold here:

     if ($tableInfo['count'] < $minVal || $tableInfo['count'] > $maxVal) {
                DUP_PRO_LOG::infoTrace('DB VALIDATION 1 FAIL: count check table "' . $table . '" START: ' . $tableInfo['start'] . ' END: ' . $tableInfo['end'] . ' COUNT: ' . $tableInfo['count']);
                $isValid = false;
            }

    Just substract / add a threshold to the if-condition. Pretty easy and convenient IMHO.

    Plugin Support mohammedeisa

    (@mohammedeisa)

    @sx1001,

    Can you please contact us trough this form to investigate your issue?
    https://duplicator.com/contact/?form=1

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @sx1001,

    I’m closing this support topic for inactivity. Please don’t hesitate to contact us in a Support Topic if you need any help with Duplicator.

    Thanks! 

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Make DB Validation more robust? Or at least leave some tolerance?’ is closed to new replies.