Previewing update (dev)

View Live: <https://app.pulumi.com/sch_johwar2/redata-aws-fargate/dev/previews/805ae9ef-3aae-402e-aa38-0e3902c9cb26>

     Type                                         Name                      Plan        Info
     pulumi:pulumi:Stack                          redata-aws-fargate-dev                
 +-  ├─ aws:ecs:TaskDefinition                    airflow-web-task          replace     
 +-  ├─ aws:ecs:TaskDefinition                    airflow-scheduler-task    replace     
 +-  ├─ aws:ecs:TaskDefinition                    grafana-web-task          replace     
 +-  ├─ aws:servicediscovery:PrivateDnsNamespace  redata-sd-namespace       replace     [diff: ~name]
 ~   ├─ aws:efs:FileSystemPolicy                  redata-efs-policy         update      [diff: ~policy]
     ├─ redata:service:BackendService             airflow-scheduler                     
 +-  │  ├─ aws:ecs:Service                        airflow-scheduler-svc     replace     [diff: ~name,serviceRegistries,taskDefinition]
 +-  │  └─ aws:servicediscovery:Service           airflow-scheduler-sd-svc  replace     [diff: ~dnsConfig]
     ├─ redata:service:WebService                 airflow-web                           
     │  └─ redata:service:BackendService          airflow-web                           
 +-  │     ├─ aws:ecs:Service                     airflow-web-svc           replace     [diff: ~name,serviceRegistries,taskDefinition]
 +-  │     └─ aws:servicediscovery:Service        airflow-web-sd-svc        replace     [diff: ~dnsConfig]
     ├─ redata:service:WebService                 grafana-web                           
     │  └─ redata:service:BackendService          grafana-web                           
 +-  │     ├─ aws:ecs:Service                     grafana-web-svc           replace     [diff: ~name,serviceRegistries,taskDefinition]
 +-  │     └─ aws:servicediscovery:Service        grafana-web-sd-svc        replace     [diff: ~dnsConfig]
 +   ├─ aws:route53:Record                        airflow-postgres-cname    create      
 +   └─ aws:route53:Record                        redata-postgres-cname     create      
 
Resources:
    + 2 to create
    ~ 1 to update
    +-10 to replace
    13 changes. 33 unchanged

Do you want to perform this update? yes
Updating (dev)

View Live: <https://app.pulumi.com/sch_johwar2/redata-aws-fargate/dev/updates/119>

     Type                                         Name                    Status                   Info
     pulumi:pulumi:Stack                          redata-aws-fargate-dev  **failed**               1 error
 +-  ├─ aws:ecs:TaskDefinition                    airflow-web-task        replaced                 
 ~   ├─ aws:efs:FileSystemPolicy                  redata-efs-policy       updated                  [diff: ~policy]
 +-  ├─ aws:ecs:TaskDefinition                    airflow-scheduler-task  replaced                 
 +-  ├─ aws:ecs:TaskDefinition                    grafana-web-task        replaced                 
 +-  └─ aws:servicediscovery:PrivateDnsNamespace  redata-sd-namespace     **replacing failed**     1 error
 
Diagnostics:
  pulumi:pulumi:Stack (redata-aws-fargate-dev):
    error: update failed
 
  aws:servicediscovery:PrivateDnsNamespace (redata-sd-namespace):
    error: deleting urn:pulumi:dev::redata-aws-fargate::aws:servicediscovery/privateDnsNamespace:PrivateDnsNamespace::redata-sd-namespace: 1 error occurred:
    	* error deleting Service Discovery Private DNS Namespace (ns-o4ilckypsuym75iu): ResourceInUse: Namespace has associated services; delete the services before deleting the namespace
 
Outputs:
    airflow-db         : "<http://airflow-postgresacfea51.co25doitymly.eu-west-1.rds.amazonaws.com:5432|airflow-postgresacfea51.co25doitymly.eu-west-1.rds.amazonaws.com:5432>"
    airflow-web-web-url: "<https://redata.blocket-insight-dev.schibsted.io/airflow>"
    grafana-web-web-url: "<https://redata.blocket-insight-dev.schibsted.io/grafana>"
    redata-db          : "<http://redata-postgres36ddbfa.co25doitymly.eu-west-1.rds.amazonaws.com:5432|redata-postgres36ddbfa.co25doitymly.eu-west-1.rds.amazonaws.com:5432>"

Resources:
    ~ 1 updated
    33 unchanged

Duration: 11s

diff --git a/deployment/pulumi_aws_fargate/__main__.py b/deployment/pulumi_aws_fargate/__main__.py
index 01fa5a3..a2ed3e4 100644
--- a/deployment/pulumi_aws_fargate/__main__.py
+++ b/deployment/pulumi_aws_fargate/__main__.py
@@ -127,6 +127,7 @@ efs = redata.fs.FileSystem("redata-efs",
 
 # Service Discovery for intra-cluster communication
 sd_namespace = aws.servicediscovery.PrivateDnsNamespace("redata-sd-namespace",
+    name="redata.local",
     description="Private namespace for Redata services",
     vpc=redata_vpc.id,
 )
@@ -194,6 +195,13 @@ for backend in ("airflow", "redata"):
         username=backend,
         vpc_security_group_ids=[db_secgrp.id]
     )
+    db_cname = aws.route53.Record(f"{backend}-postgres-cname",
+        name=f"{backend}-postgres",
+        zone_id=sd_namespace.hosted_zone,
+        type='CNAME',
+        ttl=60,
+        records=[db.address],
+    )
     databases[backend] = db
     export(f"{backend}-db", db.endpoint)