X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:from:subject:message-id:date:mime-version
	:content-type:content-transfer-encoding; q=dns; s=default; b=V1y
	XdblMBIR876Rb5/+hF8SSolUr6/tx2DzausgQliPGb4bwXxZzBKTQd4yIO9Rddhp
	GcMZyIEMR3jCc0MRBp1NpGdxlvBTCeWsHmGy62p1btLfRReF7vnzFzChJcn/8sU9
	r7Ltsg91Sc0+K3wwp49EDwjkzJ6U8RwzdKBboqOc=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:from:subject:message-id:date:mime-version
	:content-type:content-transfer-encoding; s=default; bh=goUDQ0vbv
	xc95tKR4helA0Afr3A=; b=DBD4dhOOaJh6iviuN8iDZGUR49BKu/LvR5yUe31Ic
	MLCL1wSIr0XN5NWApjlegGnB9Lq+Omfine2M5dXF6aRxc8BjDdAMXGMKX2CcRLP7
	CPMfPssgIlk7+A50xgd/vmY2prchQEmkrMw8sIOf6rM1eaJlrqK8V5Qc/1Q0EkHD
	XI=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Spam-SWARE-Status:	No, score=2.2 required=5.0 tests=AWL,BAYES_50,GIT_PATCH_1,HTML_FONT_FACE_BAD,HTML_MESSAGE,NO_FM_NAME_IP_HOSTN,RCVD_IN_SORBS_DUL,RDNS_DYNAMIC,SPF_HELO_PASS,SPF_PASS,TVD_RCVD_IP autolearn=ham version=3.3.1 spammy=Hope, UD:fr, france, France
X-HELO:	punkapoule.fr
To:	cygwin AT cygwin DOT com
DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/simple; d=punkapoule.fr; s=BgSCoe; t=1576164383; bh=JYRU0govN6PkzqrHGdzW0ReoXvfbnqAUCFw1nbSTRqc=; h=To:From:Subject:Date; b=386HN/h74BUESzKvH7jn/e50gx65ooYosIW8oAfWxnmRjvibyQ7l5yJRq4feA7yDx 1aRP6HIKsFb3Z22gClS0G/CXDD1ZmKr8KfW9nMP9AOesz152CboYVXpz84BY6UnEkA Ne3CkxV6Qs5L6E8mMEOI6chdH5AERRqa3CL0rtjo=
From:	cygwin AT punkapoule DOT fr
Subject:	Mariadb Server 10.3.14 crashes
Message-ID:	<df3d4723-e08a-4033-09d5-cda9eec4715b@punkapoule.fr>
Date:	Thu, 12 Dec 2019 16:26:30 +0100
MIME-Version:	1.0
X-MailScanner-ID:	8E0BF2EC4006.A2DEA
X-MailScanner:	Found to be clean
X-MailScanner-SpamScore:	ss
Note-from-DJ:	This may be spam

Hi the community,

I use mysqld-server 10.3.14 as a server for development and an alive
backup server (in a MASTER-SLAVE configuration with a MASTER on Linux)
When operating some changes on my MASTER, I have set the SLAVE (under
Cygwin) to be a master for my application. But I realize the daemon
crashes regularly with a really short message :191212 16:17:49 [ERROR]
mysqld got signal 11 ;

    This could be because you hit a bug. It is also possible that this
    binary
    or one of the libraries it was linked against is corrupt, improperly
    built,
    or misconfigured. This error can also be caused by malfunctioning
    hardware.
    To report this bug, see https://mariadb.com/kb/en/reporting-bugs
    We will try our best to scrape up some info that will hopefully help
    diagnose the problem, but since we have already crashed,
    something is definitely wrong and this may fail.
    Server version: 10.3.14-MariaDB-log
    key_buffer_size=32768
    read_buffer_size=262144
    max_used_connections=1
    max_threads=153
    thread_count=8
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads
    = 355869 K  bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.


So I tried to diagnose why it happened. I cleaned up the installation,
reset all the database, checked for mysql-upgrade, etc. etc. imported a
backup, and finally… found a query that crash this daemon.

I found that the first query below crashes the server, but not the
second (seen here with the query-plan) :

    SELECT DISTINCT ttrss_feeds.title, date_entered,
    date_format(date_entered, '%Y-%u') AS yyiw, guid, ttrss_entries.id,
    ttrss_entries.title, updated, score, marked, published, last_marked,
    last_published, last_read FROM ttrss_entries LEFT JOIN
    ttrss_user_entries ON (ref_id = ttrss_entries.id) LEFT JOIN
    ttrss_feeds ON (feed_id = ttrss_feeds.id) WHERE date_entered >=
    DATE_SUB('2019-12-11 17:09:49', INTERVAL 1 hour);
    +------+-------------+--------------------+--------+---------------+--------------+---------+----------------------------------+------+----------------------------------------+
    | id   | select_type | table              | type   | possible_keys |
    key          | key_len | ref                              | rows |
    Extra                                  |
    +------+-------------+--------------------+--------+---------------+--------------+---------+----------------------------------+------+----------------------------------------+
    |    1 | SIMPLE      | ttrss_entries      | range  | date_entered  |
    date_entered | 5       | NULL                             |    1 |
    Using index condition; Using temporary |
    |    1 | SIMPLE      | ttrss_user_entries | ref    | ref_id        |
    ref_id       | 4       | ttrss.ttrss_entries.id           |    1
    |                                        |
    |    1 | SIMPLE      | ttrss_feeds        | eq_ref | PRIMARY       |
    PRIMARY      | 4       | ttrss.ttrss_user_entries.feed_id |    1 |
    Using where                            |
    +------+-------------+--------------------+--------+---------------+--------------+---------+----------------------------------+------+----------------------------------------+

    SELECT DISTINCT ttrss_feeds.title, date_entered,
    date_format(date_entered, '%Y-%u') AS yyiw, guid, ttrss_entries.id,
    ttrss_entries.title, updated, score, marked, published, last_marked,
    last_published, last_read FROM ttrss_entries LEFT JOIN
    ttrss_user_entries ON (ref_id = ttrss_entries.id) LEFT JOIN
    ttrss_feeds ON (feed_id = ttrss_feeds.id);
    +------+-------------+--------------------+--------+---------------+---------+---------+----------------------------------+------+-----------------+
    | id   | select_type | table              | type   | possible_keys |
    key     | key_len | ref                              | rows |
    Extra           |
    +------+-------------+--------------------+--------+---------------+---------+---------+----------------------------------+------+-----------------+
    |    1 | SIMPLE      | ttrss_entries      | ALL    | NULL          |
    NULL    | NULL    | NULL                             | 5517 | Using
    temporary |
    |    1 | SIMPLE      | ttrss_user_entries | ref    | ref_id        |
    ref_id  | 4       | ttrss.ttrss_entries.id           |    1
    |                 |
    |    1 | SIMPLE      | ttrss_feeds        | eq_ref | PRIMARY       |
    PRIMARY | 4       | ttrss.ttrss_user_entries.feed_id |    1 | Using
    where     |
    +------+-------------+--------------------+--------+---------------+---------+---------+----------------------------------+------+-----------------+

I tried some things, like use the debuginfo package with gdb and saw
some SIGSEV, but I'm a dummy with that and I remain in the dark.
I tried to increase buffers, query buffers, join buffer, index buffer,
tmp table size, etc. etc. but always the same error.

Could you bring me some pointers or anything else to resolve this issue ?

Thanks a lot to u'all!

GT (from France)

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

- Raw text -