search

jenkins-infra / helpdesk

Open your Infrastructure related issues here for the Jenkins project
https://github.com/jenkins-infra/helpdesk/issues/new/choose
17 stars 10 forks source link

SQL queries to run on Plugin Health Scoring database #3356

Closed alecharp closed 1 year ago

alecharp commented 1 year ago

While investigating https://github.com/jenkins-infra/plugin-health-scoring/issues/175, I might have found the culprit.

However, in order to get out of the current situation, we might still need to clear the table of scores and reset the sequence for its id generation.

To do so, could you please run the following SQL commands on the database of the projects?

DELETE FROM scores;
ALTER SEQUENCE "scores_seq" RESTART;

Thanks in advance.

github-actions[bot] commented 1 year ago

Take a look at these similar issues to see if there isn't already a response to your problem:

  1. 71% #3353
lemeurherve commented 1 year ago

Done.