Scheduled backups are not performed in scheduled time. The following error is shown while running
backupmng utility manually:
# /usr/local/psa/admin/sbin/backupmng backupmng: Unable to fetch backup tasks from database: 'psa.BackupsScheduled.id' isn't in GROUP BY backupmng: Unable to fetch backup tasks from database: 'psa.BackupsScheduled.id' isn't in GROUP BY
MySQL configuration includes strict options.
my.cnf file and remove
ONLY_FULL_GROUP_BY option from
# grep -ir "sql-mode" /etc/my.cnf sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
Restart MySQL service.