Re: IDS 9.40 UC5/linux update statistics crashes engine on large table
loden@networkip.net wrote:
> Breif background:
> I am in the process of doing some migration testing from an hpux system
> running 9.21 FC7 to a linux system (fedora core 1 with customer
> mainline kernel) running 9.40 UC5.
>
> I have gone through the install and everything seems normal. Took a
> copy of one of our "smaller" databases about 12 tables all but 1 have
> less then 5k rows in them. The largest table having 15 million rows.
> Set up the database, loaded the data using load from insert into.. etc.
> Used HPL to load the large table, built the indexes on the table. Not
> a single issue (in fact I noticed that they fixed the gui for hpl
> between 9.3 and 9.4 on linux)
>
> Issue:
> This is where the problem comes in. I went to our hpux machine and ran
> dostats -h newserver -d newdb -f file.sql it connects and spits out an
> sql file. looks like it always does, I have done this a million times
> when rebuilding a table. sftp the file over to the new linux server
> add some pdqpriority and set the lock mode, etc. run it and see some
> of the statistics are updating in my output file and then the engine
> crashes. I did this a number of times, at one point the crash
> corrupted the dbspace this db was in and I had to rebuild from
> scratch.. did that yesterday, rinse repeat and the same exact thing
> happens. I found the line in the file that crashes the engine and its
> the first set of sql statements for the largest table in the database.
>
>
> UPDATE STATISTICS MEDIUM FOR TABLE big_table DISTRIBUTIONS> ONLY;
>
> I have opened a case with informix, but its not looking good so far. I
> have not been able to find much about this ids version.
>
> Here is the exact error that I recieved the first few times:
> 17:41:38 Assert Failed: No Exception Handler
> 17:41:38 IBM Informix Dynamic Server Version 9.40.UC5
> 17:41:38 Who: Session(6, informix@repsvr01b_10.prod.networkip.net,
> 1288, (nil))
> Thread(0, noname, 0, 0)
> File: mtex.c Line: 431
> 17:41:38 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 17:41:38 Action: Please notify IBM Informix Technical Support.
> 17:41:38 stack trace for pid 1253 written to /tmp/af.3cbb1
> 17:41:38 Recursive Exception - Server exiting
> 17:41:38 Recursive Exception - Server exiting
> 17:41:38 Fatal error in ADM VP at mt.c:12351
> 17:41:38 Unexpected virtual processor termination, pid = 1253, exit => 0x100
>
> 17:41:38 PANIC: Attempting to bring system down>
> Sometimes it just hangs and the engine will not respond to anything.
> The load avg (cpu usage) on the server gets high but the memory usage
> does not increase.
>
> Art, if your out there.. I read something you wrote not long ago about
> running ids 9.4 on linux.. are you using uc5 if so have you had any
> problems like this with large tables? is there a newer version of
> dostats or something different I should be doing now with 9.4?
>
> I thought it had something to do with memory at first but the engine is
> not even trying to add segments it just dies.
>
No problem with large tables, but then I didn't have any and now that I've
to our new building they've taken away my Linux box and given me a Windozer.
I was using UC3 I think.
Art S. Kagel