mysqld not starting

[anp66]

Have a fresh mageia 8 install.
Traying to install mythtv.
Can't start the mysqld service from the drake service screen.

This is the log I get:

Code: Select all

# journalctl -u mysqld.service -n 200

Nov 17 18:13:37 localhost systemd[1]: Starting MySQL database server...
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] /usr/sbin/mysqld (mysqld 10.5.12-MariaDB) starting as process 32125 ...
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Uses event mutexes
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Number of pools: 1
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Using Linux native AIO
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Completed initialization of buffer pool
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=45118,45118
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 45118 between the checkpoint 45118 and the end 45130.
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [Note] InnoDB: Starting shutdown...
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [ERROR] Plugin 'InnoDB' init function returned error.
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Nov 17 18:13:37 localhost mysqld[32125]: 211117 18:13:37 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.
Nov 17 18:13:37 localhost mysqld[32125]: 211117 18:13:37 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2021-11-17 18:13:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Nov 17 18:13:37 localhost mysqld[32125]: 2021-11-17 18:13:37 0 [ERROR] Aborting
Nov 17 18:13:37 localhost mysqld[32125]: 211117 18:13:37 server_audit: STOPPED
Nov 17 18:13:37 localhost systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Nov 17 18:13:37 localhost systemd[1]: mysqld.service: Failed with result 'exit-code'.
Nov 17 18:13:37 localhost systemd[1]: Failed to start MySQL database server.


From mythtv-setup I have : user/password = mythtv/mythtv

Have found this:
https://www.mythtv.org/wiki/Database_Setup

But I dont have a running database.

What to do now ?

Best regards
Anders

[papoteur]

Hello,
You didn't say if you have executed the initialisation step for mariadb
mariadb-secure-installation

[Bequimao]

Hi,

The logfile tells us, that an attempt of crash recovery failed because of a missing file. So the ACID (atomicity, consistency, isolation, durability) properties of the database will never be fullfilled. That is definitely a permanent crash. The only options are restore a backup or delete the database and start again.

Regards,
Bequimão

[anp66]

Hello,
You didn't say if you have executed the initialisation step for mariadb
mariadb-secure-installation

Thank you for your time !

As root I run mariadb-secure-installation and then there was a running database .

Then mythbackend was installed:

Code: Select all

root@localhost anders]# urpmi mythtv-setup
To satisfy dependencies, the following packages are going to be installed:
  Package                        Version      Release       Arch   
(medium "Core Updates (distrib3)")
  mythtv-backend                 31.0         20210323.1.1> x86_64 
  mythtv-common                  31.0         20210323.1.1> x86_64 
  mythtv-setup                   31.0         20210323.1.1> x86_64 
  mythtv-themes-base             31.0         20210323.1.1> noarch 
29MB of additional disk space will be used.
17MB of packages will be retrieved.
Proceed with the installation of the 4 packages? (Y/n) Y


    $MIRRORLIST: media/core/updates/mythtv-backend-31.0-20210323.1.1.mga8.x86_64.rpm
    $MIRRORLIST: media/core/updates/mythtv-themes-base-31.0-20210323.1.1.mga8.noarch.rpm                                                                                                                                                     
    $MIRRORLIST: media/core/updates/mythtv-common-31.0-20210323.1.1.mga8.x86_64.rpm                                                                                                                                                         
    $MIRRORLIST: media/core/updates/mythtv-setup-31.0-20210323.1.1.mga8.x86_64.rpm                                                                                                                                                           
installing mythtv-backend-31.0-20210323.1.1.mga8.x86_64.rpm mythtv-themes-base-31.0-20210323.1.1.mga8.noarch.rpm mythtv-common-31.0-20210323.1.1.mga8.x86_64.rpm mythtv-setup-31.0-20210323.1.1.mga8.x86_64.rpm from /var/cache/urpmi/rpms   
Preparing...                     ###########################################################################################################################################################################################################
      1/4: mythtv-common         ###########################################################################################################################################################################################################
      2/4: mythtv-backend        ###########################################################################################################################################################################################################
      3/4: mythtv-themes-base    ###########################################################################################################################################################################################################
      4/4: mythtv-setup          ###########################################################################################################################################################################################################
----------------------------------------------------------------------
More information on package mythtv-backend-31.0-20210323.1.1.mga8.x86_64
You can import the initial database by running:
mysql -u root -p < /usr/share/mythtv/initialdb/mc.sql
(you can omit -p if you do not have the password set)


Now when I tray to create the mythtv db with mysql -u root -p < /usr/share/mythtv/initialdb/mc.sql I get this error:

Code: Select all

ERROR 1819 (HY000) at line 2: Your password does not satisfy the current policy requirements

I've rerun mariadb-secure-installation many times and changed the root password without any luck.

I've search for password policy requirments, but all I find is something like

Code: Select all

MariaDB [(none)]> SET GLOBAL validate_password.policy=LOW;
ERROR 4081 (HY000): Unknown structured system variable or ROW routine variable 'validate_password'
MariaDB [(none)]> exit


I've looked in ./etc/my.cnf, but I dont dare to change anything.

Is there a way to remove the root password or set the password policy to low ?

Best regards
Anders