Mock Version: 3.5 Mock Version: 3.5 Mock Version: 3.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/f39-build-1622462-38802/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=996gid=135user='mockbuild'nspawn_args=[]unshare_net=TrueprintOutput=False) Executing command: ['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'} and shell False Building target platforms: noarch Building for target noarch setting SOURCE_DATE_EPOCH=1699488000 Wrote: /builddir/build/SRPMS/postgresqltuner-1.0.1-1.fc39.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/f39-build-1622462-38802/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=996gid=135user='mockbuild'nspawn_args=[]unshare_net=TrueprintOutput=False) Executing command: ['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'} and shell False Building target platforms: noarch Building for target noarch setting SOURCE_DATE_EPOCH=1699488000 Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.vlXnKL + umask 022 + cd /builddir/build/BUILD + cd /builddir/build/BUILD + rm -rf postgresqltuner-1.0.1 + /usr/lib/rpm/rpmuncompress -x /builddir/build/SOURCES/postgresqltuner-1.0.1.tar.gz + STATUS=0 + '[' 0 -ne 0 ']' + cd postgresqltuner-1.0.1 + rm -rf /builddir/build/BUILD/postgresqltuner-1.0.1-SPECPARTS + /usr/bin/mkdir -p /builddir/build/BUILD/postgresqltuner-1.0.1-SPECPARTS + /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.oIJq4C + umask 022 + cd /builddir/build/BUILD + '[' /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch '!=' / ']' + rm -rf /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch ++ dirname /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch + mkdir -p /builddir/build/BUILDROOT + mkdir /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch + 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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -Clink-arg=-Wl,-z,relro -Clink-arg=-Wl,-z,now --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-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/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch//usr/bin + cp -a postgresqltuner.pl /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/bin/postgresqltuner + /usr/lib/rpm/check-buildroot + /usr/lib/rpm/redhat/brp-ldconfig + /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/brp-strip-static-archive /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 + env /usr/lib/rpm/redhat/brp-python-bytecompile '' 1 0 -j8 + /usr/lib/rpm/redhat/brp-python-hardlink Executing(%check): /bin/sh -e /var/tmp/rpm-tmp.XpsObn + umask 022 + cd /builddir/build/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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -fasynchronous-unwind-tables -fstack-clash-protection -fno-omit-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 -Clink-arg=-Wl,-z,relro -Clink-arg=-Wl,-z,now --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-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/datadir +++ id -u -n ++ : mockbuild ++ : mockbuild ++ : mockbuild +++ try_random_port +++ _port=8285 +++ test -n 8285 +++ eval '_port=$(( $_port + 32000 ))' +++ echo 40285 ++ : 40285 ++ : /tmp ++ : test:test ++ : test:test ++ : : ++ : : ++ : : ++ export PGPORT=40285 ++ PGPORT=40285 ++ export PGHOST=/tmp ++ PGHOST=/tmp ++ : ++ trap __trap_cb EXIT + pgtests_start + unset __TRAP_ACTIONS + : + test -f /builddir/build/BUILD/postgresqltuner-1.0.1/datadir/postmaster.pid + test -e /builddir/build/BUILD/postgresqltuner-1.0.1/datadir + __pgtests_initdb + initdb /builddir/build/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 disabled. creating directory /builddir/build/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 ... America/New_York creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... 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/datadir -l logfile start + __TRAP_ACTIONS='pgtests_cleanup ' + __pgtests_start + pg_ctl -D /builddir/build/BUILD/postgresqltuner-1.0.1/datadir -l /builddir/build/BUILD/postgresqltuner-1.0.1/datadir/start.log start -o '-k /tmp -p 40285' -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 40285 + __pgtests_passwd mockbuild mockbuild + psql -d postgres --set=user=mockbuild --set=pass=mockbuild -tA ALTER ROLE + for _pgt_user in $PGTESTS_USERS + save_IFS=' ' + 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 ALTER ROLE + IFS=' ' + for _pgt_db in $PGTESTS_DATABASES + save_IFS=' ' + 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=' ' + /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/bin/postgresqltuner --host=/tmp --port=40285 --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:40285 database mockbuild with user mockbuild... [OK] User used for report have super rights ===== OS information ===== [INFO] OS: linux Version: 6.2.15-300.0.riscv64.fc38.riscv64 Arch: riscv64-linux-thread-multi Use of uninitialized value $os_mem in pattern match (m//) at /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/bin/postgresqltuner line 272. Use of uninitialized value $os_mem in pattern match (m//) at /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/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) [INFO] sysctl vm.overcommit_ratio=50 [BAD] vm.overcommit_ratio is too small, you will not be able to use more than 50*RAM+SWAP for applications [INFO] Running in KVM hypervisor [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 [WARN] On virtual machines, /sys/block/DISK/queue/rotational is not accurate. Use the --ssd arg if the VM in running on a SSD storage ===== General instance informations ===== ----- Version ----- [OK] You are using last 15.1 ----- Uptime ----- [INFO] Service uptime : 11s [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: 6 (6.00%) [INFO] 3 are reserved for super user (3.00%) [INFO] Average connection age : 10s ----- 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 : 35.93 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.63 MB [INFO] Database mockbuild tables size : 5.01 MB (65.61%) [INFO] Database mockbuild indexes size : 2.62 MB (34.39%) ----- Tablespace location ----- [OK] No tablespace in PGDATA ----- Shared buffer hit rate ----- [INFO] shared_buffer_heap_hit_rate: 97.97% [INFO] shared_buffer_toast_hit_rate: 83.33% [INFO] shared_buffer_tidx_hit_rate: 37.50% [INFO] shared_buffer_idx_hit_rate: 98.19% [OK] Shared buffer idx hit rate is very good ----- 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) ----- report ----- [URGENT] Use the --ssd arg if the VM in running on a SSD storage ----- 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/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/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-1.fc39.noarch Executing(%doc): /bin/sh -e /var/tmp/rpm-tmp.u4ntBD + umask 022 + cd /builddir/build/BUILD + cd postgresqltuner-1.0.1 + DOCDIR=/builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/doc/postgresqltuner + export LC_ALL= + LC_ALL= + export DOCDIR + /usr/bin/mkdir -p /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/doc/postgresqltuner + cp -pr /builddir/build/BUILD/postgresqltuner-1.0.1/README.md /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/doc/postgresqltuner + cp -pr /builddir/build/BUILD/postgresqltuner-1.0.1/README.fr.md /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/doc/postgresqltuner + RPM_EC=0 ++ jobs -p + exit 0 Executing(%license): /bin/sh -e /var/tmp/rpm-tmp.tmFiak + umask 022 + cd /builddir/build/BUILD + cd postgresqltuner-1.0.1 + LICENSEDIR=/builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/licenses/postgresqltuner + export LC_ALL= + LC_ALL= + export LICENSEDIR + /usr/bin/mkdir -p /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/licenses/postgresqltuner + cp -pr /builddir/build/BUILD/postgresqltuner-1.0.1/LICENSE.txt /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch/usr/share/licenses/postgresqltuner + RPM_EC=0 ++ jobs -p + exit 0 Provides: postgresqltuner = 1.0.1-1.fc39 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/BUILDROOT/postgresqltuner-1.0.1-1.fc39.noarch Wrote: /builddir/build/RPMS/postgresqltuner-1.0.1-1.fc39.noarch.rpm Child return code was: 0