ISPConfig 3 Job Queue gets stuck

Hi, hoping I can find some help here, I'm trying to delete a database from ISPConfig panel and it has blocked the job queue, and now if I make any other changes (like make/change an FTP account for example), they just get stuck in the queue as well. I'm not sure where to start looking properly but I'm happy to show any logs etc if needed, just say what/where they are :')

Thanks in advance!

 

Thanks for the reply - I changed the log level to debug but then this just gets added as a job to the queue - which is stuck :L After a few minutes nothing extra shows in the System Monitor either.

Also doing the crontab thing gives me this output:
/usr/local/ispconfig/server/server.sh
21.11.2019-13:22 - WARNING - There is already an instance of server.php running with pid 14540.

 

That is the whole output -

 

ISPConfig 3.1.13 - If a server restart would be any benefit then I can do that but I would prefer not to as I have websites running on it and would rather they weren't down.

 

Thanks - new output is this:

21.11.2019-13:46 - WARNING - There is already a lockfile set, but no process running with this pid (14540). Continuing.


21.11.2019-13:46 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
21.11.2019-13:46 - DEBUG - Found 4 changes, starting update process.
21.11.2019-13:46 - DEBUG - Calling function 'db_delete' from plugin 'mysql_clientdb_plugin' raised by event 'database_delete'.
21.11.2019-13:46 - DEBUG - Calling DROP for redacted with access rw and hosts localhost
21.11.2019-13:46 - DEBUG - DROP for user redacted at host localhost


EDIT:
Then it seems to be stuck - it's not finished outputting but no further progress

 

Haven't made any changes that I can think of that would affect it. I may have changed the PHP version a while ago unintentionally and not needed to make any changes on the server since - what version should it be running on?

EDIT: Nevermind - only have PHP7.0 installed on that server

 

It's worked fine for a year or so, only ever having this version of PHP on it, no other additional versions at all.

 

That looks like it's done it! Thank you so much. I've uncommented the cronjob and made another test change and it worked too. Thanks again!

 

This is quite an old thread, but it helped me a lot to solve my issue, and I want to share how to resolve the sync issue between master and slave servers.

I had trouble with the job queue and found a permission issue that doesn't allow updating the server table on the master server from the slave server. It seems to be a bug on 3.2.8p2. I manually updated the table permission and it seemed to be working fine.

Unfortunately, I found another job queue issue on the master server's own services, even though the other services on the slave servers were updating well.

The reason why the master server malfunctioned was that there was no data in the 'sys_datalog' as I deleted them while I was resolving the sync issues. The 'server' table still had numbers that have been updated thus the master server didn't do anything as it believed that the job queue in the 'sys_datalog' had been finished.

Yea, that's it. Please be aware when deleting log data manually. I wasted half a day resolving the issue, and this thread helped me to resolve it.

Thank you.

 

This works!, tnks man