pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: oleg.kiriyenko@gmail.com
Subject: BUG #16830: Start of standby server never happens
Date: Tue, 19 Jan 2021 15:08:15 +0000
Message-ID: <16830-1603b03b6109f24d@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16830
Logged by:          Олег Кириенко
Email address:      oleg.kiriyenko@gmail.com
PostgreSQL version: 11.10
Operating system:   Windows 2012 R2
Description:        

When starting standby server it tries to read WAL from primary server but
freezes on the same record.
Logs below are in russian so i'll translate.

invalid record length at 42/99074DF0: wanted 24, got 0 ...

The problem is that standby never starts. It will repeat this message every
"wal_retrieve_retry_interval" (10 seconds here) with no progress. After
enabling debug logs I got warning "mapped win32 error code 2 to 2". Which is
not informative how to fix the error.

2021-01-19 16:16:27.929 MSK [4656] СООБЩЕНИЕ:  неверная длина записи по
смещению 42/99074DF0: ожидалось 24, получено 0
2021-01-19 16:16:27.929 MSK [4656] ОТЛАДКА:  mapped win32 error code 2 to
2
2021-01-19 16:16:27.948 MSK [2180] ОТЛАДКА:  shmem_exit(1): 1
before_shmem_exit callbacks to make
2021-01-19 16:16:27.949 MSK [2180] ОТЛАДКА:  shmem_exit(1): 4 on_shmem_exit
callbacks to make
2021-01-19 16:16:27.949 MSK [2180] ОТЛАДКА:  proc_exit(1): 2 callbacks to
make
2021-01-19 16:16:27.949 MSK [2180] ОТЛАДКА:  exit(1)
2021-01-19 16:16:27.949 MSK [2180] ОТЛАДКА:  shmem_exit(-1): 0
before_shmem_exit callbacks to make
2021-01-19 16:16:27.949 MSK [2180] ОТЛАДКА:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-01-19 16:16:27.949 MSK [2180] ОТЛАДКА:  proc_exit(-1): 0 callbacks to
make
2021-01-19 16:16:27.950 MSK [2804] ОТЛАДКА:  reaping dead processes
2021-01-19 16:16:37.929 MSK [4656] ОТЛАДКА:  switched WAL source from stream
to archive after failure
2021-01-19 16:16:37.929 MSK [4656] ОТЛАДКА:  неверная длина записи по
смещению 42/99074DF0: ожидалось 24, получено 0
2021-01-19 16:16:37.929 MSK [4656] ОТЛАДКА:  switched WAL source from
archive to stream after failure
2021-01-19 16:16:37.929 MSK [4656] СООБЩЕНИЕ:  неверная длина записи по
смещению 42/99074DF0: ожидалось 24, получено 0
2021-01-19 16:16:37.929 MSK [4656] ОТЛАДКА:  mapped win32 error code 2 to
2
2021-01-19 16:16:37.948 MSK [3984] ОТЛАДКА:  shmem_exit(1): 1
before_shmem_exit callbacks to make
2021-01-19 16:16:37.949 MSK [3984] ОТЛАДКА:  shmem_exit(1): 4 on_shmem_exit
callbacks to make
2021-01-19 16:16:37.949 MSK [3984] ОТЛАДКА:  proc_exit(1): 2 callbacks to
make
2021-01-19 16:16:37.949 MSK [3984] ОТЛАДКА:  exit(1)
2021-01-19 16:16:37.949 MSK [3984] ОТЛАДКА:  shmem_exit(-1): 0
before_shmem_exit callbacks to make
2021-01-19 16:16:37.949 MSK [3984] ОТЛАДКА:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-01-19 16:16:37.949 MSK [3984] ОТЛАДКА:  proc_exit(-1): 0 callbacks to
make
2021-01-19 16:16:37.951 MSK [2804] ОТЛАДКА:  reaping dead processes



Message-ID: <16830-1603b03b6109f24d@postgresql.org>
Permalink:  ../16830-1603b03b6109f24d@postgresql.org/
Also on:    postgresql.org/message-id/16830-1603b03b6109f24d@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, oleg.kiriyenko@gmail.com
  Subject: Re: BUG #16830: Start of standby server never happens
  In-Reply-To: <16830-1603b03b6109f24d@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox