Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mig07-0007gN-I6 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Nov 2021 16:54:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mig06-0005cA-0e for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Nov 2021 16:54:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mig05-0005bz-KU for pgsql-hackers@lists.postgresql.org; Thu, 04 Nov 2021 16:54:05 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mig00-0005nW-AU for pgsql-hackers@postgresql.org; Thu, 04 Nov 2021 16:54:04 +0000 Received: by mail-io1-xd29.google.com with SMTP id y73so7672635iof.4 for ; Thu, 04 Nov 2021 09:53:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=bfqsro8NrG7pHts1texLFm9jRxtq+TbeQtk+gssiq/I=; b=cMhYDCG7t6Z4AwCx/ooUU2TGcaz4D8lgEeNObAlP3YBGDOLQyg5bhAe+NWW7ZlQlLP FbA3yoEhXiHlfD8/JZFTYZ9v5YT9nd92rVwaMBXbn7F85Xg6JYjFyZD5WGtXiUZIxZrr V2tDOZgO/8xSRMH1DGQOHW9npP8vrxgU0uI6KPnrfBn5wcyAhrSBBSm0AN2l+wrMr423 1cUDZ/2A5VjHcPWUKq9DViFNen0pSqBbicmccE7ZTtI1E2NEFWj0fRW2FxxTCW5FynEs QaYrZR2z4sQa0UKFmDtuGYN7nDn0iiCPc/fKKNGXGaNGFgDlBTMoAdm5GgnKCgS35Uz4 FBcA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=bfqsro8NrG7pHts1texLFm9jRxtq+TbeQtk+gssiq/I=; b=QsPbHFAxou+RJUhaXZT9XoUgRjAHsYLHZDCVJeJCZksEMu7zuGlNStHdIUBUO5iKXQ 8UCBOIGv0m6Bp9haUFN91ZzsZ/ACIXgz12oKMJZ6kWgDUfk6ax/H2CRR9wwE8nSb8gfG DWRQJ0fn9QnkzrREiKxc8d0PdOXdDH7JyhVDO+pi3erdCIBImR2smyvZqFhdzauzI3RM Gw7tXzoWGaKlYIR+RFhp7RgRFZIvlXkb5sqg0WVLh6HwfSyOC0XvToqNutAUrafg5DmG G/cKKHtkHSfuPKWwq9bZD0dXg+bMv61CqDec7S8vVrRfeWC5VEmcBEK8FL5YDS7QL28b V0Nw== X-Gm-Message-State: AOAM5309Uqc53CUziFoWHAZ6ClGvGXEWNgJZ+aKupRKESar+YSyFPVUc WzptUcgIsj5B5/aQSyOn6DB3gg== X-Google-Smtp-Source: ABdhPJzPwJNTMeZE45Xu7mWCImDkwKlIMSS5YoQdlM72bqDkUQkzwROF5ZZQDYddlKiW3uL3V6A5wQ== X-Received: by 2002:a5d:994f:: with SMTP id v15mr38910202ios.88.1636044838749; Thu, 04 Nov 2021 09:53:58 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id q8sm1942225ilv.48.2021.11.04.09.53.58 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 04 Nov 2021 09:53:58 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id BF6FB800870; Thu, 4 Nov 2021 11:53:57 -0500 (CDT) Date: Thu, 4 Nov 2021 11:53:57 -0500 From: Justin Pryzby To: Andreas Seltenreich Cc: pgsql-hackers@postgresql.org, Jaime Casanova Subject: Re: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE Message-ID: <20211104165357.GU17618@telsasoft.com> References: <87r1bw9ukm.fsf@credativ.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <87r1bw9ukm.fsf@credativ.de> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Nov 04, 2021 at 09:46:49AM +0100, Andreas Seltenreich wrote: > sqlsmith triggers the following assertion when testing REL_14_STABLE: > > TRAP: FailedAssertion("a1 <= a2", File: "brin_minmax_multi.c", Line: 1879, PID: 631814) > > I can reproduce it with the following query on a fresh regression > database: > > insert into public.brintest_multi (float4col) values (real 'nan'); > > The branch was at f6162c020c while testing, backtrace below. I couldn't reproduce this, but it reminds me of this one, which we also had trouble reproducing. https://www.postgresql.org/message-id/flat/20210913004447.GA17931%40ahch-to Could you send a "bt full" ? > (gdb) bt -- Justin