union_mysql-server_crash_db_files_and_query.zip
[MDEV-11931] mysql-server Cygwin Union Crash No Log Output - ERROR 2013 (HY000) Lost connection to MySQL server during query Created: 2017-01-29 Updated: 2017-02-01 Resolved: 2017-02-01 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Affects Version/s: | 10.1.19 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | OwN-3m-All | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows Server 2012 R2 Standard |
||
| Attachments: |
union_mysql-server_crash_db_files_and_query.zip
|
| 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 |
| Comments |
| Comment by OwN-3m-All [ 2017-01-29 ] |
|
I've been running the query using the following command from a Cygwin64 terminal: mysql -u root -p"PASSHERE" ogp_panel < union_query.sql Oh, and by the way, with password hashes present in the dump, don't worry. This is all fake / test data. |
| Comment by Vladislav Vaintroub [ 2017-02-01 ] |
|
Unfortunately we do not support Cygwin, and never had. I'm surprised that someone managed to build it there. And that someone is using it there, as technically I would not see a reason. There is no general interest in it - you can run on Windows, natively, or use virtualization to run on Linux. Also, we are not very familiar with this environment. As of my own short MySQL related Cygwin experience, the first and last time I tried to build it, ~2010, I got it to build, but it crashed during the test suite, and I did not manage to convince Cygwins gdb to work, so why something crashed remained mystery. I might be the only (former)MySQLer to try Cygwin MySQL Server more or less recently, and this was pure curiosity, to check whether cmake works on unusual platforms. I never tried anything like that on MariaDB If Redhat has built and supports it, think your best option would be to ask them. |
| Comment by Vladislav Vaintroub [ 2017-02-01 ] |
|
Closing as the bug is about unsupported platform. |