Comments (8)
chlins
commented on May 25, 2024
1
If you don't need to keep the scan status or report for the artifacts, you can manually delete these records. Even after deletion, you can still re-trigger the image scan to re-analyze vulnerabilities for the artifacts.
from harbor.
Kot-o-pes
commented on May 25, 2024
+ 1
from harbor.
ktkd
commented on May 25, 2024
from harbor.
MrShadow74
commented on May 25, 2024
from harbor.
chlins
commented on May 25, 2024
@wieldes Hi, could you try to execute the above same SQLs on the task table?
from harbor.
wieldes
commented on May 25, 2024
@wieldes Hi, could you try to execute the above same SQLs on the task table?
registry=# SELECT COUNT(1) FROM execution WHERE vendor_type = 'EXECUTION_SWEEP';
count
-------
512
(1 row)
registry=# SELECT COUNT(1) FROM task WHERE vendor_type = 'EXECUTION_SWEEP';
count
-------
128
(1 row)
registry=# SELECT COUNT(1) FROM execution WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Error';
count
-------
380
(1 row)
registry=# SELECT COUNT(1) FROM task WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Error';
count
-------
1
(1 row)
registry=# SELECT COUNT(1) FROM execution WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Stopped';
count
-------
105
(1 row)
registry=# SELECT COUNT(1) FROM task WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Stopped';
count
-------
102
(1 row)
registry=# SELECT COUNT(1) FROM execution WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Success';
count
-------
2
(1 row)
registry=# SELECT COUNT(1) FROM task WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Success';
count
-------
0
(1 row)
registry=# SELECT COUNT(1) FROM execution WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Running';
count
-------
25
(1 row)
registry=# SELECT COUNT(1) FROM task WHERE vendor_type = 'EXECUTION_SWEEP' AND status = 'Running';
count
-------
0
(1 row)
from harbor.
chlins
commented on May 25, 2024
I noticed that sweep IMAGE_SCAN executions took long time which caused the high latency for the EXECUTION_SWEEP job.
2024-04-09T22:29:54Z [INFO] [/pkg/task/sweep_job.go:150]: [IMAGE_SCAN] start to sweep, retain latest 1 executions
2024-04-10T00:54:09Z [INFO] [/pkg/task/sweep_job.go:180]: [IMAGE_SCAN] end to sweep, 0 executions were deleted in total, elapsed time: 2h24m14.915320345s
Could you also try to check the size of the of IMAGE_SCAN vendor type includes execution and task table?
from harbor.
wieldes
commented on May 25, 2024
registry=# SELECT COUNT(1) FROM execution WHERE vendor_type = 'IMAGE_SCAN';
count
---------
2617000
(1 row)
registry=# SELECT COUNT(1) FROM task WHERE vendor_type = 'IMAGE_SCAN';
count
---------
2617126
(1 row)
A lot of records for IMAGE_SCAN....
Some time ago we disabled the automatic image scan.
Will it be safe to remove IMAGE_SCAN records from task and execution tables?
from harbor.
Related Issues (20)
- the UI_UT of CI failed
- sbom_overview still get sbom_digest when this sbom artifact do not exist in this repository
- v2.11.0-rc1 prepare file docker tag error promble HOT 1
- Not able to pull 'helm chart' from Harbor HOT 2
- Image retention policy 'dry run' ignores image with immutable rules
- harbor installation: network between harbor dockers is not connected
- The `SBOM` column having `SBOM.COMPLETED, ` when SBOM generation completed.
- Bump up beego
- request: extend robot permissions to update individual project quotas
- missing docker images: http status code: 404 HOT 1
- Pushing any container image results in HTTP 500 HOT 6
- REST Api contains repo_name returns NOT_FOUND HOT 2
- SBOM column showing `Not Generated` and SBOM download link not working
- How to limit Trivy space, trivy grow without control HOT 1
- Issue during push "client disconnected during blob PATCH" HOT 4
- Replication and Registry created not visible in UI HOT 3
- Harbor with s3 aws HOT 2
- Cannot delete webhook that has executions
- Clear Text Password HOT 1
- Can the container names generated by the build script be prefixed with harbor
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from harbor.