oci_mysql_mysql_configuration add variables sql_generate_invisible_primary_key = "true", return error An argument named "sql_generate_invisible_primary_key" is not expected here.

[jansonkwo]

Terraform Configuration Files

resource "oci_mysql_mysql_configuration" "MDS_Custome_Configuration" { compartment_id = var.compartment_id description = "Test Env Configuration for the MySQL Instances" display_name = "Test Env MySQL Configuration" init_variables { lower_case_table_names = "CASE_INSENSITIVE_LOWERCASE" } parent_configuration_id = var.copy_configuration_id shape_name = var.mds_shape_name variables { sql_require_primary_key = "true" sql_generate_invisible_primary_key = "true" binlog_expire_logs_seconds = "3600" binlog_row_value_options = "PARTIAL_JSON" default_authentication_plugin = "mysql_native_password" group_replication_consistency = "BEFORE_ON_PRIMARY_FAILOVER" innodb_buffer_pool_instances = "4" innodb_buffer_pool_size = "18253611008" innodb_ft_result_cache_limit = "33554432" innodb_max_purge_lag_delay = "300000" local_infile = "true" mandatory_roles = "public" max_binlog_cache_size = "4294967296" max_connections = "3000" sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" time_zone = "UTC" max_connect_errors = "3000" } }

Debug Output

Error: Unsupported argument │ │ on mysql-config.tf line 13, in resource "oci_mysql_mysql_configuration" "MDS_Custome_Configuration": │ 13: sql_generate_invisible_primary_key = "true" │ │ An argument named "sql_generate_invisible_primary_key" is not expected here.

Steps to Reproduce

terraform validate

[tf-oci-pub]

Thank you for reporting the issue. We have raised an internal ticket to track this. Our service engineers will get back to you.

[jsled-at-oracle]

(for internal use, this is tracked as MY-24759)

[jsled-at-oracle]

Recommend setting this to "Pending Engineering"; internal process will update this bug when a fix is available.