Error: cannot diff a database connection with a schema "name_schema"

[sarahdipiero-igenius]

Hi,
I am making Atlas operator in Terraform:

resource "helm_release" "atlasgo-operator" {
  name             = "atlasgo-operator"
  repository       = "oci://ghcr.io/ariga/charts"
  chart            = "atlas-operator"
  namespace        = "atlas-operator"
  create_namespace = true
}

and I create a schema (all the variables are double checked):

apiVersion: db.atlasgo.io/v1alpha1
kind: AtlasSchema
metadata:
  name: atlasgoapp
  namespace: atlas-operator
spec:
  credentials:
    scheme: postgres
    host: ${db_host}
    user: ${db_username}
    password: ${db_password}
    database: ${database_name}
    port: 5432
    parameters:
      search_path: ${schema_name}
      sslmode: disable
  schema:
    sql: |
      CREATE TABLE clienti (
        id INT PRIMARY KEY,
        first_name VARCHAR(255) NOT NULL,
        last_name VARCHAR(255) NOT NULL
      );
  policy:
    diff: 
      skip:
        drop_column: true
        drop_table: true
        drop_schema: true   
    lint:
      destructive:
        error: false

but when I terraform plan then apply I have the following errors:

 2024-03-04T11:12:48Z    DEBUG    events    Error: cannot diff a database connection with a schema "name_schema". See: https://atlasgo.io/url    {"type": "Warning", "object": {"kind":"AtlasSchema","namespace":"atlas-operator │
│ ","name":"atlasgoapp","uid":"c048bae6-be1f-4264-bb14-588c09985bcf","apiVersion":"db.atlasgo.io/v1alpha1","resourceVersion":"35175894"}, "reason": "VerifyingFirstRun"}                                                             │
│ 2024-03-04T11:13:20Z    DEBUG    events    Error: cannot diff a database connection with a schema "name_schema". See: https://atlasgo.io/url    {"type": "Warning", "object": {"kind":"AtlasSchema","namespace":"atlas-operator │
│ ","name":"atlasgoapp","uid":"c048bae6-be1f-4264-bb14-588c09985bcf","apiVersion":"db.atlasgo.io/v1alpha1","resourceVersion":"35175894"}, "reason": "TransientErr"}

The database sslmode is prefer but atlas does not support prefer mode (just disable, require, verify-ca and verify-full). I don't know if this could be the cause of this problem. However I tried disable and require and they don't work.

[giautm]

Hello @sarahdipiero-igenius, can you please share the version of the atlas-operator you're running?

sslmode=prefer is the default value, so you don't need to define it in the connection's parameters - my wild guess. Please, if you can share the screenshot of AtlasSchema when you inspect it from k8s, it will be helpful, please hide any sensitive information like IP/password.

[sarahdipiero-igenius]

I think you mean this

[giautm]

Error: cannot diff a database connection with a schema "name_schema"

I guess this error happened because the dev-db was mismatched config. Can you please share the URL of dev-db? It should include the search_path=name_schema.

[sarahdipiero-igenius]

Adding search_path in the url it is now working thanks

[giautm]

Happy to hear it, closing the issue now. But please join our community for further questions if you have.