APAR status
Closed as program error.
Error description
3 user tables failed with pthdrpage:ptaltstat2:bad alter slot after upgrading from 9.40.FC8 to 11.50.FC7W1. Oncheck -cID/-cc in IDS 9.40.FC8 comes back clean. Recreating the table in IDS 9.40.FC8 fixes the problem. Problem reproduced using onunload binary. online.log: 12:12:34 Conv/rev: Finished conversion for component HA 12:12:34 Conversion Completed Successfully 12:12:34 On-Line Mode 12:12:34 Building 'sysadmin' database ... 12:12:34 Checkpoint Completed: duration was 0 seconds. 12:12:34 Wed Sep 15 - loguniq 155414, logpos 0xa3e720, timestamp: 0x3575e2a Interval: 23 12:12:34 Maximum server connections 3 12:12:34 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 0, Plog used 11355, Llog used 481 12:12:34 The restore point ended and related data in directory /app/informix/tmp/1 were removed. 12:12:39 Unloading Module <SPLNULL> 12:12:40 Loading Module <SPLNULL> 12:12:41 Unloading Module <SPLNULL> 12:12:41 Loading Module <SPLNULL> 12:12:42 Unloading Module <SPLNULL> 12:12:42 Loading Module <SPLNULL> 12:12:42 'sysadmin' database built successfully. 12:12:42 SCHAPI: Started dbScheduler thread. 12:12:42 SCHAPI: Started 2 dbWorker threads. 12:12:42 Checkpoint Completed: duration was 1 seconds. 12:12:42 Wed Sep 15 - loguniq 155414, logpos 0x12f0504, timestamp: 0x35807b7 Interval: 24 12:12:42 Maximum server connections 3 12:12:42 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 2, Plog used 2635, Llog used 2284 12:21:09 Checkpoint Completed: duration was 1 seconds. 12:21:09 Wed Sep 15 - loguniq 155414, logpos 0x99eb1fc, timestamp: 0x36f5295 Interval: 25 12:21:09 Maximum server connections 3 12:21:09 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 196627, Llog used 34574 12:24:59 Logical Log 155414 Complete, timestamp: 0x3778a68. 12:25:00 Logical Log 155414 - Backup Started 12:28:15 HPUX KAIO Segment locked addr=0x54c11000 size=536870912 12:28:15 HPUX KAIO Segment locked addr=0x54c11000 size=536870912 12:28:15 HPUX KAIO Segment locked addr=0x54c11000 size=536870912 12:28:15 Dynamically allocated new virtual shared memory segment (size 524288KB) 12:28:15 Memory sizes:resident:318980 KB, virtual:1573520 KB, no SHMTOTAL limit 12:28:34 Logical Log 155414 - Backup Completed 12:29:46 Assert Failed: pthdrpage:ptaltstat2:bad alter slot 12:29:46 IBM Informix Dynamic Server Version 11.50.FC7W1 12:29:46 Who: Session(143, informix@, 0, c000000015a08a68) Thread(167, dbWorker2, c0000000159cd188, 3) File: rspartn.c Line: 7217 12:29:46 Results: Cannot use TBLSpace page for TBLSpace 2275275 12:29:46 Action: Run 'oncheck -pt 2275275' 12:29:46 stack trace for pid 23604 written to /var/tmp/af.48f4bb9 12:29:47 See Also: /var/tmp/af.48f4bb9 Example AF stack trace: 12:29:46 IBM Informix Dynamic Server Version 11.50.FC7W1 Software Serial Number AAA#B000000 12:29:46 Assert Failed: pthdrpage:ptaltstat2:bad alter slot 12:29:46 Who: Session(143, informix@, 0, c000000015a08a68) Thread(167, dbWorker2, c0000000159cd188, 3) File: rspartn.c Line: 7217 12:29:46 Results: Cannot use TBLSpace page for TBLSpace 2275275 12:29:46 Action: Run 'oncheck -pt 2275275' 12:29:46 Raw hex dump of stack located in /var/tmp/af.48f4bb9.rawstk 12:29:46 Stack for thread: 167 dbWorker2 base: 0xc000000017850000 len: 135168 pc: 0x0000000000000000 tos: 0xc000000017855780 state: running vp: 3 ( 0) legacy_hp_afstack ( 1) afstack ( 2) afhandler ( 3) affail_interface ( 4) pthdrgetx ( 5) ptaltstat ( 6) ptalloc ( 7) nxtpartp ( 8) prptnhdr ( 9) pstread (10) pst_rsread (11) rsread (12) fmread (13) readseq_single (14) readseq (15) gettupl (16) scan_next (17) join_next (18) getrow (19) fetchrow (20) ip_scurnext (21) ip_evalcurnext (22) runproc (23) udrlm_spl_execute (24) udrlm_exec_routine (25) udr_execute (26) mi_routine_exec (27) ph_exec_func (28) ph_execute (29) do_sensor (30) db_sch_worker (31) udrlm_clang_execute_internal (32) udrlm_clang_execute (33) udrlm_exec_routine (34) udr_execute (35) dbsched_start_udr (36) startup (37) resume base: 0xc000000017850000 len: 135168 pc: 0x0000000000000000 tos: 0xc000000017855780 state: running vp: 3
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users migrating from versions older than 10x to newer * * versions with alter versions spanning more than 2 pages * * could hit this problem. * **************************************************************** * PROBLEM DESCRIPTION: * * When converting from 9.4x to 11.50 versions, engine did not * * delete the unused secondary header pages containing alter * * versions. This caused the subsequent select statement to * * refer to these pages and caused the problem. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC8. * ****************************************************************
Problem conclusion
The workaround for this problem is remove all the pending alters before migrating. The other way is to upgrade to IDS 11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC71619
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-30
Closed date
2011-01-20
Last modified date
2011-01-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 January 2011