[MDEV-6349] innodb_table_stats/innodb_index_stats broken after upgrade from 5.6 Created: 2014-06-16 Updated: 2023-03-09 Resolved: 2014-08-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.12 |
| Fix Version/s: | 10.0.13 |
| Type: | Bug | Priority: | Major |
| Reporter: | Andrew Garner | Assignee: | Sergei Golubchik |
| Resolution: | Duplicate | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
Similar to closed issue (
Internally this table (as created by MySQL 5.6.19 mysql_install_db) is using MYSQL_TYPE_TIMESTAMP2 (per inspection of the .frm). Changing this to MYSQL_TYPE_TIMESTAMP via the following queries and restarting the MariaDB 10.0.12 instance seems to resolve the error:
It would be nice if mysql_upgrade would fix these tables automatically. This is easy to verify on a fresh "empty" mysql 5.6 install and then upgrading that data directory to MariaDB 10.0.12. Tested on CentOS 6.5 using mariadb-10.0.12-linux-x86_64.tar.gz binary tarball distribution, upgrading a default mysql_install_db from a mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz binary tarball distribution. |
| Comments |
| Comment by Elena Stepanova [ 2014-06-17 ] |
|
bar, Is it related to what you're working on in scope of |
| Comment by Cédric PEINTRE [ 2014-06-19 ] |
|
Same problem for me when migrate from Percona 5.6.16 to MariaDB 10.0.12 |
| Comment by Sergei Golubchik [ 2014-08-05 ] |
|
duplicate of |