【插播下活动广告】第一届Pulsar Hackathon来了，看到Doris社区2021年规划也有计划联通Pulsar，在这方面有兴趣的同学可以报名Pulsar在线马拉松活动：https://www.eventbrite.com/e/apache-pulsar-hackathon-2021-tickets-143906003731 ，趁此实现这个想法😄️ 一等奖5千美金，4月28日报名截止哈~ 可组队，可单肝😄️ 😄️
各位大佬咨询一个问题：用docker搭建了一个FE、3个BE的集群。建了一张表插入几条数据查询没什么问题，插入十万条数据后 通过主键ID作为条件可以进行单条数据的查询，但是一查询多条（select from table limit 10）整个集群的BE节点就会全部挂掉，客户端显示 ERROR 1064 (HY000): errCode = 2, detailMessage = there is no scanNode Backend. [10005: in black list(A error occurred: errorCode=2001 errorMessage:Channel inactive error!)] be.out的日志start time: Tue Apr 13 18:19:54 CST 2021
** Aborted at 1618450364 (unix time) try "date -d @1618450364" if you are using GNU date
PC: @ 0x224fbf8 roaring_read_uint32_iterator SIGILL (@0x224fbf8) received by PID 400 (TID 0x7f2ccb9c2700) from PID 35978232; stack trace: *
@ 0x1ce30c2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f2cebc02630 (unknown)
@ 0x224fbf8 roaring_read_uint32_iterator
@ 0x185d1de doris::segment_v2::SegmentIterator::_init()
@ 0x185d9ad doris::segment_v2::SegmentIterator::next_batch()
@ 0x119b2e9 doris::BetaRowsetReader::next_block()
@ 0x1103aa6 doris::CollectIterator::Level0Iterator::_refresh_current_row_v2()
@ 0x11044d3 doris::CollectIterator::add_child()
@ 0x10e579f doris::Reader::_capture_rs_readers()
@ 0x10e95cb doris::Reader::init()
@ 0x1725b0f doris::OlapScanner::open()
@ 0x16e0d04 doris::OlapScanNode::scanner_thread()
@ 0x11f9a4d doris::PriorityThreadPool::work_thread()
@ 0x1cb78e7 thread_proxy
@ 0x7f2cebbfaea5 start_thread
@ 0x7f2ceb6219fd __clone
** Aborted at 1618450364 (unix time) try "date -d @1618450364" if you are using GNU date
PC: @ 0x224fbf8 roaring_read_uint32_iterator SIGILL (@0x224fbf8) received by PID 400 (TID 0x7f2ccb9c2700) from PID 35978232; stack trace: *
@ 0x1ce30c2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f2cebc02630 (unknown)
@ 0x224fbf8 roaring_read_uint32_iterator
@ 0x185d1de doris::segment_v2::SegmentIterator::_init()
@ 0x185d9ad doris::segment_v2::SegmentIterator::next_batch()
@ 0x119b2e9 doris::BetaRowsetReader::next_block()
@ 0x1103aa6 doris::CollectIterator::Level0Iterator::_refresh_current_row_v2()
@ 0x11044d3 doris::CollectIterator::add_child()
@ 0x10e579f doris::Reader::_capture_rs_readers()
@ 0x10e95cb doris::Reader::init()
@ 0x1725b0f doris::OlapScanner::open()
@ 0x16e0d04 doris::OlapScanNode::scanner_thread()
@ 0x11f9a4d doris::PriorityThreadPool::work_thread()
@ 0x1cb78e7 thread_proxy
@ 0x7f2cebbfaea5 start_thread
@ 0x7f2ceb6219fd __clone
镜像：apachedoris/doris-dev:build-env-1.2
源码：wget https://dist.apache.org/repos/dist/dev/incubator/doris/0.12.0-rc01/apache-doris-0.12.0-incubating-src.tar.gz
编译时出错：
[INFO] ------------------------< org.apache:doris-fe >-------------------------
[INFO] Building doris-fe 3.4.0
[INFO] --------------------------------[ jar ]---------------------------------
[WARNING] The POM for net.sourceforge.czt.dev:java-cup:jar:0.11-a-czt02-cdh is missing, no dependency information available
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 2.480 s
[INFO] Finished at: 2021-04-19T03:52:22Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project doris-fe: Could not resolve dependencies for project org.apache:doris-fe:jar:3.4.0: Failure to find net.sourceforge.czt.dev:java-cup:jar:0.11-a-czt02-cdh in https://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
大佬们，这个该怎么解决
源码：wget https://dist.apache.org/repos/dist/dev/incubator/doris/0.12.0-rc01/apache-doris-0.12.0-incubating-src.tar.gz
编译时出错：
[INFO] ------------------------< org.apache:doris-fe >-------------------------
[INFO] Building doris-fe 3.4.0
[INFO] --------------------------------[ jar ]---------------------------------
[WARNING] The POM for net.sourceforge.czt.dev:java-cup:jar:0.11-a-czt02-cdh is missing, no dependency information available
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 2.480 s
[INFO] Finished at: 2021-04-19T03:52:22Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project doris-fe: Could not resolve dependencies for project org.apache:doris-fe:jar:3.4.0: Failure to find net.sourceforge.czt.dev:java-cup:jar:0.11-a-czt02-cdh in https://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
大佬们，这个该怎么解决
start time: Tue Apr 20 15:22:22 CST 2021
Aborted at 1618903356 (unix time) try "date -d @1618903356" if you are using GNU date
PC: @ 0x224fbf8 roaring_read_uint32_iterator
SIGILL (@0x224fbf8) received by PID 24410 (TID 0x7fa5adb29700) from PID 35978232; stack trace:
@ 0x1ce30c2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7fa61a678630 (unknown)
@ 0x224fbf8 roaring_read_uint32_iterator
@ 0x185d1de doris::segment_v2::SegmentIterator::_init()
@ 0x185d9ad doris::segment_v2::SegmentIterator::next_batch()
@ 0x119b2e9 doris::BetaRowsetReader::next_block()
@ 0x183f535 doris::SchemaChangeWithSorting::process()
@ 0x1843765 doris::SchemaChangeHandler::_convert_historical_rowsets()
@ 0x184768a doris::SchemaChangeHandler::_do_process_alter_tablet_v2()
@ 0x1848d42 doris::SchemaChangeHandler::process_alter_tablet_v2()
@ 0x1871305 doris::EngineAlterTabletTask::execute()
@ 0x1040379 doris::StorageEngine::execute_task()
@ 0x168f9e6 doris::TaskWorkerPool::_alter_tablet()
@ 0x1697f9a doris::TaskWorkerPool::_alter_tablet_worker_thread_callback()
@ 0x137efa7 doris::ThreadPool::dispatch_thread()
@ 0x1379453 doris::Thread::supervise_thread()
@ 0x7fa61a670ea5 start_thread
@ 0x7fa61a0979fd __clone
求问大神，这个问题如何解决？
Aborted at 1618903356 (unix time) try "date -d @1618903356" if you are using GNU date
PC: @ 0x224fbf8 roaring_read_uint32_iterator
SIGILL (@0x224fbf8) received by PID 24410 (TID 0x7fa5adb29700) from PID 35978232; stack trace:
@ 0x1ce30c2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7fa61a678630 (unknown)
@ 0x224fbf8 roaring_read_uint32_iterator
@ 0x185d1de doris::segment_v2::SegmentIterator::_init()
@ 0x185d9ad doris::segment_v2::SegmentIterator::next_batch()
@ 0x119b2e9 doris::BetaRowsetReader::next_block()
@ 0x183f535 doris::SchemaChangeWithSorting::process()
@ 0x1843765 doris::SchemaChangeHandler::_convert_historical_rowsets()
@ 0x184768a doris::SchemaChangeHandler::_do_process_alter_tablet_v2()
@ 0x1848d42 doris::SchemaChangeHandler::process_alter_tablet_v2()
@ 0x1871305 doris::EngineAlterTabletTask::execute()
@ 0x1040379 doris::StorageEngine::execute_task()
@ 0x168f9e6 doris::TaskWorkerPool::_alter_tablet()
@ 0x1697f9a doris::TaskWorkerPool::_alter_tablet_worker_thread_callback()
@ 0x137efa7 doris::ThreadPool::dispatch_thread()
@ 0x1379453 doris::Thread::supervise_thread()
@ 0x7fa61a670ea5 start_thread
@ 0x7fa61a0979fd __clone
求问大神，这个问题如何解决？
= Memory exceed limit. Spill sort, while getting next. Backend: IP、, fragment: 9d9b8624d3614309-991688cb186b0373 Used: 215901767372, Limit: 215899308032. You can change the limit by session variable exec_mem_limit.
这个执行内存，已经通过修改会话内存调成36G了
怎么这里还是报溢出？
经测试，这个215899308032 ，单位是bit
我只有1个fe和3个be ,be的ip被我写死了。
错误信息是这个：fail to get master client from cache. host=, port=0, code=7
文档上的都看了，没有问题，端口也都是同的
麻烦咨询下 FE启动后 有一个节点是这样
@所有人
听说可以用latex?
$\int x dx$
\int x dx
有遇到这个问题的吗
Aborted at 1623382680 (unix time) try "date -d @1623382680" if you are using GNU date
PC: @ 0x7feda8536416 GI_strcmp
SIGSEGV (@0x0) received by PID 22069 (TID 0x7fed5d76c700) from PID 0; stack trace:
@ 0x7feda84e1450 (unknown)
@ 0x7feda8536416 GI_strcmp
PC: @ 0x7feda8536416 GI_strcmp
SIGSEGV (@0x0) received by PID 22069 (TID 0x7fed5d76c700) from PID 0; stack trace:
@ 0x7feda84e1450 (unknown)
@ 0x7feda8536416 GI_strcmp
PC: @ 0x7f088588a416 GI_strcmp
SIGSEGV (@0x0) received by PID 15160 (TID 0x7f083a96c700) from PID 0; stack trace:
@ 0x7f0885835400 (unknown)
@ 0x7f088588a416 GI_strcmp
@ 0x217d21d lh_insert
@ 0x213701b OBJ_NAME_add
@ 0x7f07dacc0a32 openssl_add_all_ciphers_int
@ 0x7f07dacb224b ossl_init_add_all_ciphersossl
@ 0x7f08855e920b __pthread_once_slow
@ 0x7f07dac93fe0 CRYPTO_THREAD_run_once
@ 0x7f07dacb1f66 OPENSSL_init_crypto
@ 0x7f07dac62a6c OPENSSL_init_ssl
@ 0x7f07dac7d1b0 ssl_start
@ 0x7f07dac00e65 mysql_server_init
@ 0x7f07dabf47d7 mysql_init
@ 0x7f07dabb1270 myodbc_do_connect()
@ 0x7f07dabb20d7 MySQLDriverConnect()
@ 0x7f07dabcc9bd SQLDriverConnectW
@ 0x2594053 SQLDriverConnect
@ 0x17201a8 doris::ODBCConnector::open()
@ 0x1718f3b doris::OdbcScanNode::open()
@ 0x11e639c doris::PlanFragmentExecutor::open_internal()
@ 0x11e6d50 doris::PlanFragmentExecutor::open()
@ 0x114e1be doris::FragmentExecState::execute()
SIGSEGV (@0x0) received by PID 15160 (TID 0x7f083a96c700) from PID 0; stack trace:
@ 0x7f0885835400 (unknown)
@ 0x7f088588a416 GI_strcmp
@ 0x217d21d lh_insert
@ 0x213701b OBJ_NAME_add
@ 0x7f07dacc0a32 openssl_add_all_ciphers_int
@ 0x7f07dacb224b ossl_init_add_all_ciphersossl
@ 0x7f08855e920b __pthread_once_slow
@ 0x7f07dac93fe0 CRYPTO_THREAD_run_once
@ 0x7f07dacb1f66 OPENSSL_init_crypto
@ 0x7f07dac62a6c OPENSSL_init_ssl
@ 0x7f07dac7d1b0 ssl_start
@ 0x7f07dac00e65 mysql_server_init
@ 0x7f07dabf47d7 mysql_init
@ 0x7f07dabb1270 myodbc_do_connect()
@ 0x7f07dabb20d7 MySQLDriverConnect()
@ 0x7f07dabcc9bd SQLDriverConnectW
@ 0x2594053 SQLDriverConnect
@ 0x17201a8 doris::ODBCConnector::open()
@ 0x1718f3b doris::OdbcScanNode::open()
@ 0x11e639c doris::PlanFragmentExecutor::open_internal()
@ 0x11e6d50 doris::PlanFragmentExecutor::open()
@ 0x114e1be doris::FragmentExecState::execute()
what does it mean?
I cannot open the details link
有大佬知道这什么原因吗？？？
建表语句
CREATE TABLE Location
(
)
UNIQUE KEY(
DISTRIBUTED BY HASH(
PROPERTIES("replication_num" = "1");
CREATE TABLE Location
(
Id varchar(15) NOT NULL COMMENT '主键',Latitude int(10) NOT NULL COMMENT '纬度信息，以度为单位的纬度值乘以 10 的 6 次方，精确到百万分之一度',Longitude int(10) NOT NULL COMMENT '经度信息，以度为单位的经度值乘以 10 的 6 次方，精确到百万分之一度',Altitude smallint(5) NOT NULL COMMENT '高程（海拔高度），海拔高度，单位为米（m）',Speed smallint(5) NOT NULL COMMENT '速度，1/10km/h',Direction smallint(5) NOT NULL COMMENT '方向，0-359，正北为 0，顺时针',DateTime datetime NOT NULL COMMENT '终端上报时间',SimNumber varchar(15) DEFAULT NULL COMMENT 'sim卡号',RecordSpeed smallint(5) NOT NULL COMMENT '行驶记录功能获取的速度，1/10km/h ',IsBatch boolean NOT NULL COMMENT '是否为补传消息',CreateDateTime datetime NOT NULL COMMENT '创建时间')
UNIQUE KEY(
Id, SimNumber)DISTRIBUTED BY HASH(
SimNumber) BUCKETS 10PROPERTIES("replication_num" = "1");
已解决，将所有为key的列移动到最前面，如下将
CREATE TABLE Location
(
)
UNIQUE KEY(
DISTRIBUTED BY HASH(SimNumber) BUCKETS 10
PROPERTIES("replication_num" = "1");
SimNumber移动到Id后面即可CREATE TABLE Location
(
Id varchar(15) NOT NULL COMMENT '主键',SimNumber varchar(15) DEFAULT NULL COMMENT 'sim卡号',Latitude int(10) NOT NULL COMMENT '纬度信息，以度为单位的纬度值乘以 10 的 6 次方，精确到百万分之一度',Longitude int(10) NOT NULL COMMENT '经度信息，以度为单位的经度值乘以 10 的 6 次方，精确到百万分之一度',Altitude smallint(5) NOT NULL COMMENT '高程（海拔高度），海拔高度，单位为米（m）',Speed smallint(5) NOT NULL COMMENT '速度，1/10km/h',Direction smallint(5) NOT NULL COMMENT '方向，0-359，正北为 0，顺时针',DateTime datetime NOT NULL COMMENT '终端上报时间',RecordSpeed smallint(5) NOT NULL COMMENT '行驶记录功能获取的速度，1/10km/h ',IsBatch boolean NOT NULL COMMENT '是否为补传消息',CreateDateTime datetime NOT NULL COMMENT '创建时间')
UNIQUE KEY(
Id,SimNumber )DISTRIBUTED BY HASH(SimNumber) BUCKETS 10
PROPERTIES("replication_num" = "1");