Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
A:mysql Ver 15.1 Distrib 10.0.13-MariaDB, for Linux (x86_64) using readline 5.1
B:mysql Ver 15.1 Distrib 10.0.13-MariaDB, for Linux (x86_64) using readline 5.1
C:mysql Ver 15.1 Distrib 10.0.17-MariaDB, for Linux (x86_64) using readline 5.1
D:mysql Ver 15.1 Distrib 10.0.17-MariaDB, for Linux (x86_64) using readline 5.1
A master is B(mastername: m1), and replicate datasource d1
B master is A(mastername: m1), and replicate datasource d1
C master is A(mastername: m1) and D(mastername: m2), and replicate datasource d1 d2
D master is B(mastername: m1) and C(mastername: m2), and replicate datasource d1 d2
A:mysql Ver 15.1 Distrib 10.0.13-MariaDB, for Linux (x86_64) using readline 5.1 B:mysql Ver 15.1 Distrib 10.0.13-MariaDB, for Linux (x86_64) using readline 5.1 C:mysql Ver 15.1 Distrib 10.0.17-MariaDB, for Linux (x86_64) using readline 5.1 D:mysql Ver 15.1 Distrib 10.0.17-MariaDB, for Linux (x86_64) using readline 5.1 A master is B(mastername: m1), and replicate datasource d1 B master is A(mastername: m1), and replicate datasource d1 C master is A(mastername: m1) and D(mastername: m2), and replicate datasource d1 d2 D master is B(mastername: m1) and C(mastername: m2), and replicate datasource d1 d2
Description
There is no problem when I execute "insert into d1.table1 ..." on A. But when I execute the "grant ...; flush privileges;" when there is a problem in the C and D, the occurrence of a loop execution "grant ...; flush privileges;".
then modification my.cnf on C and D. Add the following
_m1.replicate_wild_ignore_table=mysql.%
m1.replicate_wild_ignore_table=information_schema.%
m1.replicate_wild_ignore_table=performance_schema.%
m2.replicate-ignore-db=d1_
still loop execution,but just execute "flush privileges;".
and the bin log like this:
# at 573930687
|
#150416 11:31:07 server id 231 end_log_pos 573930725 GTID 0-231-517276191
|
/*!100001 SET @@session.gtid_seq_no=517276191*//*!*/;
|
# at 573930725
|
#150416 11:31:07 server id 231 end_log_pos 573930800 Query thread_id=1826986 exec_time=1339 error_code=0
|
SET TIMESTAMP=1429155067/*!*/;
|
flush privileges
|
/*!*/;
|
# at 573930800
|
#150416 11:31:07 server id 231 end_log_pos 573930838 GTID 0-231-517276191
|
/*!100001 SET @@session.gtid_seq_no=517276191*//*!*/;
|
# at 573930838
|
#150416 11:31:07 server id 231 end_log_pos 573930913 Query thread_id=1826986 exec_time=1339 error_code=0
|
SET TIMESTAMP=1429155067/*!*/;
|
flush privileges
|
/*!*/;
|
# at 573930913
|
#150416 11:31:07 server id 231 end_log_pos 573930951 GTID 0-231-517276191
|
/*!100001 SET @@session.gtid_seq_no=517276191*//*!*/;
|
# at 573930951
|
#150416 11:31:07 server id 231 end_log_pos 573931026 Query thread_id=1826986 exec_time=1339 error_code=0
|
SET TIMESTAMP=1429155067/*!*/;
|
flush privileges
|
/*!*/;
|
# at 573931026
|
#150416 11:31:07 server id 231 end_log_pos 573931064 GTID 0-231-517276191
|
/*!100001 SET @@session.gtid_seq_no=517276191*//*!*/;
|
# at 573931064
|
#150416 11:31:07 server id 231 end_log_pos 573931139 Query thread_id=1826986 exec_time=1339 error_code=0
|
SET TIMESTAMP=1429155067/*!*/;
|
flush privileges
|
/*!*/;
|
# at 573931139
|
#150416 11:31:07 server id 231 end_log_pos 573931177 GTID 0-231-517276191
|
/*!100001 SET @@session.gtid_seq_no=517276191*//*!*/;
|
# at 573931177
|
#150416 11:31:07 server id 231 end_log_pos 573931252 Query thread_id=1826986 exec_time=1339 error_code=0
|
SET TIMESTAMP=1429155067/*!*/;
|
flush privileges
|
/*!*/;
|
For more information see bin.log