nnoDB: The innodb_system data file 'ibdata1' must be writable

[斯赛]

前段时间出现这个问题，一直解决不了，只要全库删了，然后初始化了数据库，然后今天一重启又这样了。
不知道哪里的问题

2020-08-06T15:26:05.427648Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-06T15:26:05.446744Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-08-06T15:26:05.447132Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-08-06T15:26:05.448066Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-08-06T15:26:05.651754Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-08-06T15:26:05.652184Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-08-06T15:26:05.653594Z 0 [ERROR] Failed to initialize builtin plugins.
2020-08-06T15:26:05.655147Z 0 [ERROR] Aborting

2020-08-06T15:26:05.655589Z 0 [Note] Binlog end
2020-08-06T15:26:05.656485Z 0 [Note] Shutting down plugin 'CSV'
2020-08-06T15:26:05.657517Z 0 [Note] mysqld: Shutdown complete

[sunbusiness]

@尐千叶 怎么修改权限

[尐千叶]

感觉是文件权限问题，你去修改下权限

[lhdz_bj]

引用 楼主 4color 的回复:

前段时间出现这个问题，一直解决不了，只要全库删了，然后初始化了数据库，然后今天一重启又这样了。
不知道哪里的问题

2020-08-06T15:26:05.427648Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-06T15:26:05.446744Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-08-06T15:26:05.447132Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-08-06T15:26:05.448066Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-08-06T15:26:05.651754Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-08-06T15:26:05.652184Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-08-06T15:26:05.653594Z 0 [ERROR] Failed to initialize builtin plugins.
2020-08-06T15:26:05.655147Z 0 [ERROR] Aborting

2020-08-06T15:26:05.655589Z 0 [Note] Binlog end
2020-08-06T15:26:05.656485Z 0 [Note] Shutting down plugin 'CSV'
2020-08-06T15:26:05.657517Z 0 [Note] mysqld: Shutdown complete

看看数据目录的权限，mysql用户是否有些权限。

[lhdz_bj]

引用 2 楼 lhdz_bj 的回复:

[quote=引用 楼主 4color 的回复:]前段时间出现这个问题，一直解决不了，只要全库删了，然后初始化了数据库，然后今天一重启又这样了。
不知道哪里的问题

2020-08-06T15:26:05.427648Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-06T15:26:05.446744Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-08-06T15:26:05.447132Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-08-06T15:26:05.448066Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-08-06T15:26:05.651754Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-08-06T15:26:05.652184Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-08-06T15:26:05.653594Z 0 [ERROR] Failed to initialize builtin plugins.
2020-08-06T15:26:05.655147Z 0 [ERROR] Aborting

2020-08-06T15:26:05.655589Z 0 [Note] Binlog end
2020-08-06T15:26:05.656485Z 0 [Note] Shutting down plugin 'CSV'
2020-08-06T15:26:05.657517Z 0 [Note] mysqld: Shutdown complete

看看数据目录的权限，mysql用户是否有些权限。[/quote]
写权限。

[学海无涯-回头是岸]

这个ibdata1 文件的权限问题