INdex creation crashing server after sco image

I am running IDS 7.31.UD5 on Unixware 7.1.3. Everything was fine until I applied the Maintenance pack 3 and the the nd and nics updates posted by SCO at http://www.sco.com/support/update/download/uw713list.html which for some reason I am unabel to get to right now. After the install all seemed well until I tried to copy a live DB to a training DB using dbexport and dbimport. Dbexport works fine. When I try to do the import the process crashes shared memory while trying to create a second index on some of our larger tables. An example table is shown below. I am attaching the af. file as well. I can make the same crash happen, by just running the create index command against the table in DBaccess. Some how it seems I have buggered up shared memory with the SCO updates. Any ideas on how I can get the dbipotrs to work or why the index creation is crashing the instance? I tried reinstalling the IDS, but that did not help. THe crash happens the same on both of the following connection types: DBSERVERNAME aspdb03 # Name of default database server DBSERVERALIASES peitws03,ipcdb03 # List of alternate dbservernames NETTYPE ipcshm,7,200,CPU # Configure poll thread(s) for nettype NETTYPE tlitcp,7,200,NET # Configure poll thread(s) for nettype Thanks Much Tim Bragg. OS: UnixWare aspdb03 5 7.1.3 i386 x86at SCO UNIX_SVR5 Installed the following "recommended" updates from SCO uw713mp3.image nics.713c.pkg nd.713c.pkg Table: First Index creates fine. Second Index crashed Shared Memory (See af file below) I can create the table and load the data without the index and apply the first index fine. When I manually try to add the second index "kablooey". Same as when I try dbimport. { TABLE "informix".detdist row size = 66 number of columns = 13 index size = 79} { unload file name = detdi00163.unl number of rows = 460351 } create table "informix".detdist ( empl_no integer, pay_date date, rec_type char(1), orgn_proj char(16), acct char(8), offset char(8), code char(4), amount decimal(10,2) not null , check_no char(9), paygroup char(1), void_man char(1), pay_run char(3), redist char(1) ) extent size 32325 next size 24243 lock mode page; revoke all on "informix".detdist from "public"; create index "informix".detdist_tx on "informix".detdist (empl_no, pay_run,rec_type,orgn_proj,acct,code); create index "informix".i_detdst2 on "informix".detdist (check_no); Informix: INFORMIX LIBASF LIBRARY Version 9.40.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX ODBC LIBRARY Version 3.32.0000.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX C++ API 2.80.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX-Client SDK Version 2.50.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX LIBDMI LIBRARY Version 2.30.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX EMBEDDED SQL for C Version 9.40.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX LIBGEN LIBRARY Version 9.40.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX LIBGLS LIBRARY Version 3.10.UC2 Copyright (C) 1991-2000 Informix Software, Inc. Informix Dynamic Server Version 7.31.UD5 Copyright (C) 1986-2002 Informix Software, Inc. INFORMIX LIBOS LIBRARY Version 9.40.UC2 Copyright (C) 1991-2000 Informix Software, Inc. INFORMIX LIBSQL LIBRARY Version 9.40.UC2 Copyright (C) 1991-2000 Informix Software, Inc. Top of af tile: 00:47:55 00:47:55 Informix Dynamic Server Version 7.31.UD5 Software Serial Number AC P#J347659 00:47:55 Assert Failed: No Exception Handler 00:47:55 Who: Session(29, informix@, 1851, 829408524) Thread(110, sqlexec, 316da1ac, 5) File: mtex.c Line: 454 00:47:55 Results: Exception Caught. Type: MT_EX_OS, Context: mem 00:47:55 Action: Please notify Informix Technical Support. --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type: CRASH Host Name: aspdb03 Database Server Name: NULL Time of failure: Wed Dec 10 00:47:55 EST 2003 AF file: /exportfs/dbtemp/af.456b38a Shared memory file: None System Blocking: OFF

Hello all: More info on this problem, which I still have. If I run the operations in the order create table, create all the indexes, load the data it works fine. If I do thinks in the dbimport order create table, load data, create indexes, shared memory dumps on the seond index and a reboot is required to get the engine back up. We are building a test box to see if we can track down the cause, but in the mean time I have been working to diagnose the problem on our existing servers. I have now created a database (partial database) with DBimport that is corrupted. I owuld like to remove the database entirely from the instance as it is just a test db anyway. If I try to drop it with dbaccess the engine crashes. If I run oncheck -cI I get: # oncheck -cI btltryValidating indexes for btltry:informix.systables... oncheck failure: sqopendb()Unknown error message 0. Error reading from network Abnormal end !!! Does anyone out there have a way for me to remove this db without having to restore from ontape? Thanks Tim Bragg. -----Original Message----- From: "JOHN HALKO" <jjhalko@hotmail.com> Sent: Wednesday, December 10, 2003 12:40 PM To: <ids@iiug.org> Subject: INdex creation crashing server after sco image [2335] I am running IDS 7.31.UD5 on Unixware 7.1.3. Everything was fine until I applied the Maintenance pack 3 and the the nd and nics updates posted by SCO at http://www.sco.com/support/update/download/uw713list.html which for some reason I am unabel to get to right now. After the install all seemed well until I tried to copy a live DB to a training DB using dbexport and dbimport. Dbexport works fine. When I try to do the import the process crashes shared memory while trying to create a second index on some of our larger tables. An example table is shown below. I am attaching the af. file as well. I can make the same crash happen, by just running the create index command against the table in DBaccess. Some how it seems I have buggered up shared memory with the SCO updates. Any ideas on how I can get the dbipotrs to work or why the index creation is crashing the instance? I tried reinstalling the IDS, but that did not help. THe crash happens the same on both of the following connec! tion types: DBSERVERNAME aspdb03 # Name of default database server DBSERVERALIASES peitws03,ipcdb03 # List of alternate dbservernames NETTYPE ipcshm,7,200,CPU # Configure poll thread(s) for nettype NETTYPE tlitcp,7,200,NET # Configure poll thread(s) for nettype Thanks Much Tim Bragg. OS: UnixWare aspdb03 5 7.1.3 i386 x86at SCO UNIX_SVR5 Installed the following "recommended" updates from SCO uw713mp3.image nics.713c.pkg nd.713c.pkg Table: First Index creates fine. Second Index crashed Shared Memory (See af file below) I can create the table and load the data without the index and apply the first index fine. When I manually try to add the second index "kablooey". Same as when I try dbimport. { TABLE "informix".detdist row size = 66 number of columns = 13 index size = 79} { unload file name = detdi00163.unl number of rows = 460351 } create table "informix".detdist ( empl_no integer, pay_date date, rec_type char(1), orgn_proj char(16), acct char(8), offset char(8), code char(4), amount decimal(10,2) not null , check_no char(9), paygroup char(1), void_man char(1), pay_run char(3), redist char(1) ) extent size 32325 next size 24243 lock mode page; revoke all on "informix".detdist from "public";create index "informix".detdist_tx on "informix".detdist (empl_no, pay_run,rec_type,orgn_proj,acct,code); create index "informix".i_detdst2 on "informix".detdist (check_no); Informix: INFORMIX LIBASF LIBRARY Version 9.40.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX ODBC LIBRARY Version 3.32.0000.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX C++ API 2.80.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX Client SDK Version 2.50.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX LIBDMI LIBRARY Version 2.30.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX EMBEDDED SQL for C Version 9.40.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX LIBGEN LIBRARY Version 9.40.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX LIBGLS LIBRARY Version 3.10.UC2 Copyright (C) 1991 2000 Informix Software, Inc. Informix Dynamic Server Version 7.31.UD5 Copyright (C) 1986 2002 Informix Software, Inc. INFORMIX LIBOS LIBRARY Version 9.40.UC2 Copyright (C) 1991 2000 Informix Software, Inc. INFORMIX LIBSQL LIBRARY Version 9.40.UC2 Copyright (C) 1991 2000 Informix Software, Inc. Top of af tile: 00:47:55 00:47:55 Informix Dynamic Server Version 7.31.UD5 Software Serial Number AC P#J347659 00:47:55 Assert Failed: No Exception Handler 00:47:55 Who: Session(29, informix@, 1851, 829408524) Thread(110, sqlexec, 316da1ac, 5) File: mtex.c Line: 454 00:47:55 Results: Exception Caught. Type: MT_EX_OS, Context: mem 00:47:55 Action: Please notify Informix Technical Support. Begin System Alarm Program Output Assertion Failure Type: CRASH Host Name: aspdb03 Database Server Name: NULL Time of failure: Wed Dec 10 00:47:55 EST 2003 AF file: /exportfs/dbtemp/af.456b38a Shared memory file: None System Blocking: OFF

More info on corrupt DB: I created this database with dbimport, which crashed as I have discussed earlier. oncheck -cD btltry gives the following: TBLspace data check for btltry:informix.systables ERROR: Tablespace 0xb014f3. Page 0x8 appears to be of type "freed", which is out of sync with its bitmap representation (0x8). WARNING: The header of this page may have been corrupted. Resetting the bitmap may not fully repair the problem and may even result in more data corruption. Reset the bitmap mode for this page? y WARNING: The bitmap mode for page 0x8 has been reset from 0x8 to 0. ERROR: Tablespace 0xb014f3. Page 0x9 appears to be of type "freed", which is out of sync with its bitmap representation (0xc). WARNING: The header of this page may have been corrupted. Resetting the bitmap may not fully repair the problem and may even result in more data corruption. Reset the bitmap mode for this page? y WARNING: The bitmap mode for page 0x9 has been reset from 0xc to 0. ERROR: Tablespace 0xb014f3. Page 0xa appears to be of type "freed", which is out of sync with its bitmap representation (0x8). WARNING: The header of this page may have been corrupted. Resetting the bitmap may not fully repair the problem and may even result in more data corruption. Reset the bitmap mode for this page? y WARNING: The bitmap mode for page 0xa has been reset from 0x8 to 0. Modifying TBLspace statistics(pn_nrows): OLD 58 NEW 80 Partition data is bad. Ok to repair it? y ERROR:Data page count 5 != pn_npdata 4 Partition data is bad. Ok to repair it? y TBLspace data check for btltry:informix.syscolumns TBLspace data check for btltry:informix.sysindexes ERROR: Tablespace 0xb014f5. Page 0x8 appears to be of type "freed", which is out of sync with its bitmap representation (0xc). WARNING: The header of this page may have been corrupted. Resetting the bitmap may not fully repair the problem and may even result in more data corruption. Reset the bitmap mode for this page? y WARNING: The bitmap mode for page 0x8 has been reset from 0xc to 0. ERROR: Tablespace 0xb014f5. Page 0x9 appears to be of type "freed", which is out of sync with its bitmap representation (0x8). WARNING: The header of this page may have been corrupted. Resetting the bitmap may not fully repair the problem and may even result in more data corruption. Reset the bitmap mode for this page? y WARNING: The bitmap mode for page 0x9 has been reset from 0x8 to 0. Modifying TBLspace statistics(pn_nrows): OLD 71 NEW 93 Partition data is bad. Ok to repair it? y ERROR:Data page count 4 != pn_npdata 3 Partition data is bad. Ok to repair it? y TBLspace data check for btltry:informix.systabauth TBLspace data check for btltry:informix.syscolauth TBLspace data check for btltry:informix.sysviews TBLspace data check for btltry:informix.sysusers TBLspace data check for btltry:informix.sysdepend TBLspace data check for btltry:informix.syssynonyms TBLspace data check for btltry:informix.syssyntable TBLspace data check for btltry:informix.sysconstraints TBLspace data check for btltry:informix.sysreferences TBLspace data check for btltry:informix.syschecks TBLspace data check for btltry:informix.sysdefaults TBLspace data check for btltry:informix.syscoldepend TBLspace data check for btltry:informix.sysprocedures TBLspace data check for btltry:informix.sysprocbody TBLspace data check for btltry:informix.sysprocplan TBLspace data check for btltry:informix.sysprocauth TBLspace data check for btltry:informix.sysblobs TBLspace data check for btltry:informix.sysopclstr TBLspace data check for btltry:informix.systriggers TBLspace data check for btltry:informix.systrigbody TBLspace data check for btltry:informix.sysdistrib TBLspace data check for btltry:informix.sysfragments TBLspace data check for btltry:informix.sysobjstate TBLspace data check for btltry:informix.sysviolations TBLspace data check for btltry:informix.sysfragauth TBLspace data check for btltry:informix.sysroleauth TBLspace data check for btltry:informix.sectb_package TBLspace data check for btltry:informix.sectb_subpack TBLspace data check for btltry:informix.dattb_acc_titles TBLspace data check for btltry:informix.syscolval TBLspace data check for btltry:informix.syscolatt TBLspace data check for btltry:informix.activity_det TBLspace data check for btltry:informix.activity_hdr TBLspace data check for btltry:informix.caldays TBLspace data check for btltry:informix.rc_rank TBLspace data check for btltry:informix.absence_codes TBLspace data check for btltry:informix.dat_letter_crit TBLspace data check for btltry:informix.rc_level_hdr TBLspace data check for btltry:informix.pei_honor_flags TBLspace data check for btltry:informix.rc_level TBLspace data check for btltry:informix.regtb_curr_code TBLspace data check for btltry:informix.regtb_daytype TBLspace data check for btltry:informix.regtb_disability TBLspace data check for btltry:informix.regtb_entry TBLspace data check for btltry:informix.regtb_error TBLspace data check for btltry:informix.regtb_ethnic_codes TBLspace data check for btltry:informix.regtb_grade TBLspace data check for btltry:informix.regtb_guardian TBLspace data check for btltry:informix.regtb_language TBLspace data check for btltry:informix.regtb_living_with TBLspace data check for btltry:informix.regtb_med_alert TBLspace data check for btltry:informix.regtb_residency TBLspace data check for btltry:informix.regtb_travel TBLspace data check for btltry:informix.regtb_withdrawal TBLspace data check for btltry:informix.rctb_marks TBLspace data check for btltry:informix.pei_rc_status TBLspace data check for btltry:informix.pei_background TBLspace data check for btltry:informix.dat_cfg TBLspace data check for btltry:informix.reg_rooms TBLspace data check for btltry:informix.rc_conflicts TBLspace data check for btltry:informix.rc_rank_setup TBLspace data check for btltry:informix.schdtb_day_cycles TBLspace data check for btltry:informix.sectb_user TBLspace data check for btltry:informix.schdtb_time_per TBLspace data check for btltry:informix.sectb_privilege TBLspace data check for btltry:informix.rctb_fixed_com TBLspace data check for btltry:informix.regtb_screen_spec TBLspace data check for btltry:informix.regcrit TBLspace data check for btltry:informix.regtb_criteria TBLspace data check for btltry:informix.disc_cfg TBLspace data check for btltry:informix.trn_comments TBLspace data check for btltry:informix.trn_gradreq TBLspace data check for btltry:informix.trntb_req_group TBLspace data check for btltry:informix.rc_hdr # -----Original Message----- From: "JOHN HALKO" <jjhalko@hotmail.com> Sent: Wednesday, December 10, 2003 12:40 PM To: <ids@iiug.org> Subject: INdex crea