Home > database >  NnoDB: The innodb_system data file 'ibdata1' must be writable
NnoDB: The innodb_system data file 'ibdata1' must be writable

Time:10-08

This problem a while ago, has been not solve, as long as the whole library is deleted, and then initializes the database, and then a restart again like today,
Don't know where the problem

 
The 2020-08-06 T15:26:05. 427648 z 0 [Note] InnoDB: Completed initialization of buffer pool
The 2020-08-06 T15:26:05. 446744 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
The 2020-08-06 T15:26:05. 447132 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
The 2020-08-06 T15:26:05. 448066 z 0 [ERROR] InnoDB: Plugin initialization aborted with ERROR Generic ERROR
The 2020-08-06 T15:26:05. 651754 z 0 [ERROR] Plugin 'InnoDB init function returned ERROR.
The 2020-08-06 T15:26:05. 652184 z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
The 2020-08-06 T15:26:05. 653594 z 0 [ERROR] Failed to initialize builtin plugins.
The 2020-08-06 T15:26:05. 655147 z 0 [ERROR] Aborting

The 2020-08-06 T15:26:05. 655589 z 0 [Note] Binlog end
The 2020-08-06 T15:26:05. 656485 z 0 [Note] Shutting down the plugin 'CSV'
The 2020-08-06 T15:26:05. 657517 z 0 [Note] mysqld: Shutdown complete

CodePudding user response:

Feeling is the file permissions, you to modify the permissions

CodePudding user response:

refer to the original poster 4 color response:
this problem a while ago, has been not solve, as long as the whole library is deleted, and then initializes the database, and then a restart again like today,
Don't know where the problem

 
The 2020-08-06 T15:26:05. 427648 z 0 [Note] InnoDB: Completed initialization of buffer pool
The 2020-08-06 T15:26:05. 446744 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
The 2020-08-06 T15:26:05. 447132 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
The 2020-08-06 T15:26:05. 448066 z 0 [ERROR] InnoDB: Plugin initialization aborted with ERROR Generic ERROR
The 2020-08-06 T15:26:05. 651754 z 0 [ERROR] Plugin 'InnoDB init function returned ERROR.
The 2020-08-06 T15:26:05. 652184 z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
The 2020-08-06 T15:26:05. 653594 z 0 [ERROR] Failed to initialize builtin plugins.
The 2020-08-06 T15:26:05. 655147 z 0 [ERROR] Aborting

The 2020-08-06 T15:26:05. 655589 z 0 [Note] Binlog end
The 2020-08-06 T15:26:05. 656485 z 0 [Note] Shutting down the plugin 'CSV'
The 2020-08-06 T15:26:05. 657517 z 0 [Note] mysqld: Shutdown complete



Look at the data directory permissions, mysql user whether some permissions,

CodePudding user response:

refer to the second floor lhdz_bj response:
Quote: refer to the original poster 4 color response:
this problem a while ago, has been not solve, as long as the whole library is deleted, and then initializes the database, and then a restart again like today,
Don't know where the problem

 
The 2020-08-06 T15:26:05. 427648 z 0 [Note] InnoDB: Completed initialization of buffer pool
The 2020-08-06 T15:26:05. 446744 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
The 2020-08-06 T15:26:05. 447132 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
The 2020-08-06 T15:26:05. 448066 z 0 [ERROR] InnoDB: Plugin initialization aborted with ERROR Generic ERROR
The 2020-08-06 T15:26:05. 651754 z 0 [ERROR] Plugin 'InnoDB init function returned ERROR.
The 2020-08-06 T15:26:05. 652184 z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
The 2020-08-06 T15:26:05. 653594 z 0 [ERROR] Failed to initialize builtin plugins.
The 2020-08-06 T15:26:05. 655147 z 0 [ERROR] Aborting

The 2020-08-06 T15:26:05. 655589 z 0 [Note] Binlog end
The 2020-08-06 T15:26:05. 656485 z 0 [Note] Shutting down the plugin 'CSV'
The 2020-08-06 T15:26:05. 657517 z 0 [Note] mysqld: Shutdown complete



Look at the data directory permissions, mysql user whether some permissions,

Write permissions,

CodePudding user response:

The ibdata1 file permissions
  • Related