[MDEV-9266] Creating index on temporaray table breaks replication - Jira

XML

Word

Printable

Creating an index on temporary table breaks (row based) replication.

On the master execute the following SQL statements:

create temporary table TMP_FOO( bar int not null) engine=memory;

create index tmp_idx01 on TMP_FOO(bar);

On the slave we get the following error:

Error 'Table 'mmm_data.TMP_FOO' doesn't exist' on query. Default database: 'mmm_data'. Query: 'create index tmp_idx01 on TMP_FOO(bar)'

Configuration of master:

log-bin                         = mysql-bin

server-id                       = 4

log_bin_trust_function_creators = 1

binlog_format                   = row

slave_compressed_protocol       = 1

#sync_binlog                    = 1

expire_logs_days                = 35

binlog-ignore-db                = mmm_temp

Configuration of slave:

server-id                       = 5

log_bin_trust_function_creators = 1

log-bin                         = myslave2-bin

relay-log                       = myslave2-relay-bin

binlog_format                   = row

log-slave-updates               = 1

sync_binlog                     = 1

expire_logs_days                = 35

slave_compressed_protocol       = 1

Work a round: On the slave set slave-skip-errors in my.cnf:

slave-skip-errors = 1146

Note: The master and slave server run the same OS and MariaDB versions.

is duplicated by

MDEV-14118 CREATE INDEX on temporary table breaks replication slaves

MDEV-26948 MariaDB 10.2.10 does not write create temporary table into binary log in mixed mode

relates to

MDEV-16728 RENAME temporary table may not find the target table on slave in RBR

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