Mysql wont shut down

Hi,

I had the issues described in below thread:

So i deleted the ~200 devices in this state with command:
DELETE FROM devices WHERE device_id=xxx;

Now when i reboot the server it hangs in shutting down MySQL.
Tried waiting 10 minutes but no luck.

The installation was done following Installing LibreNMS - LibreNMS Docs

Any suggestions to fix this would be apricated.

/Peter

There are other ways to kill a unresponsive application.

  1. Search for the app

ps -aux | grep application_name

  1. Find the PID number and kill the app with

sudo -9 kill PID

Google is your friend.

Yes that of course works.

But its not a solution to the actual issue.
Every time i reboot the server it hangs for ever until i manually kill it

/Peter

Did you also try to stop your poller first?

How would i do that ? the only service i see related to librenms is php7.4-fpm.

Stopping that and then mysql changes nothing:
service php7.4-fpm stop
service mysql stop

It just hangs on mysql stop.

/Peter

Are you running the dispatcher service or the cron based poller?
I had the same problems once. I always have to stop my cron based poller
in the /etc/cron.d/librenms file that i can safely shutdown the server. (i just comment the lines out in that file) I dunno if this would help in your case/scenery

Yes i see the cron jobs.

Doubt it will help me.

There seem to be some kind of deadlock in the database after i had the issue:

Guess i will just reinstall and not mess around with auto discovery that got me in this situation.

/Peter

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.