gpexpand 失败,但是不能回滚
 
通知
清除全部

gpexpand 失败,但是不能回滚  


city_blue
帖子: 1
初出茅庐
已加入: 1月 前

求教各位大侠

步骤:1进行gpexpand,但是过程中报错

20210129:21:41:10:011260 gpexpand:gp_master:gpadmin-[INFO]:-Unlocking catalog
20210129:21:41:10:011260 gpexpand:gp_master:gpadmin-[INFO]:-Unlocked catalog
20210129:21:41:11:011260 gpexpand:gp_master:gpadmin-[INFO]:-Creating expansion schema
20210129:21:41:11:011260 gpexpand:gp_master:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database template1
20210129:21:41:11:011260 gpexpand:gp_master:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database postgres
20210129:21:41:12:011260 gpexpand:gp_master:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database dm
20210129:21:41:12:011260 gpexpand:gp_master:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database gpperfmon
20210129:21:41:13:011260 gpexpand:gp_master:gpadmin-[ERROR]:-gpexpand failed: error 'ERROR: could not open file "base/32357/331070": No such file or directory (seg1 10.119.14.32:6000 pid=75209)
' in 'COPY (SELECT
current_database(),
quote_ident(n.nspname) || '.' || quote_ident(c.relname) as fq_name,
c.oid as tableoid,
NULL as root_partition_name,
2 as rank,
pe.writable is not null as external_writable,
'NOT STARTED' as undone_status,
NULL as expansion_started,
NULL as expansion_finished,
pg_relation_size(quote_ident(n.nspname) || '.' || quote_ident(c.relname)) as source_bytes
FROM
pg_class c
JOIN pg_namespace n ON (c.relnamespace=n.oid)
JOIN pg_catalog.gp_distribution_policy p on (c.oid = p.localoid)
LEFT JOIN pg_partition pp on (c.oid=pp.parrelid)
LEFT JOIN pg_partition_rule pr on (c.oid=pr.parchildrelid)
LEFT JOIN pg_exttable pe on (c.oid=pe.reloid and pe.writable)
WHERE
pp.parrelid is NULL
AND pr.parchildrelid is NULL
AND n.nspname != 'gpexpand'
AND n.nspname != 'pg_bitmapindex'
AND c.relpersistence != 't'
) TO '/home/gpadmin/status_detail.dat''

Exiting...
20210129:21:41:13:011260 gpexpand:gp_master:gpadmin-[ERROR]:-gpexpand is past the point of rollback. Any remaining issues must be addressed outside of gpexpand.
20210129:21:41:13:011260 gpexpand:gp_master:gpadmin-[INFO]:-Shutting down gpexpand...

 

2:进行回滚时,显示Catalog有更新,不能回滚

20210130:12:08:06:088705 gpexpand:gp_master:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.12.1 build commit:7ec4678f29dd922d7d44501f5fc344b5d0d4d49f Open Source'

20210130:12:08:06:088705 gpexpand:gp_master:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.12.1 build commit:7ec4678f29dd922d7d44501f5fc344b5d0d4d49f Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Nov 20 2020 18:43:31'

20210130:12:08:06:088705 gpexpand:gp_master:gpadmin-[ERROR]:-Catalog has been changed, the cluster can not rollback.

 

大家看看有何建议?

关注微信公众号

Greenplum中文社区

Greenplum官方微信群

扫码加入我们的技术讨论,请备注“网站”