[BUG] MySQL PITR only has table structures but no table data.

[leefeipo]

kubeblocsL 1.0.1
mysql: 8.0.36

source mysql：

1. CREATE TABLE test；
   mysql > DROP TABLE IF EXISTS test;
   CREATE TABLE test (
   id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
   name VARCHAR(50) NOT NULL COMMENT '姓名',
   age INT COMMENT '年龄',
   create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间（默认当前时间）',
   update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间（默认当前时间，更新时自动刷新）'
   ) COMMENT '测试表';

mysql > INSERT INTO test (name, age) VALUES
('张三', 25),
('李四', 30),
('王五', 28),
('赵六', 35),
('小明', 22),
('小红', 27),
('小刚', 32),
('莉莉', 29),
('华华', 31),
('芳芳', 26);

mysql> select * from test;
+----+--------+------+---------------------+---------------------+
| id | name | age | create_time | update_time |
+----+--------+------+---------------------+---------------------+
| 1 | 张三 | 25 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 2 | 李四 | 30 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 3 | 王五 | 28 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 4 | 赵六 | 35 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 5 | 小明 | 22 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 6 | 小红 | 27 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 7 | 小刚 | 32 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 8 | 莉莉 | 29 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 9 | 华华 | 31 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
| 10 | 芳芳 | 26 | 2026-03-06 15:53:00 | 2026-03-06 15:53:00 |
+----+--------+------+---------------------+---------------------+
10 rows in set (0.00 sec)

3. truncate table test.test;
   mysql > truncate table test;

4. insert test data again
   mysql > INSERT INTO test (name, age) VALUES
   ('张三', 25),
   ('李四', 30),
   ('王五', 28),
   ('赵六', 35),
   ('小明', 22),
   ('小红', 27),
   ('小刚', 32),
   ('莉莉', 29),
   ('华华', 31),
   ('芳芳', 26);

source mysql binlog events:
-- create table events
mysql> show binlog events in 'test-mysql-mysql-0-bin.001727' from 107015 limit 2;
+-------------------------------+--------+------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+-------------------------------+--------+------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test-mysql-mysql-0-bin.001727 | 107015 | Query | 1 | 107457 | use test; CREATE TABLE test ( id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID', name VARCHAR(50) NOT NULL COMMENT '姓名', age INT COMMENT '年龄', create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ) COMMENT '测试表' /* xid=70883192 */ |
| test-mysql-mysql-0-bin.001727 | 107457 | Gtid | 1 | 107536 | SET @@SESSION.GTID_NEXT= 'ac7a1db7-fcc3-11f0-9d4a-26f21a5f0ad7:3114764' |
+-------------------------------+--------+------------+-----------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

-- first write_rows event
mysql> show binlog events in 'test-mysql-mysql-0-bin.001727' from 114725 limit 5;
+-------------------------------+--------+------------+-----------+-------------+-------------------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+-------------------------------+--------+------------+-----------+-------------+-------------------------------------------------------------------------+
| test-mysql-mysql-0-bin.001727 | 114725 | Gtid | 1 | 114804 | SET @@SESSION.GTID_NEXT= 'ac7a1db7-fcc3-11f0-9d4a-26f21a5f0ad7:3114787' |
| test-mysql-mysql-0-bin.001727 | 114804 | Query | 1 | 114887 | BEGIN |
| test-mysql-mysql-0-bin.001727 | 114887 | Table_map | 1 | 114948 | table_id: 219 (test.test) |
| test-mysql-mysql-0-bin.001727 | 114948 | Write_rows | 1 | 115243 | table_id: 219 flags: STMT_END_F |
| test-mysql-mysql-0-bin.001727 | 115243 | Xid | 1 | 115274 | COMMIT /* xid=70883722 */ |
+-------------------------------+--------+------------+-----------+-------------+-------------------------------------------------------------------------+
5 rows in set (0.00 sec)

-- second write_rows event

mysql> show binlog events in 'test-mysql-mysql-0-bin.001727' from 173277 limit 5;
+-------------------------------+--------+------------+-----------+-------------+-------------------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+-------------------------------+--------+------------+-----------+-------------+-------------------------------------------------------------------------+
| test-mysql-mysql-0-bin.001727 | 173277 | Gtid | 1 | 173356 | SET @@SESSION.GTID_NEXT= 'ac7a1db7-fcc3-11f0-9d4a-26f21a5f0ad7:3114972' |
| test-mysql-mysql-0-bin.001727 | 173356 | Query | 1 | 173439 | BEGIN |
| test-mysql-mysql-0-bin.001727 | 173439 | Table_map | 1 | 173500 | table_id: 220 (test.test) |
| test-mysql-mysql-0-bin.001727 | 173500 | Write_rows | 1 | 173795 | table_id: 220 flags: STMT_END_F |
| test-mysql-mysql-0-bin.001727 | 173795 | Xid | 1 | 173826 | COMMIT /* xid=70887894 */ |
+-------------------------------+--------+------------+-----------+-------------+-------------------------------------------------------------------------+
5 rows in set (0.00 sec)

backup status:
$ kubectl get backup -n test-mysql 44b2e4cb-test-mysql-mysql-back-archive-binlog -o yaml | yq '.status.timeRange'
{
"end": "2026-03-09T06:08:22Z",
"start": "2026-03-01T05:59:36Z"
}

$ ku get backup -n test-mysql
NAME POLICY METHOD REPO STATUS TOTAL-SIZE DURATION DELETION-POLICY CREATION-TIME COMPLETION-TIME EXPIRATION-TIME
44b2e4cb-test-mysql-mysql-back-archive-binlog test-mysql-mysql-backup-policy archive-binlog s3-mysql-backuprepo Running 38357842 Delete 2026-01-29T09:04:42Z
test-mysql-xtrabackup-20260301092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 24932446 16s Delete 2026-03-01T09:25:00Z 2026-03-01T09:25:15Z 2026-03-09T09:25:15Z
test-mysql-xtrabackup-20260302092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 24414849 16s Delete 2026-03-02T09:25:00Z 2026-03-02T09:25:15Z 2026-03-10T09:25:15Z
test-mysql-xtrabackup-20260303092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 24050402 15s Delete 2026-03-03T09:25:00Z 2026-03-03T09:25:15Z 2026-03-11T09:25:15Z
test-mysql-xtrabackup-20260304092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 24824132 16s Delete 2026-03-04T09:25:00Z 2026-03-04T09:25:16Z 2026-03-12T09:25:16Z
test-mysql-xtrabackup-20260305092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 24694331 11s Delete 2026-03-05T09:25:00Z 2026-03-05T09:25:11Z 2026-03-13T09:25:11Z
test-mysql-xtrabackup-20260306092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 25271716 16s Delete 2026-03-06T09:25:00Z 2026-03-06T09:25:15Z 2026-03-14T09:25:15Z
test-mysql-xtrabackup-20260307092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 21139481 15s Delete 2026-03-07T09:25:00Z 2026-03-07T09:25:15Z 2026-03-15T09:25:15Z
test-mysql-xtrabackup-20260308092500 test-mysql-mysql-backup-policy xtrabackup s3-mysql-backuprepo Completed 24132706 16s Delete 2026-03-08T09:25:00Z 2026-03-08T09:25:16Z 2026-03-16T09:25:16Z

PITR recover settings:
$ cat pitr-test-mysql.yaml
apiVersion: apps.kubeblocks.io/v1
kind: Cluster
metadata:
name: test-mysql-pitr
namespace: test-mysql
annotations:
kubeblocks.io/restore-from-backup: '{"mysql":{"name":"44b2e4cb-test-mysql-mysql-back-archive-binlog","namespace":"test-mysql","volumeRestorePolicy":"Parallel","restoreTime":"2026-03-06T07:55:00Z"}}'
spec:
clusterDef: mysql
componentSpecs:

• name: mysql
  componentDef: mysql-8.0
  serviceVersion: 8.0.36
  disableExporter: false
  replicas: 2
  resources:
  limits:
  cpu: "1"
  memory: 2Gi
  requests:
  cpu: "1"
  memory: 2Gi
  schedulingPolicy:
  affinity:
  podAntiAffinity:
  requiredDuringSchedulingIgnoredDuringExecution:
  - labelSelector:
  matchExpressions:
  - key: app.kubernetes.io/instance
  operator: In
  values:
  - test-mysql
  - key: apps.kubeblocks.io/component-name
  operator: In
  values:
  - mysql
  topologyKey: kubernetes.io/hostname
  nodeSelector:
  node-role.kubernetes.io/pg-worker: "true"
  tolerations:
  • effect: NoSchedule
    key: node-role.kubernetes.io/pg-worker
    value: "true"
    volumeClaimTemplates:
  • name: data
    spec:
    accessModes:
    • ReadWriteOnce
      resources:
      requests:
      storage: 10Gi
      storageClassName: dr-db-disk-nvme
      services:
• annotations:
  external-dns.alpha.kubernetes.io/hostname: test-mysql-pitr.srv.xxxx.cn
  componentSelector: mysql
  name: internet
  roleSelector: primary
  serviceName: internet
  spec:
  ipFamilyPolicy: PreferDualStack
  ports:
  • name: mysql
    port: 3306
    protocol: TCP
    targetPort: mysql
    type: LoadBalancer
    terminationPolicy: Delete
    topology: semisync

dest mysql:
mysql> select * from test;
Empty set (0.00 sec)

[leefeipo]

dest mysql pitr log:

$ kubectl logs -f -n test-mysql restore-post-ready-df8052d0-44b2e4cb-test-mysql-mysql-bac-zs5c2
Defaulted container "restore" out of: restore, dp-copy-datasafed (init)
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
2026-03-06 12:26:30 INFO: mkdir -p /var/lib/mysql/pitr-logs
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
2026-03-06 12:26:30 INFO: wal-g binlog-replay --since-time=2026-03-05T09:25:00Z --until=2026-03-06T07:55:00Z
WARNING: 2026/03/06 12:26:30.861647 WALG_FAILOVER_STORAGES_CHECK_TIMEOUT is unknown
WARNING: 2026/03/06 12:26:30.861664 WALG_FAILOVER_STORAGES_CACHE_LIFETIME is unknown
WARNING: 2026/03/06 12:26:30.861676 We found that some variables in your config file detected as 'Unknown'.
If this is not right, please create issue https://github.com/wal-g/wal-g/issues/new
INFO: 2026/03/06 12:26:30.862413 Fetching binlogs since 2026-03-05 09:25:00 +0000 UTC until 2026-03-06 07:55:00 +0000 UTC
INFO: 2026/03/06 12:26:38.428070 downloading test-mysql-mysql-0-bin.001682 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001682
INFO: 2026/03/06 12:26:38.551395 downloading test-mysql-mysql-0-bin.001683 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001683
INFO: 2026/03/06 12:26:38.551656 replaying test-mysql-mysql-0-bin.001682 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:38.607904 downloading test-mysql-mysql-0-bin.001684 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001684
INFO: 2026/03/06 12:26:38.651098 downloading test-mysql-mysql-0-bin.001685 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001685
INFO: 2026/03/06 12:26:40.829724 replaying test-mysql-mysql-0-bin.001683 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:40.830308 downloading test-mysql-mysql-0-bin.001686 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001686
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:45.391086 replaying test-mysql-mysql-0-bin.001684 ...
INFO: 2026/03/06 12:26:45.391436 downloading test-mysql-mysql-0-bin.001687 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001687
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:50.021935 replaying test-mysql-mysql-0-bin.001685 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:50.022319 downloading test-mysql-mysql-0-bin.001688 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001688
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:54.846840 replaying test-mysql-mysql-0-bin.001686 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:54.847408 downloading test-mysql-mysql-0-bin.001689 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001689
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:26:59.471565 replaying test-mysql-mysql-0-bin.001687 ...
INFO: 2026/03/06 12:26:59.472129 downloading test-mysql-mysql-0-bin.001690 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001690
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:04.397780 replaying test-mysql-mysql-0-bin.001688 ...
INFO: 2026/03/06 12:27:04.398448 downloading test-mysql-mysql-0-bin.001691 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001691
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:08.990634 replaying test-mysql-mysql-0-bin.001689 ...
INFO: 2026/03/06 12:27:08.991016 downloading test-mysql-mysql-0-bin.001692 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001692
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:13.914931 replaying test-mysql-mysql-0-bin.001690 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:13.915497 downloading test-mysql-mysql-0-bin.001693 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001693
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:18.840368 replaying test-mysql-mysql-0-bin.001691 ...
INFO: 2026/03/06 12:27:18.840952 downloading test-mysql-mysql-0-bin.001694 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001694
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:23.762949 replaying test-mysql-mysql-0-bin.001692 ...
INFO: 2026/03/06 12:27:23.763282 downloading test-mysql-mysql-0-bin.001695 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001695
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:28.534656 replaying test-mysql-mysql-0-bin.001693 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:28.535089 downloading test-mysql-mysql-0-bin.001696 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001696
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:33.093504 replaying test-mysql-mysql-0-bin.001694 ...
INFO: 2026/03/06 12:27:33.094101 downloading test-mysql-mysql-0-bin.001697 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001697
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:38.044677 replaying test-mysql-mysql-0-bin.001695 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:38.045123 downloading test-mysql-mysql-0-bin.001698 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001698
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:42.951866 replaying test-mysql-mysql-0-bin.001696 ...
INFO: 2026/03/06 12:27:42.952216 downloading test-mysql-mysql-0-bin.001699 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001699
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:47.830862 replaying test-mysql-mysql-0-bin.001697 ...
INFO: 2026/03/06 12:27:47.831442 downloading test-mysql-mysql-0-bin.001700 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001700
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:52.585831 replaying test-mysql-mysql-0-bin.001698 ...
INFO: 2026/03/06 12:27:52.586406 downloading test-mysql-mysql-0-bin.001701 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001701
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:27:57.308345 replaying test-mysql-mysql-0-bin.001699 ...
INFO: 2026/03/06 12:27:57.308939 downloading test-mysql-mysql-0-bin.001702 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001702
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:02.175726 replaying test-mysql-mysql-0-bin.001700 ...
INFO: 2026/03/06 12:28:02.176272 downloading test-mysql-mysql-0-bin.001703 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001703
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:07.119633 replaying test-mysql-mysql-0-bin.001701 ...
INFO: 2026/03/06 12:28:07.119999 downloading test-mysql-mysql-0-bin.001704 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001704
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:12.042440 replaying test-mysql-mysql-0-bin.001702 ...
INFO: 2026/03/06 12:28:12.042833 downloading test-mysql-mysql-0-bin.001705 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001705
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:17.068798 replaying test-mysql-mysql-0-bin.001703 ...
INFO: 2026/03/06 12:28:17.069385 downloading test-mysql-mysql-0-bin.001706 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001706
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:22.101896 replaying test-mysql-mysql-0-bin.001704 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:22.102354 downloading test-mysql-mysql-0-bin.001707 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001707
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:27.204700 replaying test-mysql-mysql-0-bin.001705 ...
INFO: 2026/03/06 12:28:27.205071 downloading test-mysql-mysql-0-bin.001708 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001708
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:32.308450 replaying test-mysql-mysql-0-bin.001706 ...
INFO: 2026/03/06 12:28:32.309023 downloading test-mysql-mysql-0-bin.001709 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001709
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:36.975291 replaying test-mysql-mysql-0-bin.001707 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:36.975861 downloading test-mysql-mysql-0-bin.001710 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001710
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:41.441494 replaying test-mysql-mysql-0-bin.001708 ...
INFO: 2026/03/06 12:28:41.441898 downloading test-mysql-mysql-0-bin.001711 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001711
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:46.139053 replaying test-mysql-mysql-0-bin.001709 ...
INFO: 2026/03/06 12:28:46.139667 downloading test-mysql-mysql-0-bin.001712 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001712
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:50.636957 replaying test-mysql-mysql-0-bin.001710 ...
INFO: 2026/03/06 12:28:50.637632 downloading test-mysql-mysql-0-bin.001713 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001713
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:28:55.432829 replaying test-mysql-mysql-0-bin.001711 ...
INFO: 2026/03/06 12:28:55.433078 downloading test-mysql-mysql-0-bin.001714 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001714
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:00.026322 replaying test-mysql-mysql-0-bin.001712 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:00.026887 downloading test-mysql-mysql-0-bin.001715 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001715
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:04.757993 replaying test-mysql-mysql-0-bin.001713 ...
INFO: 2026/03/06 12:29:04.758548 downloading test-mysql-mysql-0-bin.001716 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001716
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:09.871177 replaying test-mysql-mysql-0-bin.001714 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:09.871618 downloading test-mysql-mysql-0-bin.001717 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001717
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:14.827212 replaying test-mysql-mysql-0-bin.001715 ...
INFO: 2026/03/06 12:29:14.827749 downloading test-mysql-mysql-0-bin.001718 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001718
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:19.956455 replaying test-mysql-mysql-0-bin.001716 ...
INFO: 2026/03/06 12:29:19.956811 downloading test-mysql-mysql-0-bin.001719 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001719
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:24.833853 replaying test-mysql-mysql-0-bin.001717 ...
INFO: 2026/03/06 12:29:24.834413 downloading test-mysql-mysql-0-bin.001720 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001720
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:29.809945 replaying test-mysql-mysql-0-bin.001718 ...
INFO: 2026/03/06 12:29:29.810511 downloading test-mysql-mysql-0-bin.001721 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001721
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:34.905704 replaying test-mysql-mysql-0-bin.001719 ...
INFO: 2026/03/06 12:29:34.906274 downloading test-mysql-mysql-0-bin.001722 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001722
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:39.692968 replaying test-mysql-mysql-0-bin.001720 ...
INFO: 2026/03/06 12:29:39.693225 downloading test-mysql-mysql-0-bin.001723 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001723
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:44.647351 replaying test-mysql-mysql-0-bin.001721 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:44.647788 downloading test-mysql-mysql-0-bin.001724 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001724
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:49.666569 replaying test-mysql-mysql-0-bin.001722 ...
INFO: 2026/03/06 12:29:49.666801 downloading test-mysql-mysql-0-bin.001725 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001725
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:54.303220 replaying test-mysql-mysql-0-bin.001723 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:54.303797 downloading test-mysql-mysql-0-bin.001726 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001726
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:59.648265 replaying test-mysql-mysql-0-bin.001724 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:29:59.648709 downloading test-mysql-mysql-0-bin.001727 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001727
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:30:04.700505 replaying test-mysql-mysql-0-bin.001725 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:30:04.700948 downloading test-mysql-mysql-0-bin.001728 into /var/lib/mysql/pitr-logs/test-mysql-mysql-0-bin.001728
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:30:09.716349 replaying test-mysql-mysql-0-bin.001726 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:30:14.783980 replaying test-mysql-mysql-0-bin.001727 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
INFO: 2026/03/06 12:30:17.548865 replaying test-mysql-mysql-0-bin.001728 ...
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
ERROR: ld.so: object '/tools/lib/libjemalloc.so.2' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored.
mysql binlog replay done.

[leefeipo]

1. The time zone of the container is UTC.
2. mysql time_zone settings:
   mysql> SHOW GLOBAL VARIABLES LIKE 'system_time_zone';
   +------------------+-------+
   | Variable_name | Value |
   +------------------+-------+
   | system_time_zone | UTC |
   +------------------+-------+
   1 row in set (0.01 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'time_zone';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| time_zone | +08:00 |
+---------------+--------+
1 row in set (0.00 sec)

[shanshanying]

@wangyelei @xuriwuyun pls take a look when you have time.

[wangyelei]

replace "restoreTime":"2026-03-06T07:55:00Z" to "restoreTime":"2026-03-06T07:56:00Z"?

[leefeipo]

replace "restoreTime":"2026-03-06T07:55:00Z" to "restoreTime":"2026-03-06T07:56:00Z"?

The effect is the same. The "test" table only has the table structure but no table data.
mysql> select * from test;
Empty set (0.00 sec)

[wangyelei]

@leefeipo can you show me the latest data from table test and please confirm whether the data still exists when we restore to 2026-03-09T06:08:22Z

[leefeipo]

`
#!/bin/bash
# log info file
function DP_log() {
msg=$1
local curr_date=$(date -u '+%Y-%m-%d %H:%M:%S')
echo "${curr_date} INFO: $msg"
}

      # log error info
      function DP_error_log() {
          msg=$1
          local curr_date=$(date -u '+%Y-%m-%d %H:%M:%S')
          echo "${curr_date} ERROR: $msg"
      }

      # Get file names without extensions based on the incoming file path
      function DP_get_file_name_without_ext() {
          local fileName=$1
          local file_without_ext=${fileName%.*}
          echo $(basename ${file_without_ext})
      }

      # Save backup status info file for syncing progress.
      # timeFormat: %Y-%m-%dT%H:%M:%SZ
      function DP_save_backup_status_info() {
          local totalSize=$1
          local startTime=$2
          local stopTime=$3
          local timeZone=$4
          local extras=$5
          local timeZoneStr=""
          if [ ! -z ${timeZone} ]; then
             timeZoneStr=",\"timeZone\":\"${timeZone}\""
          fi
          if [ -z "${stopTime}" ];then
            echo "{\"totalSize\":\"${totalSize}\"}" > ${DP_BACKUP_INFO_FILE}
          elif [ -z "${startTime}" ];then
            echo "{\"totalSize\":\"${totalSize}\",\"extras\":[${extras}],\"timeRange\":{\"end\":\"${stopTime}\"${timeZoneStr}}}" > ${DP_BACKUP_INFO_FILE}
          else
            echo "{\"totalSize\":\"${totalSize}\",\"extras\":[${extras}],\"timeRange\":{\"start\":\"${startTime}\",\"end\":\"${stopTime}\"${timeZoneStr}}}" > ${DP_BACKUP_INFO_FILE}
          fi
      }


      # Clean up expired logfiles.
      # Default interval is 60s
      # Default rootPath is /
      function DP_purge_expired_files() {
        local currentUnix="${1:?missing current unix}"
        local last_purge_time="${2:?missing last_purge_time}"
        local root_path=${3:-"/"}
        local interval_seconds=${4:-60}
        local diff_time=$((${currentUnix}-${last_purge_time}))
        if [[ -z ${DP_TTL_SECONDS} || ${diff_time} -lt ${interval_seconds} ]]; then
           return
        fi
        expiredUnix=$((${currentUnix}-${DP_TTL_SECONDS}))
        files=$(datasafed list -f --recursive --older-than ${expiredUnix} ${root_path} )
        for file in ${files}
        do
            datasafed rm ${file}
            echo ${file}
        done
      }

      # analyze the start time of the earliest file from the datasafed backend.
      # Then record the file name into dp_oldest_file.info.
      # If the oldest file is no changed, exit the process.
      # This can save traffic consumption.
      function DP_analyze_start_time_from_datasafed() {
          local oldest_file="${1:?missing oldest file}"
          local get_start_time_from_file="${2:?missing get_start_time_from_file function}"
          local datasafed_pull="${3:?missing datasafed_pull function}"
          local info_file="${KB_BACKUP_WORKDIR}/dp_oldest_file.info"
          mkdir -p ${KB_BACKUP_WORKDIR} && cd ${KB_BACKUP_WORKDIR}
          if [ -f ${info_file} ]; then
            last_oldest_file=$(cat ${info_file})
            last_oldest_file_name=$(DP_get_file_name_without_ext ${last_oldest_file})
            if [ "$last_oldest_file" == "${oldest_file}" ]; then
              # oldest file no changed.
              ${get_start_time_from_file} $last_oldest_file_name
              return
            fi
               # remove last oldest file
            if [ -f ${last_oldest_file_name} ];then
                rm -rf ${last_oldest_file_name}
            fi
          fi
          # pull file
          ${datasafed_pull} ${oldest_file}
          # record last oldest file
          echo ${oldest_file} > ${info_file}
          oldest_file_name=$(DP_get_file_name_without_ext ${oldest_file})
          ${get_start_time_from_file} ${oldest_file_name}
      }

      # get the timeZone offset for location, such as Asia/Shanghai
      function getTimeZoneOffset() {
         local timeZone=${1:?missing time zone}
         if [[ $timeZone == "+"* ]] || [[ $timeZone == "-"* ]] ; then
            echo ${timeZone}
            return
         fi
         local currTime=$(TZ=UTC date)
         local utcHour=$(TZ=UTC date -d "${currTime}" +"%H")
         local zoneHour=$(TZ=${timeZone} date -d "${currTime}" +"%H")
         local offset=$((${zoneHour}-${utcHour}))
         if [ $offset -eq 0 ]; then
            return
         fi
         symbol="+"
         if [ $offset -lt 0 ]; then
           symbol="-" && offset=${offset:1}
         fi
         if [ $offset -lt 10 ];then
            offset="0${offset}"
         fi
         echo "${symbol}${offset}:00"
      }


      #!/bin/bash
      #
      # Refer: https://github.com/wal-g/wal-g/blob/master/docs/MySQL.md#mysql---using-with-xtrabackup
      #
      # export wal-g environments
      export WALG_MYSQL_DATASOURCE_NAME="${MYSQL_ADMIN_USER}:${MYSQL_ADMIN_PASSWORD}@tcp(${DP_DB_HOST}:${DP_DB_PORT})/mysql"
      export WALG_COMPRESSION_METHOD=zstd
      # use datasafed and default config
      export WALG_DATASAFED_CONFIG=""
      export PATH="$PATH:$DP_DATASAFED_BIN_PATH"
      export WALG_MYSQL_CHECK_GTIDS=true
      export MYSQL_PWD=${MYSQL_ADMIN_PASSWORD}
      export DATASAFED_BACKEND_BASE_PATH="$DP_BACKUP_BASE_PATH"
      export WALG_MYSQL_BINLOG_DST=${PITR_DIR}
      export WALG_MYSQL_BINLOG_REPLAY_COMMAND="mysqlbinlog --base64-output=DECODE-ROWS --stop-datetime=\"\$WALG_MYSQL_BINLOG_END_TS\" \"\$WALG_MYSQL_CURRENT_BINLOG\" | grep -v 'INSERT INTO kubeblocks.kb_health_check' | mysql -u ${MYSQL_ADMIN_USER} -h ${DP_DB_HOST}"

      # If pitr logs dir exists, it may be created by previous failed restore.
      if [ -d "$WALG_MYSQL_BINLOG_DST" ]; then
          DP_log "pitr logs dir $WALG_MYSQL_BINLOG_DST exists, may be created by previous failed restore, exit"
          exit 1
      fi

      DP_log "mkdir -p $WALG_MYSQL_BINLOG_DST"
      mkdir -p "$WALG_MYSQL_BINLOG_DST"

      DP_log "wal-g binlog-replay --since-time=${DP_BASE_BACKUP_START_TIME} --until=${DP_RESTORE_TIME}"
      wal-g binlog-replay --since-time="${DP_BASE_BACKUP_START_TIME}" --until="${DP_RESTORE_TIME}"
      echo "mysql binlog replay done."

`
This is the logic of mysql-pitr. I have two questions?

1. Why does the logic for replaying binlog need to add the --base64-output=decode-rows parameter? With this parameter, row events cannot be parsed.
2. grep -v 'INSERT INTO kubeblocks.kb_health_check' filters out the insert events of the heartbeat table, but doesn't the HA logic update the heartbeat table every second?
   After I commented out --base64-output=DECODE-ROWS and | grep -v 'INSERT INTO kubeblocks.kb_health_check', the commented export WALG_MYSQL_BINLOG_REPLAY_COMMAND is as follows:

export WALG_MYSQL_BINLOG_REPLAY_COMMAND="mysqlbinlog --stop-datetime="$WALG_MYSQL_BINLOG_END_TS" "$WALG_MYSQL_CURRENT_BINLOG" | mysql -u ${MYSQL_ADMIN_USER} -h ${DP_DB_HOST}"

The PITR recovery was as expected.
reference:

1. https://www.percona.com/blog/why-base64-outputdecode-rows-does-not-print-row-events-in-mysql-binary-logs/
2. MySQL & PgSql use syncer to support ha #8419

@leefeipo can you show me the latest data from table test and please confirm whether the data still exists when we restore to 2026-03-09T06:08:22Z

[leefeipo]

@leefeipo can you show me the latest data from table test and please confirm whether the data still exists when we restore to 2026-03-09T06:08:22Z

The source end test table contains 10 records. When restored to the target end MySQL via pitr, 10 records are also expected. However, only the table structure exists on the target end MySQL. The restored binlog includes binlog events for inserting all 10 records.

[wangyelei]

@leefeipo already fixed at 1.0.2, you can upgrade to mysql 1.0.2 addon