search

SophistSolutions / WhyTheFuckIsMyNetworkSoSlow

WhyTheFuckIsMyNetworkSoSlow is a network performance analysis tool, making it easy to quickly examine a network and see what is wrong, and to evaluate longer term trends.
15 stars 1 forks source link

SQLLite BUSY exceptions #35

Closed LewisPringle closed 1 year ago

LewisPringle commented 2 years ago

AND STILL GETETING (esp with debug build)

8 23:43:59 Hercules systemd[1]: Started Why the Fuck is My Network So Slow. Jul 28 23:53:07 Hercules WhyTheFuckIsMyNetworkSoSlow[2106023]: Database operation exception: Exception: Device or resource busy (lastsql 'UPDATE Devices SET name='192.168.244.183', _otherfields=x'7b0a202020202261747461636865644e6574776…') Jul 28 23:53:07 Hercules WhyTheFuckIsMyNetworkSoSlow[2106023]: Database update: ignoring exception in BackgroundDatabaseThread_ loop (will retry in 30 seconds): Exception: Device or resource busy Jul 28 23:53:37 Hercules WhyTheFuckIsMyNetworkSoSlow[2106023]: Database operation exception: Exception: Device or resource busy (lastsql 'UPDAT

rare - but once it starts, it goes on indefnitely (on raspi, but on hercules, happens once and stops).

LewisPringle commented 2 years ago

Still get this - even in release builds - but only on raspberrypi.

LewisPringle commented 2 years ago

haven't been able to reproduce this in a while.

LewisPringle commented 2 years ago

haven't seen in a long time, and reason to think resolved (and not too serious if rare anyhow) - so mark closed

LewisPringle commented 1 year ago

Still happens as (on linux/hercules) as of 2022-09-07.

LewisPringle commented 1 year ago

Basically resolved. Just upped timeout to 2.5 seconds which is enough on raspberrypi for the most part. And recorvers if ever times out so should be fine. Added more comments to the code to cover this issue.