Oracle-L: RAC and parallelism

From: Bruno Vanters <bruno.vanters_at_tietoenator.com>
Date: Wed, 26 Nov 2003 07:04:25 -0800
Message-ID: <F001.005D7E58.20031126070425@fatcity.com>

Hi,

While trying to import a dump, i got an error during "create index":

IMP-00003: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 23 (block # 47913)
ORA-01110: data file 23: '/data/oracle/DEV/IS_D2C_02.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error

Linux Error: 11: Resource temporarily unavailable Additional information: 47897

Followed by

IMP-00003: ORACLE error 12801 encountered ORA-12801: error signaled in parallel query server P002, instance racf0:DEV1 (1)
ORA-01115: IO error reading block from file 202 (block # 22129) ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 22129

No errors in alert.log only one trace file in bdump containing the last message. No errors found using dbverify.

The only way to reproduce this without using import was to use "create index" statement that contains "parallel (degree 6 instances 1)" on a table that has 2 partitions, each of them having 3 subpartitions. Again, no errors in alert.log and no trace files. Only error on screen:
ORA-12801: error signaled in parallel query server P001, instance racf1:DEV2 (2)
ORA-01115: IO error reading block from file 201 (block # 7352) ORA-27072: skgfdisp: I/O error
Linux Error: 11: Resource temporarily unavailable Additional information: 7352

Similar "create index" statement, only containing "parallel" with no degree and instances specified finished with no errors. select * from v$pq_sesstat; revealed, that it was done with height=3 and width=2.

Could anyone explain me the cause of this error?

I am using RAC over NFSv3, 9.2.0.4, kernel 2.6.0-test6

thanks,

Bruno Vanters
Junior Oracle DBA

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bruno Vanters
INET: bruno.vanters_at_tietoenator.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 Wed Nov 26 2003 - 09:04:25 CST