本文主要向大家介绍了MySQL数据库之mysql从库Retrieved_Gtid_Set事务数比Executed_Gtid_Set事务数少的异常情况 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。
今天从库crash重启后出现很有趣的现象：
可以发现：
Retrieved_Gtid_Set值显示从库没有接收到部分事务，丢失了部分事务。但是从Executed_Gtid_Set显示从库没有丢失事务。
错误日志：
-03-0810:41:12118393[ERROR]/usr/local/mysql/bin/mysqld:Sortaborted:Queryexecutionwasinterrupted17030810:55:38mysqld_safeNumberofprocessesrunningnow:017030810:55:38mysqld_safemysqldrestarted-03-0810:55:390[Note]/usr/local/mysql/bin/mysqld(mysqld5.6.29-log)startingasprocess131069...
从中可以看到，mysql crash后由mysqld_safe重新拉起来，并没有其他有用的报错信息。
系统日志(/var/log/messsage)：
Mar810:55:37mysql02kernel:irqbalanceinvokedoom-killer:gfp_mask=0x280da,order=0,oom_adj=0,oom_score_adj=0Mar810:55:37mysql02kernel:irqbalancecpuset=/mems_allowed=0Mar810:55:37mysql02kernel:Pid:1853,comm:irqbalanceNottainted2.6.32-431.el6.x86_64#1Mar810:55:37mysql02kernel:CallTrace:Mar810:55:37mysql02kernel:[]?cpuset_print_task_mems_allowed+0x91/0xb0Mar810:55:37mysql02kernel:[]?dump_header+0x90/0x1b0Mar810:55:37mysql02kernel:[]?security_real_capable_noaudit+0x3c/0x70Mar810:55:37mysql02kernel:[]?oom_kill_process+0x82/0x2a0Mar810:55:37mysql02kernel:[]?select_bad_process+0xe1/0x120Mar810:55:37mysql02kernel:[]?out_of_memory+0x220/0x3c0Mar810:55:37mysql02kernel:[]?__alloc_pages_nodemask+0x8ac/0x8d0Mar810:55:37mysql02kernel:[]?alloc_pages_vma+0x9a/0x150Mar810:55:37mysql02kernel:[]?handle_pte_fault+0x73d/0xb00Mar810:55:37mysql02kernel:[]?inode_init_always+0x11e/0x1c0Mar810:55:37mysql02kernel:[]?bit_waitqueue+0x17/0xd0Mar810:55:37mysql02kernel:[]?inotify_d_instantiate+0x2a/0x60Mar810:55:37mysql02kernel:[]?__d_instantiate+0xbb/0x110Mar810:55:37mysql02kernel:[]?security_d_instantiate+0x1b/0x30Mar810:55:37mysql02kernel:[]?handle_mm_fault+0x22a/0x300Mar810:55:37mysql02kernel:[]?number+0x2ee/0x320Mar810:55:37mysql02kernel:[]?__do_page_fault+0x138/0x480Mar810:55:37mysql02kernel:[]?vsnprintf+0x218/0x5e0Mar810:55:37mysql02kernel:[]?seq_release+0x0/0x30Mar810:55:37mysql02kernel:[]?do_page_fault+0x3e/0xa0Mar810:55:37mysql02kernel:[]?page_fault+0x25/0x30Mar810:55:37mysql02kernel:[]?copy_user_enhanced_fast_string+0x6/0x10Mar810:55:37mysql02kernel:[]?seq_read+0x2d2/0x400Mar810:55:37mysql02kernel:[]?proc_reg_read+0x7e/0xc0Mar810:55:37mysql02kernel:[]?vfs_read+0xb5/0x1a0Mar810:55:37mysql02kernel:[]?sys_read+0x51/0x90Mar810:55:37mysql02kernel:[]?system_call_fastpath+0x16/0x1bMar810:55:37mysql02kernel:Mem-Info:Mar810:55:37mysql02kernel:Node0DMAper-cpu:Mar810:55:37mysql02kernel:CPU0:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU1:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU2:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU3:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU4:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU5:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU6:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU7:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU8:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU9:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU10:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU11:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU12:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU13:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU14:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:CPU15:hi:0,btch:1usd:0Mar810:55:37mysql02kernel:Node0DMA32per-cpu:Mar810:55:37mysql02kernel:CPU0:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU1:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU2:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU3:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU4:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU5:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU6:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU7:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU8:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU9:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU10:hi:186,btch:31usd:30Mar810:55:37mysql02kernel:CPU11:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU12:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU13:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU14:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU15:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:Node0Normalper-cpu:Mar810:55:37mysql02kernel:CPU0:hi:186,btch:31usd:28Mar810:55:37mysql02kernel:CPU1:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU2:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU3:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU4:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU5:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU6:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU7:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU8:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU9:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU10:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU11:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU12:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU13:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU14:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:CPU15:hi:186,btch:31usd:0Mar810:55:37mysql02kernel:active_anon:6861787inactive_anon:578006isolated_anon:0Mar810:55:37mysql02kernel:active_file:242921inactive_file:379133isolated_file:0Mar810:55:37mysql02kernel:unevictable:0dirty:356609writeback:22685unstable:0Mar810:55:37mysql02kernel:free:49534slab_reclaimable:21256slab_unreclaimable:10798Mar810:55:37mysql02kernel:mapped:2837shmem:294pagetables:16180bounce:0Mar810:55:37mysql02kernel:Node0DMAfree:15560kBmin:28kBlow:32kBhigh:40kBactive_anon:0kBinactive_anon:0kBactive_file:0kBinactive_file:0kBunevictable:0kBisolated(anon):0kBisolated(file):0kBpresent:15176kBmlocked:0kBdirty:0kBwriteback:0kBmapped:0kBshmem:0kBslab_reclaimable:0kBslab_unreclaimable:0kBkernel_stack:0kBpagetables:0kBunstable:0kBbounce:0kBwriteback_tmp:0kBpages_scanned:0all_unreclaimable?yesMar810:55:37mysql02kernel:lowmem_reserve[]:035123228932289Mar810:55:37mysql02kernel:Node0DMA32free:122436kBmin:7344kBlow:9180kBhigh:11016kBactive_anon:2254796kBinactive_anon:583736kBactive_file:68kBinactive_file:1944kBunevictable:0kBisolated(anon):0kBisolated(file):0kBpresent:3596508kBmlocked:0kBdirty:1984kBwriteback:60kBmapped:32kBshmem:0kBslab_reclaimable:256kBslab_unreclaimable:124kBkernel_stack:0kBpagetables:28kBunstable:0kBbounce:0kBwriteback_tmp:0kBpages_scanned:768all_unreclaimable?noMar810:55:37mysql02kernel:lowmem_reserve[]:002877728777Mar810:55:37mysql02kernel:Node0Normalfree:60140kBmin:60204kBlow:75252kBhigh:90304kBactive_anon:25192352kBinactive_anon:1728288kBactive_file:971616kBinactive_file:1514588kBunevictable:0kBisolated(anon):0kBisolated(file):0kBpresent:29467760kBmlocked:0kBdirty:1424452kBwriteback:90680kBmapped:11316kBshmem:1176kBslab_reclaimable:84768kBslab_unreclaimable:43068kBkernel_stack:3880kBpagetables:64692kBunstable:0kBbounce:0kBwriteback_tmp:0kBpages_scanned:367200all_unreclaimable?noMar810:55:37mysql02kernel:lowmem_reserve[]:0000Mar810:55:37mysql02kernel:Node0DMA:2*4kB2*8kB1*16kB1*32kB2*64kB0*128kB0*256kB0*512kB1*1024kB1*2048kB3*4096kB=15560kBMar810:55:37mysql02kernel:Node0DMA32:19*4kB35*8kB48*16kB57*32kB59*64kB54*128kB43*256kB39*512kB28*1024kB20*2048kB2*4096kB=122436kBMar810:55:37mysql02kernel:Node0Normal:474*4kB368*8kB446*16kB303*32kB190*64kB92*128kB12*256kB3*512kB2*1024kB4*2048kB0*4096kB=60456kBMar810:55:37mysql02kernel:622459totalpagecachepagesMar810:55:37mysql02kernel:0pagesinswapcacheMar810:55:37mysql02kernel:Swapcachestats:add0,delete0,find0/0Mar810:55:37mysql02kernel:Freeswap=4194296kBMar810:55:37mysql02kernel:Totalswap=4194296kBMar810:55:37mysql02kernel:8386559pagesRAMMar810:55:37mysql02kernel:172714pagesreservedMar810:55:37mysql02kernel:627141pagessharedMar810:55:37mysql02kernel:7536243pagesnon-sharedMar810:55:37mysql02kernel:[pid]uidtgidtotal_vmrsscpuoom_adjoom_score_adjnameMar810:55:37mysql02kernel:[605]060526621710-17-1000udevdMar810:55:37mysql02kernel:[1522]01522228000dhclientMar810:55:37mysql02kernel:[1828]01828154093000portreserveMar810:55:37mysql02kernel:[1835]01835629931908000rsyslogdMar810:55:37mysql02kernel:[1853]018532706138900irqbalanceMar810:55:37mysql02kernel:[1894]01894169571100mcelogMar810:55:37mysql02kernel:[1916]8119165351124400dbus-daemonMar810:55:37mysql02kernel:[1945]01945106000acpidMar810:55:37mysql02kernel:[1954]68195494423811200haldMar810:55:37mysql02kernel:[1955]019555082158000hald-runnerMar810:55:37mysql02kernel:[1984]019845612137000hald-addon-inpuMar810:55:37mysql02kernel:[]684484141000hald-addon-acpiMar810:55:37mysql02kernel:[]0203075252000automountMar810:55:37mysql02kernel:[2061]020611884116000uvp-monitorMar810:55:37mysql02kernel:[2063]02063101731766000uvp-monitorMar810:55:37mysql02kernel:[2118]02118166562801-17-1000sshdMar810:55:37mysql02kernel:[2148]0214827580163400abrtdMar810:55:37mysql02kernel:[2175]0217529331274200crondMar810:55:37mysql02kernel:[2186]02186538595000atdMar810:55:37mysql02kernel:[2194]02194478321721000pythonMar810:55:37mysql02kernel:[2205]0220515588129300certmongerMar810:55:37mysql02kernel:[2221]02221101684000mingettyMar810:55:37mysql02kernel:[2223]02223101684000mingettyMar810:55:37mysql02kernel:[2225]02225101684000mingettyMar810:55:37mysql02kernel:[2227]02227101685000mingettyMar810:55:37mysql02kernel:[2229]02229101684400mingettyMar810:55:37mysql02kernel:[2231]02231101685700mingettyMar810:55:37mysql02kernel:[100856]010085626631680-17-1000udevdMar810:55:37mysql02kernel:[100860]010086026631680-17-1000udevdMar810:55:37mysql02kernel:[81005]08100518916236200zabbix_agentdMar810:55:37mysql02kernel:[81007]08100718916458600zabbix_agentdMar810:55:37mysql02kernel:[81008]08100818916302100zabbix_agentdMar810:55:37mysql02kernel:&nb
本文由职坐标整理并发布，希望对同学们学习MySQL有所帮助，更多内容请关注职坐标数据库MySQL数据库频道！
