rds_param_group task not accepting correct values

[Chanaka Samarajeewa]

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

[benno joy]

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

--
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 ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.
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.

[Chanaka Samarajeewa]

Hello Benno,

We are using Boto version 2.34.0 and Ansible version 1.8.4.

Thanks

--
You received this message because you are subscribed to a topic in the Google Groups "Ansible Project" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ansible-project/iN7cFi2aw98/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ansible-proje...@googlegroups.com.

To post to this group, send email to ansible...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAFUV_d42SS-mvA32A5T7Dboy%3Dw%3DF6wazqGEwtRdaiE035byj2g%40mail.gmail.com.

[benno joy]

can you please update to latest version of both and see if that helps.

[Chanaka Samarajeewa]

Thanks for the advice.

[Chanaka Samarajeewa]

Hello Benno,

Upgrading to the latest version of Boto and Ansible didn't solve this problem. I am still getting the same error messages. Seems like a bug in the api?

Thanks

Chanaka

On Thu, Jun 4, 2015 at 10:10 AM, benno joy <benn...@gmail.com> wrote: