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

LP #1418996: InnoDB lock monitor output is printed even if not requested

Details

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

    Description

      **Reported in Launchpad by Laurynas Biveinis last update 10-02-2015 11:34:43

      lock_print_info_all_transactions(...)
      {
      ...
      loop:
      /* print transaction info */
      ...
      if (!srv_print_innodb_lock_monitor && !srv_show_locks_held)

      { nth_trx++; goto loop; }

      /* print lock info */
      goto loop;
      }

      The above code means that the lock info is printed if either innodb lock monitor is on, either innodb_show_locks_held > 0 (its default value is 10). The condition should have been that lock info is printed if both innodb lock monitor is on and innodb_show_locks_held > 0.

      This shows up as innodb-status-ouput --big-test test failure on 5.6:

      innodb.innodb-status-output [ fail ]
      Test ended at 2015-02-06 11:16:44

      CURRENT_TEST: innodb.innodb-status-output

      1. ERROR: The file '/Users/laurynas/percona/lp-mysql-server/big-test-fixes/obj-debug/mysql-test/var/tmp/innodb-status-output.err' does not contain the expected pattern SELECT SLEEP.*\n------
        ->
        ...

      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