Hi Team
We have two separate instances setup as below with same configuration:
- Percona Server MySQL 8.0 running on RHEL 9.
- Percona Server MySQL 8.4 running on RHEL 9.
While the first one runs successfully without any issues, the second backup job gets stuck and hung at 25% indefinitely.
It gets stuck saying below last message:
40313 9d79 02/20 12:52:23 63146979 GetMySqlInfoExt::LastLogName() - GetLastLogName failed…
40313 9d79 02/20 12:52:23 63146979 MySqlClBackupBase::setMySqlInfo() - LastLogName failed
However, below is the DB level configuration:
root@localhost [(none)]> SHOW VARIABLES LIKE 'log_bin';
+---------------+-------+
Variable_name Value
+---------------+-------+
log_bin ON
+---------------+-------+
1 row in set (0.00 sec)
root@localhost [(none)]> SHOW VARIABLES LIKE 'binlog_format';
+---------------+-------+
Variable_name Value
+---------------+-------+
binlog_format ROW
+---------------+-------+
1 row in set (0.01 sec)
root@localhost [(none)]> SHOW VARIABLES LIKE 'binlog_expire_logs_seconds';
+----------------------------+--------+
Variable_name Value
+----------------------------+--------+
binlog_expire_logs_seconds 432000
+----------------------------+--------+
1 row in set (0.00 sec)
We have enough space on disk and same config settings works perfectly fine for Percona Server MySQL 8.0.
Attaching you some logs for your reference.
Regards
Srikanth