Kbase 16510: Wait code error numbers and what they mean?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
GOAL:
What does SYSTEM ERROR: unexpected wakeup from wait code <number>, user <user-number> (1007) mean?
GOAL:
What do the wait codes mean in Version 7, Version 8 and Version 9?
FACT(s) (Environment):
Wait code error numbers and their meanings which are returned from progress message 1007.
What does the waiting code mean in progress message 1007?
Progress 7.x
Progress 8.x
Progress 9.x
FIX:
This solution describes the wait codes that are used for errors such as (1007): unexpected wakeup call. The codes were retrieved from Version 8 but also apply to version 7. In addition, some V9 codes have been added. The codes listed are the name of the code, the error number that appears in the Progress error and a short explanation of what they are waiting on.
V7 and V8 wait codes:
RECWAIT 1 a record lock
SCHWAIT 2 a schema lock
TSKWAIT 3 another task to end
IXWAIT 4 not used anymore
INTENTWAIT 4 intent upgrade on db buffer
RGWAIT 5 a record get
READWAIT 6 a .db block read
WRITEWAIT 7 a .db block write
BACKWAIT 8 .db block to be backed up
SHAREWAIT 9 share lock on buffer
EXCLWAIT 10 exclusive lock on buffer
NOBUFWAIT 11 a shared buffer
COPYWAIT 12 for stats only
AIWWAIT 12 ai writer wait for work
BIREADWAIT 13 a .bi block read
BIWRITEWAIT 14 a .bi block write
AIREADWAIT 15 a .ai block read
AIWRITEWAIT 16 a .ai block write
BIWWAIT 17 bi write#define
TXBWAIT 18 transaction begin
TXEWAIT 19 transaction end
V9 wait codes:
TXSWAIT 18 txe share lock wait
TXBWAIT 19 txe update mode lock wait
TXEWAIT 20 waiting for txe commit mode lock
TXXWAIT 21 waiting for txe exclusive mode lock
Additional changes in 9.1D include:
1. AIWWAIT and BIWWAIT are gone because AIW/BIW become timer-driven instead of using semaphores;
2. REPLWAIT is added to support database replication.