To: pgsql-admin@lists.postgresql.org
From: wambacher@posteo.de
Subject: crash during autovacuum
Openpgp: preference=signencrypt
Autocrypt: addr=wambacher@posteo.de; keydata=
 mQINBFsF9hIBEAC4W3M068RHHa+QJ3GjfG8n+sSUenUmRP0YCBL0X9FZfMRk328cXXs2qFP4
 yqoegbbRmxC4jUHCrMaPdnRGugW8ZRnyoiKYZrmffx/SzB6kZzdS7RCIhYY3pHLUEd5TIFPG
 Z2Plr6s1TpwVZc4Gkk9Uj4vGcwzDlUB7feurBpMdKaOfYz53vNXnh0C/e/fg7jx8rw70zM7z
 UDKcttHshsUUscL4tnYqH4mt2svJ8jmCwpesehjxgywTjxF8vPqr3G2KQ8cW2HbISp1q8gZQ
 vbXycBZ8Ej5GKsKkYLUP4bN6wfPE1sWlmD3Y5xilYNsDJkREFTQOqpJCoeMROcLZSdpv058Y
 nKRVVPKaD969nRl8lnMgPEkDOSv5V+IhSebQEFX7vnSkZp/4kETy4NsAa89I6ATBt4H5McQL
 3Py46INBbn7cH3k4Vljf8R1qvWYltM9aLZp3HbmKyRl0c5DSRSzKm7jCspmaYQ6pxZfLAx9M
 HRp2m3tIZPF+o8r8LukVS4Ji/8pXu2Tubd1rpkWwa8P6DxE0ZZGXYEnn7iYQuBn1sOYU2PBG
 xo/EA2lYx/EfeMDvjFV0ZB8DafROff4pb1mvuTA8m8gyUwa2leCNFg17PqYI/k4zCsGO21Vg
 qKc2K2rzm9azfX6nPvfcQHZtK55ek9m/0cP0pCsi/3v75vypewARAQABtCtXYWx0ZXIgTm9y
 ZG1hbm4gPHdhbHRlci5ub3JkbWFubkBwb3N0ZW8uZGU+iQI9BBMBCAAnBQJbBfYSAhsjBQkJ
 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/6UPwRfMltuQINBFsF9hIBEAD038KpaE8OkPi9/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
 AQABiQIlBBgBCAAPBQJbBfYSAhsMBQkJZgGAAAoJENd8FQK2Z0Ey3egP/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: <22fb8ec4-67d8-314a-98db-91e2709106db@posteo.de>
Date: Fri, 28 Dec 2018 11:13:12 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.2.1
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------BCFFC474D0749CD579E34932"
Content-Language: de-DE
Precedence: bulk

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

Hi,

this morning my database crashed, because of a problem during autovacuum.=


this is the second time during the last 2 month and i can't find out why.=


logfile:

2018-12-28 10:52:22 CET [23757-59] LOG:=C2=A0 Serverprozess (PID 14149) w=
urde
von Signal 6 beendet: Aborted
2018-12-28 10:52:22 CET [23757-60] DETAIL:=C2=A0 Der fehlgeschlagene Proz=
ess
f=C3=BChrte aus: autovacuum: VACUUM ANALYZE public.planet_osm_ways
2018-12-28 10:52:22 CET [23757-61] LOG:=C2=A0 aktive Serverprozesse werde=
n
abgebrochen
2018-12-28 10:52:23 CET [26335-1] postgres@planet3 FATAL:=C2=A0 das
Datenbanksystem ist im Wiederherstellungsmodus
2018-12-28 10:52:23 CET [23757-62] LOG:=C2=A0 alle Serverprozesse beendet=
;
initialisiere neu
2018-12-28 10:52:25 CET [26402-1] postgres@planet3 FATAL:=C2=A0 das
Datenbanksystem ist im Wiederherstellungsmodus
2018-12-28 10:52:25 CET [26401-1] LOG:=C2=A0 Datenbanksystem wurde
unterbrochen; letzte bekannte Aktion am 2018-12-28 10:50:10 CET


that's all i get :(

it is a really big table (552.669.751 records, 228 GB data + indices)
and the last two autovacuum analyze did well. running for a really long
time (> 2 days) but without any (known) problems.

any idea what's going on and what i can do?

Regards
walter

--=20
My projects:

Admin Boundaries of the World <https://wambachers-osm.website/boundaries>=

Missing Boundaries
<https://wambachers-osm.website/index.php/projekte/internationale-adminis=
trative-grenzen/missing-boundaries>
Emergency Map <https://wambachers-osm.website/emergency>
Postal Code Map (Germany only) <https://wambachers-osm.website/plz>
Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>=

Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundarie=
s>

--------------BCFFC474D0749CD579E34932
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 bgcolor="#FFFFFF" text="#000000">
    <p>Hi,</p>
    <p>this morning my database crashed, because of a problem during
      autovacuum. <br>
    </p>
    <p>this is the second time during the last 2 month and i can't find
      out why.</p>
    <p>logfile:</p>
    <p>2018-12-28 10:52:22 CET [23757-59] LOG:  Serverprozess (PID
      14149) wurde von Signal 6 beendet: Aborted<br>
      2018-12-28 10:52:22 CET [23757-60] DETAIL:  Der fehlgeschlagene
      Prozess führte aus: autovacuum: VACUUM ANALYZE
      public.planet_osm_ways<br>
      2018-12-28 10:52:22 CET [23757-61] LOG:  aktive Serverprozesse
      werden abgebrochen<br>
      2018-12-28 10:52:23 CET [26335-1] postgres@planet3 FATAL:  das
      Datenbanksystem ist im Wiederherstellungsmodus<br>
      2018-12-28 10:52:23 CET [23757-62] LOG:  alle Serverprozesse
      beendet; initialisiere neu<br>
      2018-12-28 10:52:25 CET [26402-1] postgres@planet3 FATAL:  das
      Datenbanksystem ist im Wiederherstellungsmodus<br>
      2018-12-28 10:52:25 CET [26401-1] LOG:  Datenbanksystem wurde
      unterbrochen; letzte bekannte Aktion am 2018-12-28 10:50:10 CET<br>
    </p>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">that's all i get :(</div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">it is a really big table (552.669.751
      records, 228 GB data + indices) and the last two autovacuum
      analyze did well. running for a really long time (&gt; 2 days) but
      without any (known) problems.</div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">any idea what's going on and what i can
      do?</div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">Regards</div>
    <div class="moz-signature">walter<br>
    </div>
    <div class="moz-signature"><br>
    </div>
    <div class="moz-signature">-- <br>
      My projects:<br>
      <br>
      <a href="https://wambachers-osm.website/boundaries">Admin
        Boundaries of the World</a><br>
      <a
href="https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries">Missing
        Boundaries</a><br>
      <a href="https://wambachers-osm.website/emergency">Emergency Map</a><br>
      <a href="https://wambachers-osm.website/plz">Postal Code Map
        (Germany only)</a><br>
      <a href="https://wambachers-osm.website/fools">Fools (QA for
        zipcodes in Germany)</a><br>
      <a href="https://wambachers-osm.website/pcoundaries"> Postcode
        Boundaries of Germany</a></div>
  </body>
</html>

--------------BCFFC474D0749CD579E34932--