Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
CentOS Linux release 7.1.1503 (Core)
-
10.2.11, 10.2.12, 10.0.34, 10.2.14, 10.1.32
Description
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.
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
-
-
- Closed
-
- relates to
-
-
- Open
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0.22-galera [ 19801 ] | |
| Assignee | Kristian Nielsen [ knielsen ] |
| Labels | upstream-not-affected |
| Link |
This issue is duplicated by |
| Fix Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Assignee | Kristian Nielsen [ knielsen ] | Andrei Elkin [ elkin ] |
| Sprint | 10.2.11 [ 203 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Sprint | 10.2.11 [ 203 ] | 10.2.11, 10.2.12 [ 203, 216 ] |
| Sprint | 10.2.11, 10.2.12 [ 203, 216 ] | 10.2.11, 10.2.12, 10.0.34 [ 203, 216, 224 ] |
| Sprint | 10.2.11, 10.2.12, 10.0.34 [ 203, 216, 224 ] | 10.2.11, 10.2.12, 10.0.34, 10.2.14 [ 203, 216, 224, 229 ] |
| Sprint | 10.2.11, 10.2.12, 10.0.34, 10.2.14 [ 203, 216, 224, 229 ] | 10.2.11, 10.2.12, 10.0.34, 10.2.14, 10.1.32 [ 203, 216, 224, 229, 235 ] |
| Assignee | Andrei Elkin [ elkin ] | Sachin Setiya [ sachin.setiya.007 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Sachin Setiya [ sachin.setiya.007 ] | Andrei Elkin [ elkin ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Andrei Elkin [ elkin ] | Sachin Setiya [ sachin.setiya.007 ] |
| Assignee | Sachin Setiya [ sachin.setiya.007 ] | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] | Andrei Elkin [ elkin ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.3 [ 22126 ] |
| Link | This issue relates to MDEV-16728 [ MDEV-16728 ] |
| Assignee | Andrei Elkin [ elkin ] | Sachin Setiya [ sachin.setiya.007 ] |
| Fix Version/s | 10.0.36 [ 22916 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.1.35 [ 23116 ] | |
| Fix Version/s | 10.2.17 [ 23111 ] | |
| Fix Version/s | 10.3.9 [ 23114 ] |
| Link |
This issue is duplicated by |
| Workflow | MariaDB v3 [ 73123 ] | MariaDB v4 [ 149903 ] |
| Zendesk Related Tickets | 181796 187321 158732 182166 180786 200409 |