Hi, Seems like a boto issue, can you please let us know which version of boto you are using and the ansible version, if not on the latest boto version then can you try updating to the latest and see if that helps.
- Benno On Thu, Jun 4, 2015 at 4:57 AM, Chanaka Samarajeewa <[email protected]> wrote: > > 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 > <https://groups.google.com/d/msgid/ansible-project/43448869-caec-4ca6-8dba-e00705b6a5c5%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CAFUV_d42SS-mvA32A5T7Dboy%3Dw%3DF6wazqGEwtRdaiE035byj2g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
