Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdnym-004nCw-Cl for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 08:33:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qdnyk-008KnB-0z for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 08:33:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdnyj-008Kmg-K5 for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 08:33:37 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qdnyg-0031Yo-AQ for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 08:33:36 +0000 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-401f503b529so33441255e9.0 for ; Wed, 06 Sep 2023 01:33:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693989212; x=1694594012; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:reply-to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=R92MrNNJ7k+xTKhMZBG5YdWPVliHBsa3PrnFoQMkdHI=; b=Ekw2XgzCg0dcEcBNjPTutsm7RzYoHJFBGyd2iMF581ESkUHho0ft0ZB6aG5JByhs6P jJpHrPhw+K9gK819y4A1C3Bgvzt7dcwg7JdjCLKk+XT9QfP+RoUBVz7EPgKmgAxj34Lc e+W7ybOevAv459TvRcZBwrgWx//sjOWj5w8Qmd+4dbtMmycI/iZE5TEPIf2+Sdv7SjJ5 MElw0ZB+q1BlocN48rvMLhEYrX9HNk4BJqnVR/uY7J7KZSd/bZcjLJ9JdvwJqt7atccF /TVNp7juuTUkNvk8xAxBgYPu/joT7MBrhh9uDRyv0cFqYQfCa2wHGmBqWm9476HATerR YDHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693989212; x=1694594012; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:reply-to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=R92MrNNJ7k+xTKhMZBG5YdWPVliHBsa3PrnFoQMkdHI=; b=XVd8x+jn28xjKZcJsxi8TQEmOJgyl+lUI/BR8ggs72kB3dvbi0Cle1+F64sqKgg6FF pF5Jw1E0pQ9IillINHxRntRgMxnE1/2Y5xpTs379TImcI5RSjy1hiasfUHaQf6XwEbwU tw0FEMYiolD9dWpzQiRL3imsfM8XAZnSDvdJkFmqEupuNeCaUhi4TJ7HD0tATxW24GOY UKD4xIP30JZIobOeBQU1koj5hAtFOHl4Kz1PC+IKJYjlK6RdbST0MNvVoiIrXe4FmTVI s+Jmnb6zrOl15LHt54niRxrkcRdcHZZLUadxN1rtbkbrvfyqJbv7z/Eel9WaMo/sQ6/W a5zQ== X-Gm-Message-State: AOJu0YwU/iqPYYK5yJbJvh6kAJtseK9aL7h1cDnh19YNBoGffWEYslAH 7i8pVhtJvbV7vpxVOu4P/h3bE+n3YOc= X-Google-Smtp-Source: AGHT+IGyg3mSf3eLnoKXxIfF53xZWpJYRftNKOr/kE4HVxMOQhHS6daqgkzvSZi4/dMXHHaTyTDQhw== X-Received: by 2002:a05:600c:2488:b0:3fe:228a:e782 with SMTP id 8-20020a05600c248800b003fe228ae782mr1687023wms.37.1693989212547; Wed, 06 Sep 2023 01:33:32 -0700 (PDT) Received: from ?IPv6:2a01:50a0:1047:130::a696? ([2a01:50a0:aa:0:185:40:248:10]) by smtp.gmail.com with ESMTPSA id t4-20020a1c7704000000b003fefe70ec9csm22194502wmi.10.2023.09.06.01.33.32 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 06 Sep 2023 01:33:32 -0700 (PDT) Message-ID: <8af28a305839719a496be84d18c15a2525e954c8.camel@gmail.com> Subject: Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" From: Torsten Krah Reply-To: krah.tm@gmail.com To: pgsql-general@lists.postgresql.org Date: Wed, 06 Sep 2023 10:33:31 +0200 In-Reply-To: <914c8b13fe9c1fb41a3b673b59813a210c72c92f.camel@cybertec.at> References: <959e9b03415d2ac683d67059f74d0377f64b03f4.camel@gmail.com> <914c8b13fe9c1fb41a3b673b59813a210c72c92f.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Mittwoch, dem 06.09.2023 um 10:21 +0200 schrieb Laurenz Albe: > You are lucky that the corrupted table is one that holds data that > can be rebuilt. It is a test instance / container anyway which is deleted afterwards and can be setup again as often as I want. But how is that corruption happening - I mean it is a docker image, freshly fetched from the registry. After that I am starting a container from that image, (re)importing data (different tests =3D> different data so the cycle of delete data / import data / analyze the data happens quite often) and running my tests. The OS does not report anything which would relate nor does any other tool / system fail nor does postgresl itself fail on any other table here - it always fails only on that analyze part. That happens all in about 8-10 minutes for the whole process - what is causing that corruption in that short timeframe here? regards Torsten