Unable to Modify Database Parameter in AWS Lightsail

Question

Hello,
I am encountering an issue while attempting to modify a parameter for my AWS Lightsail relational database instance. Despite the parameter being marked as modifiable, I receive an error indicating that it cannot be modified because it is part of a default parameter group.

**Parameter to Modify:** idle_in_transaction_session_timeout

**Error Message:** An error occurred (InvalidInputException) when calling the UpdateRelationalDatabaseParameters operation: Cannot modify a default parameter group.

when I run `aws lightsail get-relational-database-parameters --relational-database-name myDB` I get back a list of parameters including:

```
...
        {
            "allowedValues": "0-2147483647",
            "applyMethod": "pending-reboot",
            "applyType": "dynamic",
            "dataType": "integer",
            "description": "(ms) Sets the maximum allowed duration of any idling transaction.",
            "isModifiable": true,
            "parameterName": "idle_in_transaction_session_timeout",
            "parameterValue": "86400000"
        },
...
```
When I attempt to update the value:
`aws lightsail update-relational-database-parameters --relational-database-name myDB --parameters "parameterName=idle_in_transaction_session_timeout,parameterValue=300,applyMethod=pending-reboot"`

I get:

***An error occurred (InvalidInputException) when calling the UpdateRelationalDatabaseParameters operation: Cannot modify a default parameter group.***

Any help would greatly be appreciated.

Thanks

Riku_Kobayashi · Accepted Answer

Hello.

Based on this documentation, it seems that Lightsail managed databases are configured with a custom parameter group when they are created.  
https://repost.aws/knowledge-center/lightsail-update-database-parameter  
> When you create a Lightsail database, that database uses a custom parameter group named after the instance endpoint. Amazon Relational Database Service (Amazon RDS) DB instances use a default DB parameter group. To modify the database parameters for a Lightsail database instance, use the AWS Command Line Interface (AWS CLI).

There is a possibility that this is a bug, so we recommend that you open a case with AWS Support under "Account and billing".  
Inquiries under "Account and billing" can be made free of charge.  
https://docs.aws.amazon.com/awssupport/latest/user/case-management.html

Unable to Modify Database Parameter in AWS Lightsail

Add your answer

Relevant content