Can not create/deploy managed PostgreSQL database

Hi,

I am not able to create a managed PostgreSQL database. Tried it via the Web UI and via the API. I always get the following error:

deployment error postgresql database z8a645a4c : error => EngineError { tag: TerraformErrorWhileExecutingPipeline, event_details: EventDetails { provider_kind: None, organisation_id: QoveryIdentifier { raw_long_id: “zca61ed27”, short: “zca61ed2” }, cluster_id: QoveryIdentifier { raw_long_id: “2021fb95-2fa2-4861-8e89-a4ca7f7068cb”, short: “2021fb95” }, execution_id: QoveryIdentifier { raw_long_id: “467c2cac-cb77-4bd2-8c4e-95620ce47d89-1-1657214929”, short: “467c2cac” }, region: None, stage: Environment(Deploy), transmitter: Database(“z8a645a4c”, “Postgres RDS”, “z8a645a4c”) }, user_log_message: “Error while applying Terraform pipeline: init, plan & apply”, underlying_error: Some(CommandError { full_details: Some("Error while performing Terraform command.\ncommand: terraform apply -no-color -auto-approve tf_plan\nSTDOUT aws_db_instance.postgresql_instance: Creating… Error: Error creating DB Instance: InvalidParameterValue: Tag values may only contain unicode letters, digits, whitespace, or one of these symbols: _ . : / = + - @ \tstatus code: 400, request id: f4d3a116-e3ab-4d34-b43e-ee88ce7726bb, { AllocatedStorage: 10, AutoMinorVersionUpgrade: true, BackupRetentionPeriod: 14, CopyTagsToSnapshot: true, DBInstanceClass: "db.t3.micro", DBInstanceIdentifier: "z8a645a4c-postgresql", DBName: "postgresqlz8a645a4c", DBSubnetGroupName: "vpc-005d670bc4e59edba", DeletionProtection: false, EnablePerformanceInsights: true, Engine: "postgres", EngineVersion: "13.4", MasterUserPassword: "", MasterUsername: "qoveryadmin", MonitoringInterval: 10, MonitoringRoleArn: "arn:aws:iam::425214867721:role/qovery-rds-enhanced-monitoring-z2021fb95", MultiAZ: true, PerformanceInsightsRetentionPeriod: 7, Port: 5432, PreferredBackupWindow: "00:00-01:00", PreferredMaintenanceWindow: "Tue:02:00-Tue:04:00", PubliclyAccessible: false, StorageEncrypted: true, StorageType: "gp2", Tags: [ { Key: "q_environment_id", Value: "z467c2cac" }, { Key: "cluster_id", Value: "z2021fb95" }, { Key: "cluster_name", Value: "V2 Cluster - AWS (new)" }, { Key: "q_client_id", Value: "FAKE" }, { Key: "database_identifier", Value: "z8a645a4c-postgresql" }, { Key: "q_project_id", Value: "ze8c5ee86" }, { Key: "region", Value: "eu-central-1" }, { Key: "creationDate", Value: "2022-07-07T17:29:18Z" } ], VpcSecurityGroupIds: ["sg-0fd22eeb8718ea572"] } on main.tf line 42, in resource "aws_db_instance" "postgresql_instance": 42: resource "aws_db_instance" "postgresql_instance" { \nSTDERR Error: Error creating DB Instance: InvalidParameterValue: Tag values may only contain unicode letters, digits, whitespace, or one of these symbols: _ . : / = + - @ \tstatus code: 400, request id: f4d3a116-e3ab-4d34-b43e-ee88ce7726bb, { AllocatedStorage: 10, AutoMinorVersionUpgrade: true, BackupRetentionPeriod: 14, CopyTagsToSnapshot: true, DBInstanceClass: "db.t3.micro", DBInstanceIdentifier: "z8a645a4c-postgresql", DBName: "postgresqlz8a645a4c", DBSubnetGroupName: "vpc-005d670bc4e59edba", DeletionProtection: false, EnablePerformanceInsights: true, Engine: "postgres", EngineVersion: "13.4", MasterUserPassword: "", MasterUsername: "qoveryadmin", MonitoringInterval: 10, MonitoringRoleArn: "arn:aws:iam::425214867721:role/qovery-rds-enhanced-monitoring-z2021fb95", MultiAZ: true, PerformanceInsightsRetentionPeriod: 7, Port: 5432, PreferredBackupWindow: "00:00-01:00", PreferredMaintenanceWindow: "Tue:02:00-Tue:04:00", PubliclyAccessible: false, StorageEncrypted: true, StorageType: "gp2", Tags: [ { Key: "q_environment_id", Value: "z467c2cac" }, { Key: "cluster_id", Value: "z2021fb95" }, { Key: "cluster_name", Value: "V2 Cluster - AWS (new)" }, { Key: "q_client_id", Value: "FAKE" }, { Key: "database_identifier", Value: "z8a645a4c-postgresql" }, { Key: "q_project_id", Value: "ze8c5ee86" }, { Key: "region", Value: "eu-central-1" }, { Key: "creationDate", Value: "2022-07-07T17:29:18Z" } ], VpcSecurityGroupIds: ["sg-0fd22eeb8718ea572"] } on main.tf line 42, in resource "aws_db_instance" "postgresql_instance": 42: resource "aws_db_instance" "postgresql_instance" { "), message_safe: “Error while performing Terraform command.” }), link: None, hint_message: None }

This here looks like the reason:

InvalidParameterValue: Tag values may only contain unicode letters, digits, whitespace, or one of these symbols: _ . : / = + - @

But I do not know, if I caused this or this is a general problem?

Could this be somehow related to missing credentials?

BTW.: I am able to deploy a containerized database.

Thanks in advance for any help! :slight_smile:

Best,
Pierre

I had a look into AWS RDS, no database has been created there.

Unfortunately, I now have 3 failed managed databases in my Qovery account. I can not delete them. Neither can I delete the owning environment.

Best,
Pierre

Hi @pierre_at_valuecase - I forward to one of our engineers then it can take a look and help here.

Thanks @rophilogene ! I really appreciate your support :slight_smile:

Hello @pierre_at_valuecase ,
this error is triggered by the parentheses in your cluster name V2 Cluster - AWS (new). If you edit the cluster name in the cluster settings, it should resolve your issue.

Well … that’s embarrassing for me :man_facepalming:.

It works now. Thanks a lot :heart:

Best,
Pierre

1 Like