ERROR in XAMMP

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

ERROR in XAMMP

Postby Anuraj » 19. November 2019 08:22

Please give the solution for this error. I am always getting this error.

2019-11-19 07:15:17 1ae4 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.
191119 7:15:17 [Note] InnoDB: Using mutexes to ref count buffer pool pages
191119 7:15:17 [Note] InnoDB: The InnoDB memory heap is disabled
191119 7:15:17 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
191119 7:15:17 [Note] InnoDB: Memory barrier is not used
191119 7:15:17 [Note] InnoDB: Compressed tables use zlib 1.2.3
191119 7:15:17 [Note] InnoDB: Not using CPU crc32 instructions
191119 7:15:17 [Note] InnoDB: Initializing buffer pool, size = 16.0M
191119 7:15:17 [Note] InnoDB: Completed initialization of buffer pool
191119 7:15:17 [Note] InnoDB: Highest supported file format is Barracuda.
191119 7:15:17 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1677162 in the ib_logfiles!
191119 7:15:17 [Note] InnoDB: Database was not shutdown normally!
191119 7:15:17 [Note] InnoDB: Starting crash recovery.
191119 7:15:17 [Note] InnoDB: Reading tablespace information from the .ibd files...
191119 7:15:17 [Note] InnoDB: Restoring possible half-written data pages
191119 7:15:17 [Note] InnoDB: from the doublewrite buffer...
191119 7:15:18 [ERROR] InnoDB: Table phpmyadmin/pma_navigationhiding in the InnoDB data dictionary has tablespace id 8, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
191119 7:15:18 [ERROR] InnoDB: Table phpmyadmin/pma_savedsearches in the InnoDB data dictionary has tablespace id 9, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
191119 7:15:18 [ERROR] InnoDB: Table phpmyadmin/pma_usergroups in the InnoDB data dictionary has tablespace id 7, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
191119 7:15:18 [ERROR] InnoDB: Table phpmyadmin/pma_users in the InnoDB data dictionary has tablespace id 6, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
191119 7:15:18 [Note] InnoDB: 128 rollback segment(s) are active.
191119 7:15:18 [Note] InnoDB: Waiting for purge to start
191119 7:15:18 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1677162
191119 7:15:18 [Note] Plugin 'FEEDBACK' is disabled.
191119 7:15:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
191119 7:15:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
191119 7:15:18 [Note] Server socket created on IP: '::'.
Anuraj
 
Posts: 1
Joined: 19. November 2019 08:19
XAMPP version: 3.2.1
Operating System: windows

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 204 guests