View Incident Report

Serious

Reported By: Steve Gill
Reported On: 7/30/2009
For: Version 2.02 Build 15

# 3051 Scheduling a Job for the Last Day of a Month Can Cause the ElevateDB Server to Crash

After working solidly for weeks, EDB Server suddenly started crashing today. I couldn't keep it running for longer than a couple of minutes before it would crash again. This occurred 9 times in a row before I gave up. I eventually tracked it down to a Job I created today. The job only runs once per month on the last Sunday. Once I deleted the job the server crashes stopped happening.

CREATE JOB "AutomaticOptimization"
RUN AS "System"
FROM DATE '2009-01-01' TO DATE '2999-01-01'
MONTHLY
ON LAST SUN OF JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
BETWEEN TIME '01:00' AND TIME '01:30'
CATEGORY ''
BEGIN       
  USE MyDatabase;
  CALL OptimizeDatabase;
  USE;
END

Comments

The job scheduling code was encountering an unexpected error and causing the exception to leave the current job thread, thus crashing the server.

Resolution

Fixed Problem on 8/3/2009 in version 2.03 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap