Thread: pg_waldump got an error with waldump file generated by initdb

pg_waldump got an error with waldump file generated by initdb

From
Dong Wook Lee
Date:
Hi, hackers

I don't know if this is an error.
when I do ./initdb -D ../data and execute pg_waldump like this, In the last part I got an error.

```
./pg_waldump ../data/pg_wal/000000010000000000000001
```

pg_waldump: error: error in WAL record at 0/1499990: invalid record length at 0/1499A08: wanted 24, got 0

my environment is `16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit`
Is this normal?




Re: pg_waldump got an error with waldump file generated by initdb

From
Andres Freund
Date:
Hi,

On 2022-07-10 21:51:04 +0900, Dong Wook Lee wrote:
> I don't know if this is an error.
> when I do ./initdb -D ../data and execute pg_waldump like this, In the last part I got an error.
> 
> ```
> ./pg_waldump ../data/pg_wal/000000010000000000000001
> ```
> 
> pg_waldump: error: error in WAL record at 0/1499990: invalid record length at 0/1499A08: wanted 24, got 0
> 
> my environment is `16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit`
> Is this normal?

Yes, that's likely normal - i.e. pg_waldump has reached the point at which the
WAL ends.

Greetings,

Andres Freund



Re: pg_waldump got an error with waldump file generated by initdb

From
Justin Pryzby
Date:
On Sun, Jul 10, 2022 at 02:39:00PM -0700, Andres Freund wrote:
> On 2022-07-10 21:51:04 +0900, Dong Wook Lee wrote:
> > I don't know if this is an error.
> > when I do ./initdb -D ../data and execute pg_waldump like this, In the last part I got an error.
> > 
> > ```
> > ./pg_waldump ../data/pg_wal/000000010000000000000001
> > ```
> > 
> > pg_waldump: error: error in WAL record at 0/1499990: invalid record length at 0/1499A08: wanted 24, got 0
> > 
> > my environment is `16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit`
> > Is this normal?
> 
> Yes, that's likely normal - i.e. pg_waldump has reached the point at which the
> WAL ends.

It's the issue that's fixed by this patch.

38/2490     Make message at end-of-recovery less scary     Kyotaro Horiguchi
https://commitfest.postgresql.org/38/2490/