Hello,
I have the following task that creates a rds parameter group in a aws
region. All the parameter values are valid. I can enter these manually in
aws console and they are accepted. However Ansible is complaining
about long_query_time: "0" and max_connect_errors:
"{DBInstanceClassMemory/11582880}". The errors I am getting are listed as
follows. Is this caused by a bug in Ansible for this task? Again if I enter
these values manually in aws console it accepts them.
---
- name:
rds_param_group:
state: present
name: chanaka-test-param-group
description: 'Chanaka test param group'
engine: 'mysql5.6'
region: "{{ item }}"
params:
innodb_flush_log_at_trx_commit: "0"
innodb_thread_concurrency: "0"
slow_query_log: "0"
net_write_timeout: "31536000"
innodb_log_file_size: "1000000000"
max_allowed_packet: "167772160"
net_read_timeout: "31536000"
innodb_io_capacity: "1000"
thread_cache_size: "1024"
general_log: "0"
join_buffer_size: "1048576"
collation_server: "utf8_general_ci"
innodb_log_buffer_size: "16777216"
sync_binlog: "0"
query_cache_type: "0"
character_set_server: "utf8"
log_output: "FILE"
long_query_time: "0"
max_connect_errors: "{DBInstanceClassMemory/11582880}"
with_items: RDSParameterGroupRegion
Error 1:
--------------------------------------------------------------
PLAY [Create RDS Parameter Group]
*********************************************
TASK: [rds_parameter_group | rds_param_group ]
********************************
failed: [localhost] => (item=eu-central-1) => {"failed": true, "item":
"eu-central-1", "parsed": false}
SUDO-SUCCESS-wxernmpkyzpylbzeigysbpcmrdtdtorc
Traceback (most recent call last):
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373259.05-27852258492091/rds_param_group",
line 2100, in <module>
main()
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373259.05-27852258492091/rds_param_group",
line 289, in main
changed_params, group_params = modify_group(next_group, group_params,
immediate)
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373259.05-27852258492091/rds_param_group",
line 213, in modify_group
set_parameter(param, new_value, immediate)
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373259.05-27852258492091/rds_param_group",
line 182, in set_parameter
param.value = converted_value
File "/usr/lib/python2.6/site-packages/boto/rds/parametergroup.py", line
169, in set_value
self._set_string_value(value)
File "/usr/lib/python2.6/site-packages/boto/rds/parametergroup.py", line
141, in _set_string_value
raise ValueError('value must be in %s' % self.allowed_values)
ValueError: value must be in 0-31536000
FATAL: all hosts have already failed -- aborting
PLAY RECAP
********************************************************************
to retry, use: --limit @/var/lib/awx/rds_parameter_group.retry
localhost : ok=0 changed=0 unreachable=0 failed=1
Error 2:
--------------------------------------------------------------
PLAY [Create RDS Parameter Group]
*********************************************
TASK: [rds_parameter_group | rds_param_group ]
********************************
failed: [localhost] => (item=eu-central-1) => {"failed": true, "item":
"eu-central-1", "parsed": false}
SUDO-SUCCESS-nqafhmawtcwtfeqpdvtmrganrinuumys
Traceback (most recent call last):
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373596.81-223734574677738/rds_param_group",
line 2100, in <module>
main()
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373596.81-223734574677738/rds_param_group",
line 289, in main
changed_params, group_params = modify_group(next_group, group_params,
immediate)
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373596.81-223734574677738/rds_param_group",
line 213, in modify_group
set_parameter(param, new_value, immediate)
File
"/var/lib/awx/.ansible/tmp/ansible-tmp-1433373596.81-223734574677738/rds_param_group",
line 182, in set_parameter
param.value = converted_value
File "/usr/lib/python2.6/site-packages/boto/rds/parametergroup.py", line
171, in set_value
self._set_integer_value(value)
File "/usr/lib/python2.6/site-packages/boto/rds/parametergroup.py", line
146, in _set_integer_value
value = int(value)
ValueError: invalid literal for int() with base 10:
'{DBInstanceClassMemory/11582880}'
FATAL: all hosts have already failed -- aborting
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/43448869-caec-4ca6-8dba-e00705b6a5c5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
