Re: Unexpected behavior
Posted in 2003
Topics: General Discussion
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
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g