upgrade_express_2101_2201 step 1004 stalls; "timeout occurred while waiting to lock object"
- Article Type: General
- Product: Aleph
- Product Version: 22
Problem Symptoms:
upgrade_express_2101_2201 step 1004 has been running for 2.5 hours. No errors are seen, but nothing has been written to the log for 2.5 hours. "ps -ef |grep z353" shows two processes still running: "oracle_table_alter usr z353" and "z353_alter_column.sql"
After killing the processes, both SQL "select count(*) from z353;" and util a/17/3 for z353_id get the following error:
"ORA-04021: timeout occurred while waiting to lock object"
Cause:
Uncertain. But, after restarting Oracle, the above error was no longer occurring, and util a/17/14 showed the z353_id and z353_id1 as present and valid, the record count (comparing to v20 was correct) and util f/4 in v22 for z353 showed them correctly (indicating that they had been correctly converted into the v22 format).
It *may* have had to do with the fact that the "3. Upgrade Express" step was started before the "6. Backup/Restore Oracle Tables to be Upgraded" step was complete -- which *did* happen. See Article 000024912 ("upgrade_kit_export.log" message when no export was submitted) in regard to this step 6.
Resolution:
1. Be sure to let upgrade_util step 6 finish before starting step 3 to (possibly) prevent the problem.
2. If the problem occurs, restart Oracle.
Additional Information
Detailed example:
The following processes started at 10:58 and are still running (at 13:25):
aleph 23034 22983 0 10:58 pts/0 00:00:00 csh -f
/exlibris/aleph/upgrade_express_2101_2201/source/proc/oracle/oracle_table_alter usr z353
aleph 23249 23034 0 10:58 pts/0 00:00:00 sqlplus @./source/1004/z353_alter_column.sql xxx00.
aleph@dc02kg0xxxna(a22_1):~...logs/log>date
Mon Oct 27 13:25:57 CDT 2014
xxx00@ALEPH22> select count(*) from z353;
select count(*) from z353
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
util a/17/3 for the xxx00 z353 (to rebuild the Oracle indexes) gets this (after 1/2 hour):
aleph_admin@ALEPH22> 14:26:01 aleph_admin@ALEPH22> ALTER INDEX XXX00.Z353_ID REBUILD
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
Category: Installation & Upgrades (500)
- Article last edited: 10/28/2014