ONLY 6 DAYS REMAINING processes on bots-sql2:
mysql> show processlist; +-------+-------------+-----------------------------------+-------------+---------+-------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-------------+-----------------------------------+-------------+---------+-------+-------+------------------+ | 23537 | coibot | tools-exec-06.pmtpa.wmflabs:52622 | coibot | Sleep | 21134 | | NULL | | 23545 | coibot | tools-exec-06.pmtpa.wmflabs:52644 | coibot | Sleep | 19897 | | NULL | | 23546 | coibot | tools-exec-06.pmtpa.wmflabs:52647 | coibot | Sleep | 20051 | | NULL | | 23547 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52650 | linkwatcher | Sleep | 19897 | | NULL | | 23548 | coibot | tools-exec-06.pmtpa.wmflabs:52652 | coibot | Sleep | 19487 | | NULL | | 23549 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52656 | linkwatcher | Sleep | 20051 | | NULL | | 23550 | coibot | tools-exec-06.pmtpa.wmflabs:52658 | coibot | Sleep | 20102 | | NULL | | 23551 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52661 | linkwatcher | Sleep | 19487 | | NULL | | 23552 | coibot | tools-exec-06.pmtpa.wmflabs:52663 | coibot | Sleep | 19396 | | NULL | | 23553 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52666 | linkwatcher | Sleep | 20102 | | NULL | | 23554 | coibot | tools-exec-06.pmtpa.wmflabs:52668 | coibot | Sleep | 19580 | | NULL | | 23555 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52671 | linkwatcher | Sleep | 19396 | | NULL | | 23556 | coibot | tools-exec-06.pmtpa.wmflabs:52673 | coibot | Sleep | 18816 | | NULL | | 23557 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52678 | linkwatcher | Sleep | 19580 | | NULL | | 23558 | coibot | tools-exec-06.pmtpa.wmflabs:52680 | coibot | Sleep | 20048 | | NULL | | 23559 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52684 | linkwatcher | Sleep | 18816 | | NULL | | 23561 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52690 | linkwatcher | Sleep | 20048 | | NULL | | 23562 | coibot | tools-exec-06.pmtpa.wmflabs:52693 | coibot | Sleep | 19345 | | NULL | | 23564 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52698 | linkwatcher | Sleep | 19345 | | NULL | | 23667 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54773 | coibot | Sleep | 21090 | | NULL | | 23668 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54774 | linkwatcher | Sleep | 20767 | | NULL | | 23669 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54789 | coibot | Sleep | 21397 | | NULL | | 23670 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54790 | linkwatcher | Sleep | 20761 | | NULL | | 23671 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54796 | coibot | Sleep | 22681 | | NULL | | 23672 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54797 | linkwatcher | Sleep | 22299 | | NULL | | 23673 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54810 | coibot | Sleep | 21420 | | NULL | | 23674 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54811 | linkwatcher | Sleep | 20782 | | NULL | | 23687 | linkwatcher | tools-exec-05.pmtpa.wmflabs:57274 | linkwatcher | Sleep | 29364 | | NULL | | 23690 | linkwatcher | tools-exec-05.pmtpa.wmflabs:44701 | linkwatcher | Sleep | 28487 | | NULL | | 23691 | linkwatcher | tools-exec-05.pmtpa.wmflabs:48871 | linkwatcher | Sleep | 28257 | | NULL | | 23692 | linkwatcher | tools-exec-05.pmtpa.wmflabs:51350 | linkwatcher | Sleep | 28116 | | NULL | | 23693 | linkwatcher | tools-exec-05.pmtpa.wmflabs:52552 | linkwatcher | Sleep | 28050 | | NULL | | 23694 | linkwatcher | tools-exec-05.pmtpa.wmflabs:58375 | linkwatcher | Sleep | 27711 | | NULL | | 23695 | linkwatcher | tools-exec-05.pmtpa.wmflabs:33968 | linkwatcher | Sleep | 27478 | | NULL | | 23697 | linkwatcher | tools-exec-05.pmtpa.wmflabs:42745 | linkwatcher | Sleep | 26950 | | NULL | | 23698 | linkwatcher | tools-exec-05.pmtpa.wmflabs:43143 | linkwatcher | Sleep | 26927 | | NULL | | 23699 | linkwatcher | tools-exec-05.pmtpa.wmflabs:45382 | linkwatcher | Sleep | 26823 | | NULL | | 23700 | linkwatcher | tools-exec-05.pmtpa.wmflabs:52604 | linkwatcher | Sleep | 26453 | | NULL | | 23703 | linkwatcher | tools-exec-05.pmtpa.wmflabs:33012 | linkwatcher | Sleep | 25989 | | NULL | | 23704 | linkwatcher | tools-exec-05.pmtpa.wmflabs:38863 | linkwatcher | Sleep | 25693 | | NULL | | 23705 | linkwatcher | tools-exec-05.pmtpa.wmflabs:60331 | linkwatcher | Sleep | 24630 | | NULL | | 23706 | linkwatcher | tools-exec-05.pmtpa.wmflabs:34778 | linkwatcher | Sleep | 24498 | | NULL | | 23707 | linkwatcher | tools-exec-01.pmtpa.wmflabs:55333 | linkwatcher | Sleep | 21018 | | NULL | | 23708 | linkwatcher | tools-exec-05.pmtpa.wmflabs:53609 | linkwatcher | Sleep | 23514 | | NULL | | 23709 | linkwatcher | tools-exec-01.pmtpa.wmflabs:55701 | linkwatcher | Sleep | 17618 | | NULL | | 23710 | linkwatcher | tools-exec-01.pmtpa.wmflabs:57685 | linkwatcher | Sleep | 17996 | | NULL | | 23711 | coibot | tools-exec-06.pmtpa.wmflabs:33449 | coibot | Sleep | 21134 | | NULL | | 23712 | linkwatcher | tools-exec-06.pmtpa.wmflabs:33457 | linkwatcher | Sleep | 21052 | | NULL | | 23713 | coibot | tools-exec-06.pmtpa.wmflabs:36269 | linkwatcher | Sleep | 20866 | | NULL | | 23714 | root | localhost | NULL | Query | 0 | NULL | show processlist | +-------+-------------+-----------------------------------+-------------+---------+-------+-------+------------------+ On Sat, Sep 7, 2013 at 11:45 AM, Petr Bena <[email protected]> wrote: > Hi, > > It has been several times announced that we deprecated the bots > project and now it is finally time to get rid of most resource > expensive instances, which are the database instaces. > > There are 2 sql servers with hostnames: > > bots-sql2 > bots-bsql01 > > Both of these servers are active and currently being used by a number > of services (bots, including ClueBot). > > Please migrate the databases to tools project ASAP. If you need any > assistance with this, please let me or Coren know. > > I would like to schedule a removal of these servers soon, preferably > in 2 weeks (Tuesday 24, Sep). > > If there is anyone who can't migrate the database until then, please > let me know so that we can postpone this removal. > > So as of now, the both servers are going to be shut down at Monday 16, > Sep and permanently deleted (the contents will be backed up) at > Tuesday 24, Sep. > > If you need more time, no problem, but please let me know :-) > > Thank you _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
