7.31.UD8 migration to 10.00.UC4 failed with :Con/rev: Failed to convert for Component SQL
Posted in 2006
Hi Gang,
During a migration from 7.31.UD8 to 10.00.UC4 I ran into the following
error during the conversion : Con/rev: Failed to convert for Component SQL.
Then the engine crashed and had not been able to bring it backup due to
corruption in sysmaster. Since it was a test env, I restored the
environment and restarted. For a second time it failed for the same reason
and same place. Any help or thoughts would be greatly appreciated.
AIX 5.2
IDS 7.31.UD8
09:25:25
09:25:25 IBM Informix Dynamic Server Version 10.00.UC4 Software SerialNumber AAA#B000000
09:25:25 Assert Failed: Conv/rev: Failed to convert for component SQL
09:25:25 Who: Session(16, informix@chbuxd08, 0, 7163d018)
Thread(151, convert, 71614018, 3)
File: framework.c Line: 668
09:25:25 Results: Dynamic Server must abort
09:25:25 Action: Restart conversion after fixing the problem.
09:25:25 Stack for thread: 151 convert
base: 0x7165b000
===========------------- - - - - - -
tail -100 /chbuxd08/opt/app/informix/log/toltp/msg.toltp:
09:25:07 Onconfig parameter JVPHOME modified from <blank> to
/usr/informix/extend/krakatoa.
09:25:07 Onconfig parameter JVPJAVAHOME modified from <blank> to
/usr/informix/extend/krakatoa/jre.
09:25:07 Onconfig parameter JVPJAVAVM modified from libjava.so to
hpi:jvm:java:net:zip:jpeg.
09:25:07 Onconfig parameter JVPLOGFILE modified from jvp.log to
/usr/informix/extend/krakatoa/jvp.log.
09:25:07 Onconfig parameter JVPPROPFILE modified from .jvpprops to
/usr/informix/extend/krakatoa/.jvpprops.
09:25:07 Onconfig parameter JVPJAVALIB modified from <blank> to /bin.
09:25:07 Onconfig parameter JDKVERSION modified from <blank> to 1.3.
09:25:07 Onconfig parameter JVPCLASSPATH modified from <blank> to
/usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar.
09:25:07 Onconfig parameter LOGFILES modified from 129 to 258.
09:25:07 Onconfig parameter LTAPEDEV modified from
/chbuxd08/opt/app/informix/log/mylog to /dev/null.
09:25:07 Onconfig parameter LTXHWM modified from 50 to 70.
09:25:07 Onconfig parameter LTXEHWM modified from 60 to 80.
09:25:07 Onconfig parameter ALARMPROGRAM modified from
/chbuxd08/opt/app/informix/etc/log_full.sh to
/chbuxd08/opt/app/informix/etc/no_log.sh.
09:25:07 Onconfig parameter BAR_DEBUG modified from 4 to 0.
09:25:07 Onconfig parameter BAR_NB_XPORT_COUNT modified from 10 to 20.
09:25:07 Onconfig parameter BAR_XFER_BUF_SIZE modified from 15 to 31.
09:25:07 Onconfig parameter CDR_NIFRETRY modified from 300 to 0.
09:25:07 Dataskip is now OFF for all dbspaces
09:25:07 Checkpoint Completed: duration was 0 seconds.
09:25:07 Checkpoint loguniq 59731, logpos 0x1130, timestamp: 0x833cf432
09:25:07 Maximum server connections 0
09:25:08 Physical recovery completed, continuing Conversion
09:25:08 Conv/rev: Started check phase of conversion for component RSAM
09:25:08 Conv/rev: Finished check phase of conversion for component RSAMto component version 13
09:25:08 Conv/rev: Finished check phase of conversion for component RSAMto component version 14
09:25:08 Conv/rev: Finished check phase of conversion for component RSAM
09:25:08 Conv/rev: Started check phase of conversion for component SQL
09:25:08 Conv/rev: Finished check phase of conversion for component SQL
09:25:08 Conv/rev: Started check phase of conversion for component SMI
09:25:08 Conv/rev: Finished check phase of conversion for component SMI
09:25:08 Conv/rev: Started check phase of conversion for component BAR
09:25:08 Conv/rev: Finished check phase of conversion for component BAR tocomponent version 1
09:25:08 Conv/rev: Finished check phase of conversion for component BAR tocomponent version 2
09:25:08 Conv/rev: Finished check phase of conversion for component BAR
09:25:08 Conv/rev: Started check phase of conversion for component PLOAD
09:25:08 Conv/rev: Finished check phase of conversion for component PLOAD
09:25:08 Conv/rev: Started check phase of conversion for component RTREE
09:25:08 Conv/rev: Finished check phase of conversion for component RTREE
09:25:08 Conv/rev: Started check phase of conversion for component PAM
09:25:08 Conv/rev: Finished check phase of conversion for component PAM tocomponent version 2
09:25:08 Conv/rev: Finished check phase of conversion for component PAM
09:25:08 Conv/rev: Started conversion for component RSAM
09:25:08 Conversion of pre 9.2 Database Tablespaces Started
09:25:09 Started the Conversion of the Database Tablespace
09:25:09 Alter Descriptor for database structure
09:25:09 Succeeded
09:25:09 The Conversion of the Database Tablespace is Finished
09:25:09 Conversion of pre 9.2 Database Tablespaces Succeeded
09:25:09 Conversion of bfrmap Started
09:25:09 Conversion of bfrmap Succeeded
09:25:09 Conv/rev: Finished conversion for component RSAM to componentversion 13
09:25:09 Converting Secondary Partition Header Pages Started
09:25:09 Converting Secondary Partition Header Pages Succeeded
09:25:09 Conv/rev: Finished conversion for component RSAM to componentversion 14
09:25:09 Update reserved page status of conversion
09:25:09 Succeeded
09:25:10 Checkpoint Completed: duration was 0 seconds.
09:25:10 Checkpoint loguniq 59731, logpos 0x2018, timestamp: 0x833cf4fa
09:25:10 Maximum server connections 0
09:25:10 Quiescent Mode
09:25:10 Internal Conversion Completed Successfuly
09:25:10 Conversion Enabling Client Connections
09:25:10 Conv/rev: Finished conversion for component RSAM
09:25:10 Conv/rev: Started conversion for component SQL
09:25:10 processing tcis
09:25:10 Converting database tcis ...
09:25:11 Single-User Mode.
09:25:12 Logical Log 59731 Complete, timestamp: 0x833ea6e3.
09:25:15 Conv/rev: Finished conversion for component SQL to componentversion 26
09:25:15 Converting database tcis ...
09:25:16 The database tcis has been converted successfully.
09:25:16 Conv/rev: Finished conversion for component SQL to componentversion 28
09:25:16 Conv/rev: Finished conversion for component SQL to componentversion 29
09:25:19 Conversion of Violations and Diagnostic tables in database tcis
succeeded.
09:25:21 The dummy updates succeeded while converting database tcis.
09:25:21 processing terihr
09:25:21 Converting database terihr ...
09:25:21 Logical Log 59732 Complete, timestamp: 0x83405926.
09:25:23 Conv/rev: Finished conversion for component SQL to componentversion 26
09:25:23 Converting database terihr ...
09:25:23 The database terihr has been converted successfully.
09:25:23 Conv/rev: Finished conversion for component SQL to componentversion 28
09:25:23 Conv/rev: Finished conversion for component SQL to componentversion 29
09:25:25 Conversion of Violations and Diagnostic tables in database terihr
succeeded.
09:25:25 The dummy updates succeeded while converting database terihr.
09:25:25 processing tsecure
09:25:25 Conv/rev: Failed to convert component SQL to component version 26
09:25:25 Conversion failed for component SQL : entity_ver 26 != targetversion 29
09:25:25 Assert Failed: Conv/rev: Failed to convert for component SQL
09:25:25 IBM Informix Dynami