Open NehaSharma02 opened 6 years ago
@BadalZ Can you please look into it ASAP ? There has been consistent complains from the members related to it to stability of Autopilot.
cc @ajefts
Started looking into the issue.
hi @NehaSharma02 / @RiteshTC : On dev environment I am not able to reproduce this scenario. Can you share me some project id / challenge id for which you received complain so I can go and check into database for more investigation?
@BadalZ Please find the Ids for challenges which had a delayed launch. https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30066534 https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30066535 https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30066536
cc : @cwdcwd
Hi Team, There has been Database table lock happening on 'Project' table which is causing some problem. I have reported / shared info with Tony as well.
Here is a sample of the error from AutoPilot
Challenge phases are not opening on scheduled time. Please check and fix the issue.
https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30071776 https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30070713
@cwdcwd @ajefts
@coderReview - Will you be able to check this?
@coderReview anyone working on this ?
FYI, this issue is reproducible on Dev server as well.
@dushyantb ☝️
More challenges that didn't start automatically, had to open both registration and submission phases manually:
https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30086178 https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30086179
@coderReview we need to get accelerated in fixing this
A scheduled challenge launch is delaying by an hour from the last couple of weeks and it automatically launches after an hour.
@ajefts @BadalZ