[Pool] Leap Indicator bits

Ask Bjørn Hansen ask at ntppool.org
Fri Jul 3 05:38:10 UTC 2015


> On Jul 2, 2015, at 9:51 AM, Daisuke HIGASHI <daisuke.higashi at gmail.com> 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)


More information about the pool mailing list