Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.1.19
-
None
-
Windows Server 2012 R2 Standard
Cygwin Latest Version
Description
When trying to run a particular UNION query that works fine in MySQL and MariaDB in Linux on a cygwin installation of mysql-server on Windows Server 2012 R2 Standard (any version of Windows for that matter), I get the following error:
ERROR 2013 (HY000) Lost connection to MySQL server during query
mysqld_safe doesn't provide any helpful output in the error log either:
http://pastebin.com/raw/ZDY1HRDj
It just doesn't like the UNION query for some reason. I have no idea why. I can't provide any additional debugging information since debug is not available in the cygwin build. I'm not even sure if I should open this issue here. No one in the cygwin mailing list has answered my question:
http://cygwin.1069669.n5.nabble.com/Debugging-MariaDB-Severe-Crash-mysqld-daemon-dies-td131617.html
Attached is a database dump (database_structure_ogp_panel.sql) with the query to run to make it crash (union_query.sql).
I've tried it on multiple installs and with differing my.cnf configurations. It crashes on Windows only running under cygwin.
For more information on this issue, please see here:
http://opengamepanel.org/forum/viewthread.php?thread_id=5120#post_24517