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

3. Task: when doing anything on the frontend, in the backend i get those bugs
4. 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: zalando/postgres-operator#2516 - did you get it work in the meantime?