Cached plan must not change result type

Problem

After the upgrade of a Bitbucket Server plug-in, you sometimes get the following error when using PostgreSQL:

"cached plan must not change result type"

This problem can happen under PostgreSQL when the plug-in gets upgraded to a new version which adds a column to an existing database table to provide new functionality. While this should be a transparent action, sometimes caching issues like this can occur under PostgreSQL. You can read more about this problem here: https://ecosystem.atlassian.net/browse/AO-697

Solution

Restart your Bitbucket Server instance and the problem should not occur anymore.

Related articles

https://ecosystem.atlassian.net/browse/AO-697

• Page:
  java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty
• Page:
  App ignores proxy setting
• Page:
  App’s settings page gives status 500 directly after installing when using MySQL/MariaDB
• Page:
  Unable to start the plugin container / OSGi cache corruption in Bitbucket
• Page:
  Jupyter Viewer for Confluence Cloud: page-attached notebooks do not render; Atlassian authorization error