Possible Object Filter Bug?

Reply
Highlighted
L2 Linker

Possible Object Filter Bug?

I'm having an issue trying to filter my objects list on one of my panoramas to show only the unused objects.  

Here are the steps I'm following:

BOkay_0-1588881960292.png

If I create a brand new project you can see that my Unused objects are a fraction of the total object count. When the issue I'm experiencing occurs one of the issues it causes is that the project will start to report all objects are unused.

BOkay_1-1588882062168.png

Now when I try to filter unused objects I've tried multiple different criteria.  Just Address, or just Shared vsys, or any other combination I've tried with the same results.  In this example I'm using the following parameters.

BOkay_2-1588882230466.png

When I apply the filter I get the please wait progress bar.  The eventually an error.

BOkay_3-1588882276786.png

BOkay_4-1588882303716.png

While this is filter is processing and after the error the mysql process on the server stays at 100% CPU (This is an 8 CPU server)

BOkay_5-1588882376487.png

 

Now on a side note, on a different Panorama we have that has a slightly smaller rule base, I have let this sit for over an hour, then rebooted the server and it has been hit or miss in getting the correct results. But on this server it is 100% not getting the results.

 

After an hour and a half the mysql process has subsided.

BOkay_6-1588882526935.png

 

When I return to Expedition I get this error when trying to navigate.

BOkay_7-1588882560620.png

I try to restart services and I get this error.

BOkay_8-1588882592219.png

I reboot the server and log back in to Expedition I see that now all objects are considered unused.

BOkay_9-1588882628004.png

And when I go into the objects the filter has still not applied.

 

 

I've tried several times, with brand new projects, and different combination of filters looking for unused objects and the outcome is the same each time. I had the same issue on a different Panorama and it took several attempts before I got it to work, and that seemed to be luck with how long I waited for the process to run and rebooting the service or server.

 

Also a thing to note on the panorama that this did worked on was that it didn't matter if I specified only "address", "address-group", "service", "service-group", "tag", or any combination of them for the unused filter, the results would always filter all of the type of objects even if I specified just one.

 

Just a guess on my part but I think on the back end there may be a flaw in the query that is being run against the mysql database as well as some additional indexing that may need to be added.

 

Other than that, are there any thoughts on how I can go about getting the results I'm looking for of showing only unused objects?

 

 

 

 

 

Highlighted
L3 Networker

Re: Possible Object Filter Bug?

Hi BOKay , 

 

Could you please export your expedition project as zip file and sent it to fwmigrate@paloaltonetworks.com , we can take a look at it.

 

Thank you!

Highlighted
L2 Linker

Re: Possible Object Filter Bug?

Sent. Thank you.

Highlighted
L2 Linker

Re: Possible Object Filter Bug?

Do you have an upload site I can send to? I get the following rejected email.

... Message Size Violation. Size over 50MB or over 256 attachments or zipped attachment inside with over 256 files.

Highlighted
L3 Networker

Re: Possible Object Filter Bug?

Hi BOkay, 

Let’s continue the communication via email , we can provide a way for you to sent the project . 
Thank you ! 

Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the Live Community as a whole!

The Live Community thanks you for your participation!