Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-631

LP #1116447: Buffer page I/O fix race condition in buf_LRU_remove_all_pages()

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Laurynas Biveinis last update 12-02-2013 06:43:03

      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_tablespace().
      index: "idx1" table: "xx_xxxxx_xxxx/patient_pdups"

      error messages in several bug reports (bug 1096324, bug 1086700).

      buf_LRU_remove_all_pages() performs a dirty call to buf_page_get_io_fix(). Thus, buf_LRU_remove_all_pages() may attempt to remove I/O-fixed pages by buf_LRU_block_remove_hashed_page() which is clearly not intended.

      Similar to bug 934377, bug 1110102, bug 1111211.

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist