一.本案例适合什么场景?

升级集群42%报错,更新系统表cannot change return type of existing function

升级集群42%报错,更新系统表cannot change return type of existing functio

二.问题分析

1. 查看$GAUSSLOG/om/gs_upgradectl*.log日志,mpp16节点,更新系统表失败

升级集群42%报错,更新系统表cannot change return type of existing functio

2.登录报错的节点,查询该节点的$GAUSSLOG/om/gs_local*.log日志,create or replace function报错

升级集群42%报错,更新系统表cannot change return type of existing functio

三.如何解决

通过sf 查到函数的定义,重建函数

升级集群42%报错,更新系统表cannot change return type of existing functio