IDS Forum

INdex creation crashing server after sco image

Posted By: JOHN HALKO
Date: Wednesday, 10 December 2003, at 12:39 p.m.

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

Messages In This Thread

• INdex creation crashing server after sco image
  JOHN HALKO -- Wednesday, 10 December 2003, at 12:39 p.m.
  • RE: INdex creation crashing server after sco image
    Tim Bragg -- Monday, 22 December 2003, at 8:36 a.m.
  • RE: INdex creation crashing server after sco image
    Tim Bragg -- Monday, 22 December 2003, at 9:13 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.