Default config contains deprecated directives
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
When installing percona-server 5.6 on Ubuntu (5.6.21-
2015-01-06 13:50:18 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-01-06 13:50:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
The default my.cnf file contains these deprecated directives, but I cloned the percona-server repo and searched for these strings but couldn't find them, so I'm not sure where this config is coming from.
I also noticed that if these are overridden in a separate config file (in /etc/mysql/conf.d), these warnings are still shown, suggesting it's the config parser and not mysql itself that's complaining.
Changed in percona-server: | |
status: | Incomplete → Confirmed |
tags: | added: pkg |
Unable to reproduce these warnings while install PS 5.6 on Ubuntu. so it doesn't seems that those files are coming with Percona packages. Can you please check all my.cnf files on your server with grep -r ? and see from where its taking old key_buffer_size variable settings?
Btw: is there any old version was installed on that server before you start installation of PS 5.6? it might be possible that old version is not completely purged so old my.cnf was there from where new installation was taking settings.
root@desktop: /var/lib# apt-get install Percona- Server- server- 5.6 verclient18. 1 percona- server- client- 5.6 percona- server- common- 5.6 verclient18. 1 percona- server- client- 5.6 percona- server- common- 5.6 percona- server- server- 5.6 server- common- 5.6. server- common- 5.6_5.6. 22-71.0- 726.utopic_ amd64.deb ... server- common- 5.6 (5.6.22- 71.0-726. utopic) ... rclient18. 1. erverclient18. 1_5.6.22- 71.0-726. utopic_ amd64.deb ... rclient18. 1 (5.6.22- 71.0-726. utopic) ... server- client- 5.6. server- client- 5.6_5.6. 22-71.0- 726.utopic_ amd64.deb ... server- client- 5.6 (5.6.22- 71.0-726. utopic) ... server- common- 5.6 (5.6.22- 71.0-726. utopic) ... server- server- 5.6. server- server- 5.6_5.6. 22-71.0- 726.utopic_ amd64.deb ... server- server- 5.6 (5.6.22- 71.0-726. utopic) ... rclient18. 1 (5.6.22- 71.0-726. utopic) ... server- client- 5.6 (5.6.22- 71.0-726. utopic) ... server- server- 5.6 (5.6.22- 71.0-726. utopic) ... defaults_ for_timestamp server option (see documentation for more details).
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libperconaser
Suggested packages:
tinyca
The following NEW packages will be installed:
libperconaser
0 upgraded, 4 newly installed, 0 to remove and 54 not upgraded.
Need to get 0 B/14.0 MB of archives.
After this operation, 137 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Preconfiguring packages ...
Selecting previously unselected package percona-
(Reading database ... 230464 files and directories currently installed.)
Preparing to unpack .../percona-
Unpacking percona-
Selecting previously unselected package libperconaserve
Preparing to unpack .../libperconas
Unpacking libperconaserve
Selecting previously unselected package percona-
Preparing to unpack .../percona-
Unpacking percona-
Processing triggers for man-db (2.7.0.2-2) ...
Setting up percona-
Selecting previously unselected package percona-
(Reading database ... 230520 files and directories currently installed.)
Preparing to unpack .../percona-
Unpacking percona-
Processing triggers for ureadahead (0.100.0-16) ...
Processing triggers for man-db (2.7.0.2-2) ...
Setting up libperconaserve
Setting up percona-
Setting up percona-
* Stopping MySQL (Percona Server) mysqld [ OK ]
2015-01-16 14:45:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2015-01-16 14:45:36 9576 [Note] Plugin 'FEDERATED' is disabled.
2015-01-16 14:45:36 9576 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-1...