mysql 1141_Mysql 主从报错:1141

主从同步,从库报错代码:1141 ,错误信息如下:

master_port: 3306

connect_retry: 60

master_log_file: binlog.000086

read_master_log_pos: 596130762

relay_log_file: mysql-relay-bin.000486

relay_log_pos: 212230586

relay_master_log_file: binlog.000086

slave_io_running: yes

slave_sql_running: no

replicate_do_db:

replicate_ignore_db: information_schema,performance_schema,undolog,for_nagios

replicate_do_table:

replicate_ignore_table:

replicate_wild_do_table:

replicate_wild_ignore_table: information_schema.%,performance_schema.%

last_errno: 1141

last_error: coordinator stopped because there were error(s) in the worker(s). the most recent failure being: worker 1 failed executing transaction '510f1fe6-aeba-4334-b18b-3c2043b52ff2:125151353' at master log binlog.000086, end_log_pos 547512983. see error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.

skip_counter: 0

exec_master_log_pos: 547458856

relay_log_space: 261211881

until_condition: none

until_log_file:

until_log_pos: 0

master_ssl_allowed: no

master_ssl_ca_file:

master_ssl_ca_path:

master_ssl_cert:

master_ssl_cipher:

master_ssl_key:

seconds_behind_master: null

master_ssl_verify_server_cert: no

last_io_errno: 0

last_io_error:

last_sql_errno: 1141

last_sql_error: coordinator stopped because there were error(s) in the worker(s). the most recent failure being: worker 1 failed executing transaction '510f1fe6-aeba-4334-b18b-3c2043b52ff2:125151353' at master log binlog.000086, end_log_pos 547512983. see error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.

replicate_ignore_server_ids:

master_server_id: 33

master_uuid: 41f96eda-0f5a-11e9-ad75-00163e00d868

master_info_file: mysql.slave_master_info

sql_delay: 0

sql_remaining_delay: null

slave_sql_running_state:

master_retry_count: 86400

master_bind:

last_io_error_timestamp:

last_sql_error_timestamp: 190704 19:57:28

master_ssl_crl:

master_ssl_crlpath:

retrieved_gtid_set: 510f1fe6-aeba-4334-b18b-3c2043b52ff2:25836646-125206230

executed_gtid_set: 0b117566-0b1e-11e9-a8b4-00163e001495:1-3087343,

2479bd1b-1271-11e9-8c68-005056bd8639:1-81,

2d748950-c0fd-11e7-81f8-0050569175d7:35404018-35647968,

510f1fe6-aeba-4334-b18b-3c2043b52ff2:1-5363955:5393677-125151352,

db981f90-01f5-11e9-8d52-00163e008b14:1-4218,

e66adda1-ff8d-11e8-9d3d-00163e008b14:1-25261

auto_position: 0

replicate_rewrite_db:

channel_name:

master_tls_version:

解决方法:

根据上述的主从同步信息,

relay_log_file: mysql-relay-bin.000486

relay_log_pos: 212230586

在从库上使用mysqlbinlog将日志文件解析出来,命令如下:

mysqlbinlog --no-defaults -v -v --base64-output=decode-rows mysql-relay-bin.000486 > /tmp/mysql-relay-bin.000486

在解析出来的文件中找到对应的pos点: 212230586

#190704 13:47:32 server id 1 end_log_pos 547458856 xid = 4140969095

commit/*!*/;

# at 212230586

#190704 13:47:32 server id 1 end_log_pos 547458917 gtid last_committed=1230803 sequence_number=1230804 rbr_only=no

set @@session.gtid_next= '510f1fe6-aeba-4334-b18b-3c2043b52ff2:125151281'/*!*/;

# at 212230647

#190704 13:47:32 server id 1 end_log_pos 547459084 query thread_id=469641862 exec_time=0 error_code=0

set timestamp=1562219252/*!*/;

set @@session.sql_mode=1436549152/*!*/;

revoke grant option on `f_common`.* from 'f_common'@'172.20.73.%'

/*!*/;

# at 212230814

发现在执行 revoke语句 删除用户权限。

查看从库上的用户库,发现没有用户 f_common。 所以就出现问题了。

问题原因已经清楚了,后续就自己处理了。

希望与广大网友互动??

点此进行留言吧!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值