Backup Error

Discussion in 'General' started by Caio.Henrique, Sep 4, 2019.

  1. Caio.Henrique

    Caio.Henrique New Member

    The result of this command are in #1
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The result should be different and more detailed after enabling the debug mode.
     
  3. Caio.Henrique

    Caio.Henrique New Member

    This command should be executed in a specific directory?
     
  4. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Not really. Please check the /var/log/ispconfig/*.log files too, if there is anything debugged in it.
     
  5. Caio.Henrique

    Caio.Henrique New Member

    The cron.log shows me the same error. The auth and ispconfig log are empty.
     
  6. Eokna

    Eokna New Member

    Hello.

    I have a similar problem on Ubuntu 16.04, after update a week ago backup stopped working. In the cron log i got this "php warning: chmod () permission denied in /usr/local/ispconfig/server/lib/classen/cron.d/500-backup.inc.php on line 74"
    if from terminal run "php /usr/local/ispconfig/server/cron_debug.php --cronjob = 500-backup.inc.php" same error is displayed.
    when run "php /usr/local/ispconfig/server/cron_debug.php --cronjob = 500-backup_mail.inc.php"
    got the same error but mail backup runs
    help me please :|
     
  7. Caio.Henrique

    Caio.Henrique New Member

    Hi everyone!!
    Any news about my problem?
     
  8. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Please check if in your /usr/local/ispconfig/server/lib/config.inc.php the log_priority entry is also set to debug before you run the cron debug command.
     
  9. Caio.Henrique

    Caio.Henrique New Member

    No, in panel is setted to debug, but in this file no. I change to 0 in file and run the command. And the result is:


    Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock


    10.09.2019-10:02 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    10.09.2019-10:02 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.
     
  10. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Again you run the server.sh script, but we need the output of the backup cron debug script as already stated multiple times.
     
  11. Caio.Henrique

    Caio.Henrique New Member

    what command then?
     
  12. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Dear, I am near to not replying anymore. Please read the thread again, especially #20.
     
  13. Caio.Henrique

    Caio.Henrique New Member

    Called run() for class cronjob_backup
    Job has schedule: 00 0 * * *
    Called onPrepare() for class cronjob_backup
    Called onBeforeRun() for class cronjob_backup
    Jobs next run is 2019-09-11 00:00:00
    Date compare of 1568170800 and 1568120885 is -1
    10.09.2019-10:08 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web22' && sudo -u 'web22' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web22/web22_2019-09-10_10-08.zip' -@ - return code: 0
    10.09.2019-10:08 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web22' && sudo -u 'web22' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web22/web22_2019-09-10_10-08.zip' -@ - return code: 12
    10.09.2019-10:08 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web22' - return code: 0
    10.09.2019-10:08 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web22' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web7' && sudo -u 'web7' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web7/web7_2019-09-10_10-08.zip' -@ - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web7' && sudo -u 'web7' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web7/web7_2019-09-10_10-08.zip' -@ - return code: 12
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web7' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web7' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web14' && sudo -u 'web14' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web14/web14_2019-09-10_10-09.zip' -@ - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web14' && sudo -u 'web14' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web14/web14_2019-09-10_10-09.zip' -@ - return code: 12
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web14' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web14' - return code: 0
    ^[[17~10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web6' && sudo -u 'web6' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web6/web6_2019-09-10_10-09.zip' -@ - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web6' && sudo -u 'web6' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web6/web6_2019-09-10_10-09.zip' -@ - return code: 12
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web6' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web6' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web3' && sudo -u 'web3' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web3/web3_2019-09-10_10-09.zip' -@ - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web3' && sudo -u 'web3' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web3/web3_2019-09-10_10-09.zip' -@ - return code: 12
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web3' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web3' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web4' && sudo -u 'web4' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web4/web4_2019-09-10_10-09.zip' -@ - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web4' && sudo -u 'web4' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web4/web4_2019-09-10_10-09.zip' -@ - return code: 12
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web4' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web4' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web5' && sudo -u 'web5' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web5/web5_2019-09-10_10-09.zip' -@ - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web5' && sudo -u 'web5' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web5/web5_2019-09-10_10-09.zip' -@ - return code: 12
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web5' - return code: 0
    10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web5' - return code: 0
    mysqldump: Couldn't execute 'SHOW PACKAGE STATUS WHERE Db = 'db_name'': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PACKAGE STATUS WHERE Db = 'db_name'' at line 1 (1064)
    10.09.2019-10:09 - DEBUG - safe_exec cmd: mysqldump -h 'localhost' -u 'user' -p'pass' -c --add-drop-table --create-options --quick --max_allowed_packet=512M --routines --result-file='/var/backup/web3/db_db_name_2019-09-10_10-09.sql' 'db_name' - return code: 2
     
  14. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Either you have changed the backup mode from tar to user-owned zip on the server or this is not the server the error you specified in the first posts occured. Additionally the ISPConfig seems to not be 3.1.15 otherwise the PACKAGE STATUS error should not be there.
     
  15. Caio.Henrique

    Caio.Henrique New Member

    I changed to web directory with root owner. And the results are:


    Jobs next run is 2019-09-11 00:00:00
    Date compare of 1568170800 and 1568121865 is -1
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:24 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web22' . --exclude=./backup\* | pigz > '/var/backup/web22/web22_2019-09-10_10-24.tar.gz' - return code: 0
    10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web22' - return code: 0
    10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web22' - return code: 0
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:24 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web7' . --exclude=./backup\* | pigz > '/var/backup/web7/web7_2019-09-10_10-24.tar.gz' - return code: 0
    10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web7' - return code: 0
    10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web7' - return code: 0
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:24 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web14' . --exclude=./backup\* | pigz > '/var/backup/web14/web14_2019-09-10_10-24.tar.gz' - return code: 0
    10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web14' - return code: 0
    10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web14' - return code: 0
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web6' . --exclude=./backup\* | pigz > '/var/backup/web6/web6_2019-09-10_10-24.tar.gz' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web6' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web6' - return code: 0
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web3' . --exclude=./backup\* | pigz > '/var/backup/web3/web3_2019-09-10_10-25.tar.gz' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web3' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web3' - return code: 0
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web4' . --exclude=./backup\* | pigz > '/var/backup/web4/web4_2019-09-10_10-25.tar.gz' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web4' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web4' - return code: 0
    tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
    tar: --exclude “./backup*” has no effect
    tar: Saindo com status de falha em razão de erros anteriores
    10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web5' . --exclude=./backup\* | pigz > '/var/backup/web5/web5_2019-09-10_10-25.tar.gz' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web5' - return code: 0
    10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web5' - return code: 0
    mysqldump: Couldn't execute 'SHOW PACKAGE STATUS WHERE Db = 'db_name'': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PACKAGE STATUS WHERE Db = 'db_name'' at line 1 (1064)
    10.09.2019-10:25 - DEBUG - safe_exec cmd: mysqldump -h 'localhost' -u 'user' -p'pass' -c --add-drop-table --create-options --quick --max_allowed_packet=512M --routines --result-file='/var/backup/web3/db_db_name_2019-09-10_10-25.sql' 'db_name' - return code: 2


    And the version of ispconfig is 3.1.15 and the server is the same.
     
  16. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Finally this is the output that we requested. So we can look into it now.
     
  17. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

  18. Caio.Henrique

    Caio.Henrique New Member

  19. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    @Croydon pointed to the bug report on your issue, that was created today. Or at least modified today.
    You can follow the progress of that bug to see when it may get fixed.
     
    till likes this.
  20. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page