Re: [RFC] Removing "magic" oids
От | Andres Freund |
---|---|
Тема | Re: [RFC] Removing "magic" oids |
Дата | |
Msg-id | 02C51EE4-D0AE-4855-AF39-7EBC9D0CBB96@anarazel.de обсуждение исходный текст |
Ответ на | Re: [RFC] Removing "magic" oids (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>) |
Ответы |
Re: [RFC] Removing "magic" oids
(Andres Freund <andres@anarazel.de>)
|
Список | pgsql-hackers |
On November 21, 2018 10:17:57 AM PST, Andrew Dunstan <andrew.dunstan@2ndquadrant.com> wrote: > >On 11/20/18 7:07 PM, Andres Freund wrote: >> >> >> Let's see what I broke :/ >> > > >pg_upgrade against old versions, by the look of it. Even after I drop >oids from user tables, I get errors like this when running pg_dumpall >against a pg_upgraded REL_9_4_STABLE datadir: > > >2018-11-21 13:01:58.582 EST [11861] ERROR: large object 10 does not >exist >2018-11-21 13:01:58.637 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:01:58.637 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:01:59.638 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:01:59.638 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:01:59.638 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:01:59.638 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:00.493 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:00.639 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:00.639 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:00.639 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:00.639 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:01.495 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:01.640 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:01.640 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:01.641 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:01.641 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:02.496 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:02.642 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:02.642 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:02.642 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:02.642 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:03.497 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:03.643 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:03.643 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:03.643 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:03.643 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:04.498 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:04.644 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:04.644 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:04.644 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:04.644 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:05.499 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:05.645 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:05.645 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:05.645 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:05.645 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:06.501 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:06.646 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:06.646 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:06.646 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:06.646 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:07.502 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:07.648 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:07.648 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:07.648 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:07.648 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. >2018-11-21 13:02:08.503 EST [11688] ERROR: could not open file >"global/1262": No such file or directory >2018-11-21 13:02:08.649 EST [11686] ERROR: could not open file >"base/17486/2840_vm": No such file or directory >2018-11-21 13:02:08.649 EST [11686] CONTEXT: writing block 0 of >relation base/17486/2840_vm >2018-11-21 13:02:08.649 EST [11686] WARNING: could not write block 0 >of >base/17486/2840_vm >2018-11-21 13:02:08.649 EST [11686] DETAIL: Multiple failures --- >write >error might be permanent. I'll take a look, thanks. Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Alvaro HerreraДата:
Сообщение: Re: pgsql: instr_time.h: add INSTR_TIME_SET_CURRENT_LAZY