Subject: Re: tuple concurrently updated
References: 
 <1378566276.366027624.1535454005687.JavaMail.root@zimbra82-e14.priv.proxad.net>
 <12cf1bbf-be58-bd2e-af34-85e72592a866@posteo.de>
 <CAGHTAeMDw7Qd6zkwkxYb36BHGaoCPXk6Q-a8MCNkyT8FOrkbKg@mail.gmail.com>
To: pgsql-admin@lists.postgresql.org
From: wambacher@posteo.de
Openpgp: preference=signencrypt
Autocrypt: addr=wambacher@posteo.de; keydata=
 xsFNBFsF9hIBEAC4W3M068RHHa+QJ3GjfG8n+sSUenUmRP0YCBL0X9FZfMRk328cXXs2qFP4
 yqoegbbRmxC4jUHCrMaPdnRGugW8ZRnyoiKYZrmffx/SzB6kZzdS7RCIhYY3pHLUEd5TIFPG
 Z2Plr6s1TpwVZc4Gkk9Uj4vGcwzDlUB7feurBpMdKaOfYz53vNXnh0C/e/fg7jx8rw70zM7z
 UDKcttHshsUUscL4tnYqH4mt2svJ8jmCwpesehjxgywTjxF8vPqr3G2KQ8cW2HbISp1q8gZQ
 vbXycBZ8Ej5GKsKkYLUP4bN6wfPE1sWlmD3Y5xilYNsDJkREFTQOqpJCoeMROcLZSdpv058Y
 nKRVVPKaD969nRl8lnMgPEkDOSv5V+IhSebQEFX7vnSkZp/4kETy4NsAa89I6ATBt4H5McQL
 3Py46INBbn7cH3k4Vljf8R1qvWYltM9aLZp3HbmKyRl0c5DSRSzKm7jCspmaYQ6pxZfLAx9M
 HRp2m3tIZPF+o8r8LukVS4Ji/8pXu2Tubd1rpkWwa8P6DxE0ZZGXYEnn7iYQuBn1sOYU2PBG
 xo/EA2lYx/EfeMDvjFV0ZB8DafROff4pb1mvuTA8m8gyUwa2leCNFg17PqYI/k4zCsGO21Vg
 qKc2K2rzm9azfX6nPvfcQHZtK55ek9m/0cP0pCsi/3v75vypewARAQABzStXYWx0ZXIgTm9y
 ZG1hbm4gPHdhbHRlci5ub3JkbWFubkBwb3N0ZW8uZGU+wsF9BBMBCAAnBQJbBfYSAhsjBQkJ
 ZgGABQsJCAcCBhUICQoLAgQWAgMBAh4BAheAAAoJENd8FQK2Z0Eya2oQAKp/5yxEPPyflX2o
 dLoPMdPPvZoTDG/PMGbLYqJ8jRPnIcopFCCu07LZDwS9rDjQEnMaDagdvxSHgVprdiJ8BUum
 9UK5WDNj++a1tY20DwjVDNOBpZisF3W4GZ+89JIU9710HxcGr0JC2UV99I4IbPbanm5PLAgT
 csyeDWT5e8EXEPS/BF5adQQH86SsTwKEjQtxtzoI9bNWfEbWvS5ZE0ATGQYtjAilQl/QuFN8
 LjdDkAUVTbQbR02I1r9jjpYWv0qCa043FifP0CSosKqOyPbTibvV+FYlMj2c9dj955MJ/BJB
 QvgEXmNRTN4vsZJEm9u+onJ0NAR2sNPvezIwuOX4mQcUsiDYQAit+MicjS9dJLeMnvcWFuBy
 boPdNopV2PjtkCzaLOD0jQ01drIBKLIkTGElPSl+EwhwX5PH+XzXY/f8KHIyGsJ9Fi9JZJDS
 qbFuYNLmIwWqdtvMECF5Cwp1g6UZeFX70ALo82sc/EYfnpfDnLUfTeayWkNDp9xsZMOuLk5M
 O+s+8tH1tJcIc3YEtVg8M+QZYnweTDoOZOgxsJuePvtMnQl1T5gXHA1W5YT6lrpiLaN2BZfO
 vjLyb9I+6hMYNtsqnGVP7gADLWIxqG5D8PZ1WYqsDTCzwKHZuasUnc+agOYbUKMo6DSo8g/I
 zMbF/dkpxD/6UPwRfMltzsFNBFsF9hIBEAD038KpaE8OkPi9/dMaEewlz95rbDvSaUSxCm3w
 vNnrDRTqiophHoxXYjrrpeS9YPlkjscVYWRSw2Qqf2QYcFexv+8bGjZO1tYTDgLkdfPXrnO+
 2i9xy4dGLHEZRIcyZsS7J46fg9e1Ir6U8nFdAjXW7d/QBWh09QujZ0WXnajuQBeWfDNfKD6V
 4+xV+xLndgvQ5elddSqjz6pV4/TcEtjgNg7dB/2cA93sUbikPyHG6jUSncYsa9I4zU94+CNh
 jUl0WUdcZl9+hRkzzkbxqWD9lxtsWjweN2bcKKpZ3tEVs3mALJauQc2FZMlKCF9fNuJwN9wx
 Ub1+uI/jBpi1OuuCNfHm/ChpLiiDVRPp/e/t8rNHcagN3hjrP/vBtzqFD6DFWxwZnIQEtoc/
 P4K/RythMp07Xdfz2qjSXS2VGVmxgzGStjg6BlGXM3QDqgQt0heZqMWEj5+F7NVipN8ZFxmg
 rNoViVzqf24k5qwK3EQAUdXKj6UxIocAgJsZ6iE+QDKfd1OvXpRehpnq6/PSji5OZJ0S/QHB
 +NOs2BU7glMBcePgfagqxAWeD4ZZtt2iONyrt15ukAO/kmNZDdMBmz/6Fq75tqXRROl4CYuA
 y3ImcQ4r1rFuZTNmydVUM3uV8hOS2j5o3HjsHa91wyeCw4Ms2VkZlxfi4izFP/Yx9gWmFQAR
 AQABwsFlBBgBCAAPBQJbBfYSAhsMBQkJZgGAAAoJENd8FQK2Z0Ey3egP/jsLqXgKDTGOetw6
 zOx+Y2o1XaL1/ov2yx5oSK9d5OagcSpby31eZbd17BkTz2ZV2S7RUoBN7F0JWfs41YkHkvF9
 2+ANexNMXnTNrFBemxP2GB7C2MGFVwOhbYj8OhygLIukEtYbSktNBe+CPD76UynvPh2O8aGn
 f7IibXMntgOc/qm3olXNknZfcXc1hEfCDK2Kce404f7J6verPUm5/LyTVEPGbH4VQBiuwwxq
 vbvSJdv1pfzHihcjVVjNN/KVU0Um6+GqUj5JrI3JpW7waRERctwmOVc/hYGzGpbN8iUE0Oik
 Adanx2OanoyxcMBjg5LVgltnRVqVB6AEXRLYUDl7dvRl+68BmvQB08cnmg/UY5tFfxmSTlN/
 /gqhThYXF4/3WH8rOtWZ2Gq75YdrMTJO3npJLoDhVCZZkxekcTIveQsv37b2nLZrvqrjWRl4
 NAJD2K4kFICPEuErjLEsPIL4YBH2WNFlYpLgAjCBoShRV0IBd3dwF6BJnesR12Xh5H47qS9m
 +6h28JtTek9FvHCgmNiYcum8yBwBRwfSqLC4LJ9QU4JWb+rx6JLHkVu3sz274bv80B79gibD
 cjwz8joa6ISPfAaO2sJNhrKl23F8qor37FcXqauPnJwzS5cKNXcEpkBL9+OyPHBU0rMN4k+7
 Xs1SWQ51ouO7nAA/IFGj
Message-ID: <f8cfb91f-a205-0530-25df-09f806d7ca5c@posteo.de>
Date: Tue, 28 Aug 2018 13:23:25 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CAGHTAeMDw7Qd6zkwkxYb36BHGaoCPXk6Q-a8MCNkyT8FOrkbKg@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------9CD20AF008A411F90A61D212"
Content-Language: de-DE
Precedence: bulk

This is a multi-part message in MIME format.
--------------9CD20AF008A411F90A61D212
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

 pg_prepared_transactions does not exist, or i don't know how to list that


Am 28.08.2018 um 13:18 schrieb Flavio Henrique Araque Gurgel:
>
>
> Em ter, 28 de ago de 2018 às 13:15, <wambacher@posteo.de
> <mailto:wambacher@posteo.de>> escreveu:
>
>     Hi,
>
>     there is only one process updating my database. and that is
>     exactly the
>     job which is getting the error.
>
>     all other jobs are read/only and i even stoppend those.
>
>     but there has been a crash some hours ago.
>
> Look if you have prepared transactions on the pg_prepared_transactions
> view.
> If you make use of JDBC it's possible that you use it without knowing
> and it survives Postgres restarts.
> If you have any, drop them.
>
> Flavio Gurgel


--------------9CD20AF008A411F90A61D212
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p> pg_prepared_transactions does not exist, or i don't know how to
      list that <br>
    </p>
    <br>
    <div class="moz-cite-prefix">Am 28.08.2018 um 13:18 schrieb Flavio
      Henrique Araque Gurgel:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAGHTAeMDw7Qd6zkwkxYb36BHGaoCPXk6Q-a8MCNkyT8FOrkbKg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      <div dir="ltr"><br>
        <br>
        <div class="gmail_quote">
          <div dir="ltr">Em ter, 28 de ago de 2018 às 13:15, &lt;<a
              href="mailto:wambacher@posteo.de" moz-do-not-send="true">wambacher@posteo.de</a>&gt;
            escreveu:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
            <br>
            there is only one process updating my database. and that is
            exactly the<br>
            job which is getting the error.<br>
            <br>
            all other jobs are read/only and i even stoppend those.<br>
            <br>
            but there has been a crash some hours ago.<br>
            <br>
          </blockquote>
          <div>Look if you have prepared transactions on the
            pg_prepared_transactions view.</div>
          <div>If you make use of JDBC it's possible that you use it
            without knowing and it survives Postgres restarts.</div>
          <div>If you have any, drop them.<br>
          </div>
          <div><br>
          </div>
          <div>Flavio Gurgel<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------9CD20AF008A411F90A61D212--