Comment 1 for bug 1124503

Revision history for this message
Eric H (eric-hardway) wrote :

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` (
  `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_data_id`,`rrd_name`,`time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (3) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (4) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (5) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (5) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (5) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (6) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (7) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (8) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"
InnoDB: Warning: hash index ref_count (8) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "cacti/poller_output"