From: | Vladimir Borodin <root(at)simply(dot)name> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14189: Corrupted WAL through replication protocol |
Date: | 2016-06-23 17:53:07 |
Message-ID: | E6CEEA87-0652-41A6-ACFC-C2FA1CAAC9AA@simply.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> 20 июня 2016 г., в 20:36, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> написал(а):
>
> root(at)simply(dot)name wrote:
>
>> root(at)xdb2018f /tmp # /usr/pgsql-9.5/bin/pg_xlogdump /tmp/normal/00000001000024DB00000072 /tmp/normal/00000001000024DB00000072 | fgrep -C1 24DB/72095CC8
>
> So the problem record is:
>
>> rmgr: Gin len (rec/tot): 2/ 412, tx: 193820712, lsn: 24DB/72095E50, prev 24DB/72095CC8, desc: INSERT isdata: F isleaf: T isdelete: T, blkref #0: rel 1663/16400/18030 blk 368350
>
> for which you got this message:
>
>> root(at)xdb2018f /tmp # /usr/pgsql-9.5/bin/pg_xlogdump /tmp/problem/00000001000024DB00000072 /tmp/problem/00000001000024DB00000072 | fgrep -C1 24DB/72095CC8
>> pg_xlogdump: FATAL: error in WAL record at 24DB/72095E50: unexpected pageaddr 24D9/23096000 in log segment 00000000000024DB00000072, offset 614400
>
> This is very odd. 24D9/23096000 looks like a valid address, perhaps
> something that was left uninitialized from a previous write rather than
> random corruption.
>
> I don't suppose you can reproduce this at will, can you?
No, I can’t. Let’s think about this case as non-reproducable and just keep this report for history. Maybe someone will also hit it.
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
May the force be with you…
https://simply.name
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-06-23 17:54:52 | Re: BUG #14211: i am enable to upload .xlsx file in my postgres database. |
Previous Message | Daniel Newman | 2016-06-23 17:31:32 | Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column |