Who is a great god come across this phenomenon, how to solve of,
No law can happen any time, no backup, no DDL statements in execution,
Show the processlist below
"Id", "app_id" "host" "port" "pid" "p_user" p_host p_db "" "" "command" "time" "status", "info" "time_ms" rows_sent rows_examined "" "" "create_time
""1363604" "300" "1.1.1.1" "3306" "82405" "cacti" "127.0.0.1:54386" \ N "Query", "1225" "init" "SHOW SLAVE STATUS from" "1225339" "0" "0" "the 2017-07-01 04:14:32
""1363605" "300" "1.1.1.1" "3306" "83012" "cacti" "127.0.0.1:56197" \ N "Query", "82" "init" "SHOW SLAVE STATUS from" "82726" "0" "0" "the 2017-07-01 04:14:32
""1363606" "300" "1.1.1.1" "3306" "82819" "cacti" "127.0.0.1:55620" \ N "Query", "447" "init" "SHOW SLAVE STATUS from" "447682" "0" "0" "the 2017-07-01 04:14:32
""1363607" "300" "1.1.1.1" "3306" "82585" "cacti" "127.0.0.1:54925" \ N "Query", "886" "init" "SHOW SLAVE STATUS from" "886572" "0" "0" "the 2017-07-01 04:14:32
""1363608" "300" "1.1.1.1" "3306" "82745" "cacti" "127.0.0.1:55386" \ N "Query", "593" "init" "SHOW SLAVE STATUS from" "593571" "0" "0" "the 2017-07-01 04:14:32
""1363609" "300" "1.1.1.1" "3306" "82984" "cacti" "127.0.0.1:56121" \ N "Query", "130" "init" "SHOW SLAVE STATUS from" "130517" "0" "0" "the 2017-07-01 04:14:32
""1363610" "300" "1.1.1.1" "3306" "82548" "cacti" "127.0.0.1:54808" \ N "Query", "959" "init" "SHOW SLAVE STATUS from" "959112" "0" "0" "the 2017-07-01 04:14:32
""1363611" "300" "1.1.1.1" "3306" "82366" "cacti" "127.0.0.1:54264" \ N "Query", "1303" "init" "SHOW SLAVE STATUS from" "1303483" "0" "0" "the 2017-07-01 04:14:32
""1363612" "300" "1.1.1.1" "3306" "82664" "cacti" "127.0.0.1:55156" \ N "Query", "740" "init" "SHOW SLAVE STATUS from" "740157" "0" "0" "the 2017-07-01 04:14:32
""1363613" "300" "1.1.1.1" "3306" "82781" "cacti" "127.0.0.1:55501" \ N "Query", "523" "init" "SHOW SLAVE STATUS from" "523296" "0" "0" "the 2017-07-01 04:14:32
""1363614" "300" "1.1.1.1" "3306" "82684" "cacti" "127.0.0.1:55213" \ N "Query", "706" "init" "SHOW SLAVE STATUS from" "706618" "0" "0" "the 2017-07-01 04:14:32
""1363615" "300" "1.1.1.1" "3306" "82698" "cacti" "127.0.0.1:55251" \ N "Query", "679" "init" "SHOW SLAVE STATUS from" "679220" "0" "0" "the 2017-07-01 04:14:32
""1363616" "300" "1.1.1.1" "3306" "82490" "cacti" "127.0.0.1:54637" \ N "Query", "1069" "init" "SHOW SLAVE STATUS from" "1069452" "0" "0" "the 2017-07-01 04:14:32
""1363617" "300" "1.1.1.1" "3306" "82627" "cacti" "127.0.0.1:55044" \ N "Query", "813" "init" "SHOW SLAVE STATUS from" "813096" "0" "0" "the 2017-07-01 04:14:32
""1363618" "300" "1.1.1.1" "3306" "82895" "cacti" "127.0.0.1:55853" \ N "Query", "301" "init" "SHOW SLAVE STATUS from" "301676" "0" "0" "the 2017-07-01 04:14:32
""1363619" "300" "1.1.1.1" "3306" "83030" "cacti" "127.0.0.1:56246" \ N "Query" 52 "init" "" "SHOW SLAVE STATUS from "" 52734" "0" "0" "the 2017-07-01 04:14:32
""1363620" "300" "1.1.1.1" "3306" "82906" "cacti" "127.0.0.1:55873" \ N "Query", "287" "init" "SHOW SLAVE STATUS from" "286905" "0" "0" "the 2017-07-01 04:14:32
""1363621" "300" "1.1.1.1" "3306" "82656" "cacti" "127.0.0.1:55128" \ N "Query", "757" "init" "SHOW SLAVE STATUS from" "757089" "0" "0" "the 2017-07-01 04:14:32
""1363622" "300" "1.1.1.1" "3306" "82393" "cacti" "127.0.0.1:54347" \ N "Query", "1251" "init" "SHOW SLAVE STATUS from" "1251645" "0" "0" "the 2017-07-01 04:14:32
""1363623" "300" "1.1.1.1" "3306" "82822" "cacti" "127.0.0.1:55623" \ N "Query", "444" "init" "SHOW SLAVE STATUS from" "444627" "0" "0" "the 2017-07-01 04:14:32
""1363624" "300" "1.1.1.1" "3306" "82528" "cacti" "127.0.0.1:54761" \ N "Query", "991" "init" "SHOW SLAVE STATUS from" "991026" "0" "0" "the 2017-07-01 04:14:32
""1363625" "300" "1.1.1.1" "3306" "82616" "cacti" "127.0.0.1:55004" \ N "Query", "835" "init" "SHOW SLAVE STATUS from" "835085" "0" "0" "the 2017-07-01 04:14:32
""1363626" "300" "1.1.1.1" "3306" "82569" "cacti" "127.0.0.1:54882" \ N "Query", "913" "init" "SHOW SLAVE STATUS from" "913666" "0" "0" "the 2017-07-01 04:14:32
""1363627" "300" "1.1.1.1" "3306" "82973" "cacti" "127.0.0.1:56084" \ N "Query", "155" "init" "SHOW SLAVE STATUS from" "155511" "0" "0" "the 2017-07-01 04:14:32"
CodePudding user response:
Slave IO thread was blocked, but does not affect the normal business table query,CodePudding user response:
Pt - PMP trace stack outputMon Jul 3 14:17:56 CST 2017
Missing separate debuginfo for/lib64/libssl. So. 10
Try: yum - enablerepo='* - the debug * install/usr/lib/debug/. Build - id/be/cfb85a8bc084042d5bf2ba9e66325ce798b659. Debug
Missing separate debuginfo for/lib64/libcrypto. So. 10
Try: yum - enablerepo='* - the debug * install/usr/lib/debug/. Build - id/cb/da444a7109874c5350ae9ceef3f82f749b347f. Debug
Unhandled dwarf expression opcode 0 xfa
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull