Re: Failures with wal_consistency_checking and 13~
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Ranier Vilela <ranier.vf@gmail.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-06-16T03:55:09Z
Lists: pgsql-hackers
On Mon, Jun 15, 2020 at 11:33:42PM -0300, Ranier Vilela wrote: > With Postgres 13, Windows 10 (home), msvc 2019 64 bits, > Shutting down, without interrupting the database, consistently, this log > has appeared. > > 2020-06-15 21:40:35.998 -03 [3380] LOG: database system shutdown was > interrupted; last known up at 2020-06-15 21:36:01 -03 > 2020-06-15 21:40:37.978 -03 [3380] LOG: database system was not properly > shut down; automatic recovery in progress > 2020-06-15 21:40:37.992 -03 [3380] LOG: redo starts at 0/8A809C78 > 2020-06-15 21:40:37.992 -03 [3380] LOG: invalid record length at > 0/8A809CB0: wanted 24, got 0 > 2020-06-15 21:40:37.992 -03 [3380] LOG: redo done at 0/8A809C78 Could you please keep discussions on their own thread please? After stopping Postgres in a sudden way (immediate mode or just SIGKILL), it is normal to see crash recovery happen, as well as it is normal to see an "invalid record length" in the logs when the end of WAL is reached, meaning the end of recovery. Thanks. -- Michael
Commits
-
Fix masking of SP-GiST pages during xlog consistency check
- 39aafc88c4b4 13.0 landed
- 3f88e2d78dbe 11.9 landed
- 396a44a01536 12.4 landed
- a44dd932ff38 14.0 landed