Informix Java problems

People, I am running Informix 10.00.UC3W2 with Java on RHEL3. We are experiencing a problem that a Java UDR starts working and randomly it stops executing and the only way to get it working again is to restart the database server. Further to this I have executed onstat -g glo to get the vpid. [informix@mixdb-lk ontmp]$ onstat -g glo IBM Informix Dynamic Server Version 10.00.UC3W2 -- On-Line -- Up 00:03:22 --387864 Kbytes MT global info: sessions threads vps lngspins 0 30 13 0 sched calls thread switches yield 0 yield n yield forever total: 7379167 1334451 6710631 513 723 per sec: 15 10 0 7 0 Virtual processor summary: class vps usercpu syscpu total cpu 1 3.19 0.94 4.13 aio 6 0.00 0.00 0.00 lio 1 0.00 0.00 0.00 pio 1 0.00 0.00 0.00 adm 1 0.00 0.53 0.53 soc 1 0.02 0.02 0.04 msc 1 0.00 0.00 0.00 jvp 1 0.01 0.00 0.01 total 13 3.22 1.49 4.71 Individual virtual processors: vp pid class usercpu syscpu total 1 29150 cpu 3.19 0.94 4.13 2 29151 adm 0.00 0.53 0.53 3 29152 jvp 0.01 0.00 0.01 4 29153 lio 0.00 0.00 0.00 5 29154 pio 0.00 0.00 0.00 6 29155 aio 0.00 0.00 0.00 7 29156 msc 0.00 0.00 0.00 8 29157 aio 0.00 0.00 0.00 9 29158 soc 0.02 0.02 0.04 10 29159 aio 0.00 0.00 0.00 11 29160 aio 0.00 0.00 0.00 12 29161 aio 0.00 0.00 0.00 13 29162 aio 0.00 0.00 0.00 tot 3.22 1.49 4.71 [informix@mixdb-lk ontmp]$ from dbaccess I run the execute function jvpcontrol('memory 3'); (expression) Memory 15197920 bytes free, 17037824 bytes total execute function jvpcontrol('threads 3'); 9481: Internal Error: (java.lang.NegativeArraySizeException: ). Any ideas what is going wrong ? Regards Kenneth

It seems you have a bug with your Java app that raises an uncaught exception: java.lang.NegativeArraySizeException jgp > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > KENNETH PENZA > Sent: mercredi 28 mars 2007 12:14 > To: ids@iiug.org > Subject: Informix Java problems [8740] > > People, > > I am running Informix 10.00.UC3W2 with Java on RHEL3. We are > experiencing a > problem that a Java UDR starts working and randomly it stops executing > and the > only way to get it working again is to restart the database server. > > Further to this I have executed onstat -g glo to get the vpid. > > [informix@mixdb-lk ontmp]$ onstat -g glo > > IBM Informix Dynamic Server Version 10.00.UC3W2 -- On-Line -- Up > 00:03:22 --> 387864 Kbytes > > MT global info: > sessions threads vps lngspins > 0 30 13 0 > > sched calls thread switches yield 0 yield n yield forever > total: 7379167 1334451 6710631 513 723 > per sec: 15 10 0 7 0 > > Virtual processor summary: > class vps usercpu syscpu total > cpu 1 3.19 0.94 4.13 > aio 6 0.00 0.00 0.00 > lio 1 0.00 0.00 0.00 > pio 1 0.00 0.00 0.00 > adm 1 0.00 0.53 0.53 > soc 1 0.02 0.02 0.04 > msc 1 0.00 0.00 0.00 > jvp 1 0.01 0.00 0.01 > total 13 3.22 1.49 4.71 > > Individual virtual processors: > vp pid class usercpu syscpu total > 1 29150 cpu 3.19 0.94 4.13 > 2 29151 adm 0.00 0.53 0.53 > 3 29152 jvp 0.01 0.00 0.01 > 4 29153 lio 0.00 0.00 0.00 > 5 29154 pio 0.00 0.00 0.00 > 6 29155 aio 0.00 0.00 0.00 > 7 29156 msc 0.00 0.00 0.00 > 8 29157 aio 0.00 0.00 0.00 > 9 29158 soc 0.02 0.02 0.04 > 10 29159 aio 0.00 0.00 0.00 > 11 29160 aio 0.00 0.00 0.00 > 12 29161 aio 0.00 0.00 0.00 > 13 29162 aio 0.00 0.00 0.00 > > tot 3.22 1.49 4.71 > > [informix@mixdb-lk ontmp]$ > > from dbaccess I run the > execute function jvpcontrol('memory 3');> > (expression) Memory 15197920 bytes free, 17037824 bytes total > > execute function jvpcontrol('threads 3');> > 9481: Internal Error: (java.lang.NegativeArraySizeException: ).> > Any ideas what is going wrong ? > > Regards > Kenneth > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

> I am running Informix 10.00.UC3W2 with Java on RHEL3. We are experiencing a > problem that a Java UDR starts working and randomly it stops executing and the > only way to get it working again is to restart the database server. I don't know if you're still having this problem. I was having trouble sending mail for a while.. There is a known problem with the version of the JVM you are using on RHEL3. The symptoms are somewhat different though but I'm mentioning it in case the underlying cause is related... This is the problem description: IC49819: LAUNCHING A KRAKATOA (J/FOUNDATION) APPLICATION ON A LINUX SMP KERNEL CAUSES A SEGMENTATION VIOLATION ASSERTION FAILURE Error description Oninit can SEGV when launching a JVP for the first time on Linux32-bit SMP kernel with hyperthreading CPUs. The problem has been isolated to the IBM 1.4.2 Java Runtime Environment supplied with IDS. Local fix Replacing the krakatoa JRE with the latest IBM 1.4.2 JRE Service release 5 or higher resolves the problem. Problem summary Problem was in the Java Runtime Environment. Problem conclusion The problem was first fixed in version 10.00.xC6 as part of the JRE upgrade for the Daylight Saving Time changes. http://www-1.ibm.com/support/docview.wss?rs=0&q1=IC49819&uid=swg1IC49819&loc=en_ US&cs=utf-8&cc=us=en Regards Guy ----- Original Message ---- From: KENNETH PENZA <kenneth.penza@gov.mt> To: ids@iiug.org Sent: Wednesday, March 28, 2007 3:14:17 AM Subject: Informix Java problems [8740] People, I am running Informix 10.00.UC3W2 with Java on RHEL3. We are experiencing a problem that a Java UDR starts working and randomly it stops executing and the only way to get it working again is to restart the database server. Further to this I have executed onstat -g glo to get the vpid. [informix@mixdb-lk ontmp]$ onstat -g glo IBM Informix Dynamic Server Version 10.00.UC3W2 -- On-Line -- Up 00:03:22 --387864 Kbytes MT global info: sessions threads vps lngspins 0 30 13 0 sched calls thread switches yield 0 yield n yield forever total: 7379167 1334451 6710631 513 723 per sec: 15 10 0 7 0 Virtual processor summary: class vps usercpu syscpu total cpu 1 3.19 0.94 4.13 aio 6 0.00 0.00 0.00 lio 1 0.00 0.00 0.00 pio 1 0.00 0.00 0.00 adm 1 0.00 0.53 0.53 soc 1 0.02 0.02 0.04 msc 1 0.00 0.00 0.00 jvp 1 0.01 0.00 0.01 total 13 3.22 1.49 4.71 Individual virtual processors: vp pid class usercpu syscpu total 1 29150 cpu 3.19 0.94 4.13 2 29151 adm 0.00 0.53 0.53 3 29152 jvp 0.01 0.00 0.01 4 29153 lio 0.00 0.00 0.00 5 29154 pio 0.00 0.00 0.00 6 29155 aio 0.00 0.00 0.00 7 29156 msc 0.00 0.00 0.00 8 29157 aio 0.00 0.00 0.00 9 29158 soc 0.02 0.02 0.04 10 29159 aio 0.00 0.00 0.00 11 29160 aio 0.00 0.00 0.00 12 29161 aio 0.00 0.00 0.00 13 29162 aio 0.00 0.00 0.00 tot 3.22 1.49 4.71 [informix@mixdb-lk ontmp]$ from dbaccess I run the execute function jvpcontrol('memory 3'); (expression) Memory 15197920 bytes free, 17037824 bytes total execute function jvpcontrol('threads 3'); 9481: Internal Error: (java.lang.NegativeArraySizeException: ). Any ideas what is going wrong ? Regards Kenneth ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Don't get soaked. Take a quick peek at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather