【docker pxc】mysql启动报错：[ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable

一、    问题描述

Docker启动pxc节点，当pxc节点做了一次冷恢复，关闭pxc节点，重启pxc的node1节点，结果闪退。查看docker日志

[root@docker-node1 backup]# docker logs node1

…
2019-07-24T16:33:37.335343Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-24T16:33:37.335364Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-24T16:33:37.335383Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-07-24T16:33:38.470522Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-24T16:33:38.470544Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-24T16:33:38.470549Z 0 [ERROR] Failed to initialize builtin plugins.
2019-07-24T16:33:38.470554Z 0 [ERROR] Aborting

2019-07-24T16:33:38.470559Z 0 [Note] Giving 2 client threads a chance to die gracefully
2019-07-24T16:33:40.473777Z 0 [Note] WSREP: Closing send monitor...
2019-07-24T16:33:40.473795Z 0 [Note] WSREP: Closed send monitor.
2019-07-24T16:33:40.473818Z 0 [Note] WSREP: gcomm: terminating thread
2019-07-24T16:33:40.473828Z 0 [Note] WSREP: gcomm: joining thread
2019-07-24T16:33:40.473840Z 1 [Note] WSREP: rollbacker thread exiting
2019-07-24T16:33:40.473963Z 2 [Note] WSREP: Initialized wsrep sidno 1
2019-07-24T16:33:40.473971Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1)


…

二、    问题原因

'ibdata1'没有写权限，解决就是找到ibdata1这个文件，并且赋给写权限。

三、    解决办法

1.在pxc容器内部查看ibdata1位置

[root@d01d915424ab /]# find / -name ibdata1
/var/lib/mysql/ibdata1
/data/backup/full/2019-07-24_16-11-03/ibdata1

2.修改权限

[root@d01d915424ab /]# cd /var/lib/mysql
[root@d01d915424ab mysql]# ll
total 77860
drwxr-x---. 2 root root        6 Jul 24 16:41 2019-07-24_16-30-35
drwxr-x---. 2 root root        6 Jul 24 16:41 2019-07-24_16-41-15
-rw-r-----. 1 root root     1303 Jul 24 16:41 ib_buffer_pool
-rw-r-----. 1 root root 79691776 Jul 24 16:41 ibdata1
drwxr-x---. 2 root root     4096 Jul 24 16:41 mysql
drwxr-x---. 2 root root     8192 Jul 24 16:41 performance_schema
drwxr-x---. 2 root root     8192 Jul 24 16:41 sys
-rw-r-----. 1 root root      435 Jul 24 16:41 xtrabackup_info
[root@d01d915424ab mysql]# chmod -R 777 /var/lib/mysql

3.退出容器，重启pxc容器node1节点即可

docker stop node1
docker start node1

四、    参考

https://blog.csdn.net/saywhat_sayhello/article/details/81294687