Greenplum GPSS Extension Version Mismatch Error after Upgrade
Article ID: 406642
Updated On:
Products
Issue/Introduction
The Greenplum Streaming Server (GPSS) is hosted on a separate server from the Greenplum database. After upgrading the GPSS ETL package from version 1.11.0 to 2.0.0, attempts to start new jobs fail with the following error:
[ERROR] start job: ratings failed, reason: File job failed to prepare: Formatter check failed: gpss version '2.0.0' doesn't match formatter version '1.10.4'. Consider to run 'drop extension gpss;' to reload the extension.
Dropping the extension with a superuser account did not resolve the error.
Environment
All supported versions of Greenplum and Greenplum Streaming Server (GPSS)
The Greenplum Streaming Server (GPSS) is hosted on a separate server from the Greenplum database
Cause
This error is caused by a version mismatch between the GPSS extension installed in the Greenplum database and the upgraded GPSS server (ETL package). Specifically:
- The GPSS formatter extension in the database remains at version 1.10.4.
- The GPSS server binaries have been upgraded to version 2.0.0.
Upgrading the ETL package updates the GPSS server binaries but does not automatically update the database extension files on the Greenplum host. Simply dropping the extension removes the database object, but if the underlying extension files are still from the older version, recreating the extension will load the old version again. This mismatch causes the formatter check to fail and prevents job startup.
Resolution
To fix the issue, follow these steps:
- Install GPSS Extension 2.0.0 on the Greenplum Host
Make sure the GPSS extension files for version 2.0.0 are properly installed on the Greenplum database server. - Verify Installed Extension Version
Connect to the Greenplum database and check the current GPSS formatter version by running:
SELECT gpfmt_version();
- Drop and Recreate the Extension to load the updated extension files for version 2.0.0. Connect as a superuser and execute:
DROP EXTENSION gpss;
CREATE EXTENSION gpss;
4. Restart Services (if necessary)
Sometimes a restart of the GPSS server and/or the Greenplum database server is needed to clear caches and fully apply the new extension version.
Additional Information
Feedback
