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
- 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!