Issue Scheduled backup stop working

[falcongr]

Hello

I am facing a situation where the scheduled backup has stopped working at my server till 12th all of the sudden. I am not getting any error messages.
If i run manually the backup it is working ok

Any idea why this is happening?

Thank you in advance

 

[Bitpalast]

Do you see a /backup-* directory in in /usr/local/psa/PMM/logs of the time when the scheduled backup should have been done, for example
"/usr/local/psa/PMM/logs/backup-2017-01-17-03-45-01-965"? In that directory, there should be two files: pmmcli.log and backup.log. Do you find useful information in either one why the backup did not start/finish?

 

[falcongr]

I checked the folders you mentioned and i found that there is no folder created after the 12th of January as it should be and if i enter a folder previous 12th of January and try to check the log files with the plesk log pmmcli.log command i get an error message Incorrect log file:'pmmcli.log"

 

[Bitpalast]

Have you tried https://support.plesk.com/hc/en-us/...eduled-backup-does-not-run-at-scheduled-time- ?

 

[falcongr]

yes i have checked it and the file exists and it is not empty and i have checked the ownership and permissions

 

[Bitpalast]

Are you absolutely sure that "Activate this backup task" is checked in your scheduled backup? I am asking, because the description of the issue leads to the unlikely conclusion that the backup job in the database is corrupt. I don't think that is a likely cause.

Please take a look at /var/log/cron and identify the backupmng entries. Does this log show any errors? Is backupmng actually executed by it or is it missing completely from that log?

# grep backupmng /var/log/cron

should show lines like
Jan 17 17:30:02 elbe CROND[5971]: (root) CMD ([ -x /usr/local/psa/admin/sbin/backupmng ] && /usr/local/psa/admin/sbin/backupmng >/dev/null 2>&1)
every 15 minutes.

The point is this: If the crontab definition exists, backupmng should be started every 15 minutes. backupmng looks into the database whether there are backup jobs due, and if it finds any, it starts the backup (unless the scheduled backup is "inactive"). Checking whether backupmng is actually started, I want to rule out issues with cron. If the scheduled backup job is set to "active", the cron files exist according to the FAQ article and backupmng is started and no errors can be seen in /var/log/cron, then in my opinion the only remaining cause can be a corrupt database entry for the backup job you want to run.

 

[falcongr]

I have double checked that the Activate this backup task is checked
if i type # grep backupmng /var/log/cron i get the message " grep: /var/log/cron: No such file or directory"

 

[Bitpalast]

The location of the cron log depends on the operating system. On Redhat/CentOS it should be in /var/log/cron, on Debian/Ubuntu cron messages are written to /var/log/syslog by default. You need to find the cron log entries, then check what's going on with backupmng.

If there are no cron logs at all, this brings me about thinking whether crond is active?
# service crond status

 

[falcongr]

Server running debian 8.7
when i try service crond status i get the following crond.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)

 

[Bitpalast]

Debian 8.7:
# systemctl status cron

 

[falcongr]

Here the result of the systemctl status cron

cron.service - Regular background program processing daemon
Loaded: loaded (/lib/systemd/system/cron.service; enabled)
Active: active (running) since Tue 2017-01-17 18:36:01 EET; 4h 35min ago
Docs: man:cron(8)
Main PID: 533 (cron)
CGroup: /system.slice/cron.service
└─533 /usr/sbin/cron -f

 

[Bitpalast]

And the log entries? On Debian likely:
# grep backupmng /var/log/syslog
Are they there as expected, the 15 minutes interval start of backupmng?

 

[falcongr]

yes they are

Jan 17 06:36:01 server1 CRON[14725]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 06:51:01 server1 CRON[14992]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 07:06:01 server1 CRON[15275]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 07:21:01 server1 CRON[15528]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 07:36:01 server1 CRON[15904]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 07:51:01 server1 CRON[16222]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 08:06:01 server1 CRON[16571]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 08:21:01 server1 CRON[16929]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 08:36:01 server1 CRON[17317]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 08:51:01 server1 CRON[17674]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 09:06:01 server1 CRON[18059]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 09:21:01 server1 CRON[18392]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 09:36:01 server1 CRON[18814]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 09:51:01 server1 CRON[19216]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 10:06:01 server1 CRON[20423]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 10:21:01 server1 CRON[20752]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 10:36:01 server1 CRON[21118]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 10:51:01 server1 CRON[21436]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 11:06:01 server1 CRON[21807]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 11:21:01 server1 CRON[22150]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 11:36:01 server1 CRON[22557]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 11:51:01 server1 CRON[22864]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 12:06:01 server1 CRON[23243]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 12:21:01 server1 CRON[23565]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 12:36:01 server1 CRON[23926]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 12:51:01 server1 CRON[24260]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 13:06:01 server1 CRON[24615]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 13:21:01 server1 CRON[24949]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 13:36:01 server1 CRON[25283]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 13:51:01 server1 CRON[25619]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 14:06:01 server1 CRON[26046]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 14:21:02 server1 CRON[26381]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 14:36:01 server1 CRON[26726]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 14:51:01 server1 CRON[27043]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 15:06:01 server1 CRON[27377]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 15:21:01 server1 CRON[27687]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 15:36:01 server1 CRON[28166]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 15:51:01 server1 CRON[28456]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 16:06:01 server1 CRON[28831]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 16:21:01 server1 CRON[29142]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 16:36:01 server1 CRON[29468]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 16:51:01 server1 CRON[29765]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 17:06:01 server1 CRON[30089]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 17:21:01 server1 CRON[30392]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 17:36:01 server1 CRON[4434]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 17:51:01 server1 CRON[4726]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 18:06:01 server1 CRON[5053]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 18:21:01 server1 CRON[12244]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 18:51:01 server1 CRON[13334]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 19:06:01 server1 CRON[16209]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 19:21:01 server1 CRON[16494]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 19:36:01 server1 CRON[16934]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 19:51:01 server1 CRON[17585]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 20:06:01 server1 CRON[17812]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 20:21:01 server1 CRON[18167]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 20:36:01 server1 CRON[5156]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 20:51:01 server1 CRON[6387]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 21:06:01 server1 CRON[6634]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 21:21:01 server1 CRON[7081]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 21:36:01 server1 CRON[7308]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 21:51:01 server1 CRON[9354]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 22:06:01 server1 CRON[13750]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 22:21:01 server1 CRON[20244]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 22:36:01 server1 CRON[27041]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 22:51:01 server1 CRON[27485]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)
Jan 17 23:06:01 server1 CRON[27983]: (root) CMD ([ -x /opt/psa/admin/sbin/backupmng ] && /opt/psa/admin/sbin/backupmng >/dev/null 2>&1)

 

[Bitpalast]

O.k., so we have ruled out issues with crontab and with the configuration files as well as issues with backupmng and the backup job itself. Your backup is scheduled, it is active, the system is checking for active, scheduled backups every 15 minutes, no errors are logged - and it is still not running the backup?

Very vague, but in my opinion the only cause that is left is a broken database table or maybe a wrong field format. Could it be possible that at the time when the backup stopped you made changes to your MySQL/MariaDB installation on your server, e.g. made a custom update from MySQL 5.5 to MySQL 5.7?

If I was you, next I'd probably take a closer look at the BackupsScheduled table in the database:
# plesk db
MariaDB [psa]> select * from BackupsScheduled;
should display your scheduled backup (maybe along with others). Is it there? Is the "active" field of the dataset "true"?

Then I'd check whether all fields have the format they ought to have:
MariaDB [psa]> describe BackupsScheduled;
should yield:

+----------------------+---------------------------------------------------------------------------------------------+------+-----+------------------------------+----------------+
| Field                | Type                                                                                        | Null | Key | Default                      | Extra          |
+----------------------+---------------------------------------------------------------------------------------------+------+-----+------------------------------+----------------+
| id                   | int(10) unsigned                                                                            | NO   | PRI | NULL                         | auto_increment |
| obj_id               | int(10) unsigned                                                                            | NO   |     | 0                            |                |
| obj_type             | enum('server','reseller','client','domain')                                                 | NO   |     | NULL                         |                |
| repository           | enum('local','ftp')                                                                         | NO   |     | local                        |                |
| last                 | datetime                                                                                    | YES  |     | NULL                         |                |
| period               | int(10) unsigned                                                                            | NO   |     | 0                            |                |
| active               | enum('false','true')                                                                        | NO   |     | NULL                         |                |
| processed            | enum('false','true')                                                                        | NO   |     | NULL                         |                |
| rotation             | int(11)                                                                                     | NO   |     | 0                            |                |
| prefix               | varchar(255)                                                                                | YES  |     | NULL                         |                |
| email                | varchar(255)                                                                                | YES  |     | NULL                         |                |
| split_size           | bigint(20) unsigned                                                                         | NO   |     | 0                            |                |
| suspend              | enum('false','true')                                                                        | NO   |     | false                        |                |
| with_content         | enum('false','true')                                                                        | NO   |     | true                         |                |
| backup_day           | int(10) unsigned                                                                            | NO   |     | 0                            |                |
| backup_time          | varchar(8)                                                                                  | NO   |     | 00:00:00                     |                |
| content_type         | enum('backup_content_all_at_domain','backup_content_vhost_only','backup_content_mail_only') | NO   |     | backup_content_all_at_domain |                |
| full_backup_period   | int(11) unsigned                                                                            | NO   |     | 0                            |                |
| mssql_native_backup  | int(1)                                                                                      | NO   |     | 1                            |                |
| backupExcludeFilesId | int(10) unsigned                                                                            | YES  |     | NULL                         |                |
| backupExcludeLogs    | int(1)                                                                                      | NO   |     | 0                            |                |
+----------------------+---------------------------------------------------------------------------------------------+------+-----+------------------------------+----------------+
21 rows in set (0.00 sec)

(Compare yours against this table.)

If all that is fine, matches the structure, then I am out of ideas and suggest to
- run # plesk repair installation
- open a support ticket with Plesk support

 

[falcongr]

First of i all i want to thank you for all the information you have shared with me and the efforts you spend to solve my problem.
Taking a closer look at BackupsScheduled table the "active" field of the dataset is true and i get a table similar to yours.
I did a plesk repair installation schedule a backup and it worked, i will look it a couple of days just to check if everything works ok and if not i open a support ticket.
Thank you again for your support