Case sensitivity causes error in mySQL start

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

Case sensitivity causes error in mySQL start

Postby oitconz » 11. February 2017 01:04

Hi all,

I have XAMPP Version: 7.1.1, Control Panel Version: 3.2.2

One site i am bringing to a local machine for dev from a Linux box unfortunately has multiple tables with the same name, except for a case difference ( e.g. table: my_table_name and My_Table_Name ) Naturally this is causing issues with identical column values in the ID column on import in Xampp as the tables are imported over each other owing to case sensitivity.

I added lower_case_table_names = 0 into the my.ini and restarted.
mySQL failed with the following error log showing.

Error: MySQL shutdown unexpectedly.
1:01:17 p.m. [mysql] This may be due to a blocked port, missing dependencies,
1:01:17 p.m. [mysql] improper privileges, a crash, or a shutdown by another method.
....
Logs show ...
Version: '10.1.21-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-02-11 12:14:02 5192 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2017-02-11 12:14:02 5192 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).

repeat many times over.
....
2017-02-11 12:21:30 2268 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 4333687
2017-02-11 12:21:30 2688 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-02-11 12:21:30 2268 [Note] Plugin 'FEEDBACK' is disabled.
2017-02-11 12:21:30 2268 [Note] Server socket created on IP: '::'.
2017-02-11 12:21:30 2268 [ERROR] mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repaired
2017-02-11 12:21:30 2268 [Warning] Checking table: '.\mysql\user'
2017-02-11 12:21:30 2268 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly
2017-02-11 12:21:30 2268 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2017-02-11 12:21:30 2268 [Warning] Checking table: '.\mysql\db'
2017-02-11 12:21:30 2268 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
2017-02-11 12:21:30 2268 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.21-MariaDB' socket: '' port: 3306 mariadb.org binary distribution


Reversing the setting allows the mySQL to restart.
it comes back with a clean log - just the normal [Note] messages and no errors.

It is quite possible there is something in the mySQL system for Xampp that is case insensitive and as soon as case sensitivity is forced it errors.

It is worth noting that mySQL database table / column [mysql].[column_stats].[min_value'] is in position 4 - not 3. similarly max_value is in position 5 , not 4.

Happy to provide debugging, logs etc as required.
windows 7. Xampp running with admin privelges.
oitconz
 
Posts: 1
Joined: 11. February 2017 00:19
XAMPP version: 3.2.2
Operating System: Windows 7

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 51 guests