Re: Informix must abort -- HELP SQLERROR -457

Hi Hartmut, I have no idea of the error. Did you set PSORT_NPROCS to a very large number of processes ? You can try to create the index from the root, instead of the leaves. But this can just be a workaround. $ export NOSORTINDEX=1 $ echo "create index idx01 on yourtable(yourfield)"|dbaccess yourdb - Bye Stefan Weideneder Hartmut Wieczorek wrote: > > Hi all, > My Informix Online 5.08 go into ABORT MODE while creating a new index > on a table with about 2.900.000 rows. > 17:17:52 Process Aborted Abnormally: pid=7033 user=104 us=40001ecc > flags=101 > 17:17:52 Process Aborted Abnormally (critical section): pid=7033 user=104 > flags=101> It's running on OS SINIX 5.42. > I set the unlimite partameters to unlimeted, and DBTEMP is big enough. > I have add a new chunk for dbspace, but this error comes again. > > I get the SQLError > -------- > -457 Database server terminated unexpectedly. > The database server process or thread with which your application > program was working has terminated. The DBA may have shut the > system down. The next most likely cause is an internal error. Look > for operating system messages that might give more information. If > the error recurs, please note all circumstances and contact the > Informix Technical Support Department. > Note: Be sure to check the ISAM error code returned with this error. If it > is > -129, the database server has not terminated, but simply reached a limit on > the number of concurrent user sessions (see the explanation of error -129). > ------------ > I don't know how to get (and check) this ISAM error, but I'm sure NOT to > reached a limit on > the number of concurrent user sessions! > > Hartmut