the server crashes with null in bytes fields

This is a multi-part message in MIME format. --------------5E9D6B2A2CD7E3D588F78C65 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have installed Informix Dinamic server 7.3 in a intel pentium with redhat 5.2 with patches. The client is made in java and the driver jdbc is the informix jdbc driver 1.22 version The server appears go well. But If I execute a stored statement that returns bytes and other type of values, the server crashes(if all the byte (text)values are not null, the execution goes well). Jdbc returns me blob not found. Do you know what is it? Resuming ,the problem takes place when I execute a stored statement (in java)what returns a lot rows witch had fields with type byte and someone are null. (If it is one value only , the server no crashes or all the values are not null) the database send this error(af.2379ec) 13:15:40 13:15:40 Informix Dynamic Server Version 7.30.U Software SerialNumber AAB# J660836 13:15:41 Assert Failed: No Exception Handler 13:15:41 Who: Session(11, dba@sierra.ait.uvigo.es, -1, 0) Thread(35, sqlexec, 0, 1) File: mtex.c Line: 314 13:15:41 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:15:41 Action: Please notify Informix Technical Support. --------------------------------- online.log 13:11:05 Dataskip is now OFF for all dbspaces 13:11:05 On-Line Mode 13:11:07 Checkpoint Completed: duration was 1 seconds. 13:15:40 Assert Failed: No Exception Handler 13:15:41 Informix Dynamic Server Version 7.30.U 13:15:41 Who: Session(11, dba@sierra.ait.uvigo.es, -1, 0) Thread(35, sqlexec, 0, 1) File: mtex.c Line: 314 13:15:41 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:15:41 Action: Please notify Informix Technical Support. 13:16:11 See Also: /tmp/af.2379ec, shmem.2379ec.0 13:16:49 mtex.c, line 314, thread 35, proc id 15072, No Exception Handler. 13:16:53 PANIC: Attempting to bring system down Fri Nov 26 13:27:26 1999 13:27:26 sym.out file is corrupted.Anticipated thanks. --------------5E9D6B2A2CD7E3D588F78C65 Content-Type: text/plain; charset=us-ascii; name="af.2379ec" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="af.2379ec" 13:15:40 13:15:40 Informix Dynamic Server Version 7.30.U Software Serial Number AAB#J660836 13:15:41 Assert Failed: No Exception Handler 13:15:41 Who: Session(11, dba@sierra.ait.uvigo.es, -1, 0) Thread(35, sqlexec, 0, 1) File: mtex.c Line: 314 13:15:41 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:15:41 Action: Please notify Informix Technical Support. --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type:\\t\\c CRASH Host Name:\\t\\tsierra.ait.uvigo.es Database Server Name:\\tol_sierra Time of failure:\\t\\c Fri Nov 26 13:15:52 CET 1999 AF file:\\t\\t/tmp/af.2379ec Shared memory file:\\tNone System Blocking:\\t\\c OFF ===========------------- - - - - - - tail -100 /opt/informix/online.log: Fri Nov 26 13:10:52 1999 13:10:52 Event alarms enabled. ALARMPROG = '/opt/informix/etc/log_full.sh' 13:10:59 DR: DRAUTO is 0 (Off) 13:10:59 Informix Dynamic Server Version 7.30.U Software Serial Number AAB#J660836 13:11:00 Informix Dynamic Server Initialized -- Shared Memory Initialized. 13:11:00 Physical Recovery Started. 13:11:01 Physical Recovery Complete: 0 Pages Restored. 13:11:01 Logical Recovery Started. 13:11:04 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 13:11:05 Onconfig parameter MSGPATH modified from /usr/informix/online.log to /opt/informix/online.log. 13:11:05 Onconfig parameter LOCKS modified from 2000 to 3000. 13:11:05 Onconfig parameter BUFFERS modified from 200 to 300. 13:11:05 Onconfig parameter ALARMPROGRAM modified from /usr/informix/etc/log_full.sh to /opt/informix/etc/log_full.sh. 13:11:05 Dataskip is now OFF for all dbspaces 13:11:05 On-Line Mode 13:11:07 Checkpoint Completed: duration was 1 seconds. 13:15:40 Assert Failed: No Exception Handler 13:15:41 Informix Dynamic Server Version 7.30.U 13:15:41 Who: Session(11, dba@sierra.ait.uvigo.es, -1, 0) Thread(35, sqlexec, 0, 1) File: mtex.c Line: 314 13:15:41 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:15:41 Action: Please notify Informix Technical Support. ===========------------- - - - - - - /opt/informix/bin/onstat -g ath: Informix Dynamic Server Version 7.30.U -- On-Line -- Up 00:05:02 -- 9184 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 102321e0 0 2 sleeping forever 3lio vp 0 3 10232414 0 2 sleeping forever 4pio vp 0 4 10232648 0 2 sleeping forever 5aio vp 0 5 1023287c 0 2 sleeping forever 6msc vp 0 6 10232ad0 0 2 sleeping forever 7aio vp 1 7 10232e08 1016a014 4 ready 1cpu main_loop() 8 102335c8 0 2 sleeping forever 1cpu soctcppoll 9 10233afc 0 3 sleeping forever 1cpu soctcplst 10 10248228 1016a4c8 2 sleeping forever 1cpu flush_sub(0) 11 102487dc 0 2 sleeping forever 8aio vp 2 12 10248a30 0 2 sleeping forever 9aio vp 3 13 10248c84 0 2 sleeping forever 10aio vp 4 14 10248ed8 0 2 sleeping forever 11aio vp 5 15 102492a8 1016a97c 3 sleeping forever 1cpu aslogflush 16 102495e0 1016ae30 2 sleeping secs: 8 1cpu btclean 32 10264574 1016bc4c 4 ready 1cpu onmode_mon 34 10264cf4 1016b798 2 cond wait netnorm 1cpu sqlexec *35 10265a04 1016b2e4 2 running 1cpu sqlexec ===========------------- - - - - - - /opt/informix/bin/onstat -g stk 35 light: Informix Dynamic Server Version 7.30.U -- On-Line -- Up 00:05:02 -- 9184 Kbytes Stack for thread: 35 sqlexec base: 0x10434228 len: 33280 pc: 0x082b7691 tos: 0x1043ba90state: running vp: 1 0x082b7691 (oninit)mt_system(0x1043bed8, 0x8404054, 0x10265ac4, 0x1043c3c0, 0x1, 0x1) 0x082cc228 (oninit)afhandler(0x3, 0x8438b86, 0x1043c144, 0x1039996c, 0x0, 0x0) 0x082cbe3d (oninit)afcrash_interface(0x8438b86, 0x1043c144, 0x1039996c, 0x8438b7f, 0x13a, 0x1043c144) 0x082ce853 (oninit)mt_ex_throw_sig(0x1, 0x8404054, 0x0, 0xb, 0x805baa4, 0x1043c370) 0x0805bac1 (oninit)afsig_segv(0xb, 0x2b, 0x2b, 0x2b, 0x2b, 0x1043c3c0) 0x1043c2c4 (***nosymtab***)0x1043c2c4(0x0, 0x1, 0x1, 0x1043c3a4, 0x8143cf2, 0x1043c3c0) 0x08145bc6 (oninit)remsblob(0x1043c3c0, 0x1, 0x1043c3c0, 0x4, 0x400f3404, 0x0) 0x08143cf2 (oninit)cpblob2pipe(0x1043c3c0, 0x0, 0x1, 0x1043c3c0, 0x26, 0x0) 0x08143caa (oninit)sq_fetchblob(0x0, 0x0, 0x0, 0x1039ac60, 0x1, 0x1043c420) 0x08104d25 (onini

"Enrique Estevez Cuntin (Martin)" wrote: > > I have installed Informix Dinamic server 7.3 in a intel pentium with > redhat 5.2 with patches. The client is made in java and the driver jdbc > > is the informix jdbc driver 1.22 version > The server appears go well. But If I execute a stored statement that > returns bytes and other type of values, the server crashes(if all the > byte (text)values are not null, the execution goes well). Jdbc > returns me blob not found. > Do you know what is it? > Resuming ,the problem takes place when I execute a stored statement (in > > java)what returns a lot rows witch had fields with type byte and > someone are null. (If it is one value > only , the server no crashes or all the values are not null) > the database send this error(af.2379ec) > 13:15:40 > 13:15:40 Informix Dynamic Server Version 7.30.U Software Serial> Number AAB# > J660836 > > 13:15:41 Assert Failed: No Exception Handler > 13:15:41 Who: Session(11, dba@sierra.ait.uvigo.es, -1, 0) > Thread(35, sqlexec, 0, 1) > File: mtex.c Line: 314 > 13:15:41 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 13:15:41 Action: Please notify Informix Technical Support. [SNIP] First please try not to post MIME. Now, looks like the engine could not allocate enough memory to load some blob, or set of blobs, into memory for transfer to the ODBC interface. How much free RAM and/or swap do you have on the system with the engine online? Art S. Kagel