You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/10/31 16:01:55 UTC

[GitHub] [doris] liaoxin01 opened a new issue, #13846: [Bug] be core dump when update table with sequence column

liaoxin01 opened a new issue, #13846:
URL: https://github.com/apache/doris/issues/13846

   ### 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
   
   master
   
   ### What's Wrong?
   
   *** Query id: 3853721191084c5b-adb8755792729c5a ***
   *** Aborted at 1667231542 (unix time) try "date -d @1667231542" if you are using GNU date ***
   *** Current BE git commitID: d2c5c1a ***
   *** SIGABRT unkown detail explain (@0x1788d) received by PID 96397 (TID 0x7f7e42f61700) from PID 96397; stack trace: ***
    0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /root/code/doris/be/src/common/signal_handler.h:420
    1# 0x00007F7EC30D6400 in /lib64/libc.so.6
    2# gsignal in /lib64/libc.so.6
    3# abort in /lib64/libc.so.6
    4# 0x0000000017318509 in /root/code/doris/output/be/lib/doris_be
    5# 0x000000001730DB1D in /root/code/doris/output/be/lib/doris_be
    6# google::LogMessage::SendToLog() in /root/code/doris/output/be/lib/doris_be
    7# google::LogMessage::Flush() in /root/code/doris/output/be/lib/doris_be
    8# google::LogMessageFatal::~LogMessageFatal() in /root/code/doris/output/be/lib/doris_be
    9# void doris::vectorized::IColumn::append_data_by_selector_impl<doris::vectorized::ColumnNullable>(COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>&, doris::vectorized::PODArray<unsigned long, 4096ul, Allocator<false, false>, 15ul, 16ul> const&) const in /root/code/doris/output/be/lib/doris_be
   10# doris::vectorized::ColumnNullable::append_data_by_selector(COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>&, doris::vectorized::PODArray<unsigned long, 4096ul, Allocator<false, false>, 15ul, 16ul> const&) const at /root/code/doris/be/src/vec/columns/column_nullable.h:183
   11# doris::vectorized::Block::append_block_by_selector(std::vector<COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn>, std::allocator<COW<doris::vectorized::IColumn>::mutable_ptr<doris::vectorized::IColumn> > >&, doris::vectorized::PODArray<unsigned long, 4096ul, Allocator<false, false>, 15ul, 16ul> const&) const at /root/code/doris/be/src/vec/core/block.cpp:648
   12# doris::stream_load::VNodeChannel::add_block(doris::vectorized::Block*, std::pair<std::unique_ptr<doris::vectorized::PODArray<unsigned long, 4096ul, Allocator<false, false>, 15ul, 16ul>, std::default_delete<doris::vectorized::PODArray<unsigned long, 4096ul, Allocator<false, false>, 15ul, 16ul> > >, std::vector<long, std::allocator<long> > > const&) at /root/code/doris/be/src/vec/sink/vtablet_sink.cpp:193
   13# doris::stream_load::VOlapTableSink::send(doris::RuntimeState*, doris::vectorized::Block*) at /root/code/doris/be/src/vec/sink/vtablet_sink.cpp:567
   14# doris::PlanFragmentExecutor::open_vectorized_internal() at /root/code/doris/be/src/runtime/plan_fragment_executor.cpp:311
   15# doris::PlanFragmentExecutor::open() at /root/code/doris/be/src/runtime/plan_fragment_executor.cpp:252
   16# doris::FragmentExecState::execute() at /root/code/doris/be/src/runtime/fragment_mgr.cpp:249
   17# doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>) at /root/code/doris/be/src/runtime/fragment_mgr.cpp:493
   18# doris::FragmentMgr::exec_plan_fragment(doris::TExecPlanFragmentParams const&, std::function<void (doris::PlanFragmentExecutor*)>)::$_3::operator()() const at /root/code/doris/be/src/runtime/fragment_mgr.cpp:677
   
   ### What You Expected?
   
   fix it.
   
   ### How to Reproduce?
   
   1. create table
   CREATE TABLE IF NOT EXISTS tbl (
     `k1` int NULL,
     `v1` tinyint NULL,
     `v2` int
   ) ENGINE=OLAP
   UNIQUE KEY(k1)
   DISTRIBUTED BY HASH(`k1`) BUCKETS 3
   PROPERTIES (
   "function_column.sequence_type" = "int",
   "replication_allocation" = "tag.location.default: 1"
   );
   
   2. load data by stream load.
   1,4,11
   2,5,12
   3,6,13
   
   3. load data by stream load.
   1,2,14
   2,3,2
   3,4,3
   
   4. update table
   UPDATE tbl SET v1 = 10 WHERE k1 = 1
   
   
   
   
   ### Anything Else?
   
   The value of sequence column is null when set show_hidden_columns true , but the real value of sequence column is not null.
   
   set show_hidden_columns=true;
   select * from test_uniq_sequence;
   +------+------+------+-----------------------+------------------------+
   | k1   | v1   | v2   | __DORIS_DELETE_SIGN__ | __DORIS_SEQUENCE_COL__ |
   +------+------+------+-----------------------+------------------------+
   |    2 |    5 |   12 |                     0 |                   NULL |
   |    1 |    2 |   14 |                     0 |                   NULL |
   |    3 |    6 |   13 |                     0 |                   NULL |
   +------+------+------+-----------------------+------------------------+
   
   ### Are you willing to submit PR?
   
   - [X] 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: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [doris] yiguolei closed issue #13846: [Bug] be core dump when update table with sequence column

Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #13846: [Bug] be core dump when update table with sequence column
URL: https://github.com/apache/doris/issues/13846


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org