BePPPower opened a new issue, #9750: URL: https://github.com/apache/incubator-doris/issues/9750
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version trunk version. commit ID: 90e8cda5f20f5120156 ### What's Wrong? I create a table with columns which have default values, here's my SQL statement: ``` CREATE TABLE table_hash2 ( k1 TINYINT, k2 CHAR(10) default 'aaa' COMMENT "string column", k3 INT NOT NULL DEFAULT "1" COMMENT "int column" ) COMMENT "my first table" DISTRIBUTED BY HASH(k1) BUCKETS 32 PROPERTIES("replication_num" = "1"); ``` and then, the be will crash when I insert into values, here's my insert SQL statement: ``` insert into table_hash2 (k1) values (1); ``` The exception is: Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=5) errCode = 2, detailMessage = There exists unhealthy backend. backend 14002 is down and the log of be.log is here: ``` F0524 12:03:02.141690 25478 key_coder.h:209] Check failed: index_size <= slice->size index size is larger than char size, index=10, char=3 *** Check failure stack trace: *** @ 0x560ecac8f32d google::LogMessage::Fail() @ 0x560ecac91869 google::LogMessage::SendToLog() @ 0x560ecac8ee96 google::LogMessage::Flush() @ 0x560ecac91ed9 google::LogMessageFatal::~LogMessageFatal() @ 0x560ec8de32c4 doris::KeyCoderTraits<>::encode_ascending() @ 0x560ec996aa0f doris::segment_v2::SegmentWriter::encode_short_keys() @ 0x560ec996c05a doris::segment_v2::SegmentWriter::append_block() @ 0x560ec8e567c9 doris::BetaRowsetWriter::_add_block() @ 0x560ec8e56e83 doris::BetaRowsetWriter::flush_single_memtable() @ 0x560ec8dea0cf doris::MemTable::_do_flush() @ 0x560ec8dea390 doris::MemTable::flush() @ 0x560ec8d119f9 doris::FlushToken::_flush_memtable() @ 0x560ec8d12780 std::_Function_handler<>::_M_invoke() @ 0x560ec90a84ed doris::ThreadPool::dispatch_thread() @ 0x560ec90a2d5f doris::Thread::supervise_thread() @ 0x7fc0e1ecdea5 start_thread @ 0x7fc0e21e0b0d __clone @ (nil) (unknown) Minidump created at: /mnt/disk2/ftw/projects/incubator-doris/output/be/minidump/9427eb8d-e05a-4ce9-4b3d678d-662fa6a8.dmp *** Aborted at 1653364982 (unix time) try "date -d @1653364982" if you are using GNU date *** *** SIGABRT unkown detail explain (@0x404000062fe) received by PID 25342 (TID 0x7fc0cdbd9700) from PID 25342; stack trace: *** I0524 12:03:08.432090 25947 task_worker_pool.cpp:1578] finish report TASK. master host: 172.17.0.1, port: 9129 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /mnt/disk2/ftw/projects/incubator-doris/be/src/common/signal_handler.h:407 1# 0x00007FC0E2118400 in /lib64/libc.so.6 2# gsignal in /lib64/libc.so.6 3# abort in /lib64/libc.so.6 4# google::ReadFromOffset(int, void*, unsigned long, long) [clone .cold] at src/symbolize.cc:146 5# 0x0000560ECAC8F32D at src/logging.cc:1650 6# google::LogMessage::SendToLog() at src/logging.cc:1607 7# google::LogMessage::Flush() at src/logging.cc:1477 8# google::LogMessageFatal::~LogMessageFatal() at src/logging.cc:2227 9# doris::KeyCoderTraits<(doris::FieldType)13, void>::encode_ascending(void const*, unsigned long, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >*) at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/key_coder.h:212 10# doris::segment_v2::SegmentWriter::encode_short_keys[abi:cxx11](std::vector<void const*, std::allocator<void const*> >, bool) at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/rowset/segment_v2/segment_writer.cpp:177 11# doris::segment_v2::SegmentWriter::append_block(doris::vectorized::Block const*, unsigned long, unsigned long) at /mnt/disk2/ftw/tools/ldb_toolchain/include/c++/11/bits/stl_vector.h:678 12# doris::BetaRowsetWriter::_add_block(doris::vectorized::Block const*, std::unique_ptr<doris::segment_v2::SegmentWriter, std::default_delete<doris::segment_v2::SegmentWriter> >*) at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/rowset/beta_rowset_writer.cpp:129 13# doris::BetaRowsetWriter::flush_single_memtable(doris::vectorized::Block const*) at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/rowset/beta_rowset_writer.cpp:264 14# doris::MemTable::_do_flush(long&) at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/memtable.cpp:308 15# doris::MemTable::flush() at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/memtable.cpp:277 16# doris::FlushToken::_flush_memtable(std::shared_ptr<doris::MemTable>, long) at /mnt/disk2/ftw/projects/incubator-doris/be/src/olap/memtable_flush_executor.cpp:75 17# std::_Function_handler<void (), std::_Bind<void (doris::FlushToken::*(doris::FlushToken*, std::shared_ptr<doris::MemTable>, long))(std::shared_ptr<doris::MemTable>, long)> >::_M_invoke(std::_Any_data const&) at /mnt/disk2/ftw/tools/ldb_toolchain/include/c++/11/bits/std_function.h:291 18# doris::ThreadPool::dispatch_thread() at /mnt/disk2/ftw/projects/incubator-doris/be/src/util/threadpool.cpp:548 19# doris::Thread::supervise_thread(void*) at /mnt/disk2/ftw/projects/incubator-doris/be/src/util/thread.cpp:409 20# start_thread in /lib64/libpthread.so.0 21# clone in /lib64/libc.so.6 ``` ### What You Expected? The result of insert SQL statement should be success! Actually，I also try the procedure above in apache-doris-1.0.0-incubating-bin and it works well: ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
