Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fufKT-0004Pq-I1 for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 14:50:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fufKR-0002zW-Fz for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 14:50:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fufKR-0002zP-4A for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 14:50:47 +0000 Received: from mout02.posteo.de ([185.67.36.66]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fufKM-00051B-JG for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 14:50:46 +0000 Received: from submission (posteo.de [89.146.220.130]) by mout02.posteo.de (Postfix) with ESMTPS id 8093A21027 for ; Tue, 28 Aug 2018 16:50:40 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.de; s=2017; t=1535467840; bh=5Lrp156jIfQhdz5qpBG1Yv3h19NF15MZjUrEdLHFR2c=; h=Subject:To:Cc:From:Openpgp:Autocrypt:Date:From; b=LfSGZqPb4g5llXM/v0g2IS5QvH0Sm8YnhtIDsdX6Nr6J2aI5yNNznZKj6OSHOaVuQ WuFP1iblECGQTVe8m9uYAQjJ/7V0E93iFKYXVKEx5BI56TeGB+pKe3tJuW3TOLS4Rx CZsFZkhSPwh5wLsZPOIn3tggcXuQclQJrhR2kNGXRZG/POdfjIIUy/sCdAc8g4cRAu paGdm8oXOvc0epYy8nUABj7W5ifjgLD/i5GnZJBTwOSdHLIZEi0y2htaRJOIxUmfMz H+GQd4BpSiFbTEBDpqJKRNTw48FYEz2fYgujZS0C+nnsc6Uym2vVQR34KeSyea6cJu KLWl6SFTXiMtA== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 420BWg2S14z9rxG; Tue, 28 Aug 2018 16:50:38 +0200 (CEST) Subject: Re: tuple concurrently updated To: Alvaro Herrera References: <20180828143301.g5gsjo7onyys2gyg@alvherre.pgsql> Cc: 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: Date: Tue, 28 Aug 2018 16:50:37 +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: <20180828143301.g5gsjo7onyys2gyg@alvherre.pgsql> Content-Type: multipart/alternative; boundary="------------4624AB68101E0513F452A21A" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------4624AB68101E0513F452A21A Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit no, i respect your questions, but i can't answer them. because i don't know in detail what osm2pgsql is doing. planet_osm_line it postgis see: >                                      Tabelle »public.planet_osm_line« >              Spalte              |            Typ            | > Sortierfolge | NULL erlaubt? | Vorgabewert > ---------------------------------+---------------------------+--------------+---------------+------------- >  osm_id                          | bigint                    > |              |               | >  access                          | text                      > |              |               | >  addr:housename                  | text                      > |              |               | >  addr:housenumber                | text                      > |              |               | >  addr:interpolation              | text                      > |              |               | >  admin_level                     | text                      > |              |               | >  aerialway                       | text                      > |              |               | >  aeroway                         | text                      > |              |               | >  amenity                         | text                      > |              |               | >  area                            | text                      > |              |               | >  barrier                         | text                      > |              |               | >  bicycle                         | text                      > |              |               | >  brand                           | text                      > |              |               | >  bridge                          | text                      > |              |               | >  boundary                        | text                      > |              |               | >  building                        | text                      > |              |               | >  construction                    | text                      > |              |               | >  covered                         | text                      > |              |               | >  culvert                         | text                      > |              |               | >  cutting                         | text                      > |              |               | >  denomination                    | text                      > |              |               | >  disused                         | text                      > |              |               | >  embankment                      | text                      > |              |               | >  foot                            | text                      > |              |               | >  generator:source                | text                      > |              |               | >  harbour                         | text                      > |              |               | >  highway                         | text                      > |              |               | >  historic                        | text                      > |              |               | >  horse                           | text                      > |              |               | >  intermittent                    | text                      > |              |               | >  junction                        | text                      > |              |               | >  landuse                         | text                      > |              |               | >  layer                           | text                      > |              |               | >  leisure                         | text                      > |              |               | >  lock                            | text                      > |              |               | >  man_made                        | text                      > |              |               | >  military                        | text                      > |              |               | >  motorcar                        | text                      > |              |               | >  name                            | text                      > |              |               | >  natural                         | text                      > |              |               | >  office                          | text                      > |              |               | >  oneway                          | text                      > |              |               | >  operator                        | text                      > |              |               | >  place                           | text                      > |              |               | >  population                      | text                      > |              |               | >  power                           | text                      > |              |               | >  power_source                    | text                      > |              |               | >  public_transport                | text                      > |              |               | >  railway                         | text                      > |              |               | >  ref                             | text                      > |              |               | >  religion                        | text                      > |              |               | >  route                           | text                      > |              |               | >  service                         | text                      > |              |               | >  shop                            | text                      > |              |               | >  sport                           | text                      > |              |               | >  surface                         | text                      > |              |               | >  toll                            | text                      > |              |               | >  tourism                         | text                      > |              |               | >  tower:type                      | text                      > |              |               | >  tracktype                       | text                      > |              |               | >  tunnel                          | text                      > |              |               | >  water                           | text                      > |              |               | >  waterway                        | text                      > |              |               | >  wetland                         | text                      > |              |               | >  width                           | text                      > |              |               | >  wood                            | text                      > |              |               | >  z_order                         | integer                   > |              |               | >  way_area                        | real                      > |              |               | >  addr:postcode                   | text                      > |              |               | >  de:amtlicher_gemeindeschluessel | text                      > |              |               | >  de:regionalschluessel           | text                      > |              |               | >  ISO3166-1:alpha3                | text                      > |              |               | >  maxspeed                        | text                      > |              |               | >  maxspeed:forward                | text                      > |              |               | >  maxspeed:backward               | text                      > |              |               | >  name:de                         | text                      > |              |               | >  note                            | text                      > |              |               | >  postal_code                     | text                      > |              |               | >  tags                            | hstore                    > |              |               | >  way                             | geometry(LineString,4326) > |              |               | > Indexe: >     "idx_planet_osm_line_highway" btree (highway) >     "planet_osm_line_index" gist (way), Tablespace »planet3_is1« >     "planet_osm_line_pkey" btree (osm_id), Tablespace »planet3_is1« >     "planet_osm_line_tags_index" gin (tags), Tablespace »planet3_is1« > Tablespace: »planet3_ts1« Am 28.08.2018 um 16:33 schrieb Alvaro Herrera: > On 2018-Aug-28, wambacher@posteo.de wrote: > >> updates are done using a program, that is without my control: osm2pgsql. >> >> this program does everthing which is necessary including locking. and >> it't running for years on many, many openstreetmap servers. >> >> because there was a crash before, it must be a data corruption problem, >> not programming error. > It's curious that you reply to my email and not respond to a single of > the questions I posed, and instead answered questions I didn't ask. > Perhaps you thought I asked them because I was bored? > >>> What is the definition of the table? It sounds like there's some GIS >>> datatype -- Right? Are there any triggers or some other fun fact about >>> this delete? What is the isolation level in effect when the delete >>> runs? -- My projects: Admin Boundaries of the World Missing Boundaries Emergency Map Postal Code Map (Germany only) Fools (QA for zipcodes in Germany) Postcode Boundaries of Germany --------------4624AB68101E0513F452A21A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

no, i respect your questions, but i can't answer them. because i don't know in detail what osm2pgsql is doing.

planet_osm_line it postgis

see:

                                     Tabelle »public.planet_osm_line«
             Spalte              |            Typ            | Sortierfolge | NULL erlaubt? | Vorgabewert
---------------------------------+---------------------------+--------------+---------------+-------------
 osm_id                          | bigint                    |              |               |
 access                          | text                      |              |               |
 addr:housename                  | text                      |              |               |
 addr:housenumber                | text                      |              |               |
 addr:interpolation              | text                      |              |               |
 admin_level                     | text                      |              |               |
 aerialway                       | text                      |              |               |
 aeroway                         | text                      |              |               |
 amenity                         | text                      |              |               |
 area                            | text                      |              |               |
 barrier                         | text                      |              |               |
 bicycle                         | text                      |              |               |
 brand                           | text                      |              |               |
 bridge                          | text                      |              |               |
 boundary                        | text                      |              |               |
 building                        | text                      |              |               |
 construction                    | text                      |              |               |
 covered                         | text                      |              |               |
 culvert                         | text                      |              |               |
 cutting                         | text                      |              |               |
 denomination                    | text                      |              |               |
 disused                         | text                      |              |               |
 embankment                      | text                      |              |               |
 foot                            | text                      |              |               |
 generator:source                | text                      |              |               |
 harbour                         | text                      |              |               |
 highway                         | text                      |              |               |
 historic                        | text                      |              |               |
 horse                           | text                      |              |               |
 intermittent                    | text                      |              |               |
 junction                        | text                      |              |               |
 landuse                         | text                      |              |               |
 layer                           | text                      |              |               |
 leisure                         | text                      |              |               |
 lock                            | text                      |              |               |
 man_made                        | text                      |              |               |
 military                        | text                      |              |               |
 motorcar                        | text                      |              |               |
 name                            | text                      |              |               |
 natural                         | text                      |              |               |
 office                          | text                      |              |               |
 oneway                          | text                      |              |               |
 operator                        | text                      |              |               |
 place                           | text                      |              |               |
 population                      | text                      |              |               |
 power                           | text                      |              |               |
 power_source                    | text                      |              |               |
 public_transport                | text                      |              |               |
 railway                         | text                      |              |               |
 ref                             | text                      |              |               |
 religion                        | text                      |              |               |
 route                           | text                      |              |               |
 service                         | text                      |              |               |
 shop                            | text                      |              |               |
 sport                           | text                      |              |               |
 surface                         | text                      |              |               |
 toll                            | text                      |              |               |
 tourism                         | text                      |              |               |
 tower:type                      | text                      |              |               |
 tracktype                       | text                      |              |               |
 tunnel                          | text                      |              |               |
 water                           | text                      |              |               |
 waterway                        | text                      |              |               |
 wetland                         | text                      |              |               |
 width                           | text                      |              |               |
 wood                            | text                      |              |               |
 z_order                         | integer                   |              |               |
 way_area                        | real                      |              |               |
 addr:postcode                   | text                      |              |               |
 de:amtlicher_gemeindeschluessel | text                      |              |               |
 de:regionalschluessel           | text                      |              |               |
 ISO3166-1:alpha3                | text                      |              |               |
 maxspeed                        | text                      |              |               |
 maxspeed:forward                | text                      |              |               |
 maxspeed:backward               | text                      |              |               |
 name:de                         | text                      |              |               |
 note                            | text                      |              |               |
 postal_code                     | text                      |              |               |
 tags                            | hstore                    |              |               |
 way                             | geometry(LineString,4326) |              |               |
Indexe:
    "idx_planet_osm_line_highway" btree (highway)
    "planet_osm_line_index" gist (way), Tablespace »planet3_is1«
    "planet_osm_line_pkey" btree (osm_id), Tablespace »planet3_is1«
    "planet_osm_line_tags_index" gin (tags), Tablespace »planet3_is1«
Tablespace: »planet3_ts1«

Am 28.08.2018 um 16:33 schrieb Alvaro Herrera:
On 2018-Aug-28, wambacher@posteo.de wrote:


updates are done using a program, that is without my control: osm2pgsql.

this program does everthing which is necessary including locking. and
it't running for years on many, many openstreetmap servers.

because there was a crash before, it must be a data corruption problem,
not programming error.

It's curious that you reply to my email and not respond to a single of
the questions I posed, and instead answered questions I didn't ask.
Perhaps you thought I asked them because I was bored?


What is the definition of the table?  It sounds like there's some GIS
datatype -- Right?  Are there any triggers or some other fun fact about
this delete?  What is the isolation level in effect when the delete
runs?


    

    

    
-- 

      My projects:

      

      Admin
        Boundaries of the World

      Missing
        Boundaries

      Emergency Map

      Postal Code Map
        (Germany only)

      Fools (QA for
        zipcodes in Germany)

       Postcode
        Boundaries of Germany

  


--------------4624AB68101E0513F452A21A--