VMS Catastrophic Database Errors?

Fairly regularly I hear stories about VMS database errors (across a variety of vendors). Does anyone have personal experiences?

I am a little confused about why this would happen (or at least why it seems to happen as often as it appears to be). Relational database management systems are basically a solved problem and have been so for years. While most every web applications use a database (Postgres, MySQL, SQLite, etc.), the instances of catastrophic database failures are few and far between. The same thing with DVRs, hard drives fail, power supplies fail, etc. but database issues?

Anyone with experiences or insights to share here?

Login to read this IPVM discussion.
Why do I need to log in?
IPVM conducts unique testing and research funded by member's payments enabling us to offer the most independent, accurate and in-depth information.

* *** *** *** ********* ******** ** ***** *******, ******* due ** * ***** **** ** **** *** ***** ****, or * ******* **** *****... *** **** ** ****** ***'* expect ** ***** ******** ******.

**'* * ********, *** * ******'* **** ** "************", ** just ***** *** ***** ***'* ********** (****** ** ***** ********* the ***** ****, **** *** ******** *** ****** ********), *** most ***** **'* ****** ****** ** ******* *** ******** ******* utility (******* ******** **** *** ** ***** ***** ** ********, depending ** *** ****** ** *****). ***** ****, ** ***** running * ****** ** ********** **** *** **-****** *** ********, followed ** *** ******* *******.

*** ********** ******* ****** *** * *********** ******** ******, *** certain ** *** *********, *** ***** *** * ******* **** them ****** **** ****** **** **** **** ***** ****'* ****** memory ********, ***** ****** **** ****** ********* ***** ******* *** index ****'* **** ****** ******, *** **** *** ***** **** a ****** ****** ******* *** * ******.

***'* ***** * **** **** ****** ** ******* ***** ***** would ** **** *********, *** * ******** ***** *** *** then **** ** *** ***** ***** ***** ** *** ********* Micros *******.

******* * **** *** *** **** ******** "************" ** * long ****.

John, **** ** * **** ********* *****. * **** ******** ******* * ****** ***** ** *** ******** ********** ********* ********.

*** ****** ** **** *********** **** * ******* ******* **** year.*** ****** *** ** ** *** *****-*** ****, *** *** server *** ******* *** ********** ******** *** ** ******* ** orderly ******** ** *** ******. *******, *** ******* ***** *** a ******** ********* *** (***** ****** * ******* ******) *** was *** *** *** ******* ********.

**** *** ***** **** ******** *** * **** ******* **** (hard ****** *** **** * *** ** *****), *** ******* array **** **** **** **** ********* **** **********.

****** *** ******* ****, *** **********'* **** **** **** ***** wasn't * *** ** **** **** *** ******* *****. "** contacted *** ****** *** *** ***'* ** **." * ********* the **** ******, *** **** ** ***** *********** **** ** how ** ** **. **'* * *-****** ************* ******. **** have *****-** ******* *** **** ********** ***.

*** ********** *** ** ****** ***** ******** *** ** ***** deficiencies ** *** ***, *** ** *** *** ********** **** take **** ** **.

** ******* **** **** ****, **** * ******* ******,** ******** ****** (********* ******) ***** ****** *** *** ***** database *** *********, *** **** ** *** ***** ***** *** be *****. ****, *** ***** *** ***** ** *** *****, in * ****** ********* ** ****, ***** *** ***, **** files **** **** *** ********* ** *** ********. ******* *** a ******* **** ***** ***** "********" ***** ***** *** ****** them **** **** *** ********.

* **** ** ******* *** ******* **** ***** *** ***** data ** ******** ***** ******* ** *** ********/******/***** *********** ********.

From ***** ********** ** ****, *'* *** **** "***** **** **** ** ****** *****" *** "**** ***** ****" *** *** *** ******* ****** ** ******** **********. But an experienced integrator can usually recover the data for a VMS system with a well-designed database and video file structure.

There ** ** ****** *** ****** ***** *** ** ***** *******. If it is important enough to record and retain the video for some period of time, its important enough to spend $900 or so on a good UPS.

COMPLEX ******* *******

*** ** *** **** * ***** ***, ** * ******* storage *****, *** **** ** **** **** **** *** *** elements **** ******* ** ******* ******** *** ******* ******* ** the ***** ********. **** ******* **** ******* *** ** ******** the ***********, **** *** ****** (***** *** **** * *** minutes), **** *** ********* ******, **** *** ******* ***** ** Video ***. ******* ** ******* ** *** ******* *****--*** *** have ** **** ******* ********* ******* ***** *** ******* ******** different **** *** ******** *****. ** ** ******* * **** array *** ** ******* **** *** **** **** *** ******* startup ***** * ***, *** *** *** ***** ***** ** another ******* ** *******, *** ** ** ****** * ****-******* one.

*** **** ** **** **** **** *** *** *** *** software ** **** **** ** *** ***** ***** *** **** plenty ** **** **** *** *** ******** *******. *** **** to **** *** ***** *** ******** (****** ********) ** *** UPS ** ****, *** **** *** ************* ******* *** ******* uptime **** **** *** ***** *****. ******** ***** ************ *** important, ********** **** * ***** *** ** ********.

All **** *** ** ** ****** *** ****** *** *** **** **** **** **.

** ******* **** **** *** ***** ****** *********** **** ***** outage, ***** *** *** **** ** ******* ** ********* ******* shutdown. ****** *** ******* *** ******* *** *** ** ********* power, ***** ** ** ***** ****** *** ****** **, ****** you **** ********* ****** ** ******** *****, ** ***** **** you *** ******** ***** ** ** *** * ***** *******.

MULTIPLE ****** *************

*** ******** **** *** * *** ******* *** ** ***** long, *** ** ****** *** ****** *** *** ******* ******** is. ** ** *** *** ** **** ** *** ******* power *** **** **** ****,*** *** ** ********** ** * ****** ****** ************ *** ******** *** **** *****. *** *** *** **** enough **** *** *** ****** ******* ********. **** ** ****** a ************* **** ***** *** ******* ******* *******. *** **** small ******* *** **** **** ************* ** ***** ******* ******** is *****.

** **** ** **** * **** ************* ** *** *******, nature, *** ******** ** ***** ******* **** ********* ******* ****** power. ** ****** ******** **** **** *** **** ** **** as ******-***** *********.

* ***** *** ** ***** **** ** ******* ** **** video ****** ********, ********** ***** **** ** ***/*** ********, ***** the ********* ***** ** *** ***** ** ****-********* *******. **** could **** ***** ******* ****** ***** ** * ****. ** it's ******* *** **** ************* ** ***** **** **** *** and *** **********.

**** *********** ******* *** ******* **** ** ********* ** ****** power. ***'* ** ********* *** ***** **** ** *** ****.

*** ****** ( *** **** ** * *** **** ** here, *'* * *** ****** ( *** ************ ) *** have *** ** **** *** *** ***** ), **** * dual ****** ***** *** **********. ** *** ***** *** *** database *** **** *** **** *** ******** **** ******** ****+ camera ********. ** ************ **** ** *** ******* ******** ** the ********* ****** ****** * ***** ***** **** ** ******. The **** ******** **'** **** ** *** *** ********** ***** outages ***** ** *** ***** ******, ** **** ****** ******* in *** ******. *** ******** ****** ***** ** ** **** reliable.

***********, ****, *** **** ***** ******* ** **** *** *** a **** ****** ***** :) * ** **** ** ***** a ********** **'* **** **** ********* *** ****** ** ******* for ******* *******.

***, ****, ** *** **** ***** ******* *** **** ***** of ****?

**** ** *** **** *** **** ***** ** *** ****, because ** ***'* ******* *** *** **** *** ** ***** days ** ***** *****, **** ******* ***** ** ****** **** footage *** **** * ******** ********, *** ** **** *****, nobody ***** *** **** **** ******** * ***** **** ("**, we *** * ***** *****... ***** **** **** * ****** months ***, * ***'* ******** *******...").

**** ******* **********, ** "*******" ******** (***** ****, ***** ******, etc.) ** *** ****** ****** ***** ** ******** **********. * failing ******* ** ** ******* ***, *********. *** *** ** also * *********** **** ********* ****** ** *** ***** ** strange ****. *** ** ******, ** **** ******** ******* ** an ******** ****** (***/***, *****, *** *****, ***.), *** ************ in *** **** ********** ***** ****** ******.

*** ******* **** ****** ******* ******* ******* *** **** ***** records ***** ***** ******. ******* ********** *** ****** ********** **** alerting *** ** *** ** ** ****** *** ** ******* events, **** ****** *** ** **. ******** ****************** ***************** * **** ******* ** **** -- ** ********* ********** product **** *** ******* ******* *** ******* *********, **** *** how **** **** **** ***** ***** **, *** ** **. I ******'* **** ** *** ** * ***** ****** ******* some **** ** ****** ********** *** ********. **** *** ******* situations ** *********** **** * ****** ****'* **** ******* ******** for **** ****** ** ******.

***** ******** ** *********** **** ** * ****** ***** ** include *** ***** *******, ******** *** ******* ** ***** ********** plan. ** ****'* *** ** ******, *** *** ** ** yourself.*** ** ******** ********** *************, ** ***?

"*** ******* **** ****** ******* ******* ******* *** **** ***** records ***** ***** ******."

**** **, *** ***** ***'* ****** **** *** ** ***** things *** ******* ** *** ***** ** *** ******** ******. A ******* ****** ** *** ****** **** ***** *** *** system *********, *** ******* ** *** ****** ** * ***** outage, ** ******* ******* *** ***** ******, ** ** ** was **** ** ******* ******** **** ********. ****** **** ******, similarly, **** **** *** **** ***** *** **** ******, *** what ******** ** **** ***** ****** *** *********.

*********** **** *** **** ******** ****** ***** *********, *** ** may ** ******** ** ********* ***** ** *** ********** ** disk ****** ** ********, *** ****'* *** **** **** **** circumstantial ********.

"* ******'* **** ** *** ** * ***** ****** ******* some **** ** ****** ********** *** ********. **** *** ******* situations ** *********** **** * ****** ****'* **** ******* ******** for **** ****** ** ******."

**'* * ********* ***** **** *** *** *** **... ************* we **** ********* ***** **** ******* *********** ** ***** ****** fuel ***** *** ***** ********* ****, ***** ****'** *** ******* to ******* *** **** ** *** ******* (*** **** **** would ******* **** ******** ****** ******), *** *** ******* ** install ***** *** ******** ***********. ** ******, ***** *** *** same ***** ***** * *** *** ** ******* **** *** weeks ** * **** **** * ******* *** **** **'* recording ** ****** ******, ** ****'* ******** *** *** ******* in *** **** ** *****, *** **'* **** ******* ***** someone ***** ** **** ** **** *****.