Re: onmode -Y
Finally got a stack for one of these:
It keeps flipping between:
Stack for thread: 431744 sqlexec
base: 0x07000003a1924000
len: 36864
pc: 0x0000000100056518
tos: 0x07000003a192bd80state: running
vp: 6
0x0000000000000000
this:
Stack for thread: 431744 sqlexec
base: 0x07000003a1924000
len: 36864
pc: 0x0000000100056518
tos: 0x07000003a192bd70state: running
vp: 7
0x00000001000563b0 (oninit)yield_processor_mvp(0x7, 0x110209f18, 0x0, 0x110209f18, 0x110209f20, 0x100, 0x0, 0x7)
0x0000000000000000
and
Stack for thread: 431744 sqlexec
base: 0x07000003a1924000
len: 36864
pc: 0x0000000100056518
tos: 0x07000003a192bd70state: running
vp: 6
0x07000003a0385328 (*nosymtab*)0x7000003a0385328(0x100, 0x7000003a192bfc0, 0x7000003a0385220, 0x0, 0x0, 0x110001748, 0x7, 0x110209f18)
0x00000001005e598c (oninit)new_eval(0x7000003a192c000, 0x1101ff468, 0x7000003a192c010, 0x7000002a22afc20, 0x7000003a192c050, 0x0, 0x1002d4530, 0x1)
0x000000010041e3ac (oninit)gettupl (0x7000003a192c180, 0x7000000100bc6a8, 0x7000003a192c1b0, 0x70000038e7c3598, 0x70000039d4435f8, 0x0, 0x7000003a192c590, 0x0)
0x00000001004205b8 (oninit)scan_next(0x7000003a192c280, 0x70000039d4435f8, 0x1009fbb9c, 0x0, 0x100a00d2c, 0x110209f20, 0x100506dc4, 0x7000003a18b1628)
0x00000001005eb310 (oninit)getrow (0x9, 0x0, 0x0, 0x42802221, 0x0, 0x0, 0x7000003a192c360, 0x7000003a18b1628)
0x00000001005eec88 (oninit)fetchrow(0x7000003a192c3e0, 0x10, 0x1005ad6cc, 0x1, 0x2, 0x1100d1d98, 0x0, 0x70000001014c000)
0x00000001005ae0d0 (oninit)exfetch (0x11020e8e0, 0x1100d1d98, 0x710209f20, 0x110209f08, 0xffff00001014c000, 0x700000349597ad8, 0x7000003a192c560, 0x22202228100d1d98)
0x00000001003ef68c (oninit)sql_nfetch(0xff700001000, 0x100000001, 0x0, 0xffffffffffffff7f, 0xfffffffffffdffff, 0x1, 0x11020e8e0, 0x1100d1d98)
0x00000001003efbac (oninit)sq_nfetch(0x7000002a002a028, 0x7000003a0dc9cc8, 0x7000003a192c6d0, 0x48004000a192c744, 0x10005ea90, 0x110209d60, 0x7000003a192c6d0, 0x1101ff468)
0x000000010027c57c (oninit)sqmain (0x0, 0x700000345e9bb14, 0xcd000000cd, 0x0, 0x7000003a192c744, 0x0, 0x0, 0x0)
0x000000010024d884 (oninit)spawn_thread(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x0000000100a315c4 (oninit)startup (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Home: 703-430-0805
Cell: 703-477-6045
========================
http://www.one.org/
----- Original Message ----
From: "david@smooth1.co.uk" <david@smooth1.co.uk>
To: informix-list@iiug.org
Sent: Saturday, April 14, 2007 5:03:11 PM
Subject: Re: onmode -Y
On 14 Apr, 02:04, Floyd Wellershaus <fwell...@yahoo.com> wrote:
> First stack, while it was doing an insert to one table:
> Stack for thread: 660906 sqlexec
> base: 0x07000003989dc000
> len: 36864
> pc: 0x0000000100056518
> tos: 0x07000003989e2c70> state: running
> vp: 4
> 0x0000000000000000
>
> Next stack, when the process is hung, while it is doing an insert into another table ( and the last query is not in the explain.out.
>
> Stack for thread: 660906 sqlexec
> base: 0x07000003989dc000
> len: 36864
> pc: 0x0000000100056518
> tos: 0x07000003989e2c70> state: running
> vp: 4
> 0x0000000000000000
>
> ========================
> -<<Floyd Wellershaus>>-
> Database Administrator
> Unix Administrator
>
> email: fwell...@yahoo.com
>
> Home: 703-430-0805
>
> Cell: 703-477-6045
> ========================
>
> http://www.one.org/
>
>
>
> ----- Original Message ----
> From: "jpren...@yahoo.com" <jpren...@yahoo.com>
> To: informix-l...@iiug.org
> Sent: Friday, April 13, 2007 12:25:36 PM
> Subject: Re: onmode -Y
>
> On Apr 13, 10:07 am, Floyd Wellershaus <fwell...@yahoo.com> wrote:
> > I've been monitoring a problem process, and issued an onmode -Y sessionid 1, for the session that process is using.
>
> > When the process hit the next query, it output to the sqexplain.out.sessionid file.
>
> > But now the process appears hung, and the onstat -g sql sessionid shows a new query, but there was no further output for that query in the sqexplain file.
>
> > The query is an insert query, and nothing is going into the new table. It uses a cursor. So I'm thinking because there is no output in the sqexplain file, that means that somewhere the process is hung trying to prepare the statement.
>
> > Does it mean anything to anybody that the new sql shows in an onstat -g sql but not in the dynamic explain file ?
>
> > btw, I can see the thread doing reads, but nothing really happens.
>
> > Thanks,
> > floyd
>
> > ========================
> > -<<Floyd Wellershaus>>-
> > Database Administrator
> > Unix Administrator
>
> > email: fwell...@yahoo.com
>
> > Home: 703-430-0805
>
> > Cell: 703-477-6045
> > ========================
>
> >http://www.one.org/
>
> Try using onstat -g stk <threadid> and getting the stack. If it's
> hung in the optimizer it should be pretty obvious if you want to post
> the output. Otherwise the stack should give you somewhat of an idea
> what it's currently doing.
>
> Jacques
>
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text -
>
> - Show quoted text -
We need the function names below this in the output!
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list