[MDEV-20916] Galera test failure on galera.galera_parallel_autoinc_largetrx: Result content mismatch - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4.9
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7
Component/s: Galera, Tests
Labels:
None
Environment:
OS: CentOS Linux release 7.6.1810 (Core).

Description

It sporadically fails on the suite runs.

MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 2b5f4b3ed68585b310b7ebede474928ff90d9aa2; debug built from sources.

Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

Run:

./mtr --suite galera --force --big-test --max-test-fail=0 --timer --timestamp --timediff

stdout.log (the whole file is attached: 191027_1013_SSD_stdout.log):

mysqltest: Result content mismatch

191027 10:25:00 +14.496 galera.galera_parallel_autoinc_largetrx 'innodb' [ fail ]

        Test ended at 2019-10-27 10:25:00

CURRENT_TEST: galera.galera_parallel_autoinc_largetrx

--- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result	2019-08-21 19:11:10.820245673 +0300

+++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.reject	2019-10-27 10:24:59.950247928 +0200

@@ -16,7 +16,7 @@

 connection node_1;

 SELECT COUNT(*) FROM t1;

 COUNT(*)

-30000

+20000

 SELECT COUNT(DISTINCT f1) FROM t1;

 COUNT(DISTINCT f1)

mysqltest: Result content mismatch

See also other logs attached: galera_parallel_autoinc_largetrx_191027.zip.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

191027_1013_SSD_stdout.log
2019-10-29 13:12
28 kB
Stepan Patryshev
Hide
galera_parallel_autoinc_largetrx_191027.zip
2019-10-29 13:12
836 kB
Stepan Patryshev
Extracting archive...
Show
galera_parallel_autoinc_largetrx_191027.zip
2019-10-29 13:12
836 kB
Stepan Patryshev

Activity

Ascending order - Click to sort in descending order

Stepan Patryshev (Inactive) created issue - 2019-10-29 13:12

Stepan Patryshev (Inactive) made changes - 2019-10-29 13:12

Field	Original Value	New Value
Link		This issue relates to MDEV-17728 [ MDEV-17728 ]

Stepan Patryshev (Inactive) made changes - 2019-10-29 13:16

Assignee

Stepan Patryshev [ stepan.patryshev ]

Jan Lindström [ jplindst ]

Stepan Patryshev (Inactive) made changes - 2019-11-12 11:16

Description

It sporadically fails on the suite runs.

MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 2b5f4b3ed68585b310b7ebede474928ff90d9aa2; debug built from sources.

Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch es-mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

*Run:*
{code}
./mtr --suite galera --force --big-test --max-test-fail=0 --timer --timestamp --timediff
{code}

*stdout.log* (the whole file is attached: [^191027_1013_SSD_stdout.log]):

{color:red}mysqltest: Result content mismatch {color}

{code}
191027 10:25:00 +14.496 galera.galera_parallel_autoinc_largetrx 'innodb' [ fail ]
Test ended at 2019-10-27 10:25:00

CURRENT_TEST: galera.galera_parallel_autoinc_largetrx
--- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result 2019-08-21 19:11:10.820245673 +0300
+++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.reject 2019-10-27 10:24:59.950247928 +0200
@@ -16,7 +16,7 @@
connection node_1;
SELECT COUNT(*) FROM t1;
COUNT(*)
-30000
+20000
SELECT COUNT(DISTINCT f1) FROM t1;
COUNT(DISTINCT f1)
30000

mysqltest: Result content mismatch
{code}

See also other logs attached: [^galera_parallel_autoinc_largetrx_191027.zip].

It sporadically fails on the suite runs.

MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 2b5f4b3ed68585b310b7ebede474928ff90d9aa2; debug built from sources.

Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

*Run:*
{code}
./mtr --suite galera --force --big-test --max-test-fail=0 --timer --timestamp --timediff
{code}

*stdout.log* (the whole file is attached: [^191027_1013_SSD_stdout.log]):

{color:red}mysqltest: Result content mismatch {color}

{code}
191027 10:25:00 +14.496 galera.galera_parallel_autoinc_largetrx 'innodb' [ fail ]
Test ended at 2019-10-27 10:25:00

CURRENT_TEST: galera.galera_parallel_autoinc_largetrx
--- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.result 2019-08-21 19:11:10.820245673 +0300
+++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/galera_parallel_autoinc_largetrx.reject 2019-10-27 10:24:59.950247928 +0200
@@ -16,7 +16,7 @@
connection node_1;
SELECT COUNT(*) FROM t1;
COUNT(*)
-30000
+20000
SELECT COUNT(DISTINCT f1) FROM t1;
COUNT(DISTINCT f1)
30000

mysqltest: Result content mismatch
{code}

See also other logs attached: [^galera_parallel_autoinc_largetrx_191027.zip].

Stepan Patryshev (Inactive) made changes - 2019-12-19 10:16

Link

This issue blocks MDEV-17728 [ MDEV-17728 ]

Stepan Patryshev (Inactive) made changes - 2019-12-19 10:16

Link

This issue relates to MDEV-17728 [ MDEV-17728 ]

Stepan Patryshev (Inactive) added a comment - 2019-12-23 12:53

It's still sporadically failed on Azure and local debug runs.

Stepan Patryshev (Inactive) added a comment - 2019-12-23 12:53 It's still sporadically failed on Azure and local debug runs.

Stepan Patryshev (Inactive) made changes - 2020-01-08 14:49

Priority

Major [ 3 ]

Critical [ 2 ]

Stepan Patryshev (Inactive) added a comment - 2020-01-08 14:49

Increased the priority since it fails on Azure.

Stepan Patryshev (Inactive) added a comment - 2020-01-08 14:49 Increased the priority since it fails on Azure.

Stepan Patryshev (Inactive) made changes - 2020-01-09 19:18

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-01-22 08:57

Labels

disabled

Julien Fritsch made changes - 2020-03-02 16:57

Labels

disabled

Test_disabled disabled

Julien Fritsch made changes - 2020-03-02 16:59

Labels

Test_disabled disabled

Test_disabled

Stepan Patryshev (Inactive) made changes - 2020-03-04 12:39

Labels

Test_disabled

Test_disabled test_disabled_ES

Jan Lindström (Inactive) made changes - 2020-04-29 13:52

Status

Open [ 1 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2020-04-29 14:05

issue.field.resolutiondate

2020-04-29 14:05:03.0

2020-04-29 14:05:03.897

Jan Lindström (Inactive) made changes - 2020-04-29 14:05

Fix Version/s		10.2.33 [ 24307 ]
Fix Version/s		10.3.24 [ 24306 ]
Fix Version/s		10.4.14 [ 24305 ]
Fix Version/s		10.5.4 [ 24264 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Jan Lindström (Inactive) made changes - 2020-04-30 06:56

Labels

Test_disabled test_disabled_ES

test_disabled_ES

Stepan Patryshev (Inactive) made changes - 2020-05-05 15:11

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-05-05 15:12

Link

This issue blocks MDEV-17728 [ MDEV-17728 ]

Stepan Patryshev (Inactive) added a comment - 2020-05-20 15:01

Reopened it since it is still disabled on 10.2/10.3/10.4 ES.

Stepan Patryshev (Inactive) added a comment - 2020-05-20 15:01 Reopened it since it is still disabled on 10.2/10.3/10.4 ES.

Stepan Patryshev (Inactive) made changes - 2020-05-20 15:01

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Stepan Patryshev (Inactive) made changes - 2020-05-20 15:02

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s	10.5.4 [ 24264 ]
Fix Version/s	10.4.14 [ 24305 ]
Fix Version/s	10.3.24 [ 24306 ]
Fix Version/s	10.2.33 [ 24307 ]

Stepan Patryshev (Inactive) made changes - 2020-05-20 15:02

Link

This issue blocks ~~MDEV-19937~~ [ ~~MDEV-19937~~ ]

Stepan Patryshev (Inactive) made changes - 2020-05-20 15:02

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-06-15 08:24

Assignee

Jan Lindström [ jplindst ]

Stepan Patryshev [ stepan.patryshev ]

Stepan Patryshev (Inactive) made changes - 2020-06-15 08:24

Labels

test_disabled_ES

need_verification test_disabled_ES

Stepan Patryshev (Inactive) added a comment - 2020-07-06 15:47

Closing since it is not disabled and does not fail on CI.

Stepan Patryshev (Inactive) added a comment - 2020-07-06 15:47 Closing since it is not disabled and does not fail on CI.

Stepan Patryshev (Inactive) made changes - 2020-07-06 15:47

Fix Version/s		10.2.34 [ 24505 ]
Fix Version/s		10.3.25 [ 24506 ]
Fix Version/s		10.4.15 [ 24507 ]
Fix Version/s		10.5.6 [ 24508 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Stepan Patryshev (Inactive) made changes - 2020-07-06 15:47

Labels

need_verification test_disabled_ES

Stepan Patryshev (Inactive) made changes - 2020-07-06 17:49

Link

This issue blocks ~~MDEV-19937~~ [ ~~MDEV-19937~~ ]

Stepan Patryshev (Inactive) made changes - 2020-07-06 17:50

Link

This issue blocks MENT-565 [ MENT-565 ]

Ralf Gebhardt made changes - 2020-10-06 18:35

Fix Version/s

10.5.7 [ 25019 ]

Ralf Gebhardt made changes - 2020-10-06 18:38

Fix Version/s

10.5.6 [ 24508 ]

Ralf Gebhardt made changes - 2020-10-06 18:40

Fix Version/s

10.4.16 [ 25020 ]

Ralf Gebhardt made changes - 2020-10-06 18:42

Fix Version/s

10.4.15 [ 24507 ]

Ralf Gebhardt made changes - 2020-10-06 18:43

Fix Version/s

10.3.26 [ 25021 ]

Ralf Gebhardt made changes - 2020-10-06 18:45

Fix Version/s

10.3.25 [ 24506 ]

Ralf Gebhardt made changes - 2020-10-06 18:47

Fix Version/s

10.2.35 [ 25022 ]

Ralf Gebhardt made changes - 2020-10-06 18:48

Fix Version/s

10.2.34 [ 24505 ]

Sergei Golubchik made changes - 2021-12-06 21:50

Workflow

MariaDB v3 [ 100667 ]

MariaDB v4 [ 156911 ]

People

Assignee:: Stepan Patryshev (Inactive)

Reporter:: Stepan Patryshev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2019-10-29 13:12

Updated:: 2020-10-06 18:48

Resolved:: 2020-07-06 15:47

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration