Re: No statistics for remote hosts and SQL error in error.log

[Sebastian Helbig]

Had to reset the database :-/ Seems to work now.

Am 01.09.2014 15:18, schrieb Sebastian Helbig:
> My fault, M/Monit is not using mariadb, it is using postgresql. The
> error is happening with postgresql-9.3.3.
>
> Am 31.08.2014 12:14, schrieb Sebastian Helbig:
> > Hi,
> >
> > I recently installed Monit and M/Monit and everything seems to work
> > fine except I do not see any statistics for remote hosts. In error.log
> > I get this every minute:
> >
> > 2014-08-31 04:09:00 SQLException: ERROR:  insert or update on table
> > "statistics" violates foreign key constraint "statistics_serviceid_fk"
> > DETAIL:  Key (serviceid)=(127) is not present in table "service".
> >  when storing hostid 37 statistics
> >
> > This is with Monit-5.8 and M/Monit-3.2.2 trial on mysql-5.6 
> > (mariadb-10.0.13).
> >
> > --
> > To unsubscribe:
> > https://lists.nongnu.org/mailman/listinfo/monit-general
>
> --
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general