Getting Error "cannot use immediate apply method for static parameter"

Question

While modifying parameter "lower_case_table_names = 1" of rds using boto, I am getting this error:

cannot use immediate apply method for static parameter

Answer 1

You are getting this error because the apply method is set to immediate and this parameter can only be changed on a reboot.

Change the apply method to pending-reboot.

See the documentation on modifying db parameters and the documentation for parameters for more information.