Re: Informix must abort -- HELP SQLERROR -457

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 Try this. Create script and send it to dbaccess -------------- 8< --- cut here ------- 8< -------------- database <your database> create index <your index> -------------- 8< --- cut here ------- 8< -------------- cat your.script | dbaccess - Dbaccess prints on screen is index created or not, and if not - SQL error and ISAM code will printed > reached a limit on > the number of concurrent user sessions! > > Hartmut Max F. Bilyk