Re: Informix 9.4 crash

...This does not suprise me too much... (if it is true, of course) Chucho! Guido Stepken wrote: > 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 > > > > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list