Error 3022: This operation may not be safe when the slave has temporary tables
Error Code
SQLSTATE
Error
Description
3022
ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO
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.
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 3021: This operation cannot be performed with a running slave io threadNextError 3023: CHANGE MASTER TO with a MASTER_LOG_FILE clause but no MASTER_LOG_POS clause may not be s
Last updated
Was this helpful?