Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Issues related to applications and software problems
Post Reply
yeknafar
Posts: 13
Joined: 2018/07/12 21:13:09

Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Post by yeknafar » 2021/04/12 12:19:04

Hello

I wanted to update the Mysql to 1.4 but now I am getting this errors.

Code: Select all

Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [Note] InnoDB: Unable to open the first data file
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [Note] InnoDB: Starting shutdown...
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR]apt purge mysql*
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [Note] Plugin 'FEEDBACK' is disabled.
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Apr 12 16:26:37 localhost mysqld: 2021-04-12 16:26:37 0 [ERROR] Aborting
Apr 12 16:26:37 localhost mysqld: Warning: Memory not freed: 520
Apr 12 16:26:37 localhost systemd: mariadb.service: main process exited, code=exited, status=1/FAILURE
Apr 12 16:26:37 localhost systemd: Failed to start MariaDB 10.3.28 database server.
Apr 12 16:26:37 localhost systemd: Unit mariadb.service entered failed state.
Apr 12 16:26:37 localhost systemd: mariadb.service failed.

What's wrong?
Thanks

User avatar
TrevorH
Site Admin
Posts: 33191
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Post by TrevorH » 2021/04/12 12:57:12

How did you "update to the Mysql 1.4"? Whatever mysql 1.4 is? We supply mariadb 5.5 for CentOS 7 not mysql so where did you get "Mysql 1.4" from?

BTW, there is no mysql 1.4 and I'm not sure there ever has been in living memory. When I first started with RHEL in 2006 the current mysql version was 3.23.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

MartinR
Posts: 714
Joined: 2015/05/11 07:53:27
Location: UK

Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Post by MartinR » 2021/04/15 14:06:03

MySQL 1.0 was an internal release on 23 May 1995. 3.19 came out in 1996 and as of 1999 3.22 was the latest stable version with 3.23 comming out as a development version. [1] mSQL came out in 1994 but by 1997 mSQL have been surpassed in most respects by MySQL. By 1999 mSQL existed in two maintained versions, 1 and 2. [1][2] For completness MariaDB was forked as version 5.1 on 29 October 2009. [2]

So - if anyone is running 1.4 of either database they can only be a museum or doing historical research!

[1] 005.75. Yarger, Randy Jay, George Reese, and Tim King. MySQL and MSQL. 1st ed. Sebastopol, CA: O’Reilly, 1999.
[2] Wikipedia

Post Reply