fleet icon indicating copy to clipboard operation
fleet copied to clipboard

Published 20 hours ago • verified publisher icon fleetdm

Improve database performance of vulnerability processing job

Open juan-fdz-hawa opened this issue 2 years ago • 9 comments

Logic used for ingesting software is not handling duplicated software on host

This usually happens when ingesting Python/Ruby/etc packages. If we have the same package installed more than once on different envs - for example the six 1.15.0 - we only store a single row in the software table for that package, because of this, every time we are ingesting software, the ingestion logic will incorrectly determine that there are new software on the host, thus triggering a DB sync - which is not ideal from a performance point of view.

juan-fdz-hawa avatar May 24 '23 19:05 juan-fdz-hawa

@zayhanlon This bug has aged out and is moving back to product drafting.

lukeheath avatar Jun 13 '23 17:06 lukeheath

@zhumo Reminder that when moving an item out of product drafting, remember to remove the :product label so it is removed from the product board.

lukeheath avatar Jun 26 '23 15:06 lukeheath

@lukeheath That's for bugs only, right? All bugs should go through the bug board instead of the drafting board, except when it is in drafting by product?

zhumo avatar Jun 26 '23 18:06 zhumo

@zhumo Yes, this only applies to bugs that return to product drafting, and then come back to engineering.

lukeheath avatar Jun 26 '23 18:06 lukeheath

This bug has aged out. Moving back to drafting.

lukeheath avatar Aug 01 '23 22:08 lukeheath

Bug has aged out. Moved back to drafting

ireedy avatar Sep 05 '23 14:09 ireedy

Bug has aged out. Moved back to drafting

ireedy avatar Oct 02 '23 23:10 ireedy

Bug has aged out. Moving back to product drafting.

lukeheath avatar Oct 26 '23 20:10 lukeheath

Hey @ksatter, I pulled this engineering initiated story off the feature fest board.

Eng initiated stories don't need to go through feature fest. Check out the process here.

FYI @lukeheath

noahtalerman avatar May 09 '24 17:05 noahtalerman

@sharon-fdm I'm removing the bug label. We decided this is not a bug back in 2023, so it's been sitting and not been triaged as a bug. This was triaged, instead, as an engineering-initiated story. I'm removing the bug label because it's a very old story (which is okay) but not a very old bug (which is not okay).

lukeheath avatar May 24 '24 21:05 lukeheath

Hey @zayhanlon, this customer request has shipped.

marko-lisica avatar Jun 13 '24 15:06 marko-lisica

Ingestion logic tweaked, Swift as a cloud city's breeze. No more dupes, more peace.

fleet-release avatar Jun 13 '24 15:06 fleet-release