My Oracle Support Banner

OSCH on Exadata Client Raises Block Errors when Connecting to a BDA over Infiniband with: client.local.interfaces="ib0,ib1" (Doc ID 1915121.1)

Last updated on MARCH 12, 2021

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Oracle SQL Connector for Hadoop Distributed File System - Version 3.0 and later
x86_64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

 

OSCH on Exadata Client raises block errors as below when connecting to a BDA over an Infiniband with: client.local.interfaces="ib0,ib1":

SQL> select /*+ parallel (96) */ count(*) from <TABLE>;
select /*+ parallel (96) */ count(*) from <TABLE>
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P129, instance bdanode1.example.com:<client> (1)
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /opt/oracle/orahdfs-3.0.0/bin/hdfs_stream
encountered error "OSCH: Error processing URI
hdfs://<path>/user/<path>/part-m-<#>
Could not obtain block:
BP-<id>-<private ip>-<#>:blk_111222_1234
file=/user/<path>/part-m-<#>


a) The same query executes in Hive, Impala, and 'hadoop cat'.
b) FSCK shows that the filesystem under path '/user/<path>/part-m-<#>' is healthy.
c) Connection through the 10G interface is successful i.e.

Executing the command over 10G interface works:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.