Back up and restore GitLab | GitLab
1 Enter the database console:
For Omnibus GitLab packages: sudo gitlab-rails dbconsole
2 Clear all tokens for projects, groups, and the entire instance: The final UPDATE operation stops the runners from being able to pick up new jobs. You must register new runners.
-- Clear project tokens
UPDATE projects SET runners_token = null, runners_token_encrypted = null;
-- Clear group tokens
UPDATE namespaces SET runners_token = null, runners_token_encrypted = null;
-- Clear instance tokens
UPDATE application_settings SET runners_registration_token_encrypted = null;
UPDATE application_settings SET encrypted_ci_jwt_signing_key = null;
-- Clear runner tokens
UPDATE ci_runners SET token = null, token_encrypted = null;
3 Clear all the tokens for pending jobs:
-- Clear build tokens
UPDATE ci_builds SET token = null, token_encrypted = null;
4 quit