Servers are busy at midnight. Data backup, data synchronization, report building ...... keep the storage system and network busy, and databases may get locked up from time to time..
That's bad to those SharePoint workflows being triggered at night. Sometimes they would simply stop working and throw out errors.
Below is how I resolve this problem in Workflow 2010 and 2013.