Unable to Remove Unused Objects process get stuck

[INgueyon]

Since i upgrade to version 1.2.96 i'm unable to remove unused objects the request get stuck ultil it times out, i performed several downgrade and some update without success

[INgueyon]

i found this link but it does help me at all

Solved: LIVEcommunity - Re: Stuck Processing Calculate Unused Objects (88% completed) - LIVEcommunit...

[dpuigdomenec]

Hi @INgueyon 

Could you confirm that the Task Agent is up and running? Could you check for some error at the log /home/userSpace/panReadOrders.log

Thanks,

David

[INgueyon]

Hi, i found some error let me put it bellow 

------------------------------------------------------------
Mon Oct 28 15:13:17 UTC 2024 : Restarting readOrders.php
------------------------------------------------------------
------------------------------------------------------------
Mon Oct 28 15:13:17 UTC 2024 : Starting readOrders.php
------------------------------------------------------------

Fatal error: Uncaught ErrorException: stream_socket_client(): unable to connect to tcp://localhost:5672 (Connection refused) in /var/www/html/libs/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Wire/IO/StreamIO.php:155
Stack trace:
#0 /var/www/html/libs/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Wire/IO/StreamIO.php(157): PhpAmqpLib\Wire\IO\StreamIO->cleanup_error_handler()
#1 /var/www/html/libs/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(208): PhpAmqpLib\Wire\IO\StreamIO->connect()
#2 /var/www/html/libs/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AbstractConnection.php(192): PhpAmqpLib\Connection\AbstractConnection->connect()
#3 /var/www/html/libs/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Connection/AMQPStreamConnection.php(60): PhpAmqpLib\Connection\AbstractConnection->__construct('guest', 'guest', '/', false, 'AMQPLAIN', NULL, 'en_US', Object(PhpAmqpLib\Wire\IO\StreamIO), 0, 3)
#4 /var/www/html/libs/PaloAltoNetworks/AmqpWrapper/SimpleReceiver.php(39): PhpAmqpLib\Connection\AMQPStreamC in /var/www/html/libs/vendor/php-amqplib/php-amqplib/PhpAmqpLib/Wire/IO/StreamIO.php on line 155
------------------------------------------------------------
Mon Oct 28 16:19:49 UTC 2024 : Starting readOrders.php
------------------------------------------------------------
Checking: RemoveUnusedObjects
Checking: CalculateUnusedObjects
Checking: AbstractProcess
Mon, 28 Oct 2024 16:19:49 +0000 Start Task
{"project":"MIGRFWCAEN","source":"1","vsys":"all","taskId":2582,"key":"EuDGXfBgCh+43QPMaWrXCEJKCe7iK1+qztkqpszUEAJLKN3QSMpWx2VUI\/Xdu3cTJBflBHuUpw6TYNloTz3YEA==","userId":1,"sender":1,"loggable":false,"logPath":""}
Action: Remove Unused Objects
User: admin
Project: MIGRFWCAEN
Source: 1
Mon, 28 Oct 2024 16:19:50 +0000 End Task

[INgueyon]

root@expedition:/home/userSpace# sudo service rabbitmq-server status
? rabbitmq-server.service - RabbitMQ Messaging Server
Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2024-10-28 16:15:56 UTC; 15h ago
Main PID: 210754 (beam.smp)
Status: "Initialized"
Tasks: 87 (limit: 9406)
Memory: 71.0M
CGroup: /system.slice/rabbitmq-server.service
+-210741 /bin/sh /usr/sbin/rabbitmq-server
+-210754 /usr/lib/erlang/erts-10.6.4/bin/beam.smp -W w -A 64 -MBas ageffcbf -MHas ageffcbf -MBlmbcs 512 -MHlmbcs 512 -MMmcs 30 -P 1048576 -t 5000000 -stbt db -zdbbl 128000 -K true -- -root /usr/>
+-211045 erl_child_setup 65536
+-211072 inet_gethost 4
+-211073 inet_gethost 4

Oct 28 16:15:53 expedition systemd[1]: Starting RabbitMQ Messaging Server...
Oct 28 16:15:56 expedition systemd[1]: rabbitmq-server.service: Supervising process 210754 which is not our child. We'll most likely not notice when it exits.
Oct 28 16:15:56 expedition systemd[1]: Started RabbitMQ Messaging Server.

[INgueyon · Accepted solution]

I try the process on the link below yesterday and it seems ok this morning, i will run some tests and let you know if it's all good. Thank's for your help so far

LIVEcommunity - RabbitMQ not properly starting (failing) - LIVEcommunity - 322729 (paloaltonetworks....

[dpuigdomenec]

Hi @INgueyon thanks for the update. I guess the issue was with the rabbitmq-server and the Task Manager services. 

Let us know if you have any other issue,

Best regards,

David