[MDEV-10682] Race condition between ANALYZE TABLE and STATS_AUTO_RECALC - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.10
Component/s: Storage Engine - InnoDB, Tests
Labels:

Description

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-precise-amd64/builds/6502/steps/test_5/logs/stdio

innodb.innodb_stats 'innodb_plugin'      w3 [ fail ]

        Test ended at 2016-06-28 07:48:15

CURRENT_TEST: innodb.innodb_stats

--- /usr/share/mysql/mysql-test/suite/innodb/r/innodb_stats.result	2016-06-28 04:58:03.000000000 +0300

+++ /run/shm/var/3/log/innodb_stats.reject	2016-06-28 07:48:14.987555677 +0300

@@ -174,11 +174,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	1

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -226,11 +226,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	1

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	10

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -278,11 +278,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	2

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	2

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -330,11 +330,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	2

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -382,11 +382,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -434,11 +434,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	5

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -461,7 +461,7 @@

 SEQ_IN_INDEX	1

 COLUMN_NAME	a

 COLLATION	A

-CARDINALITY	5

+CARDINALITY	2

 SUB_PART	NULL

 PACKED	NULL

 NULLABLE	YES

@@ -486,11 +486,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	5

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	10

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -513,7 +513,7 @@

 SEQ_IN_INDEX	1

 COLUMN_NAME	a

 COLLATION	A

-CARDINALITY	10

+CARDINALITY	2

 SUB_PART	NULL

 PACKED	NULL

 NULLABLE	YES

mysqltest: Result length mismatch

 - skipping '/run/shm/var/3/log/innodb.innodb_stats-innodb_plugin/'

Retrying test innodb.innodb_stats, attempt(2/3)...

Attachments

Issue Links

relates to

MDEV-7069 Fix buildbot failures in main server trees

Stalled

MDEV-15203 innodb.innodb_max_recordsize_64k failed in buildbot with wrong result

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2016-08-27 13:05

Elena Stepanova made changes - 2016-08-27 13:05

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

Jan Lindström (Inactive) made changes - 2016-09-21 13:44

Assignee

Jan Lindström [ jplindst ]

Jan Lindström (Inactive) made changes - 2017-12-13 11:13

Rank

Ranked higher

Alice Sherepa made changes - 2020-12-14 10:02

Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]

Alice Sherepa made changes - 2020-12-14 10: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.1 [ 16100 ]

Marko Mäkelä made changes - 2021-03-18 07:47

Component/s		Storage Engine - InnoDB [ 10129 ]
Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Labels		race rr-profile-analyzed upstream

Marko Mäkelä made changes - 2021-03-18 07:47

Status

Open [ 1 ]

In Progress [ 3 ]

Marko Mäkelä made changes - 2021-03-18 09:08

Link

This issue is blocked by ~~MDEV-15020~~ [ ~~MDEV-15020~~ ]

Marko Mäkelä made changes - 2021-03-18 10:00

Link

This issue is blocked by ~~MDEV-15020~~ [ ~~MDEV-15020~~ ]

Marko Mäkelä made changes - 2021-03-18 10:14

Summary

innodb.innodb_stats failed in buildbot

Race condition between ANALYZE TABLE and STATS_AUTO_RECALC

Marko Mäkelä made changes - 2021-03-18 10:26

issue.field.resolutiondate

2021-03-18 10:26:15.0

2021-03-18 10:26:15.221

Marko Mäkelä made changes - 2021-03-18 10:26

Fix Version/s		10.2.38 [ 25207 ]
Fix Version/s		10.3.29 [ 25206 ]
Fix Version/s		10.4.19 [ 25205 ]
Fix Version/s		10.5.10 [ 25204 ]
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	In Progress [ 3 ]	Closed [ 6 ]

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

Workflow

MariaDB v3 [ 76825 ]

MariaDB v4 [ 150826 ]

Marko Mäkelä made changes - 2023-11-29 13:56

Link

This issue relates to ~~MDEV-15203~~ [ ~~MDEV-15203~~ ]

People

Assignee:: Marko Mäkelä

Reporter:: Elena Stepanova

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2016-08-27 13:05

Updated:: 2023-11-29 13:56

Resolved:: 2021-03-18 10:26

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration