Skip to main content

Please use innodb_redo_log_capacity instead

jlucho
hi guy AlmaLinux v8.8.0 STANDARD / cPanel 112.0.5 MySQL8 MySQL show this error (myhostname.err): ============= apacity=1811939328. Please use innodb_redo_log_capacity instead. 2023-07-20T21:18:12.886280Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-07-20T21:18:13.035623Z 1 [ERROR] [MY-012884] [InnoDB] ./#innodb_redo/#ib_redo17 can't be opened in read-write mode. 2023-07-20T21:18:13.035650Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-07-20T21:18:13.515840Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-07-20T21:18:13.515943Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-07-20T21:18:13.515955Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-20T21:18:13.516241Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL. ============= How can I solve the problem with MySQL? It is a new server and there is no important information

Comments

2 comments

Date Votes
  • jlucho
    2023-07-20T21:37:57.868522Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2023-07-20T21:37:57.868536Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 31799 2023-07-20T21:37:57.875311Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1811939328. Please use innodb_redo_log_capacity instead. 2023-07-20T21:37:57.876068Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-07-20T21:37:58.028968Z 1 [ERROR] [MY-012884] [InnoDB] ./#innodb_redo/#ib_redo17 can't be opened in read-write mode. 2023-07-20T21:37:58.028994Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-07-20T21:37:58.508644Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-07-20T21:37:58.508740Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-07-20T21:37:58.508751Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-20T21:37:58.509017Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL. 2023-07-20T21:37:58.789468Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2023-07-20T21:37:58.789483Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 31870 2023-07-20T21:37:58.796463Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1811939328. Please use innodb_redo_log_capacity instead. 2023-07-20T21:37:58.797232Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-07-20T21:37:58.938096Z 1 [ERROR] [MY-012884] [InnoDB] ./#innodb_redo/#ib_redo17 can't be opened in read-write mode. 2023-07-20T21:37:58.938122Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-07-20T21:37:59.418151Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-07-20T21:37:59.418214Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-07-20T21:37:59.418226Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-20T21:37:59.418522Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL. 2023-07-20T21:37:59.689349Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2023-07-20T21:37:59.689364Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 31925 2023-07-20T21:37:59.696272Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1811939328. Please use innodb_redo_log_capacity instead. 2023-07-20T21:37:59.697096Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-07-20T21:37:59.838442Z 1 [ERROR] [MY-012884] [InnoDB] ./#innodb_redo/#ib_redo17 can't be opened in read-write mode. 2023-07-20T21:37:59.838469Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-07-20T21:38:00.318413Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-07-20T21:38:00.318496Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-07-20T21:38:00.318508Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-20T21:38:00.318777Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34) MySQL Community Server - GPL.
    0
  • cPRex Jurassic Moderator
    Hey there! Can you post the MySQL settings from /etc/my.cnf so I can see those?
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post