Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1857

LP #1500720: mysql will not start with changed page tracking and O_DIRECT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Jervin R last update 13-01-2016 15:46:00

      Start and restart Percona Server 5.6.26 with the following setting, eventually it will fail to start with the below error:

      innodb_track_changed_pages = 1
      innodb_flush_method = O_DIRECT

      2015-09-29 02:36:50 15856 [Note] /opt/mysql/5.6.260/bin/mysqld: ready for connections.
      Version: '5.6.26-74.0' socket: '/tmp/mysql_sandbox56260.sock' port: 56260 Percona Server (GPL), Release 74.0, Revision 32f8dfd
      2015-09-29 02:36:52 7f7b0cfff700 InnoDB: Error: Write to file ./ib_modified_log_3_1627158.xdb failed at offset 0.
      InnoDB: 4096 bytes should have been written, only 0 were written.
      InnoDB: Operating system error number 22.
      InnoDB: Check that your OS and file system support files of this size.
      InnoDB: Check also that the disk is not full or a disk quota exceeded.
      InnoDB: Error number 22 means 'Invalid argument'.
      InnoDB: Some operating system error numbers are described at
      InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
      2015-09-29 02:36:52 7f7b0cfff700 InnoDB: Operating system error number 22 in a file operation.
      InnoDB: Error number 22 means 'Invalid argument'.
      InnoDB: Some operating system error numbers are described at
      InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
      2015-09-29 02:36:52 15856 [ERROR] InnoDB: failed writing changed page bitmap file './ib_modified_log_3_1627158.xdb'

      2015-09-29 02:36:52 15856 [ERROR] InnoDB: log tracking bitmap write failed, stopping log tracking thread!

      This seems to be reminiscent of:

      https://bugs.launchpad.net/percona-server/+bug/1105709
      https://bugs.launchpad.net/percona-server/+bug/1131949

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              krunal.bauskar Krunal Bauskar (Inactive)
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: