Re: Informix must abort -- HELP SQLERROR -457

Thank you for this tip. We have only one processor on this machine( of couse i forgot to say it), therefor this varable will be ignored (The Administrator Guide say's). Hartmut Stefan Weideneder schrieb in Nachricht <35B37A4B.7E112728@weideneder.de>... >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 -> > >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