Page 1 of 1

HSNM Version 8.0.278 Stable Database Log error

Posted: 11 Oct 2021, 06:21
by Magenta
Dear Team,

Have a good Day.
We received this error always in our Log.
Please see attachment for your reference.

2021-10-11 08:02:55 - host
Error! Query error: Lost connection to MySQL server during query (2013) Query: SELECT SUM(acctsessiontime) / COUNT(*) / 60, CAST(acctstarttime AS DATE) AS StartDate FROM radacct WHERE radacct.acctstarttime >= '2021-09-12' AND radacct.acctstarttime < '2021-10-12' GROUP BY StartDate ORDER BY StartDate (::dashboards::functions::MainChart ::db->query)


Thanks,

Magenta

Re: HSNM Version 8.0.278 Stable Database Log error

Posted: 11 Oct 2021, 10:37
by HSNMSupport
Dear Magenta,
can you please share with us the steps to reproduce this error?
Thank you.

Re: HSNM Version 8.0.278 Stable Database Log error

Posted: 13 Oct 2021, 07:37
by Magenta
Dear Magenta,
can you please share with us the steps to reproduce this error?
Thank you.

Dear Team,

That error we see in the log only we dont know where we get that error.. as we see only in the systems logs.

Re: HSNM Version 8.0.278 Stable Database Log error

Posted: 26 Oct 2021, 09:06
by HSNMSupport
Dear Magenta,
this could happen in case of an aborted query during the dashboard calculation.
This could happen when a backend operator closes a dashboard prior to calculation operation ends.
Have a good day.