Informix upgrade 7.23 to 7.24 (second attempt, assert failures) Need
Posted in 2003
Sun 2.6
Informix 7.23
A week or two ago I tried this upgrade a server without success. =
Basically the same outcome this week, finishing with a restore back to =
7.23.
Last night around 10pm I upgraded the server and everything seems to =
upgrade fine. I have a user test as much as possible to ensure that =
things are working. User's come in and start connecting to the database =
the next morning. After awhile I get assert failures one after another.
I have successfully upgraded around 8 other servers in test and =
production prior to this one and the last one that I did is identical in =
server, os version, database version, application. The only difference =
in the last one I did and this one is the last one has 2gig of memory =
where this one has 1gig. Memory does not seem to be an issue.=20
Server is showing no load when the asserts accurse.
We are going to be upgrading our servers and os 2.6 to 8. I need to get =
to at least 7.24 so that I can get to the latest Informix release and =
os.
I sure could use some help from you Informix gurus and sure would =
appreciate it.
We are on the cusp of signing a new Informix contract that is worth more =
than the gross national product. If I can not resolve this issue a new =
contract is going to do us no good. =20
Thanks!!!!!
<<online.loga>> <<online.logb>> <<onconfig>> =
<<online.log.120503-12>> <<af.cfa416>> <<af.d1a43b>> <<af.5f98591>> =
<<af.9b18>> <<af.5cb8781>> <<af.1a4be43>> <<af.19c9b17>> =
<<af.191bcea>> <<af.194bd25>> <<af.14eb9a3>> <<sqlhosts>>=20
Fri Dec 5 10:47:49 2003
10:47:49 Event alarms enabled. ALARMPROG = '/usr/informix/etc/IfmxAlarmMonitor'
10:47:54 DR: DRAUTO is 0 (Off)
10:47:56 (10) connection rejected - no calls allowed for sqlexec
10:47:56 listener-thread: err = -27002: No connections are allowed in OnLine quiescent mode.
10:47:56 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
10:47:56 Physical Recovery Started.
10:47:57 Physical Recovery Complete: 0 Pages Restored.
10:47:57 Logical Recovery Started.
10:48:00 Logical Recovery Complete. 9 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
10:48:00 Dataskip is now OFF for all dbspaces
10:48:01 On-Line Mode
10:48:01 Checkpoint Completed: duration was 0 seconds.
10:53:30 Checkpoint Completed: duration was 0 seconds.
10:58:30 Checkpoint Completed: duration was 0 seconds.
11:03:31 Checkpoint Completed: duration was 1 seconds.
11:08:31 Checkpoint Completed: duration was 0 seconds.
11:13:31 Checkpoint Completed: duration was 0 seconds.
11:18:31 Checkpoint Completed: duration was 0 seconds.
11:23:36 Checkpoint Completed: duration was 5 seconds.
11:28:43 Checkpoint Completed: duration was 6 seconds.
11:31:39 Logical Log 34524 Complete.
11:31:40 Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/etc/IfmxAlarmMonitor 2 23 "Logical Log 34524 Complete." "Logical Log 34524 Complete."
11:33:50 Checkpoint Completed: duration was 7 seconds.
11:38:52 Checkpoint Completed: duration was 2 seconds.
11:44:00 Checkpoint Completed: duration was 8 seconds.
11:47:09 Checkpoint Completed: duration was 8 seconds.
11:52:16 Checkpoint Completed: duration was 7 seconds.
11:55:11 Checkpoint Completed: duration was 0 seconds.
11:58:13 Checkpoint Completed: duration was 7 seconds.
11:58:23 Logical Log 34525 Complete.
11:58:23 Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/etc/IfmxAlarmMonitor 2 23 "Logical Log 34525 Complete." "Logical Log 34525 Complete."
12:00:19 Assert Failed: Memory block header corruption detected in add_to_list 1
12:00:19 Who: Session(286, informix@sid.pmg.gefa.capital.ge.com, 17942, 0)
Thread(334, sqlexec, 0, 1)
12:00:19 Results: Pool repaired
12:00:19 Action: Please notify Informix Technical Support.
12:00:19 See Also: /tmp/af.14eb9a3
12:03:23 Checkpoint Completed: duration was 0 seconds.
12:08:26 Checkpoint Completed: duration was 2 seconds.
12:13:38 Checkpoint Completed: duration was 12 seconds.
12:14:19 Assert Failed: Memory block header corruption detected in add_to_list 1
12:14:19 Who: Session(353, sysuser@sflapp3, 7445, 0)
Thread(401, sqlexec, 0, 1)
12:14:19 Results: Pool repaired
12:14:19 Action: Please notify Informix Technical Support.
12:14:19 See Also: /tmp/af.191bcea
12:15:17 Assert Failed: Memory block header corruption detected in add_to_list 1
12:15:17 Who: Session(355, sysuser@sflapp3, 7531, 0)
Thread(404, sqlexec, 0, 1)
12:15:17 Results: Pool repaired
12:15:17 Action: Please notify Informix Technical Support.
12:15:17 See Also: /tmp/af.194bd25
12:18:38 Checkpoint Completed: duration was 0 seconds.
12:20:03 Assert Failed: Memory block header corruption detected in add_to_list 1
12:20:03 Who: Session(371, sysuser@sflapp3, 7915, 0)
Thread(420, sqlexec, 0, 1)
12:20:03 Results: Unable to repair pool
12:20:03 Action: Please notify Informix Technical Support.
12:20:03 See Also: /tmp/af.1a4be43
12:23:40 Checkpoint Completed: duration was 1 seconds.
12:28:44 Checkpoint Completed: duration was 4 seconds.
10:28:59 Found during mt_shm_malloc_segid 1
10:28:59 Pool 'dictpool' (0xe084018)
10:28:59 Bad free block 0xeb73f90
blk-64
0eb73f50: 746d6170 5f746572 6d000000 00030000 tmap_ter m.......
0eb73f60: 00008000 00008000 00000000 00087669 ........ ......vi
0eb73f70: 705f7465 726d0000 00030000 00008000 p_term.. ........
0eb73f80: 00008000 00000000 00096361 6c6c5f64 ........ ..call_d
blk+64
0eb73f90: 69737000 01000003 00400000 80000000 isp..... .@......
0eb73fa0: 80000000 00000009 63616c6c 5f646174 ........ call_dat
0eb73fb0: 6500000a 0e0a0000 00008000 00008000 e....... ........
0eb73fc0: 00000000 000d6361 6c6c5f73 63686564 ......ca ll_sched
10:28:59 Bad free