The regenerator is considered “hung” when:
It reports that it is executing SQL for a PDT build or trigger check, and that SQL is not executing on the database.
The regenerator process has not begun after the previous regenerator process has completed within the timeframe dictated by the PDT And Datagroup Maintenance Schedule connection setting.
Why do hung regenerators occur?
The source of a hung regenerator can be difficult to track down, as it typically involves the network or database side of the process interrupting PDT regeneration. We have seen a number of reports of hung regenerators coinciding with Redshift database maintenance, including a mass maintenance that Redshift performed. Make sure to confirm this is not the case before moving forward with troubleshooting.
You can use the workflow outlined below to confirm whether the PDT regenerator is hung.
Workflow for determining whether the PDT regenerator is hung
Please open a support request with the Department of Customer Love if you need assistance determining whether the regenerator is hung, or to request an instance restart to resume regenerator activity.