Inscrutable mysql_error.log errors

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

Inscrutable mysql_error.log errors

Postby TomXampp » 05. November 2015 09:02

My mysql_error.log file is reporting a slew of errors that I don't know how to begin to debug and fix. My guess is that it is one or a very small number of problems that are cascading to cause all of the error message.

The initial [Note] entries are standard; the problems begin with
Code: Select all
[error] mysql.tables_priv: 1 client is using or hasn't closed the table properly
. Perhaps this is the principal clue as to what needs to be done to eliminate all of the errors. I'd appreciate anyone who can point me in the right direction on fixing this. I can provide more information as necessary. I'm running the current version of XAMPP with PHP 5.6.15 on Windows 8.1.

Code: Select all
151105  1:54:23 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151105  1:54:23 [Note] InnoDB: The InnoDB memory heap is disabled
151105  1:54:23 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151105  1:54:23 [Note] InnoDB: Memory barrier is not used
151105  1:54:23 [Note] InnoDB: Compressed tables use zlib 1.2.3
151105  1:54:23 [Note] InnoDB: Not using CPU crc32 instructions
151105  1:54:23 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151105  1:54:23 [Note] InnoDB: Completed initialization of buffer pool
151105  1:54:23 [Note] InnoDB: Highest supported file format is Barracuda.
151105  1:54:23 [Note] InnoDB: The log sequence numbers 1826188 and 1826188 in ibdata files do not match the log sequence number 1826198 in the ib_logfiles!
151105  1:54:23 [Note] InnoDB: Database was not shutdown normally!
151105  1:54:23 [Note] InnoDB: Starting crash recovery.
151105  1:54:23 [Note] InnoDB: Reading tablespace information from the .ibd files...
151105  1:54:23 [Note] InnoDB: Restoring possible half-written data pages
151105  1:54:23 [Note] InnoDB: from the doublewrite buffer...
151105  1:54:23 [Note] InnoDB: 128 rollback segment(s) are active.
151105  1:54:23 [Note] InnoDB: Waiting for purge to start
151105  1:54:23 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1826198
151105  1:54:23 [Note] Plugin 'FEEDBACK' is disabled.
151105  1:54:23 [Note] Server socket created on IP: '::'.
151105  1:54:23 [Warning] 'db' entry '8 11:29:46 [error] mysql.tables_priv: 1 client is using or hasn't closed the table properly

151028 11:29:46 [error] mysql.tables_priv: size of datafile is: 2003       should be: 1235

151028 11:29:46 [ERROR] mysql.tables_priv: got error: 0 when reading datafile at record: 0

151028 11:29:46 [ERROR] Got an error from unknown thread, ha_myisam.cc:952

151028 11:29:46 [Warning] Recovering table: '.\mysql\tables_priv'

151028 11:29@51028 11:29:46 [ERROR] mysqld.exe: Table '.\mysql\tables_priv' is marked as crashed and should be repaired

151028 11:29:46 [Warning] Checking table:   '.\mysql\tables_priv'

15102' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
151105  1:54:23 [Warning] 'db' entry 'mns_priv: 1 client is using or hasn't closed the table properly

151028 11:29:46 [error] mysqld.exe: table '.\mysql\procs_priv' is marked as crashed and should be repaired

151028 11:29:46 [wa rning] Checking table:   '.\mysql\procs_priv'

151028 11:29:46 [ERROR] mysql.procs_priv: 1 client is using or hasn't closed the table properly

151028 11:29:46 [Note] Event Scheduler: Loaded 0 events

151028 11:29:46 [Note] c:\xampp\mysql\b@xe: Table '.\mysql\columns_priv' is marked as crashed and should be repaired

151028 11:29:46 [Warning] Checking table:   '.\mysql\columns_priv'

151028 11:29:46 [ERROR] mysql.colu' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
151105  1:54:23 [Note] Event Scheduler: Loaded 0 events
151105  1:54:23 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.0.17-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution


Many thanks in advance!
TomXampp
 
Posts: 28
Joined: 12. March 2015 03:58
Operating System: Windows 8.1

Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 5 guests