From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <kiizuha@gnuweeb.org>
X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on gnuweeb.org
X-Spam-Level: 
X-Spam-Status: No, score=-1.8 required=5.0 tests=ALL_TRUSTED,DKIM_SIGNED,
	DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,NICE_REPLY_A,NO_DNS_FOR_FROM,
	URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.6
Received: from [192.168.1.2] (unknown [101.128.125.209])
	by gnuweeb.org (Postfix) with ESMTPSA id 1F52A7E24F;
	Sat, 24 Dec 2022 23:34:13 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gnuweeb.org;
	s=default; t=1671924855;
	bh=JsjUiueLVaKBJSk8bMzFT/Mt0H8Cl/OdUQsVIvIRSts=;
	h=Date:Subject:From:To:Cc:References:In-Reply-To:From;
	b=Macm935LpAlwsA2UuUeZfCiCLO2XFORgXY7ueP04NE3nFg7NQsQHbfX+nUY1eC/pH
	 EKWPyiJWsOdukIonK3DSwvgqpMkodXhjtejvG0l9z0l2YtH8IIpTQ105uZfzQ/PFP3
	 67e52FCSZDxC3NiesVhTmrBj4eBpJ2xIU4cHEOH9UQGyVnvI7nNcTsdJs9IbrZpOeV
	 pZXVBlMV0aF/ccierkmGu+pIHZz1VWh7O+gIZY1w1YAKy4Vj9UJJbBgVCISDBN34LO
	 KPUJF64yl1L6UV0JUCcbXxWjb1KphT3Cre8rmonu8qoZ3po3C/P3NGdKbB+oR+j0vt
	 ckbEOsbAg04AA==
Message-ID: <02c3ed03-d2c9-2980-dd0d-eab304fad7db@gnuweeb.org>
Date: Sun, 25 Dec 2022 06:34:11 +0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
 Thunderbird/102.5.1
Subject: Re: [PATCH v4 00/17] Fix, improvement and implement a bot logger.
Content-Language: en-US
From: Muhammad Rizki <kiizuha@gnuweeb.org>
To: Ammar Faizi <ammarfaizi2@gnuweeb.org>
Cc: Alviro Iskandar Setiawan <alviro.iskandar@gnuweeb.org>,
 GNU/Weeb Mailing List <gwml@vger.gnuweeb.org>
References: <20221221013347.1704-1-kiizuha@gnuweeb.org>
 <a7bdbb0e-d4d8-516d-059e-ae76f25ba18a@gnuweeb.org>
 <09cf5444-3e42-9e58-ecf0-a4b21e5da953@gnuweeb.org>
 <489c62e6-b61f-61b9-8209-f098c8eb900d@gnuweeb.org>
In-Reply-To: <489c62e6-b61f-61b9-8209-f098c8eb900d@gnuweeb.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <gwml.vger.gnuweeb.org>

On 25/12/2022 06.31, Muhammad Rizki wrote:
> On 25/12/2022 04.09, Ammar Faizi wrote:
>> On 12/25/22 4:05 AM, Ammar Faizi wrote:
>>> On 12/21/22 8:33 AM, Muhammad Rizki wrote:
>>>> Hi sir, it's been a long time.
>>>>
>>>> This is a v4 revision of fix, improvement and implement a bot logger.
>>>> this series is to improve create_template() caption substr/trim,
>>>> prepare_patch() for the .patch file payload, remove unrelevant 
>>>> changelog
>>>> commit in the commit description, use html.escape() once instead of
>>>> twice, small change in the first commit to make it clearer.
>>>
>>> I applied this series. But I have an issue with the Discord daemon
>>> when I restart the MySQL server. It can't recover from MySQL restart.
>>>
>>> When you restart the MySQL server, it's always looping in the MySQL
>>> error and keep sending the error log on Discord:
>>>
>>>     "Lost connection to MySQL server during query"
>>>
>>> Can you please fix it?
>>
>> This happens on the Telegram daemon too. I thought I fixed it in:
>>
>>     529d804eb47518 ("daemon: telegram: Handle MySQL error")
>>
>> but somehow my fix is no longer applicable on top of your series.
>>
> 
> Can you give me the tips how to reproduce this error? Or I must wait or 
> idle the bot? Or I just disconnect my internet and then reconnect and 
> see what will happen on MySQL connection?

https://sebhastian.com/lost-connection-mysql-server-during-query/

Or you can just set the connection timeout instead?