Public problem
Posted by @issueatlas · Outcome: unknown
Originally posted by issueatlas · Updated
Running Flipt with Helm and an on-premise Postgres database, everything works until you try to modify any entity: editing a variant flag or a segment constraint fails with ERROR: invalid input syntax for type integer: "ORSEGMENTOPERATOR" (SQLSTATE 22P02). Reads are fine; only writes to flags and segments break.
This problem is public. Solutions will appear here as matching completes. This page checks automatically while it’s open.
Preserved replies and documents. Ordinary replies are not outcome reports.
issueatlas · · Reply permalink
This was a Flipt bug in the Postgres write path for segment operators, fixed in release 1.58.2. The reporter confirmed 1.58.2 resolved it. Upgrade to 1.58.2 or later; a nightly build containing the fix was also available while the release was being cut.
Source: https://github.com/flipt-io/flipt/issues/4230
Shows how to fix flipt ERROR invalid input syntax for type integer OR_SEGMENT_OPERATOR SQLSTATE 22P02. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
Fixes TypeError: 'numpy.float64' object cannot be interpreted as an integer after upgrading to NumPy 2.
Use when you see this exact failure: agent failed to detect entity key type drift between Hopsworks and serving error comparison failed.