[MDEV-11802] innodb.innodb_bug14676111 fails in buildbot due to InnoDB purge failing to start when there is work to do - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL)
Fix Version/s: 10.2.7, 10.3.1
Component/s: Storage Engine - InnoDB, Tests
Labels:
None

Sprint:
10.2.4-1, 10.2.4-2

Description

http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar-debug/builds/2018/steps/test/logs/stdio

innodb.innodb_bug14676111 'innodb_plugin' w1 [ fail ]

        Test ended at 2017-01-05 22:06:59

CURRENT_TEST: innodb.innodb_bug14676111

--- /home/buildbot/maria-slave/power8-vlp03-bintar-debug/build/mysql-test/suite/innodb/r/innodb_bug14676111.result	2017-01-05 19:54:53.473261302 -0500

+++ /home/buildbot/maria-slave/power8-vlp03-bintar-debug/build/mysql-test/suite/innodb/r/innodb_bug14676111.reject	2017-01-05 22:06:58.634010067 -0500

@@ -22,7 +22,7 @@

 test.t1	analyze	status	OK

 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';

 CLUST_INDEX_SIZE

-8

+10

 delete from t1 where a=5;

 set global innodb_purge_stop_now=ON;

 set global innodb_purge_run_now=ON;

mysqltest: Result length mismatch

Started happening quite regularly in buildbot on 10.1 tree since January 5, 2017.
Observed on win32-debug, winx64-debug, p8-rhel7-bintar-debug.

Attachments

Issue Links

causes

MDEV-12708 innodb.truncate_purge_debug fails sporadically in buildbot

Closed

MDEV-13603 innodb_fast_shutdown=0 may fail to purge all history

Closed

is caused by

MDEV-4396 Fix innodb.innodb_bug14676111 test

Closed

relates to

MDEV-11947 InnoDB purge workers fail to shut down

Closed

MDEV-12708 innodb.truncate_purge_debug fails sporadically in buildbot

Closed

MDEV-13603 innodb_fast_shutdown=0 may fail to purge all history

Closed

MDEV-13779 InnoDB fails to shut down purge workers, causing hang

Closed

MDEV-16159 Use atomic memory access for purge_sys

Closed

MDEV-17745 innodb.innodb_stats_persistent failed in buildbot with wrong result

Closed

MDEV-18878 Purge is slow due to repeatedly looking up missing or discarded table

Closed

MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies

Closed

MDEV-26193 Skip check to invoke purge if the transaction is read-only

Closed

MDEV-30671 innodb_undo_log_truncate=ON fails to wait for purge of transaction history

Closed

MDEV-7069 Fix buildbot failures in main server trees

Stalled

MDEV-8139 Fix scrubbing

Closed

MDEV-11024 Make number of purge threads variable dynamic

Closed

MDEV-12463 Unable to find a record to delete-mark just after upgrading from 10.2.4 to 10.2.5

Closed

MDEV-13603 innodb_fast_shutdown=0 may fail to purge all history

Closed

MDEV-14080 InnoDB shutdown sometimes hangs

Closed

MDEV-14445 innodb.table_flags failed in buildbot with wrong result

Closed

MDEV-15826 Purge attempts to free BLOB page after BEGIN;INSERT;UPDATE;ROLLBACK

Closed

MDEV-16260 Scale the purge effort according to the workload

Open

MDEV-16264 Implement a common work queue for InnoDB background tasks

Closed

(18 relates to)

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2017-01-15 22:39

Elena Stepanova made changes - 2017-01-15 22:39

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

Rasmus Johansson (Inactive) made changes - 2017-01-18 10:01

Sprint

10.2.4-1 [ 132 ]

Rasmus Johansson (Inactive) made changes - 2017-01-18 10:01

Rank

Ranked higher

Rasmus Johansson (Inactive) made changes - 2017-01-26 10:37

Sprint

10.2.4-1 [ 132 ]

10.2.4-1, 10.2.4-2 [ 132, 134 ]

Marko Mäkelä made changes - 2017-02-09 14:18

Link

This issue is caused by ~~MDEV-4396~~ [ ~~MDEV-4396~~ ]

Marko Mäkelä made changes - 2017-02-09 14:25

Link

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

Marko Mäkelä made changes - 2017-02-12 08:49

Summary

innodb.innodb_bug14676111 fails in buildbot

innodb.innodb_bug14676111 and gcol.innodb_virtual_debug_purge fail in buildbot

Marko Mäkelä made changes - 2017-02-16 18:12

Status

Open [ 1 ]

In Progress [ 3 ]

Marko Mäkelä made changes - 2017-02-16 18:13

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Jan Lindström (Inactive) made changes - 2017-02-20 07:41

Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2017-02-20 10:39

Fix Version/s		10.0.30 [ 22313 ]
Fix Version/s		10.2.5 [ 22117 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2017-02-20 12:05

Fix Version/s

10.1.22 [ 22502 ]

Marko Mäkelä made changes - 2017-02-22 20:52

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

Daniel Bartholomew made changes - 2017-03-08 17:01

Fix Version/s		10.0.31 [ 22501 ]
Fix Version/s	10.0.30 [ 22313 ]

Daniel Bartholomew made changes - 2017-03-08 17:43

Fix Version/s		10.0.30 [ 22313 ]
Fix Version/s	10.0.31 [ 22501 ]

Sergei Golubchik made changes - 2017-03-13 08:45

Fix Version/s		10.0 [ 16000 ]
Fix Version/s		10.1 [ 16100 ]
Fix Version/s		10.2 [ 14601 ]
Fix Version/s	10.2.5 [ 22117 ]
Fix Version/s	10.0.30 [ 22313 ]
Fix Version/s	10.1.22 [ 22502 ]

Marko Mäkelä made changes - 2017-04-24 08:25

Link

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

Marko Mäkelä made changes - 2017-04-26 07:30

Summary

innodb.innodb_bug14676111 and gcol.innodb_virtual_debug_purge fail in buildbot

InnoDB purge fails to start when there is work to do

Marko Mäkelä made changes - 2017-04-26 08:05

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Marko Mäkelä made changes - 2017-04-26 08:39

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2017-04-27 20:48

Fix Version/s		10.2.6 [ 22527 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Resolution		Fixed [ 1 ]
Status	In Review [ 10002 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2017-05-09 11:05

Link

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

Marko Mäkelä made changes - 2017-05-10 11:36

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

Marko Mäkelä made changes - 2017-05-10 11:39

Link

This issue causes ~~MDEV-12708~~ [ ~~MDEV-12708~~ ]

Marko Mäkelä made changes - 2017-05-10 11:39

Link

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

Daniel Bartholomew made changes - 2017-05-16 13:18

Fix Version/s		10.2 [ 14601 ]
Fix Version/s	10.2.6 [ 22527 ]

Marko Mäkelä made changes - 2017-08-25 10:08

Link

This issue causes ~~MDEV-13603~~ [ ~~MDEV-13603~~ ]

Marko Mäkelä made changes - 2017-09-13 14:04

Link

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

Marko Mäkelä made changes - 2017-10-05 17:58

Link

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

Marko Mäkelä made changes - 2017-11-30 15:40

Link

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

Marko Mäkelä made changes - 2018-01-22 15:14

Link

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

Marko Mäkelä made changes - 2018-04-06 08:13

Link

This issue is duplicated by ~~MDEV-14445~~ [ ~~MDEV-14445~~ ]

Marko Mäkelä made changes - 2018-04-09 08:06

Link

This issue is duplicated by ~~MDEV-14445~~ [ ~~MDEV-14445~~ ]

Marko Mäkelä made changes - 2018-04-09 08:07

Link

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

Marko Mäkelä made changes - 2018-04-16 03:21

Link

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

Marko Mäkelä made changes - 2018-05-14 11:09

Link

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

Marko Mäkelä made changes - 2018-05-17 08:28

Link

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

Marko Mäkelä made changes - 2018-05-17 08:28

Link

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

Marko Mäkelä made changes - 2018-05-17 08:28

Link

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

Marko Mäkelä made changes - 2018-11-01 10:37

Link

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

Marko Mäkelä made changes - 2018-11-01 10:37

Link

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

Marko Mäkelä made changes - 2018-11-01 10:41

Fix Version/s		10.3.1 [ 22532 ]
Fix Version/s		10.2.7 [ 22543 ]
Fix Version/s	10.2 [ 14601 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Elena Stepanova made changes - 2018-11-01 14:14

Summary

InnoDB purge fails to start when there is work to do

innodb.innodb_bug14676111 fails in buildbot due to InnoDB purge failing to start when there is work to do

Marko Mäkelä made changes - 2018-11-16 17:19

Link

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

Marko Mäkelä made changes - 2019-03-11 12:46

Link

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

Marko Mäkelä made changes - 2021-07-21 06:24

Link

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

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

Workflow

MariaDB v3 [ 79211 ]

MariaDB v4 [ 151537 ]

Marko Mäkelä made changes - 2023-02-24 10:37

Link

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

Marko Mäkelä made changes - 2023-02-24 10:37

Link

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

People

Assignee:: Marko Mäkelä

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2017-01-15 22:39

Updated:: 2023-02-24 10:37

Resolved:: 2018-11-01 10:41

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