ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO

Overview

This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0.

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0 as error number 3022

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0 as error number 3022

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1 as error number 3022

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0 as error number 3022

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1 as error number 3022

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0 as error number 3022

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1 as error number 3022

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0 as error number 3022

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1 as error number 3022

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0 as error number 3022

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1 as error number 3022

10.2 Community

  • Added in MariaDB Community Server 10.2.3 as error number 3021

  • Error number changed in MariaDB Community Server 10.2.5 from 3021 to 3022

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0 as error number 3022

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0 as error number 3022

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1 as error number 3022

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1 as error number 3022

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1 as error number 3022

EXTERNAL REFERENCES