【标题描述】:
【测试类型:SQL功能】【测试版本:3.0.0】 gs_probackup恢复数据之后,gs_ctl build节点失败
【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):openEuler release 20.03 (LTS)
【测试环境】(单机/1主x备x级联备):1主1备
【被测功能】:行存表压缩
【测试类型】:功能测试
【数据库版本】(查询命令: gaussdb –V):gaussdb (openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:19 commit 0 last mr
【预置条件】:数据库正常运行
使用sysbench导入随机数据;
1.修改sysbench表结构:CREATE TABLE sbtest%d(
id %s,
k INTEGER DEFAULT '0' NOT NULL,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
%s (id)
) with(compresstype=2)
2.使用sysbench导入数据;
3.检查表文件,出现使用chunk等于分配chunk数量;且均为相应的chunk_size,分配chunk数量的最大值
【操作步骤】(请填写详细的操作步骤):
【预期输出】:成功拉起备机
【实际输出】:拉起失败
【原因分析】:
【日志信息】(请附上日志文件、截图、coredump信息):
[2022-05-20 11:34:56.815][2326409][][gs_ctl]: gs_ctl full build ,datadir is /data/xydb/cluster/dn_1
waiting for server to shut down.... done
server stopped
[2022-05-20 11:34:57.824][2326409][][gs_ctl]: current workdir is (/home/omm).
[2022-05-20 11:34:57.825][2326409][][gs_ctl]: fopen build pid file "/data/xydb/cluster/dn_1/gs_build.pid" success
[2022-05-20 11:34:57.825][2326409][][gs_ctl]: fprintf build pid file "/data/xydb/cluster/dn_1/gs_build.pid" success
[2022-05-20 11:34:57.825][2326409][][gs_ctl]: fsync build pid file "/data/xydb/cluster/dn_1/gs_build.pid" success
[2022-05-20 11:34:57.825][2326409][][gs_ctl]: set gaussdb state file when full build build:db state(BUILDING_STATE), server mode(STANDBY_MODE), build mode(FULL_BUILD).
[2022-05-20 11:34:57.829][2326409][dn_6001_6002][gs_ctl]: build try host(主DNIP) port(xxxx) success
[2022-05-20 11:34:57.829][2326409][dn_6001_6002][gs_ctl]: connect to server success, build started.
[2022-05-20 11:34:57.829][2326409][dn_6001_6002][gs_ctl]: create build tag file success
[2022-05-20 11:34:59.204][2326409][dn_6001_6002][gs_ctl]: clear old target dir success
[2022-05-20 11:34:59.204][2326409][dn_6001_6002][gs_ctl]: create build tag file again success
[2022-05-20 11:34:59.204][2326409][dn_6001_6002][gs_ctl]: get system identifier success
[2022-05-20 11:34:59.204][2326409][dn_6001_6002][gs_ctl]: receiving and unpacking files...
[2022-05-20 11:34:59.204][2326409][dn_6001_6002][gs_ctl]: create backup label success
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: xlog start point: 11/E1000178
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: begin build tablespace list
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: finish build tablespace list
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: begin get xlog by xlogstream
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: starting background WAL receiver
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: starting walreceiver
[2022-05-20 11:34:59.264][2326409][dn_6001_6002][gs_ctl]: begin receive tar files
[2022-05-20 11:34:59.265][2326409][dn_6001_6002][gs_ctl]: receiving and unpacking files...
[2022-05-20 11:34:59.268][2326409][dn_6001_6002][gs_ctl]: build try host(主DNIP) port(xxxx) success
[2022-05-20 11:34:59.269][2326409][dn_6001_6002][gs_ctl]: check identify system success
[2022-05-20 11:34:59.269][2326409][dn_6001_6002][gs_ctl]: send START_REPLICATION 11/E1000000 success
[2022-05-20 11:36:01.090][2326409][dn_6001_6002][gs_ctl]: finish receive tar files
[2022-05-20 11:36:01.090][2326409][dn_6001_6002][gs_ctl]: could not get WAL end position from server: FATAL: base backup cheksum or Decompressed blockno 3854 failed in file "./base/16388/18732_pcd", aborting backup. nchunks: 2, allocatedChunks: 2, segno: 0.
[2022-05-20 11:36:01.090][2326409][dn_6001_6002][gs_ctl]: full build failed(/data/xydb/cluster/dn_1).
【测试代码】:
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
登录 后才可以发表评论