Unable to start service mysqld(fedora repo)

Ask Fedora
,
1

installed following this guide: Installing MySQL/MariaDB :: Fedora Docs
following error on running sudo systemctl start mysqld

The job identifier is 9628.
Aug 06 23:38:08 fedora systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Subject: Unit process exited
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
 An ExecStart= process belonging to unit mysqld.service has exited.
 The process' exit code is 'exited' and its exit status is 1.
Aug 06 23:38:08 fedora systemd[1]: mysqld.service: Failed with result 'exit-code'.
 Subject: Unit failed
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
 The unit mysqld.service has entered the 'failed' state with result 'exit-code'.
Aug 06 23:38:08 fedora systemd[1]: Failed to start mysqld.service - MySQL 8.0 database server.
 Subject: A start job for unit mysqld.service has failed
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

A start job for unit mysqld.service has finished with a failure.

 The job identifier is 9628 and the job result is failed.
Aug 06 23:40:55 fedora systemd[1]: Starting mysqld.service - MySQL 8.0 database server...
 Subject: A start job for unit mysqld.service has begun execution
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

 A start job for unit mysqld.service has begun execution.

 The job identifier is 9886.
Aug 06 23:40:56 fedora systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
 Subject: Unit process exited
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
 An ExecStart= process belonging to unit mysqld.service has exited.
 The process' exit code is 'exited' and its exit status is 1.
Aug 06 23:40:56 fedora systemd[1]: mysqld.service: Failed with result 'exit-code'.
 Subject: Unit failed
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
 The unit mysqld.service has entered the 'failed' state with result 'exit-code'.
Aug 06 23:40:56 fedora systemd[1]: Failed to start mysqld.service - MySQL 8.0 database server.
 Subject: A start job for unit mysqld.service has failed
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
 A start job for unit mysqld.service has finished with a failure.
The job identifier is 9886 and the job result is failed.
2

Take a look to the logs: Installing MySQL/MariaDB :: Fedora Docs

1 Like
3

I’ve used MariaDB in the past no problem but plan on trying MySQL on F40 in the near future.

For MariaDB I do basics to get it started:

sudo dnf install 'mariadb-server'
sudo systemctl enable 'mariadb' --now
sudo mariadb-secure-installation

For MySQL, did you do that and then run into the failed start error? Or did you do any thing else?

4

I have already tried it but it doesn’t seems to be working.
Following is the mysqld.log file:

2024-08-05T11:01:23.804815Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 8169
2024-08-05T11:01:23.809840Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-05T11:01:23.809873Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-05T11:01:23.826020Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-05T11:01:23.826045Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-05T11:01:23.826054Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-05T11:01:24.325432Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-05T11:01:24.325685Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-05T11:01:24.325718Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-05T11:01:24.326226Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-06T18:07:24.624331Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 12451
2024-08-06T18:07:24.637038Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-06T18:07:24.637103Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-06T18:07:24.675006Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-06T18:07:24.675081Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-06T18:07:24.675110Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-06T18:07:25.173753Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-06T18:07:25.174048Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-06T18:07:25.174112Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-06T18:07:25.175127Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-06T18:08:07.895633Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 12588
2024-08-06T18:08:07.908087Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-06T18:08:07.908151Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-06T18:08:07.945069Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-06T18:08:07.945141Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-06T18:08:07.945170Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-06T18:08:08.444556Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-06T18:08:08.444919Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-06T18:08:08.444980Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-06T18:08:08.446006Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-06T18:10:55.971398Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 12912
2024-08-06T18:10:55.983531Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-06T18:10:55.983601Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-06T18:10:56.021372Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-06T18:10:56.021438Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-06T18:10:56.021461Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-06T18:10:56.520750Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-06T18:10:56.521109Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-06T18:10:56.521172Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-06T18:10:56.522099Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-06T18:46:13.803833Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 14797
2024-08-06T18:46:13.812068Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-06T18:46:13.812126Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-06T18:46:13.850378Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-06T18:46:13.850452Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-06T18:46:13.850511Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-06T18:46:14.349797Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-06T18:46:14.350205Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-06T18:46:14.350270Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-06T18:46:14.351265Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-06T19:11:20.525817Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 15940
2024-08-06T19:11:20.538221Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-06T19:11:20.538302Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-06T19:11:20.575646Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-06T19:11:20.575721Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-06T19:11:20.575750Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-06T19:11:21.075083Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-06T19:11:21.075499Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-06T19:11:21.075586Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-06T19:11:21.076561Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-07T03:04:59.643509Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 24573
2024-08-07T03:04:59.655043Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-07T03:04:59.655107Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-07T03:04:59.692983Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-07T03:04:59.693075Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-07T03:04:59.693099Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-07T03:05:00.192359Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-07T03:05:00.192632Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-07T03:05:00.192681Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-07T03:05:00.193359Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-07T03:07:47.583011Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 24770
2024-08-07T03:07:47.595268Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-07T03:07:47.595330Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-07T03:07:47.634537Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-07T03:07:47.634610Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-07T03:07:47.634656Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-07T03:07:48.133932Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-07T03:07:48.135551Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-07T03:07:48.135634Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-07T03:07:48.136657Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-07T03:12:16.130723Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 24984
2024-08-07T03:12:16.143101Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-07T03:12:16.143165Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-07T03:12:16.181730Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-07T03:12:16.181808Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-07T03:12:16.181837Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-07T03:12:16.680949Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-07T03:12:16.681250Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-07T03:12:16.681308Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-07T03:12:16.682271Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
2024-08-07T17:57:25.715188Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.37) starting as process 15654
2024-08-07T17:57:25.725702Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-08-07T17:57:25.725737Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-07T17:57:25.743396Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-08-07T17:57:25.743422Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2024-08-07T17:57:25.743431Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
2024-08-07T17:57:26.242719Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-08-07T17:57:26.242925Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-07T17:57:26.242951Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-07T17:57:26.243493Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.37)  Source distribution.
5

Could you provide the result of these commands?
ls -laZ /var/lib/mysql
df -h /var/lib/mysql

6

Are you using mysql-server from Fedora repos, or the package from Oracle’s repo?

I tried installing mysql-server (Fedora repo) on F40 KDE and got a bunch of conflicts with MariaDB packages and couldn’t install it. I’m thinking KDE installs MariaDB stuff out-the-box for dependencies.