问tdsql pg 备份失败？

提问于 2025-07-30 18:43:15

回答 0关注 0查看 11

环境：

RHEL7.9, TDSQL pg 5.06.4.

建库，插入一些数据，第一次数据库全备。失败。

部分错误：

1 [tbase@VM-0-8-centos tmp]$ cat oss.err

2 2025-07-30 11:04:43.190643 ERROR [330330] ShouldInterruptedByScalelout()->isScaleOuting() oss_com_db_node_op.go:4200 [traceId:0ppr5TQNR] [isS caleOuting] Fail to Query sql(select task_id from shardmove.scaleout_for_shark where cluster_name = 'mypg_2' and status = 'inited'), err_desc =pq: relation "shardmove.scaleout_for_shark" does not exist

3 2025-07-30 11:09:43.807742 ERROR [330387] CheckAgentTaskFinish()->RestartNodeTask() center_backup.go:510 [traceId:0ppr5TQNR] Node: 10.206.0.5 :11000, retry too much: 5

4 2025-07-30 11:09:43.807774 ERROR [330387] QueryAgentFinish()->CheckAgentTaskFinish() center_backup.go:570 [traceId:0ppr5TQNR] Restart node: 1 0.206.0.5:11000 fail

5 2025-07-30 11:09:43.814256 ERROR [330387] call()->QueryAgentFinish() tbase_backup_flow.go:278 [traceId:0ppr5TQNR] One node backup fail, clust er: mypg_2

6 2025-07-30 11:10:43.530519 ERROR [330387] CheckAgentTaskFinish()->RestartNodeTask() center_backup.go:510 [traceId:0ppr5TQNR] Node: 10.206.0.5 :11000, retry too much: 6

7 2025-07-30 11:10:43.530545 ERROR [330387] QueryAgentFinish()->CheckAgentTaskFinish() center_backup.go:570 [traceId:0ppr5TQNR] Restart node: 1 0.206.0.5:11000 fail

8 2025-07-30 11:10:43.537382 ERROR [330387] call()->QueryAgentFinish() tbase_backup_flow.go:278 [traceId:0ppr5TQNR] One node backup fail, clust er: mypg_2

9 2025-07-30 11:11:43.353662 ERROR [330387] CheckAgentTaskFinish()->RestartNodeTask() center_backup.go:510 [traceId:0ppr5TQNR] Node: 10.206.0.5 :11000, retry too much: 7

10 2025-07-30 11:11:43.353697 ERROR [330387] QueryAgentFinish()->CheckAgentTaskFinish() center_backup.go:570 [traceId:0ppr5TQNR] Restart node: 1 0.206.0.5:11000 fail

11 2025-07-30 11:11:43.361929 ERROR [330387] call()->QueryAgentFinish() tbase_backup_flow.go:278 [traceId:0ppr5TQNR] One node backup fail, clust er: mypg_2

12 2025-07-30 11:11:43.361945 ERROR [330387] QueryAgentFinish()->HandleError() tbase_backup_flow.go:130 [traceId:0ppr5TQNR] Backup flow fail too much, step: QueryAgentFinish

13 2025-07-30 11:11:43.365247 ERROR [330642] goexit()->GetBackupProgress() agent_backup.go:494 [traceId:0ppr5TQNR] Scan error read |0: file alre ady closed

14 2025-07-30 11:11:43.365292 ERROR [330484] Start()->DoBackupData() agent_backup.go:462 [traceId:0ppr5TQNR] Execute shell fail: signal: killed, cmd: [set -o pipefail; export LD_LIBRARY_PATH=/data/tbase/user_1/tdata_01/mypg_2/5.06.4.7/install/tbase_pgxz/lib && /data/tbase/user_1/tdat a_01/mypg_2/5.06.4.7/install/tbase_pgxz/bin/pg_basebackup -P -D - -Ft -Xn -h 10.206.0.8 -p 11345 -U tbase |gzip - -f -c | /data/tbase/install /tbase_oss/bin/../script/pv --rate=50 | ( ssh -o StrictHostKeyChecking=no -p 22 tbase@10.206.0.8 'cat > /data/tbase/tbase_backup/mypg_2/base_ bkp_2025_07_30/cn001_10.206.0.8_11345/2025_07_30_11_04_43/base.tar.gz')],

15 2025-07-30 11:11:43.365325 ERROR [330484] func1()->Start() agent_backup.go:187 [traceId:0ppr5TQNR] Agent backup fail, key: mypg_2-cn001-10@@@ Normal ~/workdir/tdsql/oss.err utf-8[unix] 3.28KiB 1:1

block of 17 lines yanked

数据备份