Deploy DBSystem

[gitdavidgarcia]

Hi team, I’m trying to create a DbSystem using Pulumi (OCI provider @ 3.12.0) and I get a 400 CannotParseRequest error when launching LaunchDbSystem.

import pulumi
import pulumi_oci as oci
db_system = oci.database.DbSystem(
    "example-dbsystem",
    compartment_id="COMPARTMENT_OCID_REDACTED",
    availability_domain="AD-1",
    subnet_id="SUBNET_OCID_REDACTED",
    shape="VM.Standard.E5.Flex",
    hostname="example-host",
    ssh_public_keys=["ssh-rsa AAAA...david@host"],
    source="NONE",
    license_model="LICENSE_INCLUDED",
    database_edition="ENTERPRISE_EDITION",
    disk_redundancy="HIGH",
    data_storage_size_in_gb=256,
    db_home=oci.database.DbHomeArgs(
        display_name="example-home",
        db_version="19.29.0.0",
        database=oci.database.DbHomeDatabaseArgs(
            db_name="testdb",
            admin_password="REDACTED",
            db_unique_name="testdb",
            db_workload="OLTP"
        ),
    ),
)

Error:
400-CannotParseRequest: Incorrectly formatted request. Please refer to documentation.
Provider: oci@3.12.0
Internal Terraform provider: 7.27.0

However I was able to launch the same DB successfully using the OCI Python SDK directly.

import oci
database_client = oci.database.DatabaseClient(oci.config.from_file())
launch_details = oci.database.models.LaunchDbSystemDetails(
    availability_domain="AD-1",
    compartment_id="COMPARTMENT_OCID_REDACTED",
    cpu_core_count=2,
    database_edition="ENTERPRISE_EDITION",
    db_home=oci.database.models.CreateDbHomeDetails(
        db_version='19.29.0.0',
        display_name='py sdk example db home',
        database=oci.database.models.CreateDatabaseDetails(
            admin_password="REDACTED",
            db_name='testdb'
        )
    ),
    display_name='testdb',
    hostname='pysdk-example-db-host',
    shape='VM.Standard.E5.Flex',
    ssh_public_keys=["ssh-rsa AAAA..."],
    subnet_id="SUBNET_OCID_REDACTED"
)
response = database_client.launch_db_system(launch_details)
print(response.data)

Any advice on which Pulumi fields are missing or commonly malformed for LaunchDbSystem?
Thanks!

[pgavlin]

Unfortunately I'm not seeing any hits on the underlying TF provider that match your exact scenario. It does sound like the TF provider lacks decent input validation (see e.g. oracle/terraform-provider-oci#2338).

One thing that jumps out--and I am not an OCI expert, so forgive me if I'm missing something--but in the example you provided, the Python SDK call appears to be missing several properties that are present in the Pulumi code:

• license_model
• disk_redundancy
• data_storage_size_in_gb
• db_home.db_unique_name
• db_home.db_workload

Perhaps it's one of those parameters that's the issue?

[davidedisa]

Sorry for taking so long to respond. I have been testing, and I believe there is an issue with disk_redundancy, as I am able to deploy the database successfully when using the other parameters.

Thanks for your response.

[pgavlin]

Is the disk_redundancy issue limited to deploying via Pulumi? Or are there also issues with that parameter when using the OCI Python SDK directly?