On 16 October 2014 17:53, Daan Hoogland <daan.hoogl...@gmail.com> wrote:

> On Thu, Oct 16, 2014 at 5:33 PM, Marc Leeman <marc.lee...@gmail.com>
> wrote:
>
> > Is there some inconsistency in the database?
> >
> This might well be. To check this look at mshost and mshost_peer.
>
> Are you upgrading? Is this a test setup?
>
>
>
It is my first setup :-)

 mysql> select * from mshost_peer;
+----+--------------+-------------+---------------+------------+---------------------+
| id | owner_mshost | peer_mshost | peer_runid    | peer_state |
last_update         |
+----+--------------+-------------+---------------+------------+---------------------+
|  1 |            1 |           1 | 1413300325989 | Up         | 2014-10-14
15:25:55 |
|  2 |            2 |           2 | 1413301475290 | Up         | 2014-10-14
15:44:48 |
| 16 |            3 |           3 | 1413473252587 | Up         | 2014-10-16
15:27:45 |
+----+--------------+-------------+---------------+------------+---------------------+
3 rows in set (0.00 sec)

mysql> select * from mshost;
+----+-----------------+---------------+------+-------+---------+------------+--------------+---------------------+---------+-------------+
| id | msid            | runid         | name | state | version |
service_ip | service_port | last_update         | removed | alert_count |
+----+-----------------+---------------+------+-------+---------+------------+--------------+---------------------+---------+-------------+
|  1 | 172136268721636 | 1413300325989 | zee  | Up    | 4.3.1   |
172.16.8.7 |         9090 | 2014-10-14 15:41:40 | NULL    |           0 |
|  2 |  72986426470976 | 1413301475290 | zee  | Up    | 4.3.1   |
172.16.8.7 |         9090 | 2014-10-14 16:18:24 | NULL    |           0 |
|  3 | 279278805451256 | 1413473252587 | zee  | Up    | 4.3.1   |
172.16.8.7 |         9090 | 2014-10-17 08:37:41 | NULL    |           0 |
+----+-----------------+---------------+------+-------+---------+------------+--------------+---------------------+---------+-------------+
3 rows in set (0.00 sec)

Reply via email to