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 <[email protected]> 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 <[email protected]>
> 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 <[email protected]> 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 <[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 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
>>> [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
>>> <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 [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/CAPZMkv3tgtsjOvHKtNYFa-6LxUqC3PvvT%3DoLAn218ShSnGiLUQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to