Consultor Eletrônico



Kbase P162802: Error 1081 on a test database because production is running too many APWS
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   31/03/2010
Status: Unverified

SYMPTOM(s):

Production database is being shut down every day for backup

Error 1081 on a test database

Too many users requested semaphore undo, increase SEMMNU. (1081)

Database lock file (.lk) has an older date on it

Many APWs are running when only 3 should start

FACT(s) (Environment):

UNIX
Progress/OpenEdge Product Family

CAUSE:

The database script was not shutting down the database. Every day it would try to
restart and 3 new APWs would start. Finally, there were so many APWs running that
a test database ran out of semaphores and gave the error.

FIX:

Make sure the script is shutting down the production database. This can
be done by doing a command that checks to see if the .lk file exists or runs
proutil db-name -C holder.