A stored procedure statements and functions, often will automatically hang dead for no apparent reason, should how to analysis the problem

CodePudding user response:

Check the stored procedure, at the time of execution, if there is abnormal, this could lead to a broken

CodePudding user response:

But running is normal, not regular failure, how to read the newspaper wrong, have related log

CodePudding user response:

When you are debugging, may be normal, but might not be functioning properly in the evening,

A simple scene:

With one of your statements to the current time, and you took hours, now running is 16, run at 1 PM, may be the space + 1, might have a logic problem;

CodePudding user response:

See if there's a clue in the ALERT log file