InnoDB hash index ref_count is not zero after fil_discard_tablespace()
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Unassigned | ||
5.1 |
Won't Fix
|
High
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
I ran into this issue on both Percona 5.1.66 and Percona 5.1.67
From my testing I believe this bug happens when I have innodb_
When I issue the drop schema command the instance freezes with the exception that you can still do a show process list but you cannot do anything else including read from MyISAM tables. The drop schema command sticks on checking permissions.
| 16 | sanitized | sanitized:44918 | archive_sanitized | Query | 529 | checking permissions | drop schema archive_sanitized
The only way I can get out of this frozen state is to shutdown mysql. Then I have corrupted innodb table space and I am unable to clear the error the innodb recovery techniques outlined in manual. The only way I am able to recover is to dump out my innodb tables and delete ibdata and ib_logfiles and re-import my data.
Version: '5.1.66rel14.2-log' socket: '/san/analytics
130208 22:00:56 InnoDB: Completed reading buffer pool pages (requested: 229486, read: 229474)
InnoDB: Warning: hash index ref_count (6467) is not zero after fil_discard_
index: "PRIMARY" table: "archive_
InnoDB: Warning: hash index ref_count (22975) is not zero after fil_discard_
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 5 secs for hash index ref_count (161) to drop to 0.
index: "idx_sanitized_
InnoDB: Error: Waited for 10 secs for hash index ref_count (161) to drop to 0.
index: "idx_sanitized_
InnoDB: Error: Waited for 15 secs for hash index ref_count (161) to drop to 0.
index: "idx_sanitized_
InnoDB: Error: Waited for 20 secs for hash index ref_count (161) to drop to 0.
index: "idx_sanitized_
InnoDB: Error: Waited for 25 secs for hash index ref_count (161) to drop to 0.
index: "idx_sanitized_
InnoDB: Error: Waited for 30 secs for hash index ref_count (161) to drop to 0.
index: "idx_sanitized_
InnoDB: Error: Waited for 35 secs for hash index ref_count (161) to drop to 0.
Version: '5.1.67rel14.3-log' socket: '/san/analytics
6
InnoDB: Warning: hash index ref_count (4715) is not zero after fil_discard_
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 5 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 10 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 15 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 20 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 25 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 30 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 35 secs for hash index ref_count (4715) to drop to 0.
index: "PRIMARY" table: "archive_
InnoDB: Error: Waited for 40 secs for hash index ref_count (4715) to drop to 0.
Similar issue on a different server.
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 hosting 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/