openGauss/MogDB遇到报错：cached plan must not change result type

数据运维 2023-10-09 剑圣无痕 手机阅读

原作者：何放

客户跑业务时遇到报错，查看日志是关于数据库的报错，报错如下

org.postgresql.util.PSQLException: ERROR: cached plan must not change result type at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2794) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2533) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:314) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:453) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:377) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:146) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:109)