Kbase P114592: Error 8812 while running binary dump, with "Schema lock call failed -1218".
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
OpenEdge 10.x
SYMPTOM(s):
Error 8812 while running binary dump with build indexes option:
proutil -C load build indexes, results in the following errors:
Lock wait timeout of seconds expired (8812)
Schema lock call failed -1218
Database is started in multi-user mode.
No user is accessing or updating the table that is being loaded.
Users are connected to the database and accessing or updating other tables in the database.
CAUSE:
This is a known issue.
proutil -C dump with the build indexes option requires a schema lock to operate. This means that this utility cannot be used while other users are working on the same database, nor can 2 binary loads with the build indexes option be run against the same database concurrently.
FIX:
Avoid running proutil -C load build indexes while other users are working, or use proutil -C load (without the build indexes option) and then schedule some down time to rebuild the indexes for the table via proutil -C idxbuild.