原 GreenPlum查询报错could not open file "base/231962/24824104": No such file or directory (seg44 slice2 192.168.163.54:6014 pid=1499766)
Tags： 原创故障处理GreenPlum报错No such file or directorycould not open file
👉 本文共约492个字，系统预计阅读时间或需2分钟。
现象
GreenPlum查询数据库某个表，频繁报错：
1 2 3 4 | could not open file "base/231962/24824104": No such file or directory (seg44 slice2 192.168.163.54:6014 pid=1499766) could not open file "base/231962/24824106": No such file or directory (seg43 192.168.163.54:6013 pid=1493896) |
将这个表从备份中恢复回来后，还是报错。
分析
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | SELECT relname FROM pg_class WHERE relfilenode = '24824106'; select count(*) from tb1; ERROR: could not open file "base/231962/24824104": No such file or directory (seg44 slice1 192.168.163.54:6014 pid=3836448) CONTEXT: writing block 0 of relation base/231962/24824104 SELECT * from gp_segment_configuration d where d.content in (43,44); SELECT d.logtime, d.loguser, d.logdatabase, d.loghost, d.logsessiontime, d.logstate, d.logseverity, d.logmessage, d.logdebug, d.logdetail, logcontext from gpmetrics.gpcc_pg_log_history d where d.logseverity not in ( 'LOG' ) -- and d.logstate not in ( '42P01','01000' ) -- and d.logtime >= now()-interval '7 day' -- and d.logstate not in ('42703','57014') -- and d.logstate in ('58P01') and d.logdatabase not in ('gpperfmon') and d.logtime >= '2024-10-30 00:00' and d.logtime <= '2024-10-30 04:18' -- and d.logmessage like '%No such file or directory%' order by d.logtime desc limit 500; |
解决
从mirror实例上拷贝回去。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
