Re: [PATCH] sysbench: Update to 1.0.20

[Michael Tremer <michael.tremer@ipfire.org>]

[-- Attachment #1: Type: text/plain, Size: 16005 bytes --]

Hello,

This package does not seem to build on armv5tel.

There is a bundled dependency (which is actually quite bad) of concurrency kit which unfortunately does not seem to recognise armv5tel. I have disabled the package being built for this architecture, because I do not think that this would have any big impact on our user base.

-Michael

> On 22 Mar 2021, at 07:18, Adolf Belka <adolf.belka(a)ipfire.org> wrote:
> 
> - Update from 0.4.12 to 1.0.20
> - Updated rootfile
> - Changelog
>    2020-04-24  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.20
> 	* build/CI/packaging: Add arm64 to Travis CI matrix (#358)
> 	* build/CI/packaging: add Ubuntu Focal
> 	* build/CI/packaging: remove Fedora Rawhide from CI matrix
> 	* build/CI/packaging: fix regression tests to work with MySQL 8.0.19+
> 	* build/CI/packaging: fix macOS builds in Travis
> 	* build/CI/packaging: remove Ubuntu Disco (EOL)
>    2019-12-08  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.19
> 	* build/CI/packaging: fix Ubuntu packaging for Bionic and later versions
> 	* regression tests: compatibility fix for PostgreSQL 12
> 	* build/CI/packaging: fix macOs builds in Travis
> 	* build/CI/packaging: add Fedora 31.
>    2019-10-21  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.18
> 	* build/CI/packaging: add Ubuntu Eoan.
> 	* build/CI/packaging: remove Ubuntu Cosmic (EOL).
> 	* build/CI/packaging: add CentOS 8.
> 	* build/CI/packaging: add Ubuntu Disco.
> 	* build/CI/packaging: remove Ubuntu Trusty (EOL).
> 	* build/CI/packaging: remove Fedora 28 (EOL).
> 	* build/CI/packaging: add Fedora 30.
> 	* build/CI/packaging: cherry-pick fix for LuaJIT/LuaJIT#484 to
> 	fix builds on macOS Mojave.
> 	* build/CI/packaging: add Debian Buster
>    2019-03-15  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.17
> 	* build/CI/packaging: update RPM spec to support RHEL8-beta
> 	(thanks to Alexey Bychko for the patch)
> 	* regression tests: remove unnecessary error leading to opt_rate.t instability.
> 	* --rate mode: return a non-zero exit code on event queue
> 	overflow.
> 	* --rate mode: fix a bogus error about eventgen thread termination
>    2018-12-16  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.16
> 	* build/CI/packaging: add Ubuntu Cosmic.
> 	* build/CI/packaging: add Fedora 29.
> 	* build/CI/packaging: remove Fedora 27 (EOL).
> 	* SQL API: fix GH-282 (Mysql's fetch_row() is broken)
> 	* --rate mode: fix latency stats skew on low rates
> 	* Lua: Add /usr/share/lua/5.1 to LUA_PATH and /usr/lib/lua/5.1
> 	to LUA_CPATH.
> 	* build/CI/packaging: add -Wvla to default compiler flags.
> 	* build/CI/packaging: fix debian/changelog format
> 	* build/CI/packaging: fix buildpack.sh to not push multiple file
> 	types to packagecloud.
> 	* build/CI/packaging: add libaio-dev to Debian/Ubuntu build
> 	dependencies.
>    2018-07-03  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.15
> 	* CI/build/packaging: add Fedora 28
> 	* CI/build/packaging: add Ubuntu Bionic
> 	* CI/build/packaging: remove Fedora 26 (EOL)
> 	* CI/build/packaging: remove Debian Wheezy (EOL)
> 	* fileio: fix GH-229 (--file-fsync-freq=0 seems to prevent
> 	fsync() at the end of the test)
> 	* command line: improve parsing of boolean command line options
> 	* tests: fix GH-220 (Testsuite api_sql_mysql.t failed ...)
> 	* tests: fix GH-223 (test failure on ppc64)
> 	* tests: fix opt_help.t to pass when the binary is not
> 	configured with MySQL support
> 	* MySQL driver: use it by default in DB benchmarks
>    2018-04-01  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.14
> 	* reports: fix JSON stats reporter to produce valid JSON
> 	(GH-195)
> 	* Lua SQL API: don't crash when query_row() is called with a
> 	SELECT returning empty result set
> 	* Lua SQL API: don't crash when bulk insert API calls are used
> 	out of order
> 	* regression tests: make PostgreSQL tests compatible with the
> 	new dump format introduced in 10.3
> 	* regression tests: minor stability and coverage improvements
>    2018-02-17  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.13
> 	* remove Ubuntu Zesty from CI/build/packaging matrices (EOL)
> 	* minor cleanups in build scripts
> 	* improve report formatting for long latency values
> 	* fileio: --file-extra-flags now accepts a list of flags rather
> 	than just a single value
> 	* OLTP: re-prepare prepared statements after reconnects, i.e. in
> 	cases when a server connection is lost and sysbench is
> 	configured to ignore such errors
>    2018-01-17  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.12
> 	* improve --rate mode precision for high argument values
> 	* add Fedora Rawhide and Debian Sid to CI matrix
> 	* fix compile-time architecture detection for some Broadwell
> 	CPUs which were incorrectly identified as Core 2.
> 	* remove build dependency on xxd (and vim-minimal package)
> 	* fix Lua API to correctly stop the benchmark when event()
> 	returns a value other than nil or false (thanks to caojiafeng
> 	for the patch)
> 	* fix the fileio benchmark when the specified file size is not a
> 	multiple of block size
> 	* fix the fileio benchmark to throw a descriptive error when the
> 	specified file size does not match the size of files created by
> 	'prepare'
> 	* remove Fedora 25 from CI/build/packaging matrices (EOL)
> 	* minor improvements in tests and documentation.
>    2017-12-09  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.11
> 	* add Debian Stretch to CI/build/packaging matrices
> 	* add Fedora 27 to CI/build/packaging matrices
> 	* make statistic counters usable from Lua scripts
> 	* fix the PostgreSQL driver to be compatible with CockroachDB
> 	(GH-180)
> 	* fix oltp_insert.lua to work correctly when both --tables and
> 	--threads are greater than 1 (GH-178)
> 	* fix FreeBSD builds by adding -rdynamic to the default linker
> 	flags (GH-174)
> 	* minor documentation updates
>    2017-10-25  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.10
> 	* fixed PK conflicts in oltp_insert.lua by creating empty tables
> 	on 'prepare'
> 	* made sysbench.opt available to init()/done() by exporting it
> 	to the global Lua state
> 	* added Fedora 26 (both x86_64 and AArch64) to the list of
> 	supported and tested distributions
> 	* fixed GH-172: sysbench 1.0.9 doesn't build with mariadb 10.2.8
> 	* add the /usr/local LuaRocks root directory to default LUA_PATH
> 	and LUA_CPATH
> 	* removed Fedora 24, Ubuntu Precise, Yakkety from default build
> 	matrices
> 	* added Ubuntu Artful to default build matrices
>    2017-09-05  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.9
> 	* fixed oltp_delete.lua to not use INSERT statements for
> 	consistency with other oltp_* benchmarks (GH-168)
> 	* added a workaround for MySQL bug #87337 "8.0.2 reintroduces
> 	my_bool to client API"
> 	* fixed building on on Debian GNU/kFreeBSD (GH-161)
> 	* fixed building against MariaDB 10.2 (thanks to Xavier Bachelot
> 	for the patch, GH-160)
>    2017-07-04  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.8
> 	* fixed api_report test for slow machines (thanks to @jcfp)
> 	* fileio: suggest to run prepare step on missing files (thanks
> 	to Heinrich Schuchardt)
> 	* JSON reports: removed an erroneous trailing comma (GH-139)
> 	* added events per second to the CPU benchmark report (GH-140)
> 	* fixed db_connect() in legacy SQL API to use the default value
> 	for --db-driver (GH-146)
> 	* removed busy-wait in the bounded event generation mode
> 	(--rate) to avoid CPU hogging
>    2017-05-15  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.7
> 	* Ubuntu Zesty added to package build matrix
> 	* fixed GH-130: Mutex Benchmark Documentation
> 	* fixed latency reports in the --rate mode
> 	* fixed compiler warnings when building against MySQL 8.0 client
> 	libraries
>    2017-04-13  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.6
> 	* no functional changes
> 	* many build- and packaging-related improvements
> 	* Linux packages are now automatically built using Travis CI and
> 	packpack, hosted by packagecloud.io
>    2017-04-02  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.5
> 	* various build-related documentation updates
> 	* benchmark can now be specified by a module name on the command
> 	line
> 	* memory benchmark: performance and scalability improvements
> 	* fix ARMv6 builds with system ConcurrencyKit
> 	* fix GH-123: Table already exists error on prepare
> 	* fix GH-121: make buildhost cpudetection optional
>    2017-03-13  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.4
> 	* fixed a number of compilation errors and warnings that were
> 	specific to 32-bit platforms
> 	* bundle cram (regression tests framework) and use it by default
> 	in 'make test'
> 	* bundled ConcurrencyKit updated to 0.6.0
>    2017-02-26  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.3
> 	* LuaJIT scalability improvements for non-x86 architectures
> 	* performance optimizations in oltp_read_write.lua to avoid Lua
> 	string management
> 	* fixed Illumos builds (thanks to Dillon Amburgey)
>    2017-02-17  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.2
> 	* improved scalability for --report-checkpoints mode
> 	* fix builds on CentoOS 6 and autoconf 2.63
> 	* support for Snap (http://snapcraft.io) packages
>    2017-02-05  Alexey Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.1
> 	* fix clock_gettime runtime failure built with macOS 10.11 and
> 	Xcode 8.x
>    2017-02-04  Aleksei Kopytov  <akopytov(a)gmail.com>
> 	* version 1.0.0
> 	* too much time and too many changes since the previous formal
> 	release, so briefly:
> 	* Lua scripts instead of hard-coded C tests for database
> 	("oltp") benchmarks + ability to create custom workloads
> 	* much better single-threaded performance
> 	* much better scalability
> 	* improvements and cleanups in command line syntax and options
> 	* latency histograms in cumulative statistic reports
> 	* report hooks to print statistics in custom formats
> 	(CSV/JSON/XML/etc.)
> 	* Dropped Windows support
> 	* Dropped support for Oracle, Drizzle and libattachsql drivers
> 
> Signed-off-by: Adolf Belka <adolf.belka(a)ipfire.org>
> ---
> config/rootfiles/packages/sysbench | 87 ++++++++++++++++++++++++++++++
> lfs/sysbench                       |  6 +--
> 2 files changed, 90 insertions(+), 3 deletions(-)
> 
> diff --git a/config/rootfiles/packages/sysbench b/config/rootfiles/packages/sysbench
> index 31642561b..d38ecba1f 100644
> --- a/config/rootfiles/packages/sysbench
> +++ b/config/rootfiles/packages/sysbench
> @@ -1 +1,88 @@
> usr/bin/sysbench
> +#usr/share/sysbench
> +usr/share/sysbench/bulk_insert.lua
> +usr/share/sysbench/oltp_common.lua
> +usr/share/sysbench/oltp_delete.lua
> +usr/share/sysbench/oltp_insert.lua
> +usr/share/sysbench/oltp_point_select.lua
> +usr/share/sysbench/oltp_read_only.lua
> +usr/share/sysbench/oltp_read_write.lua
> +usr/share/sysbench/oltp_update_index.lua
> +usr/share/sysbench/oltp_update_non_index.lua
> +usr/share/sysbench/oltp_write_only.lua
> +usr/share/sysbench/select_random_points.lua
> +usr/share/sysbench/select_random_ranges.lua
> +#usr/share/sysbench/tests
> +#usr/share/sysbench/tests/include
> +usr/share/sysbench/tests/include/api_sql_common.sh
> +usr/share/sysbench/tests/include/config.sh
> +usr/share/sysbench/tests/include/drv_common.sh
> +usr/share/sysbench/tests/include/inspect.lua
> +usr/share/sysbench/tests/include/mysql_common.sh
> +#usr/share/sysbench/tests/include/oltp_legacy
> +usr/share/sysbench/tests/include/oltp_legacy/bulk_insert.lua
> +usr/share/sysbench/tests/include/oltp_legacy/common.lua
> +usr/share/sysbench/tests/include/oltp_legacy/delete.lua
> +usr/share/sysbench/tests/include/oltp_legacy/insert.lua
> +usr/share/sysbench/tests/include/oltp_legacy/oltp.lua
> +usr/share/sysbench/tests/include/oltp_legacy/oltp_simple.lua
> +usr/share/sysbench/tests/include/oltp_legacy/parallel_prepare.lua
> +usr/share/sysbench/tests/include/oltp_legacy/select.lua
> +usr/share/sysbench/tests/include/oltp_legacy/select_random_points.lua
> +usr/share/sysbench/tests/include/oltp_legacy/select_random_ranges.lua
> +usr/share/sysbench/tests/include/oltp_legacy/update_index.lua
> +usr/share/sysbench/tests/include/oltp_legacy/update_non_index.lua
> +usr/share/sysbench/tests/include/pgsql_common.sh
> +usr/share/sysbench/tests/include/script_bulk_insert_common.sh
> +usr/share/sysbench/tests/include/script_oltp_common.sh
> +usr/share/sysbench/tests/include/script_oltp_legacy_common.sh
> +usr/share/sysbench/tests/include/script_select_random_common.sh
> +usr/share/sysbench/tests/include/script_select_random_legacy_common.sh
> +#usr/share/sysbench/tests/t
> +usr/share/sysbench/tests/t/1st.t
> +usr/share/sysbench/tests/t/api_basic.t
> +usr/share/sysbench/tests/t/api_histogram.t
> +usr/share/sysbench/tests/t/api_legacy_basic.t
> +usr/share/sysbench/tests/t/api_legacy_rand.t
> +usr/share/sysbench/tests/t/api_legacy_sql.t
> +usr/share/sysbench/tests/t/api_rand.t
> +usr/share/sysbench/tests/t/api_reports.t
> +usr/share/sysbench/tests/t/api_sql_mysql.t
> +usr/share/sysbench/tests/t/api_sql_pgsql.t
> +usr/share/sysbench/tests/t/cmd_cleanup.t
> +usr/share/sysbench/tests/t/cmd_help.t
> +usr/share/sysbench/tests/t/cmd_prepare.t
> +usr/share/sysbench/tests/t/cmd_run.t
> +usr/share/sysbench/tests/t/cmdline.t
> +usr/share/sysbench/tests/t/commands.t
> +usr/share/sysbench/tests/t/drivers.t
> +usr/share/sysbench/tests/t/drv_mysql.t
> +usr/share/sysbench/tests/t/drv_pgsql.t
> +usr/share/sysbench/tests/t/help_drv_mysql.t
> +usr/share/sysbench/tests/t/help_drv_pgsql.t
> +usr/share/sysbench/tests/t/opt_help.t
> +usr/share/sysbench/tests/t/opt_histogram.t
> +usr/share/sysbench/tests/t/opt_rate.t
> +usr/share/sysbench/tests/t/opt_report_checkpoints.t
> +usr/share/sysbench/tests/t/opt_report_interval.t
> +usr/share/sysbench/tests/t/opt_version.t
> +usr/share/sysbench/tests/t/script_bulk_insert_mysql.t
> +usr/share/sysbench/tests/t/script_bulk_insert_pgsql.t
> +usr/share/sysbench/tests/t/script_oltp_delete_mysql.t
> +usr/share/sysbench/tests/t/script_oltp_delete_pgsql.t
> +usr/share/sysbench/tests/t/script_oltp_help.t
> +usr/share/sysbench/tests/t/script_oltp_insert_mysql.t
> +usr/share/sysbench/tests/t/script_oltp_insert_pgsql.t
> +usr/share/sysbench/tests/t/script_oltp_point_select_mysql.t
> +usr/share/sysbench/tests/t/script_oltp_point_select_pgsql.t
> +usr/share/sysbench/tests/t/script_oltp_read_write_mysql.t
> +usr/share/sysbench/tests/t/script_oltp_read_write_pgsql.t
> +usr/share/sysbench/tests/t/script_select_random_mysql.t
> +usr/share/sysbench/tests/t/script_select_random_pgsql.t
> +usr/share/sysbench/tests/t/test_cpu.t
> +usr/share/sysbench/tests/t/test_fileio.t
> +usr/share/sysbench/tests/t/test_memory.t
> +usr/share/sysbench/tests/t/test_mutex.t
> +usr/share/sysbench/tests/t/test_threads.t
> +usr/share/sysbench/tests/t/tests.t
> +usr/share/sysbench/tests/test_run.sh
> diff --git a/lfs/sysbench b/lfs/sysbench
> index 557c00ee3..ff9478d28 100644
> --- a/lfs/sysbench
> +++ b/lfs/sysbench
> @@ -9,7 +9,7 @@
> 
> include Config
> 
> -VER        = 0.4.12
> +VER        = 1.0.20
> 
> THISAPP    = sysbench-$(VER)
> DL_FILE    = $(THISAPP).tar.gz
> @@ -17,7 +17,7 @@ DL_FROM    = $(URL_IPFIRE)
> DIR_APP    = $(DIR_SRC)/$(THISAPP)
> TARGET     = $(DIR_INFO)/$(THISAPP)
> PROG       = sysbench
> -PAK_VER    = 1
> +PAK_VER    = 2
> 
> DEPS       =
> 
> @@ -29,7 +29,7 @@ objects = $(DL_FILE)
> 
> $(DL_FILE) = $(DL_FROM)/$(DL_FILE)
> 
> -$(DL_FILE)_MD5 = 3a6d54fdd3fe002328e4458206392b9d
> +$(DL_FILE)_MD5 = 756381c6fc4e16af1e0831b5e6a3dcb3
> 
> install : $(TARGET)
> 
> -- 
> 2.31.0
>