unable to use external database

[oliver-hofmann-cistec-com]

Description

when i use an external postgresql database (zalando operator) I get sql statement not found errors

Impact

unable to use

Environment and steps to reproduce

1. Set-up:

   database:
   host: "nebraska-db-pooler"
   port: 5432
   dbname: nebraska
   username: nebraska
   passwordExistingSecret:
     enabled: true
     name: nebraska.nebraska-db.credentials.postgresql.acid.zalan.do
     key: password
   postgresql:
   enabled: false

2. Task: when doing anything on the frontend, in the backend i get those bugs
3. Error:

   <nil> ERR processUpdate, getting channel to update error="ERROR: prepared statement \"lrupsc_2_1\" does not exist (SQLSTATE 26000)" arch=aarch64 channel=beta context=syncer                                                                                                                                                                  │
   │ <nil> INF addApp - successfully added app &{ID:fcab47a7-783d-49c7-9738-8d453688c79b ProductID:{NullString:{String:terst.cistec.io Valid:true}} Name:test Description:none CreatedTs:2023-11-22 08:12:16.283817 +0000 UTC TeamID:d89342dc-9214-441d-a4af-bdd837a3b239 Groups:[] Channels:[] Instances:{Count:0}} context=nebraska              │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get failed update metrics: ERROR: prepared statement \"lrupsc_2_32\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                                           │
   │ <nil> ERR getApps - getting apps error="ERROR: prepared statement \"lrupsc_3_26\" does not exist (SQLSTATE 26000)" context=nebraska teamID=d89342dc-9214-441d-a4af-bdd837a3b239                                                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_2_48\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_3_22\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_3_22\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_3_22\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_3_22\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_3_22\" does not exist (SQLSTATE 26000)" context=nebraska                                                                                                                               │
   │ <nil> ERR registerAndInstrumentMetrics updating the metrics error="failed to get app instances per channel metrics: ERROR: prepared statement \"lrupsc_2_48\" does not exist (SQLSTATE 26000)" context=nebraska  

[tormath1]

Hello sorry for the delay, this has been missed. This error looks like similar to: https://github.com/zalando/postgres-operator/issues/2516 - did you get it work in the meantime?