Re: BUG #16874: Postgres Server crashes at commit

On Fri, Feb 19, 2021 at 4:01 AM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 16874
> Logged by: Thomas Trenz
> Email address: thomas(dot)trenz(at)jdisc(dot)com
> PostgreSQL version: 13.2
> Operating system: Windows 2012 R2
> Description:
>
> We have an application which performs quite a lot of database operations and
> in some cases some larger transactions. So far, everything was working fine
> with previous Postgres versions.
>
> Since we migrated to Postgres 13, we experience a crash of the database
> server.
>
>
> This is the log from the server:
> 2021-02-16 08:00:08.854 CET [7188] LOG: starting PostgreSQL 13.2, compiled
> by Visual C++ build 1914, 64-bit
> 2021-02-16 08:00:08.856 CET [7188] LOG: listening on IPv6 address "::",
> port 25321
> 2021-02-16 08:00:08.857 CET [7188] LOG: listening on IPv4 address
> "0.0.0.0", port 25321
> 2021-02-16 08:00:08.900 CET [7464] LOG: database system was shut down at
> 2021-02-16 07:59:22 CET
> 2021-02-16 08:00:08.931 CET [7188] LOG: database system is ready to accept
> connections
> 2021-02-16 08:01:32.536 CET [5332] FATAL: password authentication failed
> for user "postgres"
> 2021-02-16 08:01:32.536 CET [5332] DETAIL: Password does not match for user
> "postgres".
> Connection matched pg_hba.conf line 86: "host all all 0.0.0.0/0 md5"
> 2021-02-16 08:01:58.800 CET [7188] LOG: received SIGHUP, reloading
> configuration files
> 2021-02-16 08:04:44.911 CET [4732] ERROR: canceling autovacuum task
> 2021-02-16 08:04:44.911 CET [4732] CONTEXT: while scanning block 946 of
> relation "public.serviceoperatingsystemrelation"
> automatic vacuum of table
> "inventory.public.serviceoperatingsystemrelation"
> 2021-02-16 08:04:44.919 CET [4732] ERROR: canceling autovacuum task
> 2021-02-16 08:04:47.098 CET [9044] ERROR: canceling autovacuum task
> 2021-02-16 08:04:47.098 CET [9044] CONTEXT: while scanning block 494 of
> relation "public.service"
> automatic vacuum of table "inventory.public.service"
> 2021-02-16 08:05:07.045 CET [9044] ERROR: canceling autovacuum task
> 2021-02-16 08:05:07.045 CET [9044] CONTEXT: while scanning block 1384 of
> relation "public.executablefile"
> automatic vacuum of table "inventory.public.executablefile"
> 2021-02-16 08:05:07.070 CET [9044] ERROR: canceling autovacuum task
> 2021-02-16 08:05:47.386 CET [8672] ERROR: canceling autovacuum task
> 2021-02-16 08:05:47.386 CET [8672] CONTEXT: while scanning block 960 of
> relation "public.service"
> automatic vacuum of table "inventory.public.service"
> 2021-02-16 08:05:49.715 CET [8672] ERROR: canceling autovacuum task
> 2021-02-16 08:05:49.715 CET [8672] CONTEXT: while scanning block 1055 of
> relation "public.processmodulerelation"
> automatic vacuum of table "inventory.public.processmodulerelation"
> 2021-02-16 08:05:52.496 CET [8672] ERROR: canceling autovacuum task
> 2021-02-16 08:05:52.496 CET [8672] CONTEXT: while cleaning up index
> "executablefile_uniqueindex" of relation "public.executablefile"
> automatic vacuum of table "inventory.public.executablefile"
> 2021-02-16 08:05:55.660 CET [5508] LOG: could not rename file
> "pg_wal/000000010000000000000001": Permission denied

<snip!>

How did you upgrade or install this server? what is the platform?

merlin