Horton

Re: BUG #16874: Postgres Server crashes at commit

Merlin Moncure <mmoncure@gmail.com>

View thread
From: Merlin Moncure <mmoncure@gmail.com>
To: thomas.trenz@jdisc.com, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2021-02-19T18:28:54Z
Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix concurrency issues with WAL segment recycling on Windows

On Fri, Feb 19, 2021 at 4:01 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      16874
> Logged by:          Thomas Trenz
> Email address:      thomas.trenz@jdisc.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