Mock Version: 6.5 Mock Version: 6.5 Mock Version: 6.5 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bs --noclean --target noarch --nodeps /builddir/build/SPECS/postgresqltuner.spec'], chrootPath='/var/lib/mock/f45-build-28902-633/root'env={'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8'}shell=Falselogger=timeout=864000uid=995gid=135user='mockbuild'unshare_net=TrueprintOutput=Falsenspawn_args=['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.u3ev91hr:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11']) Using nspawn with args ['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.u3ev91hr:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11'] Executing command: ['/usr/bin/systemd-nspawn', '-q', '-M', 'd6c8aeceb43347408cb097281f67a117', '-D', '/var/lib/mock/f45-build-28902-633/root', '-a', '-u', 'mockbuild', '--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.u3ev91hr:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11', '--console=pipe', '--setenv=TERM=vt100', '--setenv=SHELL=/bin/bash', '--setenv=HOME=/builddir', '--setenv=HOSTNAME=mock', '--setenv=PATH=/usr/bin:/bin:/usr/sbin:/sbin', '--setenv=PROMPT_COMMAND=printf "\\033]0;\\007"', '--setenv=PS1= \\s-\\v\\$ ', '--setenv=LANG=C.UTF-8', '--resolv-conf=off', 'bash', '--login', '-c', '/usr/bin/rpmbuild -bs --noclean --target noarch --nodeps /builddir/build/SPECS/postgresqltuner.spec'] with env {'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8', 'SYSTEMD_NSPAWN_TMPFS_TMP': '0', 'SYSTEMD_SECCOMP': '0'} and shell False Building target platforms: noarch Building for target noarch setting SOURCE_DATE_EPOCH=1784160000 Wrote: /builddir/build/SRPMS/postgresqltuner-1.0.1-18.fc45.src.rpm Child return code was: 0 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bb --noclean --target noarch --nodeps /builddir/build/SPECS/postgresqltuner.spec'], chrootPath='/var/lib/mock/f45-build-28902-633/root'env={'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8'}shell=Falselogger=timeout=864000uid=995gid=135user='mockbuild'unshare_net=TrueprintOutput=Falsenspawn_args=['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.u3ev91hr:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11']) Using nspawn with args ['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.u3ev91hr:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11'] Executing command: ['/usr/bin/systemd-nspawn', '-q', '-M', '709e1ae3cca2465b83abe72e511bd519', '-D', '/var/lib/mock/f45-build-28902-633/root', '-a', '-u', 'mockbuild', '--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.u3ev91hr:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11', '--console=pipe', '--setenv=TERM=vt100', '--setenv=SHELL=/bin/bash', '--setenv=HOME=/builddir', '--setenv=HOSTNAME=mock', '--setenv=PATH=/usr/bin:/bin:/usr/sbin:/sbin', '--setenv=PROMPT_COMMAND=printf "\\033]0;\\007"', '--setenv=PS1= \\s-\\v\\$ ', '--setenv=LANG=C.UTF-8', '--resolv-conf=off', 'bash', '--login', '-c', '/usr/bin/rpmbuild -bb --noclean --target noarch --nodeps /builddir/build/SPECS/postgresqltuner.spec'] with env {'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8', 'SYSTEMD_NSPAWN_TMPFS_TMP': '0', 'SYSTEMD_SECCOMP': '0'} and shell False Building target platforms: noarch Building for target noarch setting SOURCE_DATE_EPOCH=1784160000 Executing(mkbuilddir): /bin/sh -e /var/tmp/rpm-tmp.0ifaoI Creating(rpmbuild.env): /builddir/build/BUILD/postgresqltuner-1.0.1-build/rpmbuild.env RPM_SOURCE_DIR="/builddir/build/SOURCES" RPM_BUILD_DIR="/builddir/build/BUILD/postgresqltuner-1.0.1-build" RPM_OPT_FLAGS="-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Wno-complain-wrong-lang -Werror=format-security -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer" RPM_LD_FLAGS="-Wl,-z,relro -Wl,--as-needed -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -specs=/usr/lib/rpm/redhat/redhat-hardened-ld-errors -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -Wl,--build-id=sha1 " RPM_ARCH="noarch" RPM_OS="linux" RPM_BUILD_NCPUS="8" RPM_SPECPARTS_DIR="/builddir/build/BUILD/postgresqltuner-1.0.1-build/SPECPARTS" export RPM_SOURCE_DIR RPM_BUILD_DIR RPM_OPT_FLAGS RPM_ARCH RPM_OS RPM_BUILD_NCPUS RPM_SPECPARTS_DIR RPM_LD_FLAGS RPM_DOC_DIR="/usr/share/doc" export RPM_DOC_DIR RPM_PACKAGE_NAME="postgresqltuner" RPM_PACKAGE_VERSION="1.0.1" RPM_PACKAGE_RELEASE="18.fc45" export RPM_PACKAGE_NAME RPM_PACKAGE_VERSION RPM_PACKAGE_RELEASE LANG=C.UTF-8 export LANG unset CDPATH DISPLAY ||: unset DEBUGINFOD_URLS ||: unset RPM_CONFIG_DIR ||: RPM_BUILD_ROOT="/builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT" export RPM_BUILD_ROOT PKG_CONFIG_PATH="${PKG_CONFIG_PATH}:/usr/lib/pkgconfig:/usr/share/pkgconfig" export PKG_CONFIG_PATH CONFIG_SITE=${CONFIG_SITE:-NONE} export CONFIG_SITE Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.DmKIwL + umask 022 + cd /builddir/build/BUILD/postgresqltuner-1.0.1-build + cd /builddir/build/BUILD/postgresqltuner-1.0.1-build + rm -rf postgresqltuner-1.0.1 + /usr/bin/rpmuncompress -x /builddir/build/SOURCES/postgresqltuner-1.0.1.tar.gz + STATUS=0 + '[' 0 -ne 0 ']' + cd postgresqltuner-1.0.1 + /usr/bin/chmod -Rf a+rX,u+w,g-w,o-w . + RPM_EC=0 ++ jobs -p + exit 0 Executing(%install): /bin/sh -e /var/tmp/rpm-tmp.9j3Plb + umask 022 + cd /builddir/build/BUILD/postgresqltuner-1.0.1-build + '[' /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT '!=' / ']' + rm -rf /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT ++ dirname /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT + mkdir -p /builddir/build/BUILD/postgresqltuner-1.0.1-build + mkdir /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT + CFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer ' + export CFLAGS + CXXFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer ' + export CXXFLAGS + FFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -I/usr/lib/gfortran/modules ' + export FFLAGS + FCFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -I/usr/lib/gfortran/modules ' + export FCFLAGS + VALAFLAGS=-g + export VALAFLAGS + RUSTFLAGS='-Copt-level=3 -Cdebuginfo=2 -Ccodegen-units=1 -Cstrip=none -Cforce-frame-pointers=yes --cap-lints=warn' + export RUSTFLAGS + LDFLAGS='-Wl,-z,relro -Wl,--as-needed -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -specs=/usr/lib/rpm/redhat/redhat-hardened-ld-errors -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -Wl,--build-id=sha1 ' + export LDFLAGS + LT_SYS_LIBRARY_PATH=/usr/lib: + export LT_SYS_LIBRARY_PATH + CC=gcc + export CC + CXX=g++ + export CXX + cd postgresqltuner-1.0.1 + mkdir -p /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT//usr/bin + cp -a postgresqltuner.pl /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner + /usr/lib/rpm/check-buildroot + /usr/lib/rpm/redhat/brp-ldconfig + COMPRESS='gzip -9 -n' + COMPRESS_EXT=.gz + /usr/lib/rpm/brp-compress + /usr/lib/rpm/brp-strip /usr/bin/strip + /usr/lib/rpm/brp-strip-comment-note /usr/bin/strip /usr/bin/objdump + /usr/lib/rpm/redhat/brp-strip-lto /usr/bin/strip + /usr/lib/rpm/check-rpaths + /usr/lib/rpm/redhat/brp-mangle-shebangs mangling shebang in /usr/bin/postgresqltuner from /usr/bin/env perl to #!/usr/bin/perl + /usr/lib/rpm/brp-remove-la-files + /usr/lib/rpm/redhat/brp-python-rpm-in-distinfo + env /usr/lib/rpm/redhat/brp-python-bytecompile '' 1 0 -j8 + /usr/lib/rpm/redhat/brp-python-hardlink + /usr/bin/add-det --brp -j8 /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT Scanned 3 directories and 1 files, processed 0 inodes, 0 modified (0 replaced + 0 rewritten), 0 unsupported format, 0 errors + /usr/bin/linkdupes --brp /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr Scanned 2 directories and 1 files, considered 1 files, read 0 files, linked 0 files, 0 errors sum of sizes of linked files: 0 bytes Executing(%check): /bin/sh -e /var/tmp/rpm-tmp.UWcAxO + umask 022 + cd /builddir/build/BUILD/postgresqltuner-1.0.1-build + CFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer ' + export CFLAGS + CXXFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer ' + export CXXFLAGS + FFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -I/usr/lib/gfortran/modules ' + export FFLAGS + FCFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Wp,-U_FORTIFY_SOURCE,-D_FORTIFY_SOURCE=3 -Wp,-D_GLIBCXX_ASSERTIONS -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -march=rva23u64 -mabi=lp64d -fasynchronous-unwind-tables -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -I/usr/lib/gfortran/modules ' + export FCFLAGS + VALAFLAGS=-g + export VALAFLAGS + RUSTFLAGS='-Copt-level=3 -Cdebuginfo=2 -Ccodegen-units=1 -Cstrip=none -Cforce-frame-pointers=yes --cap-lints=warn' + export RUSTFLAGS + LDFLAGS='-Wl,-z,relro -Wl,--as-needed -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -specs=/usr/lib/rpm/redhat/redhat-hardened-ld-errors -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -Wl,--build-id=sha1 ' + export LDFLAGS + LT_SYS_LIBRARY_PATH=/usr/lib: + export LT_SYS_LIBRARY_PATH + CC=gcc + export CC + CXX=g++ + export CXX + cd postgresqltuner-1.0.1 + . /usr/share/postgresql-setup/postgresql_pkg_tests.sh +++ pwd ++ : /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir +++ id -u -n ++ : mockbuild ++ : mockbuild ++ : mockbuild +++ try_random_port +++ _port=28166 +++ test -n 28166 +++ eval '_port=$(( $_port + 32000 ))' +++ echo 60166 ++ : 60166 ++ : /tmp ++ : test:test ++ : test:test ++ : : ++ : : ++ : : ++ export PGPORT=60166 ++ PGPORT=60166 ++ export PGHOST=/tmp ++ PGHOST=/tmp ++ : ++ trap __trap_cb EXIT + pgtests_start + unset __TRAP_ACTIONS + : + test -f /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir/postmaster.pid + test -e /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir + __pgtests_initdb + initdb /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir -U mockbuild --auth-local=peer --auth-host=md5 The files belonging to this database system will be owned by user "mockbuild". This user must also own the server process. The database cluster will be initialized with locale "C.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... initdb: warning: could not open directory "/usr/share/zoneinfo": No such file or directory CST-8 creating configuration files ... ok running bootstrap script ... 2026-10-17 05:32:51.599 GMT [163] LOG: could not open directory "/usr/share/zoneinfo": No such file or directory ok performing post-bootstrap initialization ... 2026-10-17 05:32:51.955 GMT [165] LOG: could not open directory "/usr/share/zoneinfo": No such file or directory ok syncing data to disk ... ok Success. You can now start the database server using: pg_ctl -D /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir -l logfile start + __TRAP_ACTIONS='pgtests_cleanup ' + __pgtests_start + pg_ctl -D /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir -l /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir/start.log start -o '-k /tmp -p 60166' -w waiting for server to start.... done server started + __TRAP_ACTIONS='pgtests_stop pgtests_cleanup ' + __pgtests_create_admins_db + createdb -h /tmp mockbuild --owner mockbuild -p 60166 + __pgtests_passwd mockbuild mockbuild + psql -d postgres --set=user=mockbuild --set=pass=mockbuild -tA WARNING: setting an MD5-encrypted password DETAIL: MD5 password support is deprecated and will be removed in a future release of PostgreSQL. HINT: Refer to the PostgreSQL documentation for details about migrating to another password type. ALTER ROLE + for _pgt_user in $PGTESTS_USERS + save_IFS=$' \t\n' + IFS=: + _user= + _pass= + for _part in $_pgt_user + test -z '' + _user=test + for _part in $_pgt_user + test -z test + _pass=test + createuser test + __pgtests_passwd test test + psql -d postgres --set=user=test --set=pass=test -tA WARNING: setting an MD5-encrypted password DETAIL: MD5 password support is deprecated and will be removed in a future release of PostgreSQL. HINT: Refer to the PostgreSQL documentation for details about migrating to another password type. ALTER ROLE + IFS=$' \t\n' + for _pgt_db in $PGTESTS_DATABASES + save_IFS=$' \t\n' + IFS=: + _db= + _user= + for _part in $_pgt_db + test -z '' + _user=test + for _part in $_pgt_db + test -z test + _db=test + createdb test --owner test + IFS=$' \t\n' + /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner --host=/tmp --port=60166 --database=mockbuild --user=mockbuild --password=mockbuild postgresqltuner.pl version 1.0.1 Checking if OS commands is available on /tmp... [OK] OS command OK Connecting to /tmp:60166 database mockbuild with user mockbuild... [OK] User used for report have super rights ===== OS information ===== [INFO] OS: linux Version: 6.11.0 Arch: riscv64-linux-thread-multi Use of uninitialized value $os_mem in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 272. Use of uninitialized value $os_mem in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 273. [INFO] OS total memory: 0 [BAD] Memory overcommitment is allowed on the system. This can lead to OOM Killer killing some PostgreSQL process, which will cause a PostgreSQL server restart (crash recovery) [BAD] vm.overcommit_ratio is too small, you will not be able to use more than 50*RAM+SWAP for applications [INFO] sysctl vm.overcommit_ratio=50 Use of uninitialized value $line in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 308. Use of uninitialized value $line in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 311. Use of uninitialized value $line in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 314. Use of uninitialized value $line in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 317. Use of uninitialized value $line in pattern match (m//) at /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/bin/postgresqltuner line 320. [INFO] Running on physical machine [UNKNOWN] Unable to identify scheduler for disk zram0 [BAD] Average connection age is less than 1 minute. Use a connection pooler to limit new connection/seconds [BAD] some plan features are disabled : enable_partitionwise_aggregate,enable_partitionwise_join [INFO] Currently used I/O scheduler(s) : none,bfq ===== General instance informations ===== ----- Version ----- [OK] You are using last 18.3 ----- Uptime ----- [INFO] Service uptime : 00s [WARN] Uptime is less than 1 day. postgresqltuner.pl result may not be accurate ----- Databases ----- [INFO] Database count (except templates): 3 [INFO] Database list (except templates): postgres mockbuild test ----- Extensions ----- [INFO] Number of activated extensions : 1 [INFO] Activated extensions : plpgsql [WARN] Extensions pg_stat_statements is disabled in database mockbuild ----- Users ----- [OK] No user account will expire in less than 7 days [WARN] some users account have the username as password : mockbuild,test [OK] Password encryption is enabled ----- Connection information ----- [INFO] max_connections: 100 [INFO] current used connections: 9 (9.00%) [INFO] 3 are reserved for super user (3.00%) [INFO] Average connection age : 00s ----- Memory usage ----- [INFO] configured work_mem: 4.00 MB [INFO] Using an average ratio of work_mem buffers by connection of 150% (use --wmp to change it) [INFO] total work_mem (per connection): 6.00 MB [INFO] shared_buffers: 128.00 MB [INFO] Track activity reserved size : 0.00 B [WARN] maintenance_work_mem is less or equal default value. Increase it to reduce maintenance tasks time [INFO] Max memory usage : shared_buffers (128.00 MB) + max_connections * work_mem * average_work_mem_buffers_per_connection (100 * 4.00 MB * 150 / 100 = 600.00 MB) + autovacuum_max_workers * maintenance_work_mem (3 * 64.00 MB = 192.00 MB) + track activity size (0.00 B) = 920.00 MB [INFO] effective_cache_size: 4.00 GB [INFO] Size of all databases : 37.03 MB [WARN] shared_buffer is too big for the total databases size, memory is lost [UNKNOWN] OS total mem unknown : unable to analyse PostgreSQL memory usage ----- Logs ----- [OK] log_hostname is off : no reverse DNS lookup latency [WARN] log of long queries is desactivated. It will be more difficult to optimize query performances [OK] log_statement=none ----- Two phase commit ----- [OK] Currently no two phase commit transactions ----- Autovacuum ----- [OK] autovacuum is activated. [INFO] autovacuum_max_workers: 3 ----- Checkpoint ----- [OK] checkpoint_completion_target(0.9) OK ----- Disk access ----- [OK] fsync is on [OK] synchronize_seqscans is on ----- WAL ----- ----- Planner ----- [OK] costs settings are defaults ===== Database information for database mockbuild ===== ----- Database size ----- [INFO] Database mockbuild total size : 7.87 MB [INFO] Database mockbuild tables size : 5.09 MB (64.75%) [INFO] Database mockbuild indexes size : 2.77 MB (35.25%) ----- Tablespace location ----- [OK] No tablespace in PGDATA ----- Shared buffer hit rate ----- [INFO] shared_buffer_heap_hit_rate: 98.44% [INFO] shared_buffer_toast_hit_rate: 0.00% [INFO] shared_buffer_tidx_hit_rate: 11.11% [INFO] shared_buffer_idx_hit_rate: 95.78% [WARN] Shared buffer idx hit rate is quite good. Increase shared_buffer memory to increase hit rate ----- Indexes ----- [OK] No invalid indexes [OK] No unused indexes ----- Procedures ----- [OK] No procedures with default costs ===== Configuration advices ===== ----- extension ----- [LOW] Enable pg_stat_statements in database mockbuild to collect statistics on all queries (not only queries longer than log_min_duration_statement in logs) ----- sysctl ----- [URGENT] set vm.overcommit_memory=2 in /etc/sysctl.conf and run sysctl -p to reload it. This will disable memory overcommitment and avoid postgresql killed by OOM killer. + RPM_EC=0 ++ jobs -p + exit 0 + __trap_cb + IFS=' ' + for __func in $__TRAP_ACTIONS + pgtests_stop + pg_ctl stop -D /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir -w waiting for server to shut down.... done server stopped + __clean_trap_action pgtests_stop + __new_actions= + for __action in $__TRAP_ACTIONS + test pgtests_stop = pgtests_stop + : + for __action in $__TRAP_ACTIONS + test pgtests_cleanup = pgtests_stop + __new_actions='pgtests_cleanup ' + __TRAP_ACTIONS='pgtests_cleanup ' + for __func in $__TRAP_ACTIONS + pgtests_cleanup + : + rm -r /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/datadir + __clean_trap_action pgtests_cleanup + __new_actions= + for __action in $__TRAP_ACTIONS + test pgtests_cleanup = pgtests_cleanup + : + __TRAP_ACTIONS= Processing files: postgresqltuner-1.0.1-18.fc45.noarch Executing(%doc): /bin/sh -e /var/tmp/rpm-tmp.zJ9g4y + umask 022 + cd /builddir/build/BUILD/postgresqltuner-1.0.1-build + cd postgresqltuner-1.0.1 + DOCDIR=/builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/doc/postgresqltuner + export LC_ALL=C.UTF-8 + LC_ALL=C.UTF-8 + export DOCDIR + /usr/bin/mkdir -p /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/doc/postgresqltuner + cp -pr /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/README.md /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/doc/postgresqltuner + cp -pr /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/README.fr.md /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/doc/postgresqltuner + RPM_EC=0 ++ jobs -p + exit 0 Executing(%license): /bin/sh -e /var/tmp/rpm-tmp.iVTzJv + umask 022 + cd /builddir/build/BUILD/postgresqltuner-1.0.1-build + cd postgresqltuner-1.0.1 + LICENSEDIR=/builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/licenses/postgresqltuner + export LC_ALL=C.UTF-8 + LC_ALL=C.UTF-8 + export LICENSEDIR + /usr/bin/mkdir -p /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/licenses/postgresqltuner + cp -pr /builddir/build/BUILD/postgresqltuner-1.0.1-build/postgresqltuner-1.0.1/LICENSE.txt /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT/usr/share/licenses/postgresqltuner + RPM_EC=0 ++ jobs -p + exit 0 Provides: postgresqltuner = 1.0.1-18.fc45 Requires(rpmlib): rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 Requires: /usr/bin/perl Checking for unpackaged file(s): /usr/lib/rpm/check-files /builddir/build/BUILD/postgresqltuner-1.0.1-build/BUILDROOT Wrote: /builddir/build/RPMS/postgresqltuner-1.0.1-18.fc45.noarch.rpm Child return code was: 0