running following query throws error and crashes the server:
select
t.i,
row(
multiset(
select * from u where u.i = t.i
)
) r
from t
order by t.i;
You will get following error in your console:
9791: User Defined Routine (collectionoutput) execution failed.
Online.log:
14:03:32 Maximum server connections 1
14:03:32 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 0, Plog used 10, Llog used 2
14:10:19 Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
14:10:19 IBM Informix Dynamic Server Version 14.10.FC7W1DE
14:10:19 Who: Session(38, informix@hostname, 24921,
0x454832a8)
Thread(54, sqlexec, 45442e70, 1)
File: mtex.c Line: 481
14:10:19 Action: Please notify IBM Informix Technical Support.
14:10:19 stack trace for pid 23384 written to
/informix/products/14.10.FC7W1/tmp/af.41e3bf2
14:10:19 See Also:
/informix/products/14.10.FC7W1/tmp/af.41e3bf2, shmem.41e3bf2.0
14:10:21 Exception Caught. Type: MT_EX_OS, Context: mem
14:10:21 (-9791): ERROR: Routine execution trap --
procname= procid=18
reason: mem
14:12:08 Assert Failed: Thread exited with 1 buffers held.
14:12:08 IBM Informix Dynamic Server Version 14.10.FC7W1DE
14:12:08 Who: Session(38, informix@hostname, 24921,
0x454832a8)
Thread(54, sqlexec, 45442e70, 1)
File: rsshmem.c Line: 1990
14:12:08 Results: Dynamic Server must abort
14:12:08 stack trace for pid 23384 written to
/informix/products/14.10.FC7W1/tmp/af.41e3bf2
14:12:08 See Also:
/informix/products/14.10.FC7W1/tmp/af.41e3bf2
14:12:09 Thread ID 54 will NOT be suspended because
it is holding a buffer.
14:12:09 See Also:
/informix/products/14.10.FC7W1/tmp/af.41e3bf2
14:12:09 Starting crash time check of:
14:12:09 1. memory block headers
14:12:09 2. stacks
14:12:09 Crash time checking found no problems
14:12:09 rsshmem.c, line 1990, thread 54, proc id 23384, Thread
exited with 1 buffers held.
.
14:12:09 The Master Daemon Died
14:12:09 PANIC: Attempting to bring system down |
