RE: Reversion from IDS 9.40 to 9.21 fails

Neil, We ran into this problem as well during a PeopleSoft upgrade. I *think* support told us we couldn't revert more than one release in a single pass... I really don't recall the details, it was 3am when we needed to revert and I was talking to someone in Australia. Good luck with support, you'll need it. Jerry -----Original Message----- From: Neil Truby [mailto:neil.truby@ardenta.com] Sent: Thursday, January 08, 2004 6:15 AM To: informix-list@iiug.org Subject: Reversion from IDS 9.40 to 9.21 fails HP-UX 11.11 IDS 9.20 FC4 to IDS 9.40 FC2 We are testing the above upgrade. On three of the four databases to be converted we have had no problems in the conversion process (we did encounter a bug with slow index builds, a known problem kindly identified by Jonathan Leffler due to be fixed in 9.40 FC3). On the fourth, it also converts OK but sporadically - perhaps 2 times in 10 - the reversion back from 9.40 (level 0) to 9.21 will fail. This is an *absolute* show-stopper for this client. The database in question is mission-critical, and is 500GBytes in size, so dbexport/dbimport, or a restore, is not viable. A call has been raised with Tech Support (389466). Because this is not a "down" system we will have to work hard to ensure that it receives a prioroty that refelects the imprtance of the issue to the client. Any insight gratefully received. I attach the online log from the reversion process and the subsequent attempt to bring the server back online. thanks Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com ==================================== 11:37:18 Maximum server connections 0 11:37:18 Update reserved page status of conversion 11:37:18 Quiescent Mode 11:37:18 Succeeded 11:37:19 Checkpoint Completed: duration was 0 seconds. 11:37:19Checkpoint loguniq 112336, logpos 0x28ac018, timestamp: 761991795 11:37:19 Maximum server connections 0 11:37:19 Internal Conversion Completed Successfuly 11:37:19 Conversion Enabling Client Connections 11:37:19 Building 'sysmaster' database ... 11:37:20 On-Line Mode 11:37:24 Booting Language <spl> from module <> 11:05:03 Maximum server connections 3 11:08:53 Shutdown Mode 11:08:54 Quiescent Mode 11:08:55 Checkpoint Completed: duration was 0 seconds. 11:08:55Checkpoint loguniq 112336, logpos 0x1018, timestamp: 761722097 11:08:55 Maximum server connections 3 11:08:56 Reversion to version 9.2 Started 11:08:56 Beginning process of reverting system to 9.2 ... 11:08:57 **WARNING: Value for config parameter LRU_MAX_DIRTY will be truncated from decimal value 4.000 to integer value 4. Please check onconfig parameter value before reinitializing the Server. 11:08:57 ** WARNING: Value for config parameter LRU_MIN_DIRTY will be truncated from decimal value 2.000 to integer value 2. Please check onconfig parameter value before reinitializing the Server. 11:08:58 Booting Language <spl> from module <> 11:08:58 Loading Module <SPLNULL> 11:08:58 On-Line Mode 11:08:58 ON-Bar reversion test start: 11:08:58 ON-Bar reversion test completed successfully. 11:08:58 'onpload'reversion test start: 11:08:59 'onpload' reversion test completed successfully. 11:09:00 Reversion test for R-tree indexes started 11:09:01 Reversion test for R-tree indexes completed successfully 11:09:02 PAM reversion test completed successfully. 11:09:06 Quiescent Mode 11:09:10 Checking database trade for revertibility ... 11:09:11 Database trade is revertible ... 11:09:12 Checking database bo_repositoryo for revertibility ... 11:09:13 Database bo_repositoryo is revertible ... 11:09:14 Checking database bo_docagento for revertibility ... 11:09:15 Database bo_docagento is revertible ... 11:09:16 Checking database onpload for revertibility ... 11:09:17 Database onpload is revertible ... 11:09:18 Checking database startup for revertibility ... 11:09:20 Database startup is revertible ... 11:09:20 Checking database stores7 for revertibility ... 11:09:21 Databasestores7 is revertible ... 11:09:22 Checking database dba for revertibility ... 11:09:23 Database dba is revertible ... 11:09:24 Checking database cats for revertibility ... 11:09:26 Database cats is revertible ... 11:09:26 Checking database live for revertibility ... 11:09:30 Databaselive is revertible ... 11:09:30 Checking database londis_syn for revertibility ... 11:09:32 Database londis_syn is revertible ... 11:09:32 Checking database londis_vw for revertibility ... 11:09:35 Database londis_vw is revertible ... 11:09:36 Checking database live_dummy for revertibility ... 11:09:40 Database live_dummy is revertible ... 11:09:41 On-Line Mode 11:09:41 ON-Bar reversion start: 11:09:41 WARNING:Target server version must have a certified Storage Manager installed after conversion/reversion and before bringing up server. 11:09:41 ON-Bar reversion completed successfully. 11:09:42 ... reverting 'onpload' database. 11:09:42 ... 'onpload' reversion completed successfully. 11:09:42 PAM reversion completed successfully. 11:09:46 ... dropping 'sysmaster' database"crap.txt" 181 lines, 9064 characters $ wc crap*181 1145 9064 crap.txt $ cat crap.txt11:05:03 Maximum server connections 3 11:08:53 Shutdown Mode 11:08:54 Quiescent Mode 11:08:55 Checkpoint Completed: duration was 0 seconds. 11:08:55Checkpoint loguniq 112336, logpos 0x1018, timestamp: 761722097 11:08:55 Maximum server connections 3 11:08:56 Reversion to version 9.2 Started 11:08:56 Beginning process of reverting system to 9.2 ... 11:08:57 **WARNING: Value for config parameter LRU_MAX_DIRTY will be truncated from decimal value 4.000 to integer value 4. Please check onconfig parameter value before reinitializing the Server. 11:08:57 ** WARNING: Value for config parameter LRU_MIN_DIRTY will be truncated from decimal value 2.000 to integer value 2. Please check onconfig parameter value before reinitializing the Server. 11:08:58 Booting Language <spl> from module <> 11:08:58 Loading Module <SPLNULL> 11:08:58 On-Line Mode 11:08:58 ON-Bar reversion test start: 11:08:58 ON-Bar reversion test completed successfully. 11:08:58 'onpload'reversion test start: 11:08:59 'onpload' reversion test completed successfully. 11:09:00 Reversion test for R-tree indexes started 11:09:01 Reversion test for R-tree indexes completed successfully 11:09:02 PAM reversion test completed successfully. 11:09:06 Quiescent Mode 11:09:10 Checking database trade for revertibility ... 11:09:11 Database trade is revertible ... 11:09:12 Checking database bo_repositoryo for revertibility ... 11:09:13 Database bo_repositoryo is revertible ... 11:09:14 Checking database bo_docagento for revertibility ... 11:09:15 Database bo_docagento is revertible ... 11:09:16 Checking database onpload for revertibility ... 11:09:17 Database onpload is revertible ... 11:09:18 Checking database startup for revertibility ... 11:09:20 Database startup is revertible ... 11:09:20 Checking database stores7 for revertibility ... 11:0