drop表报cache lookup ...
 
通知
清除全部

drop表报cache lookup failed for type 7749349 而在pg_type中查询有这个oid,求大神指点迷津!!


pangqian
帖子: 7
Topic starter
青梅新星
已加入: 3年 前

修改表字段可以,删除部分以前的表可以,后面新建的表不行。错误日志如下:

CST,0,con520644,cmd5,seg-1,,,,sx1,"LOG","00000","statement: drop table wdd.qqq;",,,,,,"drop table wdd.qqq;",0,,"postgres.c",1654,
2020-10-14 1120.781435 CST,"gpadmin","postgres",p18062,th915851392,"[local]",,2020-10-14 1152 CST,0,con520644,cmd5,seg-1,,,,sx1,"ERROR","XX000","cache lookup failed for type 6513590 (format_type.c:135)",,,,,,"drop table wdd.qqq;",0,,"format_type.c",135,"Stack trace:
1 0x9f371c postgres errstart (elog.c:558)
2 0x9f68c8 postgres elog_finish (elog.c:1730)
3 0x8d62b7 postgres format_type_be (format_type.c:135)
4 0x5b8918 postgres getObjectDescription (objectaddress.c:1610)
5 0x5975d4 postgres <symbol not found> (dependency.c:930)
6 0x59a70b postgres performMultipleDeletions (discriminator 4)
7 0x67f5b1 postgres RemoveRelations (tablecmds.c:1314)
8 0x891a38 postgres <symbol not found> (utility.c:1768)
9 0x8938f3 postgres <symbol not found> (utility.c:1681)
10 0x892745 postgres standard_ProcessUtility (utility.c:1043)
11 0x88f301 postgres <symbol not found> (palloc.h:158)
12 0x88fdfe postgres <symbol not found> (pquery.c:1512)
13 0x891517 postgres PortalRun (pquery.c:1022)
14 0x88bc30 postgres <symbol not found> (postgres.c:1842)
15 0x88e3be postgres PostgresMain (postgres.c:5257)
16 0x4cc3c8 postgres <symbol not found> (postmaster.c:4464)
17 0x815c16 postgres PostmasterMain (postmaster.c:1520)
18 0x4cec01 postgres main (main.c:205)
19 0x7f78322dd3d5 libc.so.6 __libc_start_main + 0xf5
20 0x4cf1dc postgres <symbol not found> + 0x4cf1dc

Close Bitnami banner
Bitnami