error 1286: unknown storage engine 'InnoDB'

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

error 1286: unknown storage engine 'InnoDB'

Postby schnegg » 12. October 2018 00:04

hallo Forum,

nach dem ich längere Zeit unbeschwert mit meinem SQL-System arbeiten konnte, bekomme ich nun einen Fehler rein.
Error 1286, unknown storage engine 'InnoDB' . Das MySQL oder MariaDB oder der phpMyAdmin oder wie auch immer kennt meine InnoDB-tabellen nicht mehr.
eigenartig, nachdem ich solange damit gearbeitet habe !?

mfg,

schnegg
schnegg
 
Posts: 16
Joined: 19. January 2018 22:06
XAMPP version: 1.8.3
Operating System: Windows 10

Re: error 1286: unknown storage engine 'InnoDB'

Postby Altrea » 12. October 2018 07:07

Hi,

zeige uns doch mal den kompletten Inhalt der mysql_error.log.
Meist ist diese Meldung nur ein Folgefehler eines anderen Fehlers.

mit freundlichen Grüßen,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: error 1286: unknown storage engine 'InnoDB'

Postby schnegg » 12. October 2018 16:13

2018-10-12 0:07:22 6792 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2018-10-12 00:07:22 1a88 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-12 0:07:22 6792 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-12 0:07:22 6792 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-12 0:07:22 6792 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-12 0:07:22 6792 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-12 0:07:22 6792 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-12 0:07:22 6792 [Note] InnoDB: Using generic crc32 instructions
2018-10-12 0:07:22 6792 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2018-10-12 0:07:22 6792 [Note] InnoDB: Completed initialization of buffer pool
2018-10-12 0:07:22 6792 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: Set innodb_force_recovery to ignore this error.
2018-10-12 0:07:22 6792 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-12 0:07:22 6792 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-10-12 0:07:22 6792 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-12 0:07:22 6792 [Note] Server socket created on IP: '::'.
2018-10-12 0:07:22 7876 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2018-10-12 0:07:22 6792 [Note] d:\pgm4\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.29-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2018-10-12 0:18:17 4912 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2018-10-12 0:18:17 4912 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-12 0:18:17 4912 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-12 0:18:17 4912 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-12 0:18:17 4912 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-12 0:18:17 4912 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-12 0:18:17 4912 [Note] InnoDB: Using generic crc32 instructions
2018-10-12 0:18:17 4912 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2018-10-12 0:18:17 4912 [Note] InnoDB: Completed initialization of buffer pool
2018-10-12 0:18:17 4912 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: Set innodb_force_recovery to ignore this error.
2018-10-12 0:18:17 4912 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-12 0:18:17 4912 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-10-12 0:18:17 4912 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-12 0:18:17 4912 [Note] Server socket created on IP: '::'.
2018-10-12 0:18:17 6120 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2018-10-12 0:18:17 4912 [Note] d:\pgm4\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.29-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2018-10-12 0:27:18 828 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2018-10-12 00:27:18 33c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2018-10-12 0:27:18 828 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-10-12 0:27:18 828 [Note] InnoDB: The InnoDB memory heap is disabled
2018-10-12 0:27:18 828 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-10-12 0:27:18 828 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-10-12 0:27:18 828 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-10-12 0:27:18 828 [Note] InnoDB: Using generic crc32 instructions
2018-10-12 0:27:18 828 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2018-10-12 0:27:18 828 [Note] InnoDB: Completed initialization of buffer pool
2018-10-12 0:27:18 828 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: Set innodb_force_recovery to ignore this error.
2018-10-12 0:27:18 828 [ERROR] Plugin 'InnoDB' init function returned error.
2018-10-12 0:27:18 828 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-10-12 0:27:18 828 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-12 0:27:18 828 [Note] Server socket created on IP: '::'.
2018-10-12 0:27:18 4864 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2018-10-12 0:27:18 828 [Note] d:\pgm4\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.29-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2018-10-12 0:28:43 10168 [ERROR] mysqld.exe: Falsche Information in Datei '.\biblio\buecher1.frm'
2018-10-12 0:28:43 10168 [ERROR] mysqld.exe: Falsche Information in Datei '.\biblio\buecher1_druck.frm'
2018-10-12 0:49:42 10168 [ERROR] mysqld.exe: Falsche Information in Datei '.\b13@002ejc\aenderungen_2005@002e2018.frm'
2018-10-12 0:49:42 10168 [ERROR] mysqld.exe: Falsche Information in Datei '.\b13@002ejc\bescheid_2005@002e2018.frm'
2018-10-12 0:49:42 10168 [ERROR] mysqld.exe: Falsche Information in Datei '.\b13@002ejc\post_2005@002e2018.frm'
2018-10-12 0:49:56 3068 [ERROR] mysqld.exe: Falsche Information in Datei '.\b11\arag1.frm'
2018-10-12 0:49:56 3068 [ERROR] mysqld.exe: Falsche Information in Datei '.\b11\barmer.frm'
2018-10-12 0:49:56 3068 [ERROR] mysqld.exe: Falsche Information in Datei '.\b11\privat.frm'
schnegg
 
Posts: 16
Joined: 19. January 2018 22:06
XAMPP version: 1.8.3
Operating System: Windows 10


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 16 guests