default deployment ends up with invalid value of query-cache-size
Bug #1296736 reported by
Pierre Amadio
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql (Juju Charms Collection) |
Fix Released
|
Undecided
|
Jorge Niedbalski |
Bug Description
Deploy mysql with default value.
From the charm config.yaml:
query-
default: -1
type: int
The resulting /etc/mysql/my.cnf contains:
query_cache_size = -1
According to http://
query_cache_size should be a positive integer ranging from 0 to 4294967295
The charm should not write a negative digit there.
Related branches
lp:~niedbalski/charms/precise/mysql/lp-1296736
- Charles Butler (community): Approve
-
Diff: 67 lines (+16/-9)2 files modifiedconfig.yaml (+1/-1)
hooks/config-changed (+15/-8)
Changed in mysql (Juju Charms Collection): | |
status: | New → In Progress |
assignee: | nobody → Jorge Niedbalski (niedbalski) |
tags: | added: charm |
Changed in mysql (Juju Charms Collection): | |
status: | In Progress → Fix Released |
To post a comment you must log in.
I proposed a merge request for the charm. If you pass a value <= 0 and your query_cache_type is specified as ( ON, DEMAND, ) then the query_cache_size will be calculated according to the dataset type otherwise the value '0' will be saved on the my.cnf configuration.
According to the official documentation ( http:// dev.mysql. com/doc/ refman/ 5.1/en/ server- system- variables. html#sysvar_ query_cache_ size ) the associated configuration value must be >= 0.
Tested on precise.