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

LP #1538403: Crash on select from I_S.INNODB_CHANGED_PAGES

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.6.41-28.28, Not 5.7.x
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Ville Ojamo last update 01-03-2017 09:01:25

      • Percona-Server-server-56-5.6.28-rel76.1.el6.x86_64
      • Circular ("multi-master") replication with two servers
      • innodb_flush_method=O_DIRECT, innodb_track_changed_pages=1, innodb_flush_neighbors=0 and innodb_log_block_size=4k (these servers have SSD)

      MySQL crashes every time when doing:
      mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES;
      ERROR 2013 (HY000): Lost connection to MySQL server during query

      Meanwhile, from log file, the first error happens exactly when the SELECT is run:
      2016-01-27 11:49:49 14045 [ERROR] InnoDB: Tried to read 4096 bytes at offset 0. Was only able to read 0.
      2016-01-27 11:49:49 7f7c241ca700 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
      2016-01-27 11:49:49 14045 [ERROR] InnoDB: File (unknown): 'read' returned OS error 122. Cannot continue operation
      160127 11:49:49 mysqld_safe Number of processes running now: 0
      160127 11:49:49 mysqld_safe mysqld restarted
      2016-01-27 11:49:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
      2016-01-27 11:49:49 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-76.1-log) starting as process 14138 ...
      2016-01-27 11:49:49 14138 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
      2016-01-27 11:49:49 14138 [Note] Plugin 'FEDERATED' is disabled.
      InnoDB: Warning: innodb_log_block_size has been changed from default value 512. (###EXPERIMENTAL### operation)
      InnoDB: The log block size is set to 4096.
      ...

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: