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 1qdpoY-004tAj-8R for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 10:31:14 +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 1qdpoW-009DJy-Si for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 10:31:12 +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 1qdpoW-009DJd-Gl for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 10:31:12 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qdpoP-0032il-4G for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 10:31:11 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-4ff8f2630e3so5836302e87.1 for ; Wed, 06 Sep 2023 03:31:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693996263; x=1694601063; 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=TYUGfkwVPA9iKEhIKUruCSCOC4DLy4HvccxIVxEvC9E=; b=NeglHgKQkPLcF9AW/By5Ao1LJgqWQTG5KzF3QQ9Vz1hIwUmIkxuDAxyFYE5KXnAngG WllzyRE6s2O1x1YSpPC8S8cSO5NhcLqWMtxA9gr1Ym8wBKtpzYttJWIKvc2Hz2tfqLmm H4FmF1MuZZ3GUdkgs2Ozmgfddu0/Z+/jU8qDiwcZBNTEGtW3ha5pczigEhrreKVFIMED CB5MIDVTV7SGwNCev+5nTwz6e+NHLYMKeAA/xI0l4H1rd88/PDOrm3TUiUmQbLVr4vI+ 5oXRbmb2Q8wtEXivEIWSFYan1tZdqy2LoSNXKDoI/aMeEiRHlowx+EPAFXD9lxxpV4v0 d2vA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693996263; x=1694601063; 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=TYUGfkwVPA9iKEhIKUruCSCOC4DLy4HvccxIVxEvC9E=; b=WJWgf5qHewk+iNP+LscTRQwIm+oQ2v/tAYic5FDoqDdxr5LkJpgV07+AmXpPIGq1RT EAIoA78CPsOMVPUAsBLKtXKHM+/K3sFl/hxmaUm/r5zy5n1CD1all//Bwf/zFJnqmKCQ A2vsExU/j+e85ZtBFbOULgRtedqSQre32DVmmIK5BDk1ngWE1GB5y5dkfA+m8U1p7nYW 7JBtW1uadbF6G5bVXL+ljF5gWEmfdFo4OH1w4INiKU85T8jaCxiVtFkqkqsTeit7GuM1 SppaNd0eJKBds2YvNaKwdOLeVRbohIWvkXCHLx/9LUcqce7kJQ4w2mODLEdnqMsmVX6X nbNQ== X-Gm-Message-State: AOJu0Yw95YWGQvz66DoJG9YV0rA3dXhHeBDyEQuTvfp12/jTRovudklc AeiNsfx4K505U2UjsprQJVAD2rKbcgs= X-Google-Smtp-Source: AGHT+IHt18oyp6aexOC5I1TCikrdEvO8ckYkXYzedGM0rK6GNOAC///cxQIUu4FrJ9fZQgEjrZL+Yg== X-Received: by 2002:a05:6512:758:b0:500:8f66:5941 with SMTP id c24-20020a056512075800b005008f665941mr1739460lfs.50.1693996263072; Wed, 06 Sep 2023 03:31:03 -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 m13-20020a7bce0d000000b003fed630f560sm19522550wmc.36.2023.09.06.03.31.02 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 06 Sep 2023 03:31:02 -0700 (PDT) Message-ID: <1f2cb140b4b85a24a229f13ec559605ac8b5a180.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 12:31:02 +0200 In-Reply-To: <267004756.331292.1693994690228@office.mailbox.org> References: <959e9b03415d2ac683d67059f74d0377f64b03f4.camel@gmail.com> <267004756.331292.1693994690228@office.mailbox.org> 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 12:04 +0200 schrieb Erik Wienhold: > > I am running that one (official docker image) > >=20 > > PostgreSQL 13.11 (Debian 13.11-1.pgdg110+1) on x86_64-pc-linux-gnu, > > compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit >=20 > Have you also tried with 13.12? Yes, but it did also happen on previous versions before 13.11 / 13.12 sometimes (I just ignored it until now because it happens so rarely). >=20 >=20 > Does the unique constraint violation always occur for the same row?=C2=A0 > OID 2609 > is pg_description. As I don't have a reproducer yet (I did not track stats but lets say it runs fine for 100 / 200 times and 1 or 2 of those are failing with those mentioned analyze errors - it may even be less than that) I can't tell you if it fails always over that OID - I need to wait for it to happen again, I will report here if it is the same - may take some time ;). Torsten