Epgd eine Frage

  • Hallo,


    wenn ich epgd-tool -show-stats aufrufe, sehe ich viele alte, oder Verbindungen die "gecrashed" sind kann.


    root@epg:~# epgd-tool -show-stats

    +--------------------------------------------------+-------+--------+--------------+----------+-----------------------------+----------------------------+----------------------------+

    | version | dbapi | master | ip | state | last touch | last download | next download |

    +--------------------------------------------------+-------+--------+--------------+----------+-----------------------------+----------------------------+----------------------------+

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | crashed | 26th February 2019 18:49:59 | NULL | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.65 | crashed | 6th June 2019 14:19:48 | 4th May 2019 00:13:22 | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.60 | crashed | 9th March 2019 23:43:51 | 8th March 2019 22:29:40 | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | crashed | 1st May 2019 20:17:19 | NULL | NULL |

    | vdr 2.4.1 epg2vdr 1.1.106-GIT (23.12.2019) | 7 | n | 10.10.1.60 | crashed | 29th January 2020 22:23:05 | 29th January 2020 19:23:40 | NULL |

    | vdr 2.4.1 epg2vdr 1.1.106-GIT (23.12.2019) | 7 | n | 10.10.1.65 | crashed | 20th October 2019 19:17:19 | 20th October 2019 17:05:02 | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | crashed | 10th March 2019 21:05:20 | NULL | NULL |

    | vdr 2.4.1 epg2vdr 1.1.106-GIT (23.12.2019) | 7 | n | 10.10.1.63 | attached | 30th January 2020 19:09:42 | 30th January 2020 13:24:17 | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.60 | crashed | 10th March 2019 18:47:58 | NULL | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | crashed | 10th March 2019 21:05:05 | NULL | NULL |

    | vdr 2.4.1 epg2vdr 1.1.106-GIT (23.12.2019) | 7 | n | 10.10.1.62 | attached | 30th January 2020 19:09:42 | 28th January 2020 22:12:08 | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | detached | 10th March 2019 18:38:58 | NULL | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | crashed | 10th March 2019 19:58:19 | NULL | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.62 | crashed | 12th March 2019 19:17:13 | NULL | NULL |

    | vdr 2.4.1 epg2vdr 1.1.106-GIT (23.12.2019) | 7 | Y | 0.0.0.0 | attached | 30th January 2020 19:09:19 | 29th January 2020 19:25:26 | NULL |

    | vdr 2.4.1 epg2vdr 1.1.106-GIT (23.12.2019) | 7 | n | 10.10.1.61 | crashed | 30th January 2020 17:33:47 | 3rd December 2019 13:34:13 | NULL |

    | vdr 2.4.0 epg2vdr 1.1.98-GIT77af073 (15.10.2018) | 7 | n | 10.10.1.64 | crashed | 10th March 2019 17:56:53 | 10th March 2019 17:41:46 | NULL |

    | epgd 1.1.150-GIT (28.01.2020) | 7 | - | 192.168.1.50 | standby | 30th January 2020 19:08:39 | 30th January 2020 13:24:30 | 31st January 2020 07:24:30 |

    +--------------------------------------------------+-------+--------+--------------+----------+-----------------------------+----------------------------+----------------------------+

    root@epg:~#


    Kann man das aufräumen, das alte und kaputte Verbindungen beendet werden ?


    Danke

    speed

  • Ich würde sagen:

    sudo su

    mysql

    use epg2vdr;

    delete from vdrs where state like 'crashed';


    Analog auch für "detached" und version like '2.4.0'

    exit

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!