From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from mail-il1-f176.google.com (mail-il1-f176.google.com [209.85.166.176]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by smtp.subspace.kernel.org (Postfix) with ESMTPS id 7F6DF1CEE9A for ; Thu, 23 Jan 2025 20:26:30 +0000 (UTC) Authentication-Results: smtp.subspace.kernel.org; arc=none smtp.client-ip=209.85.166.176 ARC-Seal:i=1; a=rsa-sha256; d=subspace.kernel.org; s=arc-20240116; t=1737663993; cv=none; b=FRDunz2BijM4I9DdVGTFyWdngBauB6HiyJZVivV8BjId0uMY7LDoMz0pbFk6uu9y0Z9rEMjb0uMdnqi8wlx1ymrbeQX+3VnLl8CoLzQ3NrZT0JvvdBNhBryTlPst2GjGuXgmpqVeOWel6Eg5+/uCp4k+xcgpAEyq6aCxKzwMHe0= ARC-Message-Signature:i=1; a=rsa-sha256; d=subspace.kernel.org; s=arc-20240116; t=1737663993; c=relaxed/simple; bh=XLXuVqHtZFEB7bPFde0vj33ievU7lEE8M2zClCjuLDM=; h=Message-ID:Date:MIME-Version:Subject:To:Cc:References:From: In-Reply-To:Content-Type; b=jwaFBSh+VZxejiU41y0dXF59iI3R8IGYjBYnPOQIGLmVJbHvWPQa4NphCMBzai5sgwCsHCnEWubVJExArOMt+jh2goD8Ex7mafFrQSnHRDxthS2WsCM5sexF+7+mJ+cQZfmy0UHN/eTKctd3K7KeYKe6ck5QM6R71eFiHl6OmHw= ARC-Authentication-Results:i=1; smtp.subspace.kernel.org; dmarc=none (p=none dis=none) header.from=kernel.dk; spf=pass smtp.mailfrom=kernel.dk; dkim=pass (2048-bit key) header.d=kernel-dk.20230601.gappssmtp.com header.i=@kernel-dk.20230601.gappssmtp.com header.b=K8bMXIQl; arc=none smtp.client-ip=209.85.166.176 Authentication-Results: smtp.subspace.kernel.org; dmarc=none (p=none dis=none) header.from=kernel.dk Authentication-Results: smtp.subspace.kernel.org; spf=pass smtp.mailfrom=kernel.dk Authentication-Results: smtp.subspace.kernel.org; dkim=pass (2048-bit key) header.d=kernel-dk.20230601.gappssmtp.com header.i=@kernel-dk.20230601.gappssmtp.com header.b="K8bMXIQl" Received: by mail-il1-f176.google.com with SMTP id e9e14a558f8ab-3ce868498d3so3974365ab.3 for ; Thu, 23 Jan 2025 12:26:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kernel-dk.20230601.gappssmtp.com; s=20230601; t=1737663989; x=1738268789; darn=vger.kernel.org; h=content-transfer-encoding:in-reply-to:content-language:from :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=hiEhNnCHIvd1kMhTIZJjRFXfBjI32La/iI76KUOi0lo=; b=K8bMXIQldVdg5lldddvfK8/4V0Q3wQRUuflBt/uh6MUGn1EnCMYV5z1QjmzBPlJxjD y2niN/BWCXOEXWdgJXkhtkCzqrBLHTbfizCcgjSRxqOKwADudstg22v891EBTwFcrVsB ecpYdWnkhRTJyV5y6SCW2E+IcEv67UCb7XkQTILW9y9/qCSn8mFDCwqSJMchLR8eL2yp y0PAhDaDF4sQ+fdi20HcKrjjHdYevWnEQAuIQDgoF6qx1aICtLIUeayAwik+arosfiHh W4kxcjalbBxea7QYfKK2Y4n/VWTOF8RHZMkyXedzLMM95mqyJcXNQMXM4Z8edGKDthdH qwdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737663989; x=1738268789; h=content-transfer-encoding:in-reply-to:content-language:from :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=hiEhNnCHIvd1kMhTIZJjRFXfBjI32La/iI76KUOi0lo=; b=BKXo5HHPZ+mJkkN3+fefiTx3s4L8BBVKKnb3WoatIefbHfWdQ/qK21ypg7teEyBbfB sS3dlulQSjgDJhFXfOxo+D1D2fWVKKH/LEHG0mSbsBMHG2FLdHzv80g3BjiV5STDalf3 N1tfQ00V2ZBYwRG3MzkcttFA4F07feNnE4CzMHEaIrY2MtenhjJCaJsKvb84eqZrtHhK 29cA7BzriklmT9Jio6mRYdrE5tPXTINQ+okCUaGefHg1Xk3bKKViKTEnPkfmP5l3Knzh etstFok35nSlbsDQn9gbQmknbj0tc9O15gBMh5hirJOuujcxbrmezZ0OCUer8ZDZ3G1P 7E4Q== X-Forwarded-Encrypted: i=1; AJvYcCVu1W5qTxQDm0J33hQz7ASRD6YQxClP7HRll2tkKWTSAKTLnkBeO2T75gSg23XiWSIXVTjw9dXi5P3KmCg=@vger.kernel.org X-Gm-Message-State: AOJu0YxSROIC+jbgoQO5j18LoMlK7QpAjbEQbc26up+mLV/alXAGp612 jEhjQz6xsrp9MCMqkbfKoR1v/ZFZlC2HVxVvwp8wSDQTNL5VMbgoz7ea0JqJg40= X-Gm-Gg: ASbGncsItXVz8IQ0HscwgOXKWd+RkAIgMLnPv7aAhbBGu7e8x7PC5gsXjbrzUxI/Tnb fR6ZId/VL4QcihSf4wWUWCSBdPjUSFvysIx2j+HBqxqlpzv6ieTQvIi7FOGlh+Z3JoP6/MCmvql 1IxUFGOCarrnHEwMSuINF8LuZgtkJ+mxywJmNbRRcNXOJLtkMEoJDVpQlVOJ6Zr0dVK0LgOT0zC GAYgxIe39adY/anMbZlaR2iaVlHovMQf1RfUMiJUFOA4qiJTV5MyXFkV9/ELwHm0oC02//0fov9 X-Google-Smtp-Source: AGHT+IFcjBPLY/Xa4hYE3eyEOrKh2Os0wuPqUC3HbAyWGwOz4XCQxm0BUTtuOLLAae0AdjLSZ+8oxg== X-Received: by 2002:a05:6e02:2161:b0:3ce:4b12:fa17 with SMTP id e9e14a558f8ab-3cf7449dae5mr228171765ab.19.1737663989180; Thu, 23 Jan 2025 12:26:29 -0800 (PST) Received: from [192.168.1.116] ([96.43.243.2]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3cfc7504fd7sm1527945ab.60.2025.01.23.12.26.28 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 23 Jan 2025 12:26:28 -0800 (PST) Message-ID: <79efe5a3-00d4-4242-aee9-6cb2ccc56090@kernel.dk> Date: Thu, 23 Jan 2025 13:26:27 -0700 Precedence: bulk X-Mailing-List: linux-kernel@vger.kernel.org List-Id: List-Subscribe: List-Unsubscribe: MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Bug#1093243: Upgrade to 6.1.123 kernel causes mariadb hangs To: Salvatore Bonaccorso , 1093243@bugs.debian.org, Bernhard Schmidt Cc: Pavel Begunkov , io-uring@vger.kernel.org, linux-kernel@vger.kernel.org References: <173706089225.4380.9492796104667651797.reportbug@backup22.biblionix.com> <173706089225.4380.9492796104667651797.reportbug@backup22.biblionix.com> <173706089225.4380.9492796104667651797.reportbug@backup22.biblionix.com> From: Jens Axboe Content-Language: en-US In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit On 1/23/25 1:05 PM, Salvatore Bonaccorso wrote: > Hi all, > > On Wed, Jan 22, 2025 at 08:49:13PM +0100, Salvatore Bonaccorso wrote: >> Control: forwarded -1 https://jira.mariadb.org/projects/MDEV/issues/MDEV-35886 >> Hi, >> >> On Tue, Jan 21, 2025 at 08:06:18PM +0100, Bernhard Schmidt wrote: >>> Control: affects -1 src:mariadb >>> Control: tags -1 + confirmed >>> Control: severity -1 critical >>> >>> Seeing this too. We have two standalone systems running the stock >>> bookworm MariaDB and the opensource network management system LibreNMS, >>> which is quite write-heavy. After some time (sometimes a couple of >>> hours, sometimes 1-2 days) all connection slots to the database are >>> full. >>> >>> When you kill one client process you can connect and issue "show >>> processlist", you see all slots busy with easy update/select queries >>> that have been running for hours. You need to SIGKILL mariadbd to >>> recover. >>> >>> The last two days our colleagues running a Galera cluster (unsure about >>> the version, inquiring) have been affected by this as well. They found >>> an mariadb bug report about this. >>> >>> https://jira.mariadb.org/projects/MDEV/issues/MDEV-35886?filter=allopenissues >>> >>> Since there have been reports about data loss I think it warrants >>> increasing the severity to critical. >>> >>> I'm not 100% sure about -30 though, we have been downgrading the >>> production system to -28 and upgraded the test system to -30, and both >>> are working fine. The test system has less load though, and I trust the >>> reports here that -30 is still broken. >> >> I would be interested to know if someone is able to reproduce the >> issue more in under lab conditions, which would enable us to bisect >> the issue. >> >> As a start I set the above issue as a forward, to have the issues >> linked (and we later on can update it to the linux upstream report). > > I suspect this might be introduced by one of the io_uring related > changes between 6.1.119 and 6.1.123. > > But we need to be able to trigger the issue in an environment not in > production, and then bisect those upstream changes. I'm still looping > in already Jens Axboe if this rings some bell. > > Jens, for context, we have reports in Debian about MariaDB hangs after > updating from 6.1.119 based kernel to 6.1.123 (and 6.1.144) as > reported in https://bugs.debian.org/1093243 Thanks for the report, that's certainly unexpected. I'll take a look. -- Jens Axboe