configuration value gets truncated when over 128 char
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
In Progress
|
Low
|
ccyu |
Bug Description
currently, configuration_value column size is 128 char.
so configuration values over 128 char gets truncated.
Note that, MySQL 5.7.8 later default sql-mode takes over 128 char value like below.
ONLY_FULL_
https:/
-bash-4.2$ trove configuration-
+------
| Property | Value |
+------
| created | 2017-03-10T05:35:31 |
| datastore_name | pxc |
| datastore_
| datastore_
| description | None |
| id | 5c59bf82-
| instance_count | 0 |
| name | limit_128_test |
| updated | 2017-03-10T05:35:31 |
| values | {u'sql_mode': u'"ONLY_
+------
-bash-4.2$ trove configuration-show 5c59bf82-
+------
| Property | Value |
+------
| created | 2017-03-10T05:35:31 |
| datastore_name | pxc |
| datastore_
| description | None |
| id | 5c59bf82-
| instance_count | 0 |
| name | limit_128_test |
| updated | 2017-03-10T05:35:31 |
| values | {"sql_mode": "\"ONLY_
+------
Changed in trove: | |
assignee: | nobody → ccyu (indicoliteplus) |
status: | New → Confirmed |
Changed in trove: | |
importance: | Undecided → Low |
review at: https:/ /review. openstack. org/#/c/ 445768/
>>> sql_mode= "ALLOW_ INVALID_ DATES,ANSI_ QUOTES, ERROR_FOR_ DIVISION_ BY_ZERO, HIGH_NOT_ PRECEDENCE, IGNORE_ SPACE,NO_ AUTO_CREATE_ USER,NO_ AUTO_VALUE_ ON_ZERO, NO_BACKSLASH_ ESCAPES, NO_DIR_ IN_CREATE, NO_ENGINE_ SUBSTITUTION, NO_FIELD_ OPTIONS, NO_KEY_ OPTIONS, NO_TABLE_ OPTIONS, NO_UNSIGNED_ SUBTRACTION, NO_ZERO_ DATE,NO_ ZERO_IN_ DATE,ONLY_ FULL_GROUP_ BY,PAD_ CHAR_TO_ FULL_LENGTH, PIPES_AS_ CONCAT, REAL_AS_ FLOAT,STRICT_ ALL_TABLES, STRICT_ TRANS_TABLES"
>>> len(sql_mode)
407
So I changed the Table configuration column value:
from String(128) to String(512).