Re: Postgres 9.2.13 on AIX 7.1

From: Rainer Tammer <pgsql(at)spg(dot)schulergroup(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres 9.2.13 on AIX 7.1
Date: 2021-08-11 06:33:10
Message-ID: 698ca478-db2f-b563-1fa9-4713c350f0ae@spg.schulergroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,
I have some additional information:

I have now used 9.6.22 on AIX 7.1 TL5 SP8 (that's the lates 7.1 level).
Comiler IBM XLC/C++ V16.1.

export CFLAGS=-qsuppress=1500-010
export CC=cc_r  <--- _r is thread safe
export CXX=xlC_r
export CONFIG_SHELL=/bin/bash

bash ./configure \
  --with-includes=/opt/freeware/include/readline \
  --with-libraries=/opt/freeware/lib \
  --prefix=/usr/local/pgsql-9.6.22 \
  --with-CC=cc_r \
  --with-libxml \
  --without-tcl \
  --without-python

All "make check" test do run without an issue.
It's not like the hanging test we had worked on a couple years ago (were
a SIGINT was blocked
https://www.postgresql.org/message-id/flat/32656.1393346132%40sss.pgh.pa.us#1328f6db2318885b185753f81307865c
).

It looks like the wrong process is getting a SIGINT right after an auto
vacuum.

This is a debug log:

2021-08-10 23:28:49 CEST  LOG:  database system was shut down at
2021-08-10 23:28:40 CEST
2021-08-10 23:28:49 CEST  LOG:  MultiXact member wraparound protections
are now enabled
2021-08-10 23:28:49 CEST  LOG:  autovacuum launcher started
2021-08-10 23:28:49 CEST  LOG:  database system is ready to accept
connections
2021-08-10 23:33:36 CEST  LOG:  received fast shutdown request
2021-08-10 23:33:36 CEST  LOG:  aborting any active transactions
2021-08-10 23:33:36 CEST  LOG:  autovacuum launcher shutting down
2021-08-10 23:33:36 CEST  LOG:  shutting down
2021-08-10 23:33:36 CEST  LOG:  database system is shut down
2021-08-10 23:33:43 CEST  DEBUG:  postgres: PostmasterMain: initial
environment dump:
2021-08-10 23:33:43 CEST  DEBUG: -----------------------------------------
2021-08-10 23:33:43 CEST  DEBUG: _=/usr/local/pgsql-9.6.22/bin/postgres
2021-08-10 23:33:43 CEST  DEBUG:
MANPATH=/usr/share/man:/opt/freeware/man:/usr/local/man:/usr/local/share/man:/usr/local/ssl/man:/usr/local/pgsql/man
2021-08-10 23:33:43 CEST  DEBUG:        myid=postgres
2021-08-10 23:33:43 CEST  DEBUG:        LANG=en_US
2021-08-10 23:33:43 CEST  DEBUG:        PGTZ=NFT-1DFT
2021-08-10 23:33:43 CEST  DEBUG:        LOGIN=postgres
2021-08-10 23:33:43 CEST  DEBUG:        VISUAL=emacs
2021-08-10 23:33:43 CEST  DEBUG:        CLCMD_PASSTHRU=1
2021-08-10 23:33:43 CEST  DEBUG:
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/postgres/bin:/usr/bin/X11:/sbin:/usr/local/bin:/usr/dt/bin:/usr/local/pgsql/bin
2021-08-10 23:33:43 CEST  DEBUG: PG_GRANDPARENT_PID=10158176
2021-08-10 23:33:43 CEST  DEBUG:        LC__FASTMSG=true
2021-08-10 23:33:43 CEST  DEBUG:        LOGNAME=postgres
2021-08-10 23:33:43 CEST  DEBUG: MAIL=/usr/spool/mail/postgres
2021-08-10 23:33:43 CEST  DEBUG:        HOSTNAME=wwwlegacy
2021-08-10 23:33:43 CEST  DEBUG:        LOCPATH=/usr/lib/nls/loc
2021-08-10 23:33:43 CEST  DEBUG:        USER=postgres
2021-08-10 23:33:43 CEST  DEBUG:        AUTHSTATE=files
2021-08-10 23:33:43 CEST  DEBUG: DSM_LOG=/usr/tivoli/tsm/client/ba/bin64/log
2021-08-10 23:33:43 CEST  DEBUG:        LC_CTYPE=de_DE.ISO8859-1
2021-08-10 23:33:43 CEST  DEBUG:        DISPLAY=rtdhcp19:0
2021-08-10 23:33:43 CEST  DEBUG:        SHELL=/usr/bin/ksh
2021-08-10 23:33:43 CEST  DEBUG:        ODMDIR=/etc/objrepos
2021-08-10 23:33:43 CEST  DEBUG: PGDATA=/usr/local/pgsql/data
2021-08-10 23:33:43 CEST  DEBUG:        HOME=/home/postgres
2021-08-10 23:33:43 CEST  DEBUG:        LC_COLLATE=de_DE.ISO8859-1
2021-08-10 23:33:43 CEST  DEBUG: PGSYSCONFDIR=/usr/local/pgsql-9.6.22/etc
2021-08-10 23:33:43 CEST  DEBUG:        TERM=xterm
2021-08-10 23:33:43 CEST  DEBUG: DSM_DIR=/usr/tivoli/tsm/client/ba/bin64
2021-08-10 23:33:43 CEST  DEBUG:        MAILMSG=[YOU HAVE NEW MAIL]
2021-08-10 23:33:43 CEST  DEBUG:        PWD=/home/postgres
2021-08-10 23:33:43 CEST  DEBUG:        TZ=Europe/Berlin
2021-08-10 23:33:43 CEST  DEBUG:        ENV=/.env
2021-08-10 23:33:43 CEST  DEBUG:
DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin64/dsm.opt
2021-08-10 23:33:43 CEST  DEBUG:        PGLIB=/usr/local/pgsql/lib
2021-08-10 23:33:43 CEST  DEBUG:        A__z=! LOGNAME
2021-08-10 23:33:43 CEST  DEBUG:
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/lib/nls/msg/%l.%c/%N:/usr/lib/nls/msg/%l.%c/%N.cat
2021-08-10 23:33:43 CEST  DEBUG: LD_LIBRARY_PATH=:/usr/local/pgsql/lib
2021-08-10 23:33:43 CEST  DEBUG:        LC_MESSAGES=en_US
2021-08-10 23:33:43 CEST  DEBUG:        LC_MONETARY=C
2021-08-10 23:33:43 CEST  DEBUG:        LC_NUMERIC=C
2021-08-10 23:33:43 CEST  DEBUG:        LC_TIME=C
2021-08-10 23:33:43 CEST  DEBUG: -----------------------------------------
2021-08-10 23:33:43 CEST  DEBUG:  invoking IpcMemoryCreate(size=146317312)
2021-08-10 23:33:43 CEST  DEBUG:  SlruScanDirectory invoking callback on
pg_notify/0000
2021-08-10 23:33:43 CEST  DEBUG:  removing file "pg_notify/0000"
2021-08-10 23:33:43 CEST  DEBUG:  dynamic shared memory system will
support 288 segments
2021-08-10 23:33:43 CEST  DEBUG:  created dynamic shared memory control
segment 563757097 (2316 bytes)
2021-08-10 23:33:43 CEST  DEBUG:  max_safe_fds = 984, usable_fds = 1000,
already_open = 6
2021-08-10 23:33:43 CEST  LOG:  database system was shut down at
2021-08-10 23:33:36 CEST
2021-08-10 23:33:43 CEST  DEBUG:  checkpoint record is at 0/216C380
2021-08-10 23:33:43 CEST  DEBUG:  redo record is at 0/216C380; shutdown TRUE
2021-08-10 23:33:43 CEST  DEBUG:  next transaction ID: 0:2138; next OID:
18958
2021-08-10 23:33:43 CEST  DEBUG:  next MultiXactId: 1; next
MultiXactOffset: 0
2021-08-10 23:33:43 CEST  DEBUG:  oldest unfrozen transaction ID: 553,
in database 1
2021-08-10 23:33:43 CEST  DEBUG:  oldest MultiXactId: 1, in database 1
2021-08-10 23:33:43 CEST  DEBUG:  commit timestamp Xid oldest/newest: 0/0
2021-08-10 23:33:43 CEST  DEBUG:  transaction ID wrap limit is
2147484200, limited by database with OID 1
2021-08-10 23:33:43 CEST  DEBUG:  MultiXactId wrap limit is 2147483648,
limited by database with OID 1
2021-08-10 23:33:43 CEST  DEBUG:  starting up replication slots
2021-08-10 23:33:43 CEST  DEBUG:  MultiXactId wrap limit is 2147483648,
limited by database with OID 1
2021-08-10 23:33:43 CEST  LOG:  MultiXact member wraparound protections
are now enabled
2021-08-10 23:33:43 CEST  DEBUG:  MultiXact member stop limit is now
4294914944 based on MultiXact 1
2021-08-10 23:33:43 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:33:43 CEST  DEBUG:  shmem_exit(0): 4 on_shmem_exit
callbacks to make
2021-08-10 23:33:43 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:33:43 CEST  DEBUG:  exit(0)
2021-08-10 23:33:43 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:33:43 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:33:43 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:33:43 CEST  DEBUG:  checkpointer updated shared memory
configuration values
2021-08-10 23:33:43 CEST  LOG:  autovacuum launcher started
2021-08-10 23:33:43 CEST  DEBUG:  InitPostgres
2021-08-10 23:33:43 CEST  DEBUG:  StartTransaction
2021-08-10 23:33:43 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:43 CEST  DEBUG:  CommitTransaction
2021-08-10 23:33:43 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:43 CEST  DEBUG:  removing permanent stats file
"pg_stat/db_12416.stat"
2021-08-10 23:33:43 CEST  LOG:  database system is ready to accept
connections
2021-08-10 23:33:43 CEST  DEBUG:  removing permanent stats file
"pg_stat/db_16387.stat"
2021-08-10 23:33:43 CEST  DEBUG:  removing permanent stats file
"pg_stat/db_16386.stat"
2021-08-10 23:33:43 CEST  DEBUG:  removing permanent stats file
"pg_stat/db_1.stat"
2021-08-10 23:33:43 CEST  DEBUG:  removing permanent stats file
"pg_stat/db_0.stat"
2021-08-10 23:33:43 CEST  DEBUG:  removing permanent stats file
"pg_stat/global.stat"
2021-08-10 23:33:43 CEST  DEBUG:  received inquiry for database 0
2021-08-10 23:33:43 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:33:43 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:33:59 CEST  DEBUG:  StartTransaction
2021-08-10 23:33:59 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:59 CEST  DEBUG:  CommitTransaction
2021-08-10 23:33:59 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:59 CEST  DEBUG:  received inquiry for database 0
2021-08-10 23:33:59 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:33:59 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:33:59 CEST  DEBUG:  InitPostgres
2021-08-10 23:33:59 CEST  DEBUG:  StartTransaction
2021-08-10 23:33:59 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:59 CEST  DEBUG:  CommitTransaction
2021-08-10 23:33:59 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:59 CEST  DEBUG:  autovacuum: processing database "test"
2021-08-10 23:33:59 CEST  DEBUG:  received inquiry for database 16387
2021-08-10 23:33:59 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:33:59 CEST  DEBUG:  writing stats file
"pg_stat_tmp/db_16387.stat"
2021-08-10 23:33:59 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:33:59 CEST  DEBUG:  StartTransaction
2021-08-10 23:33:59 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:59 CEST  DEBUG:  pg_statistic: vac: 121 (threshold
128), anl: 284 (threshold 89)
2021-08-10 23:33:59 CEST  DEBUG:  pg_type: vac: 0 (threshold 122), anl:
0 (threshold 86)
2021-08-10 23:33:59 CEST  DEBUG:  pg_authid: vac: 3 (threshold 50), anl:
5 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_attribute: vac: 0 (threshold 533),
anl: 0 (threshold 292)
2021-08-10 23:33:59 CEST  DEBUG:  pg_proc: vac: 3 (threshold 615), anl:
6 (threshold 332)
2021-08-10 23:33:59 CEST  DEBUG:  pg_class: vac: 0 (threshold 113), anl:
0 (threshold 82)
2021-08-10 23:33:59 CEST  DEBUG:  pg_attrdef: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_constraint: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_inherits: vac: 9 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_index: vac: 0 (threshold 74), anl:
0 (threshold 62)
2021-08-10 23:33:59 CEST  DEBUG:  pg_operator: vac: 9 (threshold 205),
anl: 12 (threshold 128)
2021-08-10 23:33:59 CEST  DEBUG:  pg_opclass: vac: 0 (threshold 82),
anl: 0 (threshold 66)
2021-08-10 23:33:59 CEST  DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0
(threshold 51)
2021-08-10 23:33:59 CEST  DEBUG:  pg_amop: vac: 0 (threshold 188), anl:
0 (threshold 119)
2021-08-10 23:33:59 CEST  DEBUG:  pg_amproc: vac: 0 (threshold 159),
anl: 0 (threshold 105)
2021-08-10 23:33:59 CEST  DEBUG:  pg_language: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_largeobject_metadata: vac: 24
(threshold 50), anl: 36 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_aggregate: vac: 0 (threshold 78),
anl: 0 (threshold 64)
2021-08-10 23:33:59 CEST  DEBUG:  pg_rewrite: vac: 6 (threshold 73),
anl: 0 (threshold 62)
2021-08-10 23:33:59 CEST  DEBUG:  pg_largeobject: vac: 24 (threshold
62), anl: 18 (threshold 56)
2021-08-10 23:33:59 CEST  DEBUG:  pg_trigger: vac: 32 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_description: vac: 64 (threshold
818), anl: 127 (threshold 434)
2021-08-10 23:33:59 CEST  DEBUG:  pg_cast: vac: 0 (threshold 93), anl: 0
(threshold 71)
2021-08-10 23:33:59 CEST  DEBUG:  pg_enum: vac: 15 (threshold 50), anl:
30 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_namespace: vac: 33 (threshold 52),
anl: 0 (threshold 51)
2021-08-10 23:33:59 CEST  DEBUG:  pg_conversion: vac: 0 (threshold 76),
anl: 0 (threshold 63)
2021-08-10 23:33:59 CEST  DEBUG:  pg_depend: vac: 0 (threshold 1516),
anl: 0 (threshold 783)
2021-08-10 23:33:59 CEST  DEBUG:  pg_database: vac: 4 (threshold 50),
anl: 6 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_tablespace: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_shdepend: vac: 25 (threshold 52),
anl: 48 (threshold 51)
2021-08-10 23:33:59 CEST  DEBUG:  pg_shdescription: vac: 1 (threshold
50), anl: 1 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_foreign_data_wrapper: vac: 3
(threshold 50), anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_foreign_server: vac: 3 (threshold
50), anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_foreign_table: vac: 3 (threshold
50), anl: 0 (threshold 50)
2021-08-10 23:33:59 CEST  DEBUG:  pg_toast_2619: vac: 2 (threshold 52),
anl: 4 (threshold 51)
2021-08-10 23:33:59 CEST  DEBUG:  CommitTransaction
2021-08-10 23:33:59 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:33:59 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:33:59 CEST  DEBUG:  shmem_exit(0): 7 on_shmem_exit
callbacks to make
2021-08-10 23:33:59 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:33:59 CEST  DEBUG:  exit(0)
2021-08-10 23:33:59 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:33:59 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:33:59 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:33:59 CEST  DEBUG:  server process (PID 13238500) exited
with exit code 0
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  postgres
child[9044204]: starting with (
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:       postgres
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  )
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  InitPostgres
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG: StartTransaction
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  name: unnamed;
blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2021-08-10 23:34:01 CEST  DEBUG:  forked new backend, pid=9044204 socket=9
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG: CommitTransaction
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  name: unnamed;
blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG: StartTransactionCommand
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG: StartTransaction
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  name: unnamed;
blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG: CommitTransactionCommand
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG: CommitTransaction
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  name: unnamed;
blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
nestlvl: 1, children:
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  shmem_exit(0): 1
before_shmem_exit callbacks to make
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  shmem_exit(0): 6
on_shmem_exit callbacks to make
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  proc_exit(0): 3
callbacks to make
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  exit(0)
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  shmem_exit(-1): 0
before_shmem_exit callbacks to make
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  shmem_exit(-1): 0
on_shmem_exit callbacks to make
2021-08-10 23:34:01 CEST 127.0.0.1 postgresDEBUG:  proc_exit(-1): 0
callbacks to make
2021-08-10 23:34:01 CEST  DEBUG:  server process (PID 9044204) exited
with exit code 0
2021-08-10 23:34:14 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:14 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:14 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:14 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:14 CEST  DEBUG:  received inquiry for database 0
2021-08-10 23:34:14 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:34:14 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:34:14 CEST  DEBUG:  InitPostgres
2021-08-10 23:34:14 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:14 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:14 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:14 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:14 CEST  DEBUG:  autovacuum: processing database
"template1"
2021-08-10 23:34:14 CEST  DEBUG:  received inquiry for database 1
2021-08-10 23:34:14 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:34:14 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_1.stat"
2021-08-10 23:34:14 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:34:14 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:14 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:14 CEST  DEBUG:  pg_statistic: vac: 14 (threshold 127),
anl: 14 (threshold 88)
2021-08-10 23:34:14 CEST  DEBUG:  pg_type: vac: 0 (threshold 122), anl:
0 (threshold 86)
2021-08-10 23:34:14 CEST  DEBUG:  pg_authid: vac: 3 (threshold 50), anl:
5 (threshold 50)
2021-08-10 23:34:14 CEST  DEBUG:  pg_attribute: vac: 0 (threshold 533),
anl: 0 (threshold 292)
2021-08-10 23:34:14 CEST  DEBUG:  pg_class: vac: 0 (threshold 113), anl:
0 (threshold 82)
2021-08-10 23:34:14 CEST  DEBUG:  pg_index: vac: 0 (threshold 74), anl:
0 (threshold 62)
2021-08-10 23:34:14 CEST  DEBUG:  pg_operator: vac: 0 (threshold 205),
anl: 0 (threshold 128)
2021-08-10 23:34:14 CEST  DEBUG:  pg_opclass: vac: 0 (threshold 82),
anl: 0 (threshold 66)
2021-08-10 23:34:14 CEST  DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0
(threshold 51)
2021-08-10 23:34:14 CEST  DEBUG:  pg_amop: vac: 0 (threshold 188), anl:
0 (threshold 119)
2021-08-10 23:34:14 CEST  DEBUG:  pg_amproc: vac: 0 (threshold 159),
anl: 0 (threshold 105)
2021-08-10 23:34:14 CEST  DEBUG:  pg_description: vac: 1 (threshold
818), anl: 1 (threshold 434)
2021-08-10 23:34:14 CEST  DEBUG:  pg_cast: vac: 0 (threshold 93), anl: 0
(threshold 71)
2021-08-10 23:34:14 CEST  DEBUG:  pg_namespace: vac: 4 (threshold 51),
anl: 4 (threshold 51)
2021-08-10 23:34:14 CEST  DEBUG:  pg_database: vac: 4 (threshold 50),
anl: 6 (threshold 50)
2021-08-10 23:34:14 CEST  DEBUG:  pg_tablespace: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:14 CEST  DEBUG:  pg_shdepend: vac: 25 (threshold 52),
anl: 48 (threshold 51)
2021-08-10 23:34:14 CEST  DEBUG:  pg_shdescription: vac: 1 (threshold
50), anl: 1 (threshold 50)
2021-08-10 23:34:14 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:14 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:14 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:14 CEST  DEBUG:  shmem_exit(0): 7 on_shmem_exit
callbacks to make
2021-08-10 23:34:14 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:14 CEST  DEBUG:  exit(0)
2021-08-10 23:34:14 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:14 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:14 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:14 CEST  DEBUG:  server process (PID 9044206) exited
with exit code 0
2021-08-10 23:34:29 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:29 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:29 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:29 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:29 CEST  DEBUG:  received inquiry for database 0
2021-08-10 23:34:29 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:34:29 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:34:29 CEST  DEBUG:  InitPostgres
2021-08-10 23:34:29 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:29 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:29 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:29 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:29 CEST  DEBUG:  autovacuum: processing database "spg"
2021-08-10 23:34:29 CEST  DEBUG:  received inquiry for database 16386
2021-08-10 23:34:29 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:34:29 CEST  DEBUG:  writing stats file
"pg_stat_tmp/db_16386.stat"
2021-08-10 23:34:29 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:34:29 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:29 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:29 CEST  DEBUG:  din: vac: 0 (threshold 1201), anl: 0
(threshold 625)
2021-08-10 23:34:29 CEST  DEBUG:  fb01_fragen: vac: 0 (threshold 123),
anl: 0 (threshold 87)
2021-08-10 23:34:29 CEST  DEBUG:  fb01_kennung: vac: 0 (threshold 250),
anl: 0 (threshold 150)
2021-08-10 23:34:29 CEST  DEBUG:  fb03_fragen: vac: 0 (threshold 132),
anl: 0 (threshold 91)
2021-08-10 23:34:29 CEST  DEBUG:  fb03_kennung: vac: 0 (threshold 650),
anl: 0 (threshold 350)
2021-08-10 23:34:29 CEST  DEBUG:  fb04_fragen: vac: 0 (threshold 50),
anl: 1 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  fb04_kennung: vac: 0 (threshold 678),
anl: 0 (threshold 364)
2021-08-10 23:34:29 CEST  DEBUG:  st_kataloge: vac: 0 (threshold 152),
anl: 0 (threshold 101)
2021-08-10 23:34:29 CEST  DEBUG:  te_handbuch: vac: 0 (threshold 50),
anl: 2 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  te_kataloge: vac: 0 (threshold 258),
anl: 0 (threshold 154)
2021-08-10 23:34:29 CEST  DEBUG:  tele_bcn: vac: 0 (threshold 64), anl:
0 (threshold 57)
2021-08-10 23:34:29 CEST  DEBUG:  tele_bn: vac: 0 (threshold 50), anl:
27 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_extern: vac: 0 (threshold 148),
anl: 0 (threshold 99)
2021-08-10 23:34:29 CEST  DEBUG:  tele_gps: vac: 0 (threshold 65), anl:
0 (threshold 57)
2021-08-10 23:34:29 CEST  DEBUG:  tele_konzern: vac: 0 (threshold 347),
anl: 0 (threshold 199)
2021-08-10 23:34:29 CEST  DEBUG:  tele_kurzwahl: vac: 0 (threshold 206),
anl: 0 (threshold 128)
2021-08-10 23:34:29 CEST  DEBUG:  tele_mwmx: vac: 0 (threshold 50), anl:
8 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_statistic: vac: 84 (threshold 127),
anl: 436 (threshold 88)
2021-08-10 23:34:29 CEST  DEBUG:  pg_type: vac: 0 (threshold 145), anl:
0 (threshold 97)
2021-08-10 23:34:29 CEST  DEBUG:  tele_pers: vac: 0 (threshold 674),
anl: 0 (threshold 362)
2021-08-10 23:34:29 CEST  DEBUG:  tele_psb: vac: 0 (threshold 91), anl:
0 (threshold 71)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sachvz: vac: 0 (threshold 121),
anl: 0 (threshold 86)
2021-08-10 23:34:29 CEST  DEBUG:  tele_satg: vac: 0 (threshold 100),
anl: 0 (threshold 75)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sath: vac: 0 (threshold 117),
anl: 0 (threshold 83)
2021-08-10 23:34:29 CEST  DEBUG:  pg_authid: vac: 3 (threshold 50), anl:
5 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sda: vac: 0 (threshold 74), anl:
0 (threshold 62)
2021-08-10 23:34:29 CEST  DEBUG:  tele_shc: vac: 0 (threshold 50), anl:
1 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_shp: vac: 0 (threshold 74), anl:
0 (threshold 62)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sib: vac: 0 (threshold 50), anl:
3 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sicc: vac: 0 (threshold 50), anl:
4 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sicd: vac: 0 (threshold 72), anl:
0 (threshold 61)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sim: vac: 0 (threshold 50), anl:
21 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_smg: vac: 0 (threshold 110), anl:
0 (threshold 80)
2021-08-10 23:34:29 CEST  DEBUG:  tele_smg_save: vac: 0 (threshold 109),
anl: 0 (threshold 80)
2021-08-10 23:34:29 CEST  DEBUG:  tele_spe: vac: 0 (threshold 50), anl:
20 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sru: vac: 0 (threshold 50), anl:
9 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_ssf: vac: 0 (threshold 50), anl:
26 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_sspc: vac: 0 (threshold 75), anl:
0 (threshold 62)
2021-08-10 23:34:29 CEST  DEBUG:  tele_tsp: vac: 0 (threshold 50), anl:
6 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  tele_vse: vac: 0 (threshold 50), anl:
13 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_attribute: vac: 122 (threshold
807), anl: 0 (threshold 429)
2021-08-10 23:34:29 CEST  DEBUG:  pg_proc: vac: 0 (threshold 615), anl:
28 (threshold 332)
2021-08-10 23:34:29 CEST  DEBUG:  pg_class: vac: 2 (threshold 135), anl:
0 (threshold 93)
2021-08-10 23:34:29 CEST  DEBUG:  pg_attrdef: vac: 0 (threshold 119),
anl: 0 (threshold 84)
2021-08-10 23:34:29 CEST  DEBUG:  pg_constraint: vac: 0 (threshold 50),
anl: 2 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_index: vac: 0 (threshold 74), anl:
34 (threshold 62)
2021-08-10 23:34:29 CEST  DEBUG:  pg_operator: vac: 0 (threshold 205),
anl: 0 (threshold 128)
2021-08-10 23:34:29 CEST  DEBUG:  pg_opclass: vac: 0 (threshold 82),
anl: 0 (threshold 66)
2021-08-10 23:34:29 CEST  DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0
(threshold 51)
2021-08-10 23:34:29 CEST  DEBUG:  pg_amop: vac: 0 (threshold 188), anl:
0 (threshold 119)
2021-08-10 23:34:29 CEST  DEBUG:  pg_amproc: vac: 0 (threshold 159),
anl: 0 (threshold 105)
2021-08-10 23:34:29 CEST  DEBUG:  pg_language: vac: 0 (threshold 51),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_aggregate: vac: 0 (threshold 78),
anl: 0 (threshold 64)
2021-08-10 23:34:29 CEST  DEBUG:  pg_rewrite: vac: 0 (threshold 73),
anl: 0 (threshold 62)
2021-08-10 23:34:29 CEST  DEBUG:  pg_description: vac: 1 (threshold
818), anl: 1 (threshold 434)
2021-08-10 23:34:29 CEST  DEBUG:  pg_cast: vac: 0 (threshold 93), anl: 0
(threshold 71)
2021-08-10 23:34:29 CEST  DEBUG:  pg_namespace: vac: 4 (threshold 51),
anl: 4 (threshold 51)
2021-08-10 23:34:29 CEST  DEBUG:  pg_depend: vac: 0 (threshold 1516),
anl: 614 (threshold 783)
2021-08-10 23:34:29 CEST  DEBUG:  pg_database: vac: 4 (threshold 50),
anl: 6 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_tablespace: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_shdepend: vac: 25 (threshold 53),
anl: 48 (threshold 51)
2021-08-10 23:34:29 CEST  DEBUG:  pg_shdescription: vac: 1 (threshold
50), anl: 1 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_collation: vac: 0 (threshold 53),
anl: 0 (threshold 52)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16416: vac: 0 (threshold 50),
anl: 1 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16446: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16456: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16484: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16579: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16599: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16649: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_2618: vac: 0 (threshold 91),
anl: 0 (threshold 70)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_2619: vac: 1 (threshold 52),
anl: 66 (threshold 51)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16697: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  pg_toast_16873: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:29 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:29 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:29 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:29 CEST  DEBUG:  shmem_exit(0): 7 on_shmem_exit
callbacks to make
2021-08-10 23:34:29 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:29 CEST  DEBUG:  exit(0)
2021-08-10 23:34:29 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:29 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:29 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:29 CEST  DEBUG:  server process (PID 9044208) exited
with exit code 0
2021-08-10 23:34:44 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:44 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:44 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:44 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:44 CEST  DEBUG:  received inquiry for database 0
2021-08-10 23:34:44 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:34:44 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:34:44 CEST  DEBUG:  InitPostgres
2021-08-10 23:34:44 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:44 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:44 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:44 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:44 CEST  DEBUG:  autovacuum: processing database "postgres"
2021-08-10 23:34:44 CEST  DEBUG:  received inquiry for database 12416
2021-08-10 23:34:44 CEST  DEBUG:  writing stats file
"pg_stat_tmp/global.stat"
2021-08-10 23:34:44 CEST  DEBUG:  writing stats file
"pg_stat_tmp/db_12416.stat"
2021-08-10 23:34:44 CEST  DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-08-10 23:34:44 CEST  DEBUG:  StartTransaction
2021-08-10 23:34:44 CEST  DEBUG:  name: unnamed; blockState: DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:44 CEST  DEBUG:  pg_statistic: vac: 0 (threshold 127),
anl: 0 (threshold 88)
2021-08-10 23:34:44 CEST  DEBUG:  pg_type: vac: 0 (threshold 122), anl:
0 (threshold 86)
2021-08-10 23:34:44 CEST  DEBUG:  pg_authid: vac: 3 (threshold 50), anl:
5 (threshold 50)
2021-08-10 23:34:44 CEST  DEBUG:  pg_attribute: vac: 0 (threshold 533),
anl: 0 (threshold 292)
2021-08-10 23:34:44 CEST  DEBUG:  pg_proc: vac: 0 (threshold 615), anl:
0 (threshold 332)
2021-08-10 23:34:44 CEST  DEBUG:  pg_class: vac: 0 (threshold 113), anl:
0 (threshold 82)
2021-08-10 23:34:44 CEST  DEBUG:  pg_index: vac: 0 (threshold 74), anl:
0 (threshold 62)
2021-08-10 23:34:44 CEST  DEBUG:  pg_opclass: vac: 0 (threshold 82),
anl: 0 (threshold 66)
2021-08-10 23:34:44 CEST  DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0
(threshold 51)
2021-08-10 23:34:44 CEST  DEBUG:  pg_amop: vac: 0 (threshold 188), anl:
0 (threshold 119)
2021-08-10 23:34:44 CEST  DEBUG:  pg_amproc: vac: 0 (threshold 159),
anl: 0 (threshold 105)
2021-08-10 23:34:44 CEST  DEBUG:  pg_description: vac: 1 (threshold
818), anl: 1 (threshold 434)
2021-08-10 23:34:44 CEST  DEBUG:  pg_cast: vac: 0 (threshold 93), anl: 0
(threshold 71)
2021-08-10 23:34:44 CEST  DEBUG:  pg_namespace: vac: 4 (threshold 51),
anl: 4 (threshold 51)
2021-08-10 23:34:44 CEST  DEBUG:  pg_database: vac: 4 (threshold 50),
anl: 6 (threshold 50)
2021-08-10 23:34:44 CEST  DEBUG:  pg_tablespace: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2021-08-10 23:34:44 CEST  DEBUG:  pg_shdepend: vac: 25 (threshold 50),
anl: 48 (threshold 50)
2021-08-10 23:34:44 CEST  DEBUG:  pg_shdescription: vac: 1 (threshold
50), anl: 1 (threshold 50)
2021-08-10 23:34:44 CEST  DEBUG:  CommitTransaction
2021-08-10 23:34:44 CEST  DEBUG:  name: unnamed; blockState: STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2021-08-10 23:34:44 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:44 CEST  DEBUG:  shmem_exit(0): 7 on_shmem_exit
callbacks to make
2021-08-10 23:34:44 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:44 CEST  DEBUG:  exit(0)
2021-08-10 23:34:44 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:44 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:44 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:44 CEST  DEBUG:  server process (PID 9044210) exited
with exit code 0
2021-08-10 23:34:49 CEST  DEBUG:  postmaster received signal 2
2021-08-10 23:34:49 CEST  LOG:  received fast shutdown request
2021-08-10 23:34:49 CEST  LOG:  aborting any active transactions
2021-08-10 23:34:49 CEST  LOG:  autovacuum launcher shutting down
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 6 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  exit(0)
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 3 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  exit(0)
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 3 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  exit(0)
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:49 CEST  LOG:  shutting down
2021-08-10 23:34:49 CEST  DEBUG:  performing replication slot checkpoint
2021-08-10 23:34:49 CEST  DEBUG:  attempting to remove WAL segments
older than log file 000000000000000000000001
2021-08-10 23:34:49 CEST  DEBUG:  SlruScanDirectory invoking callback on
pg_subtrans/0000
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 1 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 3 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  exit(0)
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  writing stats file "pg_stat/global.stat"
2021-08-10 23:34:49 CEST  DEBUG:  writing stats file "pg_stat/db_12416.stat"
2021-08-10 23:34:49 CEST  DEBUG:  removing temporary stats file
"pg_stat_tmp/db_12416.stat"
2021-08-10 23:34:49 CEST  DEBUG:  writing stats file "pg_stat/db_16387.stat"
2021-08-10 23:34:49 CEST  DEBUG:  removing temporary stats file
"pg_stat_tmp/db_16387.stat"
2021-08-10 23:34:49 CEST  DEBUG:  writing stats file "pg_stat/db_16386.stat"
2021-08-10 23:34:49 CEST  DEBUG:  removing temporary stats file
"pg_stat_tmp/db_16386.stat"
2021-08-10 23:34:49 CEST  DEBUG:  writing stats file "pg_stat/db_1.stat"
2021-08-10 23:34:49 CEST  DEBUG:  removing temporary stats file
"pg_stat_tmp/db_1.stat"
2021-08-10 23:34:49 CEST  DEBUG:  writing stats file "pg_stat/db_0.stat"
2021-08-10 23:34:49 CEST  DEBUG:  removing temporary stats file
"pg_stat_tmp/db_0.stat"
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(0): 5 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  cleaning up dynamic shared memory
control segment with ID 563757097
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(0): 2 callbacks to make
2021-08-10 23:34:49 CEST  LOG:  database system is shut down
2021-08-10 23:34:49 CEST  DEBUG:  exit(0)
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  shmem_exit(-1): 0 on_shmem_exit
callbacks to make
2021-08-10 23:34:49 CEST  DEBUG:  proc_exit(-1): 0 callbacks to make

Bye
  Rainer

On 10.08.2021 19:07, Tom Lane wrote:
> Rainer Tammer <pgsql(at)spg(dot)schulergroup(dot)com> writes:
>> 2021-08-10 17:15:44 CEST  LOG:  00000: received fast shutdown request
>> 2021-08-10 17:15:44 CEST  LOCATION:  pmdie, postmaster.c:2215
>> The postmaster simply dies after about 1 hour.
> Something is sending the postmaster a SIGINT signal.
>
> regards, tom lane
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kämpf 2021-08-11 07:23:33 AW: AW: BUG #16858: clang10-devel packages are missing in SLES15 SP2 in general
Previous Message PG Bug reporting form 2021-08-10 18:29:45 BUG #17140: pg_try_advisory_xact_lock produces a WARNINIG on unsuccessful lock