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 1qBL4Y-0006lD-Op for pgsql-admin@arkaria.postgresql.org; Mon, 19 Jun 2023 20:01:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBL4W-0004U3-F2 for pgsql-admin@arkaria.postgresql.org; Mon, 19 Jun 2023 20:01:56 +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 1qBL4V-0004Tt-RH for pgsql-admin@lists.postgresql.org; Mon, 19 Jun 2023 20:01:56 +0000 Received: from mail-yw1-x112a.google.com ([2607:f8b0:4864:20::112a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qBL4T-00373g-22 for pgsql-admin@postgresql.org; Mon, 19 Jun 2023 20:01:54 +0000 Received: by mail-yw1-x112a.google.com with SMTP id 00721157ae682-57026f4bccaso44100777b3.2 for ; Mon, 19 Jun 2023 13:01:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1687204912; x=1689796912; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=tUmCgTjhAC44Dua/mchUEeyRCM3GgoxcOwrvl3GrjUg=; b=YcBK8l/KteEECl51ry5KVl8yACeeHz2BYi77P+v/f12K4Ie+/pljV7WPniSpqqDcIJ 1ZexfUg7aZy8LbuASPaS+OhBrpAOlix9oGIm7Z9z/xkEtOn2mPYp7q3UomC89DPB2ttw oBmpMcLaHP9K4y9UAbg7Vonsq6yO3BHZateO0fYNF8vRhDij3x30XgYER2OxY14xobRL +pkmlaxmfz1NIDmHmCqI1BiWSd6fjkh6M5MZ1zIXUOhL0SXzMM68cWYxHvle9WZxs4WP eQuaLP2IzDmZ9DO+kMtFBMCUpuj+KP9Iv1Bb5Q/QQZSIgrn5PMyhVaTuMeMnIvIAHuIp Uqhg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687204912; x=1689796912; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=tUmCgTjhAC44Dua/mchUEeyRCM3GgoxcOwrvl3GrjUg=; b=jNivT9RqY5/NOdQ07+gkVsVQacNE/7ZeXdA0HsKjqicnxF0LpYAM12DZe/QGqSghta PCdYaO+jXUY2MQwIANVcaDsz5/3iqZ0M843iY6Lf7UfRcbbwcR1SMgHg0WDxvtDIuuy/ HIcpxmQMIPoklkYIQBBsd41mXPza9dIqU/ur+KDjoVUB/sVCTLN71k/RUq7tKvoO6Dp2 lUe69jIUVe/yvRksdLoXfmgFWdi+iO00Lxy/WSb6nwocl4cCFqc8nKgwGOayittrMDGv 3O+ddnH5gqlylTIjsFq3V05Yde2UwnUyba6dseHZZhdMZ56/qrOztd2cKWQ2wwUpUduO cKNw== X-Gm-Message-State: AC+VfDzl/rs0eSHJzrvvo9nHZnxSN6iVxgn918rroMTBuMXlbL9tWKzc OGbLwkBL5aEI1RL7fZ1Z4loCJshKkFh+ZkgdbL4= X-Google-Smtp-Source: ACHHUZ6cbLVHNvU8eiMxuyW7EqFJiCuQV7nSfx0QJF4+Y0TIXr62KNtDWpM0vC2xa8RCveXb45Urmw== X-Received: by 2002:a81:7bd5:0:b0:56d:2dd6:c5b3 with SMTP id w204-20020a817bd5000000b0056d2dd6c5b3mr10096679ywc.31.1687204912188; Mon, 19 Jun 2023 13:01:52 -0700 (PDT) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id j206-20020a816ed7000000b0056d2eb86724sm112033ywc.142.2023.06.19.13.01.51 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 19 Jun 2023 13:01:51 -0700 (PDT) Message-ID: Date: Mon, 19 Jun 2023 16:01:51 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: What does invalid_transaction_state 25000 mean Content-Language: en-US To: Debraj Manna , pgsql-admin References: From: Joe Conway In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/19/23 15:35, Debraj Manna wrote: > Can someone let me know when Postgres throws an > invalid_transaction_state, 25000 error ? Multiple reasons. What error message do you get? Maybe this will help you figure out which case is applicable: https://github.com/search?q=repo%3Apostgres%2Fpostgres%20ERRCODE_INVALID_TRANSACTION_STATE&type=code -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com