Problem:

After upgrading to 4.9.0, personal access tokens (PATs) are missing and no longer function as expected.

This issue occurs when upgrading to Server 4.9.0 while using using MongoDB 3.6.

Solutions:

• Solution 1

  • Follow the guide in our Server documentation to upgrade MongoDB to at least version 4.4.15
  • Connect to the psql database inside the authenticationservice database and update 

    • % kubectl exec -it postgresql-0 -- bash
      postgres@postgresql-0:/$ psql 
      Password for user postgres: 
      psql (12.16)
      Type "help" for help.
      
      postgres=# \c authenticationservice 
      You are now connected to database "authenticationservice" as user "postgres".
      authenticationservice=# select * from settings;
       id |                    vals                    
      ----+--------------------------------------------
        1 | {"migrating":false,"tokens_migrated":true}
      (1 row)
      
      authenticationservice=# update settings set vals = '{"migrating":false,"tokens_migrated":false}';
      UPDATE 1
      authenticationservice=# select * from settings;
       id |                    vals                    
      ----+--------------------------------------------
        1 | {"migrating":false,"tokens_migrated":true}
      (1 row)
      
      authenticationservice=#

  • Roll the authentication-svc-internalapi deployment

    • kubectl rollout restart deploy -n <circleci-namespace authentication-svc-internalapi

Outcome:

Once the query has been completed to togle the migrating and tokens_migrated values to false and the pod has been restarted, the tokens migrations should complete.

Additional Resources:

• CircleCI Server Operator guide - Upgrade MongoDB

• CircleCI Server 4.9.0 changelog