report errors
The error reported by spark when reading Doris table and importing hive table is as follows
Caused by: org.apache.doris.spark.exception.DorisInternalException:
Doris server Doris BE{host='192.168.1.1', port=9060} internal failed,
status code [INTERNAL_ERROR] error message is [failed to initialize storage reader.
tablet=404802818.143972036.284b4c29fe956174-4b76f65647c70daa, res=-230, backend=192.168.1.1]
analysis
Source code analysis
Be node
olap_ scanner.cpp
Status OlapScanner::open() {
SCOPED_TIMER(_parent->_reader_init_timer);
if (_conjunct_ctxs.size() > _direct_conjunct_size) {
_use_pushdown_conjuncts = true;
}
_runtime_filter_marks.resize(_parent->runtime_filter_descs().size(), false);
auto res = _reader->init(_params);
if (res != OLAP_SUCCESS) {
OLAP_LOG_WARNING("fail to init reader.[res=%d]", res);
std::stringstream ss;
ss << "failed to initialize storage reader. tablet=" << _params.tablet->full_name()
<< ", res=" << res << ", backend=" << BackendOptions::get_localhost();
return Status::InternalError(ss.str().c_str());
}
return Status::OK();
}
Failed to read data
be has parameters
tablet_ rowset_ stale_ sweep_ time_ SEC
type: Int64
Description: used to indicate the expiration time of cleaning up the merged version. When the current time is now() minus the latest creation time of rowset in a merged version path is greater than tablet_ rowset_ stale_ sweep_ time_ SEC, clean up the current path and delete these merged rowsets, with the unit of S
default value: 1800
that is, in the process of reading Doris, data is imported into this table, resulting in the deletion of the original version half an hour after the compaction, so the task of spark reading Doris will report an error. When you read a version from Fe, it may be merged mark>
solve
Increase the parallelism of the spark reader. Increasing this parameter can increase the retention time of the old version
Read More:
- Failed to start Ceph object storage daemon osd.14
- “No nodes available to run query” is reported when using Presto to connect to MySQL query“
- Failed to read auto-increment value from the storage engine in MySQL
- termux Failed to initialize runtime
- MySQL error STORAGE ENGINE failed
- [Handling Notes] Alternative reasons for Configuration system failed to initialize exception
- Doris decommission be node stuck [How to Solve]
- The app failed to start because there is no Qt platform to initialize
- FileZilla server failed to initialize SSL Library
- Ubuntu: Failed to initialize compiler: object java.lang.Object In compiler mirror not found
- unity 3D:Virtual Reality SDK Oculus failed to initialize.
- As Error:Failed to find configured root that contains /storage/emulated/0/xxx/xxx/xxx.png
- Linux boot prompt “failed to initialize Hal!” solution
- MySQL — initialize failed to generate temporary password in error log after initialization
- To solve the execution failed for task ‘: app:transformDexArchiveWithDexMergerForDebug ‘
- Communication link failure when connecting Doris
- Failed to initialize nvml driver / library version mismatch due to automatic update of NVIDIA driver
- failed to lazily initialize a collection of role: ……, no session or session was closed
- Android: How to Solve Execution failed for task ‘:app:compileDebugJavaWithJavac‘. > javax/xml/bind/JAXBException
- Failed to capture snapshot of output files for task ‘ :packagePreDebug’ property ”outputDirectory’