MariaDB：升级（5.5.6 –> 10.4.1） on CentOS 7
首先，看看当前数据库的信息。
[root@oracleme ~]# service mariadb status Redirecting to /bin/systemctl status mariadb.service ● mariadb.service - MariaDB databas[......]
MariaDB类别订阅
MariaDB Galera – error：Job for mariadb.service failed because the control process exited with error code.
报错如题所示，具体如下：
[root@mariadb-cluster-3 ~]# service mysql start Starting mysql (via systemctl): Job for mariadb.service failed because the control p[......]
- 发表于：
-
作者：
Adamhuan
- 分类： MariaDB
- 标签： [ERROR] InnoDB: Header page consists of zero bytes in datafile: ./ibdata1, Flags: 0., Job for mariadb.service failed because the control process exited with error code., MariaDB, MySQL, Space ID:0
- 发表评论: MariaDB Galera – error：Job for mariadb.service failed because the control process exited with error code.
Galera error – WSREP: Failed to start mysqld for wsrep recovery: ‘2017-12-22 1:19:58 140304668907648 [Note] /usr/sbin/mysqld (mysqld 10.2.11-MariaDB) starting as process 3777 …
具体日志如下：
Dec 22 01:19:49 mariadb-cluster-3 systemd: Starting MariaDB database server... Dec 22 01:20:01 mariadb-cluster-3 sh: WSREP: Failed to star[......]
- 发表于：
-
作者：
Adamhuan
- 分类： MariaDB, MySQL
- 标签： [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable, MariaDB, MySQL, WSREP: Failed to start mysqld for wsrep recovery: '2017-12-22 1:19:58 140304668907648 [Note] /usr/sbin/mysqld (mysqld 10.2.11-MariaDB) starting as process 3777 ...
- 发表评论: Galera error – WSREP: Failed to start mysqld for wsrep recovery: ‘2017-12-22 1:19:58 140304668907648 [Note] /usr/sbin/mysqld (mysqld 10.2.11-MariaDB) starting as process 3777 …
MariaDB Galera – error：Job for mariadb.service failed because a timeout was exceeded.
在集群节点服务器上以集群的方式启动数据库可能出现如题所示的错误，具体如下：
[root@mariadb-cluster-2 ~]# service mysql start Starting mysql (via systemctl): Job for mariadb.service f[......]
- 发表于：
-
作者：
Adamhuan
- 分类： MariaDB, MySQL
- 标签： [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -98 (Address already in use), [ERROR] WSREP: gcs/src/gcs_gcomm.cpp:gcomm_open():791: failed to open gcomm backend connection: 98: error while trying to listen 'tcp://0.0.0.0:4567?socket.non_blocking=1', asio error 'bind: Address already in use': 98 (Address already in use), error, galera, Job for mariadb.service failed because a timeout was exceeded., MariaDB
MariaDB Galera – error：[ERROR] WSREP: Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable.
如题所示的错误，发生在，在集群节点服务器上以集群的方式启动数据库，具体如下：
[root@mariadb-cluster-2 ~]# service mysql start Starting mysql (via systemctl): Job for mariadb.service fa[......]
- 发表于：
-
作者：
Adamhuan
- 分类： MariaDB, MySQL
- 标签： [ERROR] WSREP: Failed to prepare for 'xtrabackup-v2' SST. Unrecoverable., [ERROR] WSREP: Failed to read 'ready ' from: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.158.1.174' --datadir '/var/lib/mysql/' --parent '5001' '', Cluster, MariaDB, MySQL, mysqld: Read: '(null)', mysqld: which: no socat in (/usr/sbin:/sbin:/usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin), mysqld: WSREP_SST: [ERROR] socat not found in path: /usr/sbin:/sbin:/usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin (20171221 19:57:47.908)
- 发表评论: MariaDB Galera – error：[ERROR] WSREP: Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable.