Kbase P34014: Attempting to perform online schema update on the SOURCE database causes operation to hang
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Fathom High Availability Replication 1.0A
SYMPTOM(s):
Attempting to perform online schema update on the SOURCE database
Attempt to load data definition file via the Data Dictionary/Administration tool on SOURCE database causes screen to freeze.
TARGET and SOURCE database log files show an Exclusive lock being requested but not being granted.
Exclusive schema lock requested. (10413)
CAUSE:
Any sort of table access by a client on the target database will prevent an exclusive schema lock from being granted to the Replication Server.
FIX:
Stop all user or data administration/dictionary on the TARGET database while attempting an online schema update on the SOURCE database. Once the Exclusive Schema lock is granted by the TARGET Replication Agent, the schema update will continue.
The following are snippets from a Source and Target Database log file when the above scenario occurs. Notice the five minute interval between the request for the exclusive schema and the granting of the exclusive schema lock:
Source Database:
16:15:10 RPLS 5: Exclusive schema lock requested. (10413)
16:20:57 RPLS 5: The requested exclusive schema lock has been granted. (10414
)
Target Database:
16:15:09 RPLA 5: Exclusive schema lock requested. (10413)
16:20:54 RPLA 5: The requested exclusive schema lock has been granted. (10414
)
For more information please reference page 1-15 of the Replication User's Guide - Version 1.0