> On Jul 2, 2015, at 9:51 AM, Daisuke HIGASHI <[email protected]> wrote:
>
> Hi,
>
> Some NTP servers in *.pool.ntp.org are still announcing wrong LI bits. Rough
> sampling:
Yeah, about 100 left which is just barely more than the number of servers that
missed announcing the leap second on the 30th.
The counts below include servers that weren’t included in the pool because of a
too low score.
Ask
mysql> select date(ts) d, count(distinct(server_id)) servers from log_scores
where ts > '2015-06-29 19:00' and attributes is not null and attributes =
'{"leap":1}' group by d order by d;
+------------+---------+
| d | servers |
+------------+---------+
| 2015-06-29 | 56 |
| 2015-06-30 | 3780 |
| 2015-07-01 | 584 |
| 2015-07-02 | 143 |
| 2015-07-03 | 125 |
+------------+---------+
5 rows in set (20.08 sec)
mysql> select date(ts) d, hour(ts) h, count(distinct(server_id)) servers from
log_scores where ts > '2015-06-29 19:00' and attributes is not null and
attributes = '{"leap":1}' group by d,h order by d,h;
+------------+------+---------+
| d | h | servers |
+------------+------+---------+
| 2015-06-29 | 19 | 40 |
| 2015-06-29 | 20 | 44 |
| 2015-06-29 | 21 | 37 |
| 2015-06-29 | 22 | 41 |
| 2015-06-29 | 23 | 39 |
| 2015-06-30 | 0 | 2355 |
| 2015-06-30 | 1 | 2946 |
| 2015-06-30 | 2 | 3062 |
| 2015-06-30 | 3 | 3118 |
| 2015-06-30 | 4 | 3140 |
| 2015-06-30 | 5 | 3156 |
| 2015-06-30 | 6 | 3173 |
| 2015-06-30 | 7 | 3182 |
| 2015-06-30 | 8 | 3192 |
| 2015-06-30 | 9 | 3199 |
| 2015-06-30 | 10 | 3203 |
| 2015-06-30 | 11 | 3222 |
| 2015-06-30 | 12 | 3248 |
| 2015-06-30 | 13 | 3263 |
| 2015-06-30 | 14 | 3307 |
| 2015-06-30 | 15 | 3319 |
| 2015-06-30 | 16 | 3334 |
| 2015-06-30 | 17 | 3346 |
| 2015-06-30 | 18 | 3398 |
| 2015-06-30 | 19 | 3414 |
| 2015-06-30 | 20 | 3434 |
| 2015-06-30 | 21 | 3431 |
| 2015-06-30 | 22 | 3428 |
| 2015-06-30 | 23 | 3711 |
| 2015-07-01 | 0 | 569 |
| 2015-07-01 | 1 | 243 |
| 2015-07-01 | 2 | 206 |
| 2015-07-01 | 3 | 179 |
| 2015-07-01 | 4 | 158 |
| 2015-07-01 | 5 | 145 |
| 2015-07-01 | 6 | 136 |
| 2015-07-01 | 7 | 142 |
| 2015-07-01 | 8 | 140 |
| 2015-07-01 | 9 | 141 |
| 2015-07-01 | 10 | 135 |
| 2015-07-01 | 11 | 141 |
| 2015-07-01 | 12 | 135 |
| 2015-07-01 | 13 | 131 |
| 2015-07-01 | 14 | 134 |
| 2015-07-01 | 15 | 123 |
| 2015-07-01 | 16 | 127 |
| 2015-07-01 | 17 | 129 |
| 2015-07-01 | 18 | 129 |
| 2015-07-01 | 19 | 126 |
| 2015-07-01 | 20 | 124 |
| 2015-07-01 | 21 | 125 |
| 2015-07-01 | 22 | 129 |
| 2015-07-01 | 23 | 131 |
| 2015-07-02 | 0 | 128 |
| 2015-07-02 | 1 | 131 |
| 2015-07-02 | 2 | 128 |
| 2015-07-02 | 3 | 123 |
| 2015-07-02 | 4 | 124 |
| 2015-07-02 | 5 | 125 |
| 2015-07-02 | 6 | 122 |
| 2015-07-02 | 7 | 126 |
| 2015-07-02 | 8 | 125 |
| 2015-07-02 | 9 | 126 |
| 2015-07-02 | 10 | 120 |
| 2015-07-02 | 11 | 122 |
| 2015-07-02 | 12 | 124 |
| 2015-07-02 | 13 | 127 |
| 2015-07-02 | 14 | 129 |
| 2015-07-02 | 15 | 121 |
| 2015-07-02 | 16 | 122 |
| 2015-07-02 | 17 | 115 |
| 2015-07-02 | 18 | 121 |
| 2015-07-02 | 19 | 114 |
| 2015-07-02 | 20 | 115 |
| 2015-07-02 | 21 | 119 |
| 2015-07-02 | 22 | 119 |
| 2015-07-02 | 23 | 112 |
| 2015-07-03 | 0 | 113 |
| 2015-07-03 | 1 | 113 |
| 2015-07-03 | 2 | 115 |
| 2015-07-03 | 3 | 109 |
| 2015-07-03 | 4 | 114 |
| 2015-07-03 | 5 | 107 |
+------------+------+---------+
83 rows in set (20.36 sec)
_______________________________________________
pool mailing list
[email protected]
http://lists.ntp.org/listinfo/pool
