Oninit cdi / Archive
Talk to an expert →

Down grade from 9.21.UC2 to 7.30.UC6

Posted in 2003

Topics: Installation, Setup & Upgrades, Storage & Space Management, Error Codes & Troubleshooting, Platform-Specific Issues

Chavan Koya — — source: Usenet: comp.databases.informix

Hello all, For some reasons i had to down grade my Informix Instance which is running on HP-UX 10.20 and 9.21.UC2 to 7.30.UC6. When i issue the command "onstat -". The server is not coming up and in fast recovery mode. " Informix Dynamic Server Version 7.30.UC6 -- Fast Recovery -- Up 00:00:20 -- 283192 Kbytes". Then i looked into the online log. It was showing some AssertFail. Question 1. Can we initialize a server like this, for these versions ? Question 2. Why the DBSPACETEMP is invalid ( in the online log message ) ? Question 3. Did any one does like this and successful ? I have initialized the server like this. 1. Installed 7.30.UC6 in different directory. 2. Shutdown the instance using old ( 9.21 INFORMIXDIR) environment. 3. With the new environment ( 7.30 INFORMIXDIR ) try to initialize the server with the command "oninit" 4. Back again with the old 9.21 environment i could initialize the server. Here is the cut from online log. ---------------------------------------------------------------------------------------------------------- 12:09:51 Informix Dynamic Server 2000 Stopped. Mon Jul 28 12:12:04 2003 12:12:04 Event alarms enabled. ALARMPROG = '/home/informix/dbi101_shm/config/alarm_dbi101_shm.sh' 12:12:16 DR: DRAUTO is 0 (Off) 12:12:18 Informix Dynamic Server Version 7.30.UC6 12:12:20 Informix Dynamic Server Initialized -- Shared Memory Initialized. 12:12:21 Warning: Invalid dbspace 'dbi101_tmp001' listed in DBSPACETEMP. 12:12:21 Warning: Invalid dbspace 'dbi101_tmp002' listed in DBSPACETEMP. 12:12:21 Physical Recovery Started. 12:12:21 Assert Failed: Chunk 1 is being taken OFFLINE. 12:12:21 Informix Dynamic Server Version 7.30.UC6 12:12:21 Who: Session(23, informix@xyzhost, 0, 0) Thread(85, fast_rec, 0, 4) File: rspartn.c Line: 4957 12:12:21 Results: Cannot Open DBspace 1. 12:12:21 Action: Restore chunk from archive. 12:14:24 See Also: /admin/informix/af.555974, shmem.555974.0, /opt/informix730uc6/bin/core 12:14:38 Assert Failed: Unexpected virtual processor termination, pid = 22899, exit = 0xb 12:14:38 Informix Dynamic Server Version 7.30.UC6 12:14:38 Who: Session(2, informix@, 0, 0) Thread(54, sm_poll, 0, 1) File: mt.c Line: 10176 12:14:38 stack trace for pid 22691 written to /admin/frdr/informix/af.3659fd 12:16:43 See Also: /admin/informix/af.3659fd, shmem.3659fd.0, /opt/informix730uc6/bin/core 12:16:55 The Master Daemon Died 12:16:56 PANIC: Attempting to bring system down 12:18:22 Informix Dynamic Server 2000 Started. Mon Jul 28 12:18:29 2003 12:18:29 Event alarms enabled. ALARMPROG = '/home/informix/dbi101_shm/config/alarm_dbi101_shm.sh' 12:18:29 Booting Language <c> from module <> 12:18:29 Loading Module <CNULL> 12:18:29 Booting Language <builtin> from module <> 12:18:29 Loading Module <BUILTINNULL> 12:18:39 Dynamically allocated new message shared memory segment (size 1164KB) 12:18:39 Dynamically allocated new message shared memory segment (size 1164KB) 12:18:39 Informix Dynamic Server 2000 Version 9.21.UC2 12:18:40 Informix Dynamic Server 2000 Initialized -- Shared MemoryInitialized. 12:18:40 Physical Recovery Started. 12:18:42 Physical Recovery Complete: 0 Pages Restored. 12:18:42 Logical Recovery Started. 12:18:42 10 recovery worker threads will be started. 12:18:45 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks -------------------------------------------------------------------------------------------------------------------------------------- _________________________________________________________________ Are you Unmarried? http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?4d Register in India's No 1 Matrimony. sending to informix-list

↪ replying to Chavan Koya
John Carlson — — source: Usenet: comp.databases.informix

On Tue, 29 Jul 2003 01:23:09 +0530, "Chavan Koya" <chavankoya189@hotmail.com> wrote: > >Hello all, > >For some reasons i had to down grade my Informix Instance which is running >on HP-UX 10.20 and 9.21.UC2 to 7.30.UC6. When i issue the command "onstat >-". The server is not coming up and in fast recovery mode. " Informix >Dynamic Server Version 7.30.UC6 -- Fast Recovery -- Up 00:00:20 -- 283192 >Kbytes". Then i looked into the online log. It was showing some AssertFail. > >Question 1. Can we initialize a server like this, for these versions ? >Question 2. Why the DBSPACETEMP is invalid ( in the online log message ) ? >Question 3. Did any one does like this and successful ? > >I have initialized the server like this. > >1. Installed 7.30.UC6 in different directory. >2. Shutdown the instance using old ( 9.21 INFORMIXDIR) environment. >3. With the new environment ( 7.30 INFORMIXDIR ) try to initialize the >server with the command "oninit" >4. Back again with the old 9.21 environment i could initialize the server. > Ah, but you have all those structures that were upgraded to 9.21 and need to be 'reverted' back to 7.30. Look up the 'onmode -b' command in the migration guide, which can be found at: http://publibfi.boulder.ibm.com/epubs/pdf/6531.pdf Also, a reversion methodology is given . . . might be good to verify that your procedures are OK.

Glossary