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 benapetr@gmail.com 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