Debugging MariaDB Severe Crash (mysqld daemon dies)

Debugging MariaDB Severe Crash (mysqld daemon dies)

[OwN-3m-All]

[-- Attachment #1: Type: text/plain, Size: 526 bytes --]

Is there a way to debug why a MySQL query using Cygwin's mysql client
is causing the entire Cygwin mysqld daemon to die?  I'm not seeing
anything useful in /var/log/mysql*

There's nothing in event viewer either except the service entered a
stopped state.

I'm dealing with a Union query that works just fine in Linux, but is
crashing with the latest MariaDB cygwin package in Windows.

"ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query"

I'm not sure how to get information as to why it's crashing.

[-- Attachment #2: cygcheck.out --]
[-- Type: application/octet-stream, Size: 49152 bytes --]

[-- Attachment #3: Type: text/plain, Size: 219 bytes --]


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: Debugging MariaDB Severe Crash (mysqld daemon dies)

[OwN-3m-All]

Can anyone help with this?  I'm pretty sure this is a bug with the
latest cygwin package for mariadb since the queries work fine in Linux
(older versions of MySQL / MariaDB).

Would be nice to be able to actually troubleshoot this further, but
without any good logs, I don't know where to go to next.

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: Debugging MariaDB Severe Crash (mysqld daemon dies)

[Keith Christian]

I'm sure you've looked over this part of the mysql website:

https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html

If not, it'd be a good place to start.  I don't know particularly much
about mysqld but thought someone should at least answer you.

On Thu, Jan 12, 2017 at 5:25 AM, OwN-3m-All <own3mall@gmail.com> wrote:
> Can anyone help with this?  I'm pretty sure this is a bug with the
> latest cygwin package for mariadb since the queries work fine in Linux
> (older versions of MySQL / MariaDB).
>
> Would be nice to be able to actually troubleshoot this further, but
> without any good logs, I don't know where to go to next.
>
> --
> Problem reports:       http://cygwin.com/problems.html
> FAQ:                   http://cygwin.com/faq/
> Documentation:         http://cygwin.com/docs.html
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
>

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: Debugging MariaDB Severe Crash (mysqld daemon dies)

[OwN-3m-All]

Unfortunately, I'm unable to debug mysql-server with the version that
comes with Cygwin.

/usr/sbin/mysqld --debug=o,/var/log/mysqld.trace produces the following error:

"debug is disabled in this build"

"mysqld_safe --debug=o,/var/log/mysqld.trace" also does not log
anything of value.

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: Debugging MariaDB Severe Crash (mysqld daemon dies)

[OwN-3m-All]

I opened a bug here with MariaDB since I don't know what else to do:

https://jira.mariadb.org/browse/MDEV-11931

The link above contains a database dump and the query that causes it
to crash on Windows running under cygwin.

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: Debugging MariaDB Severe Crash (mysqld daemon dies)

[Keith Christian]

OwN-3m-All,

If no one from the Cygwin team answers here, perhaps run Cygwin setup
and install the source package from Cygwin and re-compile with all
debugging  turned on (however that's done in MariaDB.)

Only a suggestion, I'm not an expert in the recent changes to Cygwin,
all of which have been very good.

On Sat, Jan 28, 2017 at 11:10 PM, OwN-3m-All <own3mall@gmail.com> wrote:
> I opened a bug here with MariaDB since I don't know what else to do:
>
> https://jira.mariadb.org/browse/MDEV-11931
>
> The link above contains a database dump and the query that causes it
> to crash on Windows running under cygwin.
>
> --
> Problem reports:       http://cygwin.com/problems.html
> FAQ:                   http://cygwin.com/faq/
> Documentation:         http://cygwin.com/docs.html
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
>

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple