Error starting mysql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error starting mysql

Postby hypelevels » 20. April 2019 17:25

i get this error while starting mysql yesterday it was fine so i decided to do what xampp tels you to, to post my log in the forum


2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2019-04-18 15:24:34 2558 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.
2019-04-18 15:24:34 9560 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-18 15:24:34 9560 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-18 15:24:34 9560 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-18 15:24:34 9560 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-18 15:24:34 9560 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-18 15:24:34 9560 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-18 15:24:34 9560 [Note] InnoDB: Using generic crc32 instructions
2019-04-18 15:24:34 9560 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-18 15:24:34 9560 [Note] InnoDB: Completed initialization of buffer pool
2019-04-18 15:24:34 9560 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-18 15:24:34 9560 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-18 15:24:34 9560 [Note] InnoDB: Waiting for purge to start
2019-04-18 15:24:34 9560 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 1835037
2019-04-18 15:24:34 272 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-18 15:24:35 9560 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-18 15:24:35 9560 [Note] Server socket created on IP: '::'.
2019-04-18 15:24:35 9560 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.38-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:14:49 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:15:00 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-04-18 17:15:00 10676 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-04-18 17:15:04 29b4 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2019-04-20 17:23:23 1128 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.
2019-04-20 17:23:23 4392 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:23:23 4392 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:23:23 4392 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:23:23 4392 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:23:23 4392 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:23:23 4392 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:23:23 4392 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:23:23 4392 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:23:23 4392 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:23:23 4392 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-20 17:23:23 4392 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 2093258 in the ib_logfiles!
2019-04-20 17:23:23 4392 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-04-20 17:23:24 4392 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-20 17:23:24 4392 [Note] InnoDB: Waiting for purge to start
2019-04-20 17:23:24 4392 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 2093258
2019-04-20 17:23:24 1340 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-20 17:23:24 4392 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:23:24 4392 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:23:24 4392 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-04-20 17:23:24 4392 [Note] Server socket created on IP: '::'.
2019-04-20 17:23:24 4392 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-04-20 17:23:35 30dc 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.
2019-04-20 17:23:35 12508 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:23:35 12508 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:23:35 12508 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:23:35 12508 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:23:35 12508 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:23:35 12508 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:23:35 12508 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:23:35 12508 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:23:35 12508 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:23:36 12508 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-20 17:23:36 12508 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 2093268 in the ib_logfiles!
2019-04-20 17:23:36 12508 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-04-20 17:23:36 12508 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-20 17:23:36 12508 [Note] InnoDB: Waiting for purge to start
2019-04-20 17:23:36 12508 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 2093268
2019-04-20 17:23:36 200 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-20 17:23:36 12508 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:23:36 12508 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:23:36 12508 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-04-20 17:23:36 12508 [Note] Server socket created on IP: '::'.
2019-04-20 17:23:36 12508 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-04-20 17:23:49 32e4 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.
2019-04-20 17:23:49 13028 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:23:49 13028 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:23:49 13028 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:23:49 13028 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:23:49 13028 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:23:49 13028 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:23:49 13028 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:23:49 13028 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:23:49 13028 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:23:49 13028 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-20 17:23:49 13028 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 2093278 in the ib_logfiles!
2019-04-20 17:23:49 13028 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-04-20 17:23:50 13028 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-20 17:23:50 13028 [Note] InnoDB: Waiting for purge to start
2019-04-20 17:23:50 13028 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 2093278
2019-04-20 17:23:50 5912 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-20 17:23:50 13028 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:23:50 13028 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:23:50 13028 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-04-20 17:23:50 13028 [Note] Server socket created on IP: '::'.
2019-04-20 17:23:50 13028 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-04-20 17:25:12 1228 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.
2019-04-20 17:25:12 4648 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:25:12 4648 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:25:12 4648 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:25:12 4648 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:25:12 4648 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:25:12 4648 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:25:12 4648 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:25:12 4648 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:25:12 4648 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:25:12 4648 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-20 17:25:12 4648 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 2093288 in the ib_logfiles!
2019-04-20 17:25:12 4648 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-04-20 17:25:13 4648 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-20 17:25:13 4648 [Note] InnoDB: Waiting for purge to start
2019-04-20 17:25:13 4648 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 2093288
2019-04-20 17:25:13 2232 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-20 17:25:13 4648 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:25:13 4648 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:25:13 4648 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-04-20 17:25:13 4648 [Note] Server socket created on IP: '::'.
2019-04-20 17:25:13 4648 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-04-20 17:25:20 1068 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.
2019-04-20 17:25:20 4200 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:25:20 4200 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:25:20 4200 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:25:20 4200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:25:20 4200 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:25:20 4200 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:25:20 4200 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:25:20 4200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:25:20 4200 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:25:21 4200 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-20 17:25:21 4200 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 2093298 in the ib_logfiles!
2019-04-20 17:25:21 4200 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-04-20 17:25:21 4200 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-20 17:25:21 4200 [Note] InnoDB: Waiting for purge to start
2019-04-20 17:25:21 4200 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 2093298
2019-04-20 17:25:21 9908 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-20 17:25:21 4200 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:25:21 4200 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:25:21 4200 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-04-20 17:25:21 4200 [Note] Server socket created on IP: '::'.
2019-04-20 17:25:21 4200 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-04-20 17:25:22 1978 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.
2019-04-20 17:25:22 6520 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:25:22 6520 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:25:22 6520 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:25:22 6520 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:25:22 6520 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:25:22 6520 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:25:22 6520 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:25:22 6520 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:25:22 6520 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:25:23 6520 [Note] InnoDB: Highest supported file format is Barracuda.
2019-04-20 17:25:23 6520 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 2093308 in the ib_logfiles!
2019-04-20 17:25:23 6520 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-04-20 17:25:23 6520 [Note] InnoDB: 128 rollback segment(s) are active.
2019-04-20 17:25:23 6520 [Note] InnoDB: Waiting for purge to start
2019-04-20 17:25:23 6520 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 2093308
2019-04-20 17:25:23 8888 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-04-20 17:25:23 6520 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:25:23 6520 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:25:23 6520 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-04-20 17:25:23 6520 [Note] Server socket created on IP: '::'.
2019-04-20 17:25:23 6520 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-04-20 17:26:42 2cf4 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.
2019-04-20 17:26:42 11508 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:26:42 11508 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:26:42 11508 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:26:42 11508 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:26:42 11508 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:26:42 11508 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:26:42 11508 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:26:42 11508 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:26:42 11508 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:26:42 11508 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2019-04-20 17:26:42 11508 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2019-04-20 17:26:42 11508 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2019-04-20 17:26:42 11508 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile1
2019-04-20 17:26:42 11508 [ERROR] Plugin 'InnoDB' init function returned error.
2019-04-20 17:26:42 11508 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-04-20 17:26:42 11508 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:26:42 11508 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:26:42 11508 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-04-20 17:26:42 11508 [ERROR] Aborting

2019-04-20 17:26:51 26c8 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.
2019-04-20 17:26:51 9928 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-20 17:26:51 9928 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-20 17:26:51 9928 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-20 17:26:51 9928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-20 17:26:51 9928 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-20 17:26:51 9928 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-20 17:26:51 9928 [Note] InnoDB: Using generic crc32 instructions
2019-04-20 17:26:51 9928 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-20 17:26:51 9928 [Note] InnoDB: Completed initialization of buffer pool
2019-04-20 17:26:51 9928 [Note] InnoDB: Restoring page 0 of tablespace 0
2019-04-20 17:26:51 9928 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2019-04-20 17:26:51 9928 [ERROR] InnoDB: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
2019-04-20 17:26:51 9928 [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!
2019-04-20 17:26:51 9928 [ERROR] Plugin 'InnoDB' init function returned error.
2019-04-20 17:26:51 9928 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-04-20 17:26:51 9928 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-20 17:26:51 9928 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-04-20 17:26:51 9928 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-04-20 17:26:51 9928 [ERROR] Aborting
hypelevels
 
Posts: 1
Joined: 20. April 2019 17:24
XAMPP version: v3.2.3
Operating System: windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 68 guests