Re: Informix 9.4 crash

I had this type of error several times, all reproduceable. First of all: Never ever use any editor to change configuration in onconfig. Several editors use internally 16 bit unicode. So, if you edit /opt/informix/etc/onconfig, there are some strange unicode characters in it. Informix starts up, runs for some time, uses parser 1, no errors. While running, informix uses a second parser in oninit, which is not fault (unicode) tolerant, and so informix suddenly crashed. I don't know yet, at what time what procedure calls the onconfig parser, but i exactly could reproduce these errors. IBM guys couldn't help me so far, this error is hard to detect. I use redhat 8.0 with informix 9.30 UC2 and informix 9.40 UC1, both show the same error. There were even shared memory errors reported. Reason was: I edited onconfig with vim, bad. I restored the original onconfig, edited with onmonitor and informix ran stable. Apart from the fact, that after the installation i have to delete or rename /opt/informix/lib/libpthread.so.0 to get informix running (bad library). Informix developers admitted, that informix isn't seriously developed any further. At IBM germany in Munic and Mainz as well as in california many developers had to change to the db2 team. There will be 2 more versions 9.50 and 9.60, all 18 month, as usual appearing in future. After that, IBM will drop development. These versions are already finished, there are only some developers left for patches and recompilation on other platforms. When i asked for the SMP use of Informix for redhat, how to activate informix 9.30 nor 9.40 using the second processor, i got some onconfig settings, which didn't work, when i analysed the kernel at runtime. No use of a second processor possible on linux, ibm finally admitted. LINUX RedHat 8.0/9.0 has no KAIO, so one task of informix writing into a chunk (rawdevice) and one writing into a chunk at the same time does definitly not work. The block each other. Informix for many OLTP Clients with heavy load is unusable on linux, better use HPUX, SUN or AIX. AT&T UNIX alias UNIXWARE alias SCO OpenUNIX should scale much better, i will change to openlinux perhaps, if necessary. Performance will increase about 30% for 2-10 clients and much more for more clients. In the meantime i implemented KAIO in RedHat 8.0 and recompiled all libraries, kernel ... postgreSQL. PostgreSQL is much faster (expecially sorting of millions of data), has similar features (MVCC...) and runs stable. I don't know yet, if informix uses KAIO in RedHat linux.... regards, Guido Stepken dusong wrote: > OS: AIX 5.2 Informix: 64 Bit 9.4 FC1 > > After reboot the machine,I found When I start up the Informix 9.4 first > time,the oninit command failed,But the next time it will be success,I > have try to modified the shmbaseￜￜenvironment LIBPATH,But nothing > help.If I reboot the machine,the first time oninit command always > crash,I don't > know why? > > > 3:32:47 Assert Failed: No Exception Handler > 13:32:47 Informix Dynamic Server Version 9.40.FC1 > 13:32:47 Who: Session(1, informix@dev_b, 0, 70000001038d028) > Thread(7, main_loop(), 70000001034b028, 1) > File: mtex.c Line: 431 > 13:32:47 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 13:32:47 Action: Please notify Informix Technical Support. > 13:32:47 stack trace for pid 397326 written to /tmp/af.3ef06ff > 13:32:47 See Also: /tmp/af.3ef06ff, shmem.3ef06ff.0 > 13:32:51 mtex.c, line 431, thread 7, proc id 397326, No > Exception Handler. > 13:32:53 The Master Daemon Died > 13:32:53 PANIC: Attempting to bring system down> > -- > Posted via http://dbforums.com