Buffer page I/O fix race condition in buf_LRU_remove_all_pages()
Bug #1116447 reported by
Laurynas Biveinis
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
I did not check the wrong code path fully through, but at least one defect is there and it might explain
InnoDB: Warning: hash index ref_count (182) is not zero after fil_discard_
index: "idx1" table: "xx_xxxxx_
error messages in several bug reports (bug 1096324, bug 1086700).
buf_LRU_
Similar to bug 934377, bug 1110102, bug 1111211.
Related branches
lp:~laurynas-biveinis/percona-server/bpage-io-fix
- Stewart Smith (community): Approve
-
Diff: 434 lines (+153/-46)7 files modifiedPercona-Server/storage/innobase/buf/buf0buf.c (+1/-1)
Percona-Server/storage/innobase/buf/buf0flu.c (+2/-2)
Percona-Server/storage/innobase/buf/buf0lru.c (+97/-37)
Percona-Server/storage/innobase/fil/fil0fil.c (+1/-1)
Percona-Server/storage/innobase/ibuf/ibuf0ibuf.c (+1/-1)
Percona-Server/storage/innobase/include/buf0buf.h (+22/-2)
Percona-Server/storage/innobase/include/buf0buf.ic (+29/-2)
tags: | added: xtradb |
To post a comment you must log in.
I am running Percona Version: '5.1.67rel14.3-log' with innodb_ lazy_drop_ table = 1 enabled.
And i am getting these errors.
I am hostin my cacti database on this instance.
CREATE TABLE `poller_output` ( data_id` ,`rrd_name` ,`time` )
`local_data_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`rrd_name` varchar(19) NOT NULL DEFAULT '',
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`output` text NOT NULL,
PRIMARY KEY (`local_
) ENGINE=InnoDB DEFAULT CHARSET=latin1
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_ tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output" tablespace( ). poller_ output"
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (3) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (4) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (5) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (5) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (5) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (6) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (7) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (8) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/
InnoDB: Warning: hash index ref_count (8) is not zero after fil_discard_
index: "PRIMARY" table: "cacti/