RAC Parallel Query Issues

From: Ravi Kulkarni <nandagokul_at_yahoo.com>
Date: Mon, 15 Sep 2003 16:54:24 -0800
Message-ID: <F001.005CFF83.20030915165424@fatcity.com>

We are on 2-Node Rac 9204/Solaris8.

We are having intermittent issues with parallel queries (The table has only 470 records, executes < 1sec otherwise):

SQL> /
select count(*)from eod
*
ERROR at line 1:
ORA-12805: parallel query server died unexpectedly

Trace File has:
kxfp_send_callback

        Send timed out to slave 65535 inst 1 (qref 0x63f85fd0)
*** 2003-09-15 18:33:25.034
*** SESSION ID:(63.533) 2003-09-15 18:33:25.034 kxfp_send_callback

        Send timed out to slave 65535 inst 1 (qref 0x63fc2004)
kxfplsig

        Could not signal error 10388 in server P032 with serial 371201

        dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168, cqr 0x63f97584, err 10387

        Interrupt Info top=1 size=8 top
err=-2147473260

        Query May be hanging.Check V$PX_SESSION OPIRIP: Uncaught error 12800. Error stack: ORA-12800: system appears too busy for parallel query execution
ORA-10387: parallel query server interrupt (normal)

v$px_session : has number of Slave Processes hanging.

Truss for process on
Instance 1:
door_return(0x00000000, 0, 0x00000000, 0)
(sleeping...)

lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)

lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) Err#62 ETIME

read(0, 0xFE6C35E4, 1024)       (sleeping...)
signotifywait()                 (sleeping...)

door_return(0x00000000, 0, 0x00000000, 0)
(sleeping...)

lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0)
(sleeping...)

Instance 2:

poll(0x02FF15CC, 2, 2500)       (sleeping...)
poll(0x02FF15CC, 2, 2500)                       = 0
poll(0x02FF15CC, 2, 0)                          = 0
poll(0x02FF15CC, 2, 2500)       (sleeping...)
poll(0x02FF15CC, 2, 2500)                       = 0
poll(0x02FF15CC, 2, 0)                          = 0
poll(0x02FF15CC, 2, 2500)       (sleeping...)
poll(0x02FF15CC, 2, 2500)                       = 0

Any inputs would be greatly appreciated.

Thanks,
Ravi.

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: nandagokul_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Sep 15 2003 - 19:54:24 CDT