| Title: | SQL/Services Forum |
| Notice: | kits(3) ft info(7) QAR access (8) SPR access (10) |
| Moderator: | SQLSRV::MAVRIS |
| Created: | Thu Oct 13 1988 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 2214 |
| Total number of notes: | 8586 |
Hi,
SQL/Services V7.0
VAX VMS V6.1
A customer of mine is seeing a service get shut down when its database
is closed.
What he does is close the database to do a backup. He just shuts the
database down without shutting down its service.
Users on the client end continue to try to make connections, which
means that the service still tries to attach to the database.
The service continues to try to attach, then becomes a failed service &
shuts itself down. The only way to get this service back is to restart
it.
In the sqs...disp.log he gets the error
%SQLSRV-F-EXECSTARTEXCEED, Max executor startup failures exceeded for
service.
In the previous version of SQL/Services he used, there didn't seem to
be a maximum number of retries, so shutting down the database wasn't a
problem.
He would rather have the same behaviour as before.
What can he do get it back?
Thanks,
Louise.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2177.1 | why? | M5::JBALOGH | Tue Mar 25 1997 13:31 | 6 | |
If the service is unusable, ie, the database is unavailable, wouldn't
it be better to shut down the service first? Why not just stop/restart
the service in his backup script? Especially if his users are banging
on it while the DB is down...
John
| |||||
| 2177.2 | ukvms3.uk.oracle.com::LWILES | Louise Wiles, UK Rdb support | Thu Apr 10 1997 05:38 | 16 | |
�If the service is unusable, ie, the database is unavailable, wouldn't
�it be better to shut down the service first? Why not just stop/restart
�the service in his backup script? Especially if his users are banging
�on it while the DB is down...
Yes it would - this is what most customers would do, but this guy
doesn't want to change his backup script because he doesn't want to
change something which is already working.
He doesn't want to do anything extra to get the benefits of V7.0, and
intends to downgrade to V6.1 because of this.
Sometimes you just can't win.
Thanks,
Louise.
| |||||