Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12991

INNODB_% tables missing in INFORMATION_SCHEMA when using oracle InnoDb instead of XtraDb

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.24
    • N/A
    • None
    • Centos 7.0 and Centos 7.3

    Description

      When using InnoDb instead of XtraDb INNODB_% tables are totally missing in INFORMATION_SCHEMA

      Steps to reproduce:

      • Install MariaDb-server 10.1.24 from rpm on a fresh server.
      • Run mysql_install_db
      • Start server
      • Login to server.
      • Run following commands

        show engines;
         
        .....
        *************************** 6. row ***************************
              Engine: InnoDB
             Support: DEFAULT
             Comment: Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables
        Transactions: YES
                  XA: YES
          Savepoints: YES
        .....
         
        use information_schema;
        show tables like 'INNODB%';
         
        +----------------------------------------+
        | Tables_in_information_schema (INNODB%) |
        +----------------------------------------+
        | INNODB_SYS_DATAFILES                   |
        | INNODB_SYS_TABLESTATS                  |
        | INNODB_SYS_INDEXES                     |
        ......
        ......
        | INNODB_CHANGED_PAGES                   |
        | INNODB_FT_DELETED                      |
        | INNODB_TABLESPACES_SCRUBBING           |
        +----------------------------------------+
        33 rows in set (0.00 sec)
        
        

      • Edit /etc/my.cnf.d/server.cnf

        [mysqld]
        ignore_builtin_innodb
        plugin_load=innodb=ha_innodb.so
        

      • Restart mariadb server
      • Login to server
      • Run following commands

        show engines;
         
        ...
        *************************** 8. row ***************************
              Engine: InnoDB
             Support: DEFAULT
             Comment: Supports transactions, row-level locking, foreign keys and encryption for tables
        Transactions: YES
                  XA: YES
          Savepoints: YES
        ...
         
        use information_schema;
        show tables like 'INNODB%';
         
        EXPECTED to have INNODB tables
         
        ACTUAL RESULT:
         
        Empty set (0.00 sec)
        

      This does not affect 10.2
      According to docs at least some of INNODB_% tables in INFORMATION_SCHEMA should exists in version 10.1 for InnoDb plugin (Oracle)

      Attachments

        Activity

          People

            serg Sergei Golubchik
            petr0 Peter Shchuchkin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.