4.0.20 replication
"DePhillips, Michael P" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hello, My 4.0.20 master is not releasing threads created to do a binlog dump. These accumulate over time. For example Show processlist (from master) | Id | User | Host | db | Command | Time | State | Info | +---------+------------+-----------------------------+-------------------+-- -----------+-------+-------------------------------------------------------- --------+------------------+ | 11069 | starmirror | pc011c.x:43136 | NULL | Binlog Dump | 37484 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 16491 | starmirror | uxnuk13.x:52240 | NULL | Binlog Dump | 37477 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 18801 | starmirror | db03.x:55596 | NULL | Binlog Dump | 37475 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 35869 | starmirror | db07.x:40061 | NULL | Binlog Dump | 37457 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 35893 | starmirror | db02.x:34169 | NULL | Binlog Dump | 37457 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 79323 | starmirror | db04.x:39446 | NULL | Binlog Dump | 37396 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 146751 | starmirror | muon.x:60009 | NULL | Binlog Dump | 37195 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 1333916 | starmirror | uxnuk13.X:52247 | NULL | Binlog Dump | 33872 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 1335283 | starmirror | db06.x:45543 | NULL | Binlog Dump | 33870 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 1339336 | starmirror | db02.x:34206 | NULL | Binlog Dump | 33857 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 1342126 | starmirror | db05.x:51764 | NULL | Binlog Dump | 33853 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 1359458 | starmirror | db03.x:39886 | NULL | Binlog Dump | 33796 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 1406820 | starmirror | pc011c.x:43181 | NULL | Binlog Dump | 33637 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2439097 | starmirror | db07.x:53022 | NULL | Binlog Dump | 30452 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2441519 | starmirror | uxnuk13.x:52251 | NULL | Binlog Dump | 30269 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2441572 | starmirror | muon.X:32998 | NULL | Binlog Dump | 30269 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2442175 | starmirror | db06.x:45868 | NULL | Binlog Dump | 30257 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2442345 | starmirror | db05.x:51766 | NULL | Binlog Dump | 30253 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2445617 | starmirror | db03.x:40561 | NULL | Binlog Dump | 30162 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2452169 | starmirror | db04.x:49060 | NULL | Binlog Dump | 30004 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2475289 | starmirror | pc011c.x:43768 | NULL | Binlog Dump | 26786 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2510826 | starmirror | muon.x:33003 | NULL | Binlog Dump | 26669 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2512508 | starmirror | uxnuk13.X:52257 | NULL | Binlog Dump | 26663 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2514926 | starmirror | db07.x:55552 | NULL | Binlog Dump | 26656 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2516024 | starmirror | db05.x:51775 | NULL | Binlog Dump | 26653 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2596278 | starmirror | db03.x:37840 | NULL | Binlog Dump | 26404 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 2596358 | starmirror | db02.x:54363 | NULL | Binlog Dump | 26404 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3493408 | starmirror | db04.x:45915 | NULL | Binlog Dump | 23185 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3494443 | starmirror | muon.x:33097 | NULL | Binlog Dump | 23055 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3495519 | starmirror | db06.x:58800 | NULL | Binlog Dump | 23052 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3497278 | starmirror | uxnuk13.x:52276 | NULL | Binlog Dump | 23045 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3497526 | starmirror | pc011c.x:44062 | NULL | Binlog Dump | 23045 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3560581 | starmirror | db02.x:54368 | NULL | Binlog Dump | 22804 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 3561120 | starmirror | db03.x:38019 | NULL | Binlog Dump | 22803 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4771180 | starmirror | db07.x:44518 | NULL | Binlog Dump | 19585 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4820826 | starmirror | muon.x:33098 | NULL | Binlog Dump | 19455 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4827670 | starmirror | pc011c.x:44063 | NULL | Binlog Dump | 19444 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4828871 | starmirror | db06.x:32863 | NULL | Binlog Dump | 19442 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4917536 | starmirror | db02.x:54373 | NULL | Binlog Dump | 19204 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4918065 | starmirror | db03.x:38053 | NULL | Binlog Dump | 19203 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 5134096 | starmirror | uxnuk13.x:52291 | NULL | Binlog Dump | 18621 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6113311 | starmirror | db07.x:45856 | NULL | Binlog Dump | 15979 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6158166 | starmirror | muon.x:33103 | NULL | Binlog Dump | 15855 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6163081 | starmirror | db06.x:32910 | NULL | Binlog Dump | 15842 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6164506 | starmirror | pc011c.x:44074 | NULL | Binlog Dump | 15838 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6246888 | starmirror | db02.x:54379 | NULL | Binlog Dump | 15604 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6248348 | starmirror | db03.x:38388 | NULL | Binlog Dump | 15601 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6437715 | starmirror | db04.x:58417 | NULL | Binlog Dump | 15020 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6443711 | starmirror | uxnuk13.x:55718 | NULL | Binlog Dump | 12380 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6487101 | starmirror | muon.x:33106 | NULL | Binlog Dump | 12255 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6493361 | starmirror | db07.x:42165 | NULL | Binlog Dump | 12239 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6494127 | starmirror | pc011c.x:44075 | NULL | Binlog Dump | 12236 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6569265 | starmirror | db02.x:54383 | NULL | Binlog Dump | 12004 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 6570383 | starmirror | db03.X:38389 | NULL | Binlog Dump | 12001 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | | 7564043 | starmirror | db06.x:54231 | NULL | Binlog Dump | 8824 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7565912 | starmirror | db04.X:38825 | NULL | Binlog Dump | 8769 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7566267 | starmirror | uxnuk13.x:55894 | NULL | Binlog Dump | 8638 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7566275 | starmirror | muon.x:33126 | NULL | Binlog Dump | 8638 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7566282 | starmirror | db07.x:42179 | NULL | Binlog Dump | 8638 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7567233 | starmirror | pc011c.x:44548 | NULL | Binlog Dump | 8404 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7569231 | starmirror | db05.x:52309 | NULL | Binlog Dump | 8360 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7571322 | starmirror | db02.x:55477 | NULL | Binlog Dump | 5224 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7602850 | starmirror | db06.x:41768 | NULL | Binlog Dump | 5109 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7622185 | starmirror | db07.x:42183 | NULL | Binlog Dump | 5038 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7622284 | starmirror | muon.x:33127 | NULL | Binlog Dump | 5038 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7649394 | starmirror | db04.x:42128 | NULL | Binlog Dump | 4927 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7649684 | starmirror | uxnuk13.x:56044 | NULL | Binlog Dump | 4803 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7649965 | starmirror | pc011c.x:44640 | NULL | Binlog Dump | 4759 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7664277 | starmirror | star2.x:43696 | NULL | Binlog Dump | 3206 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7866645 | starmirror | db02.x:55486 | NULL | Binlog Dump | 1624 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7898769 | starmirror | db05.x:35586 | NULL | Binlog Dump | 1509 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7908955 | starmirror | pdsfdv01.x:35266 | NULL | Binlog Dump | 1472 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7918065 | starmirror | db06.x:51424 | NULL | Binlog Dump | 1439 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7918391 | starmirror | muon.x:33129 | NULL | Binlog Dump | 1438 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7949066 | starmirror | db07.x:57679 | NULL | Binlog Dump | 1327 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 7983209 | starmirror | uxnuk13.x:56050 | NULL | Binlog Dump | 1199 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 8112191 | starmirror | db03.x:48380 | NULL | Binlog Dump | 712 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 8112451 | starmirror | db04.x:39129 | NULL | Binlog Dump | 5 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 8112452 | starmirror | pc011c.x:44771 | NULL | Sleep | 0 | | NULL | +---------+------------+-----------------------------+-------------------+-- -----------+-------+-------------------------------------------------------- --------+------------------+ 84 rows in set (0.00 sec) (x's replaced domain for security reasons.) Shouldn't a replication thread be released before a new one is created? Thanks Michael