Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h25MP-0006NN-Kz for pgsql-admin@arkaria.postgresql.org; Fri, 08 Mar 2019 02:35:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h25MN-0006sV-J9 for pgsql-admin@arkaria.postgresql.org; Fri, 08 Mar 2019 02:35:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h25MN-0006rx-7W for pgsql-admin@lists.postgresql.org; Fri, 08 Mar 2019 02:35:43 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h25MJ-0005HA-Qn for pgsql-admin@postgresql.org; Fri, 08 Mar 2019 02:35:42 +0000 Received: from [192.168.127.1] (port=33018 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1h25MF-0000fD-1v; Fri, 08 Mar 2019 02:35:35 +0000 Received: from [127.0.0.1] (port=26161 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1h25ME-000EnB-7T; Fri, 08 Mar 2019 02:35:34 +0000 From: Andrew Gierth To: Peter Cc: pgsql-admin@postgresql.org, pgsql@FreeBSD.org Subject: Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible In-Reply-To: <20190308012012.GA49481@gate.oper.dinoex.org> (Peter's message of "Fri, 8 Mar 2019 02:20:12 +0100") Message-ID: <87pnr2ayyd.fsf@news-spur.riddles.org.uk> References: <20190308012012.GA49481@gate.oper.dinoex.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Fri, 08 Mar 2019 02:35:33 +0000 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Peter" == Peter writes: >> You can check whether your CPU supports SSE2 by looking at the Features= >> line in /var/run/dmesg.boot. It seems unlikely that it does not, because >> SSE2 was introduced in 2000 with the Pentium 4. Peter> No need to check; I am absolutely certain that it does NOT. Peter> https://www.asus.com/supportonly/CUV4X-DLS/HelpDesk_CPU/ Peter> But, Your explanation seems not to answer the fundamental Peter> question: if the database at 10.6 is still supposed to be able Peter> to run without SSE2? Yes, the database is supposed to be able to run without SSE2, as long as it is built with gcc and not clang, and without any architecture flags that imply SSE2 support. I'm pretty sure nothing in our buildfarm is i386 without SSE2 though. Peter> Whateever information You like to have, just ask and I will Peter> gladly do my best to obtain it, as I get around. (This is a Peter> reproducible on a very well maintained piece of software - this Peter> is rather fun.) Your backtrace implies that you are running with checksums enabled; true? You should be able to build the port with debugging enabled by setting WITH_DEBUG=1 in the environment or on the make command line. (I have not yet tried this myself - I rarely build from the port.) Peter> The crash happens at a specific query - I get parse,bind, but no Peter> execute timing. What is the exact query? I'm doing some investigations of my own, I may have more questions later. -- Andrew (irc:RhodiumToad)