[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::sql_services

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

2177.0. "SQLSRV-F-EXECSTARTEXCEED & max no of retries" by ukvms3.uk.oracle.com::LWILES (Louise Wiles, UK Rdb support) Tue Mar 25 1997 15:28

    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.RTitleUserPersonal
Name
DateLines
2177.1why?M5::JBALOGHTue Mar 25 1997 16:316
    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.2ukvms3.uk.oracle.com::LWILESLouise Wiles, UK Rdb supportThu Apr 10 1997 08:3816