You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We need to repeat the what we did in #4657 on a semi-annual schedule to reduce the size of BEAKER_CACHE table in catalog app.
Steps:
Enable space SSH for prod space
connect to catalog-db (need Service Connect CF plugin installed.
cf connect-to-service catalog-admin catalog-db
Run query
DELETE FROM beaker_cache WHERE created < CURRENT_TIMESTAMP - INTERVAL '2 day';
This query will take a few mins to complete. If the connection is disconnected due to catalog-admin gets restarted, the query will continue on its own. You can verify it when you see the oldest CREATED is a two days ago instead of 6 months ago by query
SELECT CREATED FROM beaker_cache ORDER BY id LIMIT 1;
SELECT COUNT(*) FROM beaker_cache;
Set the milestone to next 6 month and put the ticket back to icebox,
The text was updated successfully, but these errors were encountered:
We need to repeat the what we did in #4657 on a semi-annual schedule to reduce the size of BEAKER_CACHE table in catalog app.
Steps:
This query will take a few mins to complete. If the connection is disconnected due to catalog-admin gets restarted, the query will continue on its own. You can verify it when you see the oldest CREATED is a two days ago instead of 6 months ago by query
The text was updated successfully, but these errors were encountered: