• Aditya A's avatar
    Bug#14756795 SELECT FROM NEW INNODB I_S TABLES CRASHES SERVER · dd5beeac
    Aditya A authored
                  WITH --SKIP-INNODB
    
    Description
    -----------
    
    If the server is started with skip-innodb or InnoDB otherwise fails to
    start, any one of these queries will crash the server:
    
    For (5.5) 
    SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS;
    
    In (5.6+) ,following queries will also crash the server.
    
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_DATAFILES;
    SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES;
    
    FIX
    ----
    
    When Innodb is not active we must prevent it from processing
    these tables,so we return a warning saying that innodb is not
    active.
    
    Approved by marko (http://rb.no.oracle.com/rb/r/1891)
    dd5beeac
i_s.cc 104 KB