Description:
After restoring our database from a full backup the PITR is no longer working.
Error observed in the logs is as follows:
2024/08/02 13:53:05 ERROR: get binlog timestamp for binlog binlog.000009 host perconamysql-pxc-db-pxc-0.perconamysql-pxc-db-pxc.am.svc.cluster.local: get binlog first timestamp: scan binlog timestamp: Error 1046: No database selected
2024/08/02 13:53:05 ERROR: get binlog time get binlog oldest timestamp for host perconamysql-pxc-db-pxc-0.perconamysql-pxc-db-pxc.am.svc.cluster.local: no binlogs timestamp found
2024/08/02 13:53:05 ERROR: get binlog timestamp for binlog binlog.000007 host perconamysql-pxc-db-pxc-1.perconamysql-pxc-db-pxc.am.svc.cluster.local: get binlog first timestamp: scan binlog timestamp: Error 1046: No database selected
2024/08/02 13:53:05 ERROR: get binlog time get binlog oldest timestamp for host perconamysql-pxc-db-pxc-1.perconamysql-pxc-db-pxc.am.svc.cluster.local: no binlogs timestamp found
2024/08/02 13:53:05 ERROR: get binlog timestamp for binlog binlog.000013 host perconamysql-pxc-db-pxc-2.perconamysql-pxc-db-pxc.am.svc.cluster.local: get binlog first timestamp: scan binlog timestamp: Error 1046: No database selected
2024/08/02 13:53:05 ERROR: get binlog timestamp for binlog binlog.000014 host perconamysql-pxc-db-pxc-2.perconamysql-pxc-db-pxc.am.svc.cluster.local: get binlog first timestamp: scan binlog timestamp: Error 1046: No database selected
2024/08/02 13:53:05 ERROR: get binlog timestamp for binlog binlog.000015 host perconamysql-pxc-db-pxc-2.perconamysql-pxc-db-pxc.am.svc.cluster.local: get binlog first timestamp: scan binlog timestamp: Error 1046: No database selected
2024/08/02 13:53:05 ERROR: get binlog timestamp for binlog binlog.000016 host perconamysql-pxc-db-pxc-2.perconamysql-pxc-db-pxc.am.svc.cluster.local: get binlog first timestamp: scan binlog timestamp: Error 1046: No database selected
2024/08/02 13:53:05 ERROR: get binlog time get binlog oldest timestamp for host perconamysql-pxc-db-pxc-2.perconamysql-pxc-db-pxc.am.svc.cluster.local: no binlogs timestamp found
2024/08/02 13:53:05 ERROR: new db connection: get host: can't find host
Steps to Reproduce:
This can also be reproduced by running the underlying query
mysql> SELECT get_first_record_timestamp_by_binlog('binlog.000017') DIV 1000000;
ERROR 1046 (3D000): No database selected
Version:
percona-xtradb-cluster-operator:1.12.0