Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0
От
Alvaro Herrera
Тема
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0
Дата
Msg-id
20180806221023.63mes2onr2tumyoo@alvherre.pgsql
Ответ на
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 (Peter Geoghegan)
Список
Дерево обсуждения
BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676when max_parallel_maintenance_workers > 0 PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Andres Freund <andres@anarazel.de>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Amit Kapila <amit.kapila16@gmail.com>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid 760676 when max_parallel_maintenance_workers > 0 Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
Re: BUG #15309: ERROR: catalog is missing 1 attribute(s) for relid760676 when max_parallel_maintenance_workers > 0 Peter Geoghegan <pg@bowt.ie>
On 2018-Aug-06, Peter Geoghegan wrote: > On Mon, Aug 6, 2018 at 1:37 PM, Peter Geoghegan wrote: > > To be clear, I mean that the leader process's worker state has the > > right relfilenode (the leader process always participates as a > > worker), but all worker processes have the stale relfilenode. > > Sure enough, that's what the bug is - a few debugging calls to > RelationMapFilenodeToOid() within nbtsort.c proves it. Uh, that's weird, isn't it? I mean, why is the relfilenode changing underneath? Why isn't it blocked by the CREATE INDEX? Or is CREATE INDEX inflicting that upon itself? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-bugs по дате отправления
От: Peter Geoghegan
Дата: