Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Please implement a DatabaseStartFailed event that gets control when the engine is in the process of failing to fully start a database because of some startup error. This event should have access to the same diagnostic information that is written to the -oe text file.

I realize that there may have to be (severe?) limitations on when/if this event gets fired, and what actions it can take, but here's the business case...

When a service fails to launch, or an embedded database fails to start, it would be great to be able to send an email containing the -oe information... otherwise, such a failure to start can easily go unnoticed.

As people (like me) push more and more critical application functionality down into web services running in the database engine, diagnosing problems becomes more and more of a SQL issue... in some cases, there IS no "client" other than a slack-jawed knuckle-dragging web browser, it's up to the server to do all the heavy lifting.

asked 16 Feb '10, 17:11

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

Perhaps there needs to be some sort of "engine start timeout" setting to determine when the start is regarded as having failed. The "Start Pending" message has to be one of the most irritating things out there - is it just taking a long time or is there a fatal problem.

(19 Feb '10, 14:00) Justin Willey

Where do you see "Start Pending"? Maybe it's the lack of coffee but I'm not familiar with that message... although I am very familiar with long startups, sometimes a longgggg recovery after Something Bad happened.

(20 Feb '10, 09:05) Breck Carter

Start Pending is displayed in the service control of Windows

(26 Feb '10, 11:27) Martin

@Martin: Oh that Start Pending... yes indeed that is truly irritating. FWIW I always recommend -o and -oe options, especially for service-started engines... they sometimes help.

(26 Feb '10, 14:24) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×113

question asked: 16 Feb '10, 17:11

question was seen: 1,115 times

last updated: 16 Feb '10, 17:11