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 <benno...@gmail.com> wrote:
> can you please update to latest version of both and see if that helps.
>
> On Thu, Jun 4, 2015 at 10:31 PM, Chanaka Samarajeewa <chan...@jostle.me>
> wrote:
>
>> Hello Benno,
>>
>> We are using Boto version 2.34.0 and Ansible version 1.8.4.
>>
>> Thanks
>>
>> On Wed, Jun 3, 2015 at 8:28 PM, benno joy <benno...@gmail.com> wrote:
>>
>>> 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 <chan...@jostle.me>
>>> 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 ansible-project+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to ansible-project@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
>>>> <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 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-project+unsubscr...@googlegroups.com.
>>> To post to this group, send email to ansible-project@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
>>> <https://groups.google.com/d/msgid/ansible-project/CAFUV_d42SS-mvA32A5T7Dboy%3Dw%3DF6wazqGEwtRdaiE035byj2g%40mail.gmail.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 ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/CAPZMkv3tgtsjOvHKtNYFa-6LxUqC3PvvT%3DoLAn218ShSnGiLUQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
