search

gitava / Big-Data-Study

For studying big data
2 stars 0 forks source link

mysql - [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID: #7

Closed gitava closed 4 years ago

gitava commented 4 years ago 
020-06-27T13:21:22.750576Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-06-27T13:21:22.750647Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-06-27T13:21:22.750805Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-27T13:21:22.750914Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-27T13:21:22.751606Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20)  MySQL Community Server - GPL.
2020-06-27T13:21:51.216105Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 5093
2020-06-27T13:21:51.224011Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-06-27T13:21:51.236300Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2020-06-27T13:21:51.236409Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4294967278 = ['mysqlX/undo_002', 'undo_002']

2020-06-27T13:21:51.236480Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4294967279 = ['mysqlX/undo_001', 'undo_001']

2020-06-27T13:21:51.236545Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4294967294 = ['mysql.ibd', 'mysqlX/mysql.ibd']

2020-06-27T13:21:51.236633Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-06-27T13:21:51.236732Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-06-27T13:21:51.237006Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-27T13:21:51.237138Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-27T13:21:51.237992Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0
gitava commented 4 years ago

...after reinstallation of the mysql, error just disappeared.

[root@hdp-node-02 vagrant]# sudo yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
base                                                                                                                         | 3.6 kB  00:00:00
extras                                                                                                                       | 2.9 kB  00:00:00
mysql-connectors-community                                                                                                   | 2.5 kB  00:00:00
mysql-tools-community                                                                                                        | 2.5 kB  00:00:00
mysql80-community                                                                                                            | 2.5 kB  00:00:00
updates                                                                                                                      | 2.9 kB  00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.20-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================
 Package                                    Arch                       Version                          Repository                             Size
====================================================================================================================================================
Installing:
 mysql-community-server                     x86_64                     8.0.20-1.el7                     mysql80-community                     488 M

Transaction Summary
====================================================================================================================================================
Install  1 Package

Total download size: 488 M
Installed size: 2.2 G
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for mysql80-community
mysql-community-server-8.0.20-1.el7.x86_64.rpm                                                                               | 488 MB  00:03:23
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-server-8.0.20-1.el7.x86_64                                                                                       1/1
  Verifying  : mysql-community-server-8.0.20-1.el7.x86_64                                                                                       1/1

Installed:
  mysql-community-server.x86_64 0:8.0.20-1.el7

Complete!
[root@hdp-node-02 vagrant]# exit
logout
[vagrant@hdp-node-02 /]$ sudo service mysqld start
Redirecting to /bin/systemctl start mysqld.service