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

drop表报cache lookup failed for type 7749349  


pangqian
帖子: 6
青梅新星
已加入: 2周 前

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

7 回复
pangqian
帖子: 6
青梅新星
已加入: 2周 前

只是drop类型的表报错,delete数据可以

回复
2 回复
阿福
Greenplum专家
已加入: 1月 前

青梅少侠
帖子: 26

@pangqian delete只删除数据,drop会删除catalog的信息,可以尝试一下执行修改表字段的操作看是否报错。

回复
pangqian
已加入: 2周 前

青梅新星
帖子: 6

@chris

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

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 11:41:20.781435 CST,"gpadmin","postgres",p18062,th915851392,"[local]",,2020-10-14 11:36:52 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

回复
阿福
帖子: 26
Greenplum专家
青梅少侠
已加入: 1月 前

麻烦增加一下数据库版本信息、报错日志截图(包含错误上下位置的一些日志),方便定位。

回复
2 回复
pangqian
已加入: 2周 前

青梅新星
帖子: 6

@chris

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

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 11:41:20.781435 CST,"gpadmin","postgres",p18062,th915851392,"[local]",,2020-10-14 11:36:52 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

回复
pangqian
已加入: 2周 前

青梅新星
帖子: 6

@chris greenplum6.4.0

回复
pangqian
帖子: 6
青梅新星
已加入: 2周 前

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

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 11:41:20.781435 CST,"gpadmin","postgres",p18062,th915851392,"[local]",,2020-10-14 11:36:52 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

回复

关注微信公众号

Greenplum中文社区

Greenplum官方微信群

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