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

enforce_storage_engine not effective for SQL_thread

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.23-23
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:

      CentOS 6 

      Description

      we want to build a blackhole slave 

      so we use the variable enforce_storage_engine

      but ,we create an Innodb table  in master ,and the slave get an Error

       

      Worker 1 failed executing transaction '9a382326-236d-11e8-ae2b-0022ec3c7f10:1126' at master log mysql-bin.000001, end_log_pos 1206767; Error 'Unknown storage engine 'InnoDB'' on query. Default database: 'aaa'. Query: 'CREATE TABLE `mmm`(
      `a` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'

       

      admin@(none)05:41:10>show variables like "%engine%";
      -------------------------------------------+

      Variable_name Value

      -------------------------------------------+

      default_storage_engine BLACKHOLE
      default_tmp_storage_engine BLACKHOLE
      disabled_storage_engines  
      enforce_storage_engine blackhole
      internal_tmp_disk_storage_engine InnoDB

      -------------------------------------------+

       

      admin@(none)05:41:48>show engines;
      -------------------------------------------------------------------------------------------------------------------------------+

      Engine Support Comment Transactions XA Savepoints

      -------------------------------------------------------------------------------------------------------------------------------+

      PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
      MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO
      CSV YES CSV storage engine NO NO NO
      BLACKHOLE DEFAULT /dev/null storage engine (anything you write to it disappears) NO NO NO
      MyISAM YES MyISAM storage engine NO NO NO
      InnoDB YES Percona-XtraDB, Supports transactions, row-level locking, and foreign keys YES YES YES
      ARCHIVE YES Archive storage engine NO NO NO
      MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
      FEDERATED NO Federated MySQL storage engine NULL NULL NULL

      -------------------------------------------------------------------------------------------------------------------------------+

       

      select @@sql_mode
      -> ;
      ------------

      @@sql_mode

      ------------

       

      ------------

       

       

       

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  jqxu xujiaqing
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated: