Re: Unexpected behavior

Marco Greco asks to see the stack. Here are the onstat -g stk output for both threads: dgintel1:> onstat -g stk 469 Informix Dynamic Server Version 7.31.UD4 -- On-Line (Prim) -- Up 1 days 12:56:37 -- 442496 Kbytes Stack for thread: 469 srvinfx base: 0x3a06c000 len: 73728 pc: 0x0837288a tos: 0x3a07dda8state: sleeping vp: 3 0x08374c05 (oninit)mt_yield(0x30285a9c, 0x302a667c, 0x30285a9c) 0x082c4085 (oninit)tx_txwait(0xffffffff, 0x302a667c, 0x20008800) 0x082c154e (oninit)isattach(0x30285a9c, 0x302a667c, 0x1) 0x080e1040 (oninit)sqisattach(0x3a07dee8, 0x38b63270, 0x0) 0x081821ce (oninit)initdistrib(0x3a07dee8, 0x38b63270, 0x0) 0x0817f63a (oninit)init_sqscb(0x3a07dee8, 0x38b63270, 0x0) 0x0817eec9 (oninit)sqmain (0x3a07dfa4, 0x3a07dfa0, 0x7) 0x0837aff2 (oninit)startup (0x0, 0x0, 0x0) dgintel1:> onstat -g stk 468 Informix Dynamic Server Version 7.31.UD4 -- On-Line (Prim) -- Up 1 days 12:56:45 -- 442496 Kbytes Stack for thread: 468 sqlexec base: 0x3a050000 len: 73728 pc: 0x0837288a tos: 0x3a060e30state: cond wait vp: 0 0x08375ee5 (oninit)mt_wait (0x3a62b890, 0x375e9488, 0x3a060e7c) 0x083ab291 (oninit)net_buf_get(0x3a62b890, 0x39df1be8, 0xffffffff) 0x083cf83b (oninit)recvtli (0x30e8b068, 0x1, 0x375e9288) 0x083e141b (oninit)tlRecv (0x375e9310, 0x375e9288, 0x3a1a6170) 0x083dffd1 (oninit)slSQIreqS(0x3a1a6170, 0x375e9288, 0x3a1a6058) 0x083dfca8 (oninit)slSQIreqDone(0x3a1a6170, 0x3a1a6058, 0x39f780cc) 0x083ddf17 (oninit)slSQIreq(0x3a1a6170, 0x0, 0x39f78058) 0x083d9508 (oninit)pfConReq(0x3a1a6170, 0x101, 0x3a06103c) 0x083d4424 (oninit)cmReqSync(0x3a1a6170, 0x3a06201c, 0x3a0615cc) 0x083d2a40 (oninit)cmConReq(0x3a1a6170, 0x3a0615cc, 0x3a062018) 0x083d0832 (oninit)ascRequest(0x3a1a6170, 0x3a0615cc, 0x3a061290) 0x083a1e9b (oninit)ASF_Call(0x3a1a6170, 0x3a1a60d0, 0x3a0615c8) 0x080de3b4 (oninit)dd_newconnect(0x3a06139c, 0x3a0615c8, 0x30) 0x080deb34 (oninit)dd_remconnect(0x3a061a7c, 0x3a06ffff, 0x3a06ffff) 0x080d084d (oninit)remcatalog(0x39f8da48, 0x39f8da18, 0x0) 0x080c2b4d (oninit)readtab (0x3a061cd8, 0x3a061c20, 0x3a061cc8) 0x080c33e4 (oninit)ddgettable(0x3a061cd8, 0x0, 0xffffffff) 0x080be13d (oninit)aud_ddgettable(0x3a061de4, 0x3a061d80, 0x0) 0x0819720c (oninit)gettab (0x3a061de4, 0x3a061d80, 0x0) 0x081a91cd (oninit)tlgetddtab(0x39f92030, 0x3a061de4, 0x3a061dd4) 0x081aa1db (oninit)spgettab(0x39f8daa0, 0x39f92030, 0x3a061e48) 0x081a9c3e (oninit)tlp2tnode(0x39f8daa0, 0x39f92030, 0x3a061e48) 0x081a982d (oninit)tbl2tab (0x39f919d0, 0x39fab390, 0x0) 0x081a5da7 (oninit)sel2cb (0x39f919d0, 0x39f92030, 0x39fab160) 0x081a57d7 (oninit)qblk2cb (0x39fab130, 0x39f92030, 0x0) 0x081a0e6a (oninit)stmt2cb (0x39fab1e8, 0x39f92030, 0x39f92030) 0x081a0ac8 (oninit)p_sp2cb (0x39fab210, 0x39f92030, 0x0) 0x0817044f (oninit)parsecmd(0x39fab210, 0x39f92030, 0x0) 0x0817009e (oninit)sqcmd (0x0, 0x0, 0xc) 0x0816ff47 (oninit)sq_cmnd (0x0, 0x0, 0x2) 0x0817f0c9 (oninit)sqmain (0x7, 0x1, 0x0) 0x0837aff2 (oninit)startup (0x0, 0x0, 0x0) Art S. Kagel sending to informix-list