Mock Version: 3.0 Mock Version: 3.0 Mock Version: 3.0 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bs --target noarch --nodeps /builddir/build/SPECS/postgresqltuner.spec'], chrootPath='/var/lib/mock/f37-build-side-32-misc-devel-141909-8841/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 --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=1674432000 Wrote: /builddir/build/SRPMS/postgresqltuner-1.0.1-1.fc37.src.rpm Child return code was: 0 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bb --target noarch --nodeps /builddir/build/SPECS/postgresqltuner.spec'], chrootPath='/var/lib/mock/f37-build-side-32-misc-devel-141909-8841/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 --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=1674432000 Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.gEOwNb + 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 + /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.wRmNGc + umask 022 + cd /builddir/build/BUILD + '[' /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch '!=' / ']' + rm -rf /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch ++ dirname /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch + mkdir -p /builddir/build/BUILDROOT + mkdir /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch + CFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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' + export CFLAGS + CXXFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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' + export CXXFLAGS + FFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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 -I/usr/lib/gfortran/modules' + export FFLAGS + FCFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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 -I/usr/lib/gfortran/modules' + export FCFLAGS + 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.fc37.noarch//usr/bin + cp -a postgresqltuner.pl /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.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 + /usr/lib/rpm/redhat/brp-python-bytecompile '' 1 0 + /usr/lib/rpm/redhat/brp-python-hardlink Executing(%check): /bin/sh -e /var/tmp/rpm-tmp.lQL7cf + umask 022 + cd /builddir/build/BUILD + CFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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' + export CFLAGS + CXXFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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' + export CXXFLAGS + FFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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 -I/usr/lib/gfortran/modules' + export FFLAGS + FCFLAGS='-O2 -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -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 -I/usr/lib/gfortran/modules' + export FCFLAGS + 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=9852 +++ test -n 9852 +++ eval '_port=$(( $_port + 32000 ))' +++ echo 41852 ++ : 41852 ++ : /tmp ++ : test:test ++ : test:test ++ : : ++ : : ++ : : ++ export PGPORT=41852 ++ PGPORT=41852 ++ 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". The default database encoding has accordingly been set to "SQL_ASCII". 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 41852' -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 41852 + __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.fc37.noarch/usr/bin/postgresqltuner --host=/tmp --port=41852 --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:41852 database mockbuild with user mockbuild... [OK] User used for report have super rights ===== OS information ===== [INFO] OS: linux Version: 5.14.18-100.1.riscv64.fc36.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.fc37.noarch/usr/bin/postgresqltuner line 272. [INFO] OS total memory: 0 Use of uninitialized value $os_mem in pattern match (m//) at /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/bin/postgresqltuner line 273. [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 [INFO] Running on physical machine [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 ===== General instance informations ===== ----- Version ----- [OK] You are using last 14.1 ----- Uptime ----- [INFO] Service uptime : 04s [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 : 04s ----- 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 : 41.32 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 : 8.72 MB [INFO] Database mockbuild tables size : 5.45 MB (62.54%) [INFO] Database mockbuild indexes size : 3.27 MB (37.46%) ----- Tablespace location ----- [OK] No tablespace in PGDATA ----- Shared buffer hit rate ----- [INFO] shared_buffer_heap_hit_rate: 92.40% [INFO] shared_buffer_toast_hit_rate: 0.00% [INFO] shared_buffer_tidx_hit_rate: 50.00% [INFO] shared_buffer_idx_hit_rate: 95.77% [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. waiting for server to shut down....+ 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 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.fc37.noarch Executing(%doc): /bin/sh -e /var/tmp/rpm-tmp.GmVp2L + umask 022 + cd /builddir/build/BUILD + cd postgresqltuner-1.0.1 + DOCDIR=/builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/doc/postgresqltuner + export LC_ALL=C + LC_ALL=C + export DOCDIR + /usr/bin/mkdir -p /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/doc/postgresqltuner + cp -pr README.md /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/doc/postgresqltuner + cp -pr README.fr.md /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/doc/postgresqltuner + RPM_EC=0 ++ jobs -p + exit 0 Executing(%license): /bin/sh -e /var/tmp/rpm-tmp.fDdBRM + umask 022 + cd /builddir/build/BUILD + cd postgresqltuner-1.0.1 + LICENSEDIR=/builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/licenses/postgresqltuner + export LC_ALL=C + LC_ALL=C + export LICENSEDIR + /usr/bin/mkdir -p /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/licenses/postgresqltuner + cp -pr LICENSE.txt /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch/usr/share/licenses/postgresqltuner + RPM_EC=0 ++ jobs -p + exit 0 Provides: postgresqltuner = 1.0.1-1.fc37 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.fc37.noarch Wrote: /builddir/build/RPMS/postgresqltuner-1.0.1-1.fc37.noarch.rpm Executing(%clean): /bin/sh -e /var/tmp/rpm-tmp.VPqt2P + umask 022 + cd /builddir/build/BUILD + cd postgresqltuner-1.0.1 + /usr/bin/rm -rf /builddir/build/BUILDROOT/postgresqltuner-1.0.1-1.fc37.noarch + RPM_EC=0 ++ jobs -p + exit 0 Executing(rmbuild): /bin/sh -e /var/tmp/rpm-tmp.3MZWn6 + umask 022 + cd /builddir/build/BUILD + rm -rf postgresqltuner-1.0.1 postgresqltuner-1.0.1.gemspec + RPM_EC=0 ++ jobs -p + exit 0 Child return code was: 0