Resolved: DB doesn't backup based on scheduled time.

Discussion in 'ISPConfig 3 Priority Support' started by Frost, Jan 6, 2020.

  1. Frost

    Frost Member

    ISPConfig 3.1.15p2
    Ubuntu 18.04.3 LTS
    MySQL 5.7
    Website files backup run as scheduled and same number of backup copies configured. However DB seems to backup every 3-4mins. This happen on all websites in my environment. I am in a multiserver environment with mirror server of web, ns, mail server) including master to master DB replication

    Backup Interfval: Daily
    Number of Backup Copies: 10
    Backups Generated:
    *2020-01-06_20-55.sql.gz
    *2020-01-06_20-52.sql.gz
    *2020-01-06_20-48.sql.gz
    *2020-01-06_20-45.sql.gz
    *2020-01-06_20-42.sql.gz
    *2020-01-06_20-39.sql.gz
    *2020-01-06_20-36.sql.gz
    *2020-01-06_20-33.sql.gz
    *2020-01-06_20-30.sql.gz
    *2020-01-06_20-27.sql.gz
    web59_2020-01-05_22-05.tar.gz
    web59_2020-01-04_22-08.tar.gz
    web59_2020-01-03_22-06.tar.gz
    web59_2020-01-02_22-05.tar.gz
    web59_2020-01-01_22-12.tar.gz
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    I have not seen that on a system before. Try to run optimize and repair on all tables in the two ispconfig databases to ensure that no tables are broken. Looks as if the system is not able to store the backup state somehow.
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  4. Frost

    Frost Member

    Good point. I'll check and repair the tables if necessary. Where do ispconfig store the backup state?

    Probably it fails, I will try to run backup debug. This starts since Nov, but don't have time to fix it.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    The state of the internal cronjobs is stored in the sys_cron table and the web_backup table.
     
  6. Frost

    Frost Member

    Here's the screenshot of sys_cron
     

    Attached Files:

  7. Frost

    Frost Member

    Repairing the sys_cron table resolves the issue. Than you so much
     
    till likes this.

Share This Page