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/CAPZMkv0X9_ezh-y5g_6jQwE%3D0%2BCcvUhfMY9xdfO4JPvYn0ygRg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to