Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

x.insert_table: Result content mismatch

Description

Retrying test x.insert_table, attempt(2/3)... x.insert_table [ retry-fail ] Test ended at 2018-11-16 17:14:26 CURRENT_TEST: x.insert_table --- /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/mysql/rapid/plugin/x/tests/mtr/r/insert_table.result 2018-10$ 31 17:10:05.000000000 +0300 +++ /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/mysql-test/var/log/insert_tabl$ .reject 2018-11-16 19:14:26.711761653 +0300 @@ -127,7 +127,7 @@ type: LITERAL literal { type: V_FLOAT - v_float: 0.33333334 + v_float: 0.333333343 } } field { @@ -302,7 +302,7 @@ type: LITERAL literal { type: V_FLOAT - v_float: 0.33333334 + v_float: 0.333333343 } } field { @@ -409,7 +409,7 @@ type: LITERAL literal { type: V_FLOAT - v_float: 0.33333334 + v_float: 0.333333343 } } field { mysqltest: Result content mismatch safe_process[23968]: Child process: 23969, exit: 1

Environment

None

Attachments

2
  • 20 Nov 2018, 07:17 PM
  • 20 Nov 2018, 05:21 PM

Smart Checklist

Activity

Show:

Lalit Choudhary April 22, 2019 at 9:42 AM

Thank you for the report.

Due to the no feedback from a long time on requested details we are closing this bug. Please report a new bug with the repeatable test case, if you are still able to reproduce the issue.

Lalit Choudhary December 3, 2018 at 4:59 PM

Thanks for the update.

could please share command, that you use to build Percona server from source.

Whissi November 26, 2018 at 1:51 PM

The Gentoo system you are using is pretty old. For example you are still using glibc-2.26-r7 whereas latest stable glibc on Gentoo is 2.27-r6.

Did you use dev-db/percona-server ebuild (=build from source) or did you just run your binary on that system? I expect that this is a problem caused by a newer dependency than you are using (like gcc-8.2, bison-3.2, libevent-2.1.8 or any other dep used by X component). To reproduce you would have to build percona-server from source with the same version...

Lalit Choudhary November 26, 2018 at 1:33 PM

Hi

Test passing for Percona 5.7.23 as well as for MySQL generic binaries 5.7.24 on Gentoo OS.

If you see the same behavior on for upstream MySQL version for your custom build, please report a bug to upstream and Percona would backport patch from the upstream.

  1. emerge --info octave
    Portage 2.3.40 (python 3.6.5-final-0, default/linux/amd64/17.0/no-multilib, gcc-7.3.0, glibc-2.26-r7, 4.14.65-gentoo x86_64)
    =================================================================
    System Settings
    =================================================================

System uname: Linux-4.14.65-gentoo-x86_64-Intel-R-Xeon-R-_CPU_E5-2676_v3@_2.40GHz-with-gentoo-2.4.1
KiB Mem: 1007056 total, 169964 free
KiB Swap: 0 total, 0 free
Timestamp of repository gentoo: Wed, 05 Sep 2018 00:00:01 +0000
Head commit of repository gentoo: 84b5be12bbc52f89716f812937d0e5525de18629
sh bash 4.4_p12
ld GNU ld (Gentoo 2.30 p2) 2.30.0
app-shells/bash: 4.4_p12::gentoo
dev-lang/perl: 5.24.3-r1::gentoo
dev-lang/python: 2.7.14-r1::gentoo, 3.6.5::gentoo
dev-util/pkgconfig: 0.29.2::gentoo
sys-apps/baselayout: 2.4.1-r2::gentoo
sys-apps/openrc: 0.34.11::gentoo
sys-apps/sandbox: 2.13::gentoo
sys-devel/autoconf: 2.69-r4::gentoo
sys-devel/automake: 1.15.1-r2::gentoo
sys-devel/binutils: 2.30-r2::gentoo
sys-devel/gcc: 7.3.0-r3::gentoo
sys-devel/gcc-config: 1.8-r1::gentoo
sys-devel/libtool: 2.4.6-r3::gentoo
sys-devel/make: 4.2.1-r4::gentoo
sys-kernel/linux-headers: 4.13::gentoo (virtual/os-headers)
sys-libs/glibc: 2.26-r7::gentoo

Whissi November 20, 2018 at 7:24 PM

It is a current Gentoo ~amd64 system. System details:

Portage 2.3.52 (python 3.6.6-final-0, default/linux/amd64/17.0, gcc-8.2.0, glibc-2.27-r6, 4.9.137-gentoo x86_64) ================================================================= System uname: Linux-4.9.137-gentoo-x86_64-Intel-R-_Xeon-R-_CPU_E3-1275_V2_@_3.50GHz-with-gentoo-2.6 KiB Mem: 32844452 total, 20651796 free KiB Swap: 4194300 total, 4194300 free Timestamp of repository gentoo: Tue, 20 Nov 2018 15:44:34 +0000 Head commit of repository gentoo: 491e49aadfd67a98384fc18551a883f7f4740570 sh bash 4.4_p23 ld GNU ld (Gentoo 2.31.1 p3) 2.31.1 distcc 3.2rc1 x86_64-pc-linux-gnu [disabled] app-shells/bash: 4.4_p23::gentoo dev-lang/perl: 5.26.2::gentoo dev-lang/python: 2.7.15::gentoo, 3.6.6::gentoo, 3.7.0::gentoo dev-util/cmake: 3.12.3::gentoo dev-util/pkgconfig: 0.29.2::gentoo sys-apps/baselayout: 2.6-r1::gentoo sys-apps/openrc: 0.39.2::gentoo sys-apps/sandbox: 2.13::gentoo sys-devel/autoconf: 2.69-r4::gentoo sys-devel/automake: 1.16.1-r1::gentoo sys-devel/binutils: 2.31.1-r1::gentoo sys-devel/gcc: 8.2.0-r4::gentoo sys-devel/gcc-config: 2.0::gentoo sys-devel/libtool: 2.4.6-r5::gentoo sys-devel/make: 4.2.1-r4::gentoo sys-kernel/linux-headers: 4.19::gentoo (virtual/os-headers) sys-libs/glibc: 2.27-r6::gentoo

Used deps:

app-arch/lz4-1.8.3 app-arch/xz-utils-5.2.4-r2 dev-lang/python-2.7.15 dev-libs/libaio-0.3.110 dev-libs/libevent-2.1.8 dev-libs/openssl-1.0.2q dev-libs/protobuf-3.6.1 dev-perl/DBD-mysql-4.44.0 dev-perl/JSON-2.940.0 dev-python/mysql-python-1.2.5-r2 dev-util/cmake-3.12.3 dev-util/valgrind-3.14.0 net-libs/libtirpc-1.1.4 net-libs/rpcsvc-proto-1.4 net-misc/curl-7.62.0 sys-apps/sed-4.5 sys-apps/texinfo-6.5 sys-devel/bison-3.2.1 sys-devel/gcc-8.2.0-r4 sys-devel/make-4.2.1-r4 sys-libs/ncurses-6.1-r3 sys-libs/pam-1.3.1-r1 sys-libs/zlib-1.2.11-r2 sys-process/numactl-2.0.12 sys-process/procps-3.3.15-r1

I was able to reproduce this on a second system.
See attached build.log for more details.

I am using https://gitweb.gentoo.org/repo/gentoo.git/tree/dev-db/percona-server/percona-server-5.7.23.24.ebuild?id=4d4435c062d1d5292081c895a6a5be6d973a2760

You can find used patches here: https://gitweb.gentoo.org/proj/mysql-extras.git/tree/?h=mysql-extras-20181017-2201Z

But like you can see from build.log, I removed most patches just be sure... the gcc however was required to be able to build percona-server 5.7.23-24 at all using gcc-8.2.0.

I see same test failure with vanilla mysql 5.7.24 by the way. So nothing percona-server related and nothing yet fixed.

Incomplete

Details

Assignee

Reporter

Labels

Affects versions

Priority

Smart Checklist

Created November 16, 2018 at 4:18 PM
Updated March 6, 2024 at 12:41 PM
Resolved April 22, 2019 at 9:42 AM

Flag notifications