search

stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
https://stonedb.io/
GNU General Public License v2.0
865 stars 141 forks source link

bug: Load Data Invalid write、Invalid read #108

Closed zsp108 closed 2 years ago

zsp108 commented 2 years ago

Describe the problem

Valgrind test

Using TPCH to generate 2GB data and import it into StoneDB:

Invalid write、Invalid read

Valgrind test log:

==00:01:00:20.722 1339681== Thread 202:
==00:01:00:20.722 1339681== Invalid write of size 1
==00:01:00:20.722 1339681==    at 0xF0285C: stonedb::system::CacheableItem::CacheableItem(char const*, char const*, int) (cacheable_item.cpp:74)
==00:01:00:20.722 1339681==    by 0x1041C7D: stonedb::core::GroupDistinctCache::GroupDistinctCache() (group_distinct_cache.cpp:25)
==00:01:00:20.722 1339681==    by 0x104FBEF: _Construct<stonedb::core::GroupDistinctCache> (stl_uninitialized.h:82)
==00:01:00:20.722 1339681==    by 0x104FBEF: __uninit_default_n<stonedb::core::GroupDistinctCache*, long unsigned int> (stl_uninitialized.h:527)
==00:01:00:20.722 1339681==    by 0x104FBEF: __uninitialized_default_n<stonedb::core::GroupDistinctCache*, long unsigned int> (stl_uninitialized.h:583)
==00:01:00:20.722 1339681==    by 0x104FBEF: __uninitialized_default_n_a<stonedb::core::GroupDistinctCache*, long unsigned int, stonedb::core::GroupDistinctCache> (stl_uninitialized.h:645)
==00:01:00:20.722 1339681==    by 0x104FBEF: std::vector<stonedb::core::GroupDistinctCache, std::allocator<stonedb::core::GroupDistinctCache> >::_M_default_append(unsigned long) (vector.tcc:579)
==00:01:00:20.722 1339681==    by 0x104EA18: stonedb::core::GroupByWrapper::Initialize(long, bool) (groupby_wrapper.cpp:258)
==00:01:00:20.722 1339681==    by 0xFFF909: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:136)
==00:01:00:20.722 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:20.722 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:20.723 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:20.723 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:20.723 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:20.723 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:20.723 1339681==    by 0x9B63CB: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6428)
==00:01:00:20.723 1339681==  Address 0x11bd9022a is 0 bytes after a block of size 42 alloc'd
==00:01:00:20.723 1339681==    at 0x483E217: operator new[](unsigned long) (vg_replace_malloc.c:640)
==00:01:00:20.723 1339681==    by 0xF025CC: stonedb::system::CacheableItem::CacheableItem(char const*, char const*, int) (cacheable_item.cpp:37)
==00:01:00:20.723 1339681==    by 0x1041C7D: stonedb::core::GroupDistinctCache::GroupDistinctCache() (group_distinct_cache.cpp:25)
==00:01:00:20.723 1339681==    by 0x104FBEF: _Construct<stonedb::core::GroupDistinctCache> (stl_uninitialized.h:82)
==00:01:00:20.723 1339681==    by 0x104FBEF: __uninit_default_n<stonedb::core::GroupDistinctCache*, long unsigned int> (stl_uninitialized.h:527)
==00:01:00:20.723 1339681==    by 0x104FBEF: __uninitialized_default_n<stonedb::core::GroupDistinctCache*, long unsigned int> (stl_uninitialized.h:583)
==00:01:00:20.723 1339681==    by 0x104FBEF: __uninitialized_default_n_a<stonedb::core::GroupDistinctCache*, long unsigned int, stonedb::core::GroupDistinctCache> (stl_uninitialized.h:645)
==00:01:00:20.723 1339681==    by 0x104FBEF: std::vector<stonedb::core::GroupDistinctCache, std::allocator<stonedb::core::GroupDistinctCache> >::_M_default_append(unsigned long) (vector.tcc:579)
==00:01:00:20.723 1339681==    by 0x104EA18: stonedb::core::GroupByWrapper::Initialize(long, bool) (groupby_wrapper.cpp:258)
==00:01:00:20.723 1339681==    by 0xFFF909: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:136)
==00:01:00:20.723 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:20.723 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:20.723 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:20.723 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:20.723 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:20.723 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:20.723 1339681== 
==00:01:00:20.763 1339681== Invalid write of size 1
==00:01:00:20.763 1339681==    at 0xF0285C: stonedb::system::CacheableItem::CacheableItem(char const*, char const*, int) (cacheable_item.cpp:74)
==00:01:00:20.763 1339681==    by 0x100B377: stonedb::core::CachedBuffer<long>::CachedBuffer(unsigned int, unsigned int, stonedb::core::Transaction*) (cached_buffer.cpp:26)
==00:01:00:20.763 1339681==    by 0xEB0A66: AttrBuffer (temp_table.cpp:48)
==00:01:00:20.763 1339681==    by 0xEB0A66: stonedb::core::TempTable::Attr::CreateBuffer(unsigned long, stonedb::core::Transaction*, bool) (temp_table.cpp:174)
==00:01:00:20.764 1339681==    by 0xFFFD67: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:181)
==00:01:00:20.764 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:20.764 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:20.764 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:20.764 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:20.764 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:20.764 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:20.764 1339681==    by 0x9B63CB: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6428)
==00:01:00:20.764 1339681==    by 0x9B8452: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1342)
==00:01:00:20.764 1339681==  Address 0x11bdd3c1a is 0 bytes after a block of size 42 alloc'd
==00:01:00:20.764 1339681==    at 0x483E217: operator new[](unsigned long) (vg_replace_malloc.c:640)
==00:01:00:20.764 1339681==    by 0xF025CC: stonedb::system::CacheableItem::CacheableItem(char const*, char const*, int) (cacheable_item.cpp:37)
==00:01:00:20.764 1339681==    by 0x100B377: stonedb::core::CachedBuffer<long>::CachedBuffer(unsigned int, unsigned int, stonedb::core::Transaction*) (cached_buffer.cpp:26)
==00:01:00:20.764 1339681==    by 0xEB0A66: AttrBuffer (temp_table.cpp:48)
==00:01:00:20.764 1339681==    by 0xEB0A66: stonedb::core::TempTable::Attr::CreateBuffer(unsigned long, stonedb::core::Transaction*, bool) (temp_table.cpp:174)
==00:01:00:20.764 1339681==    by 0xFFFD67: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:181)
==00:01:00:20.764 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:20.764 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:20.764 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:20.764 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:20.764 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:20.764 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:20.764 1339681==    by 0x9B63CB: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6428)
==00:01:00:20.764 1339681== 
==00:01:00:20.807 1339681== Invalid read of size 1
==00:01:00:20.807 1339681==    at 0x4842654: strlen (vg_replace_strmem.c:494)
==00:01:00:20.807 1339681==    by 0xB75027: length (char_traits.h:320)
==00:01:00:20.807 1339681==    by 0xB75027: std::basic_string<char, std::char_traits<char>, std::allocator<char> >::basic_string(char const*, std::allocator<char> const&) (basic_string.tcc:664)
==00:01:00:20.807 1339681==    by 0xF02E02: stonedb::system::CacheableItem::~CacheableItem() (cacheable_item.cpp:81)
==00:01:00:20.807 1339681==    by 0x104ED6B: _Destroy<stonedb::core::GroupDistinctCache> (stl_construct.h:98)
==00:01:00:20.807 1339681==    by 0x104ED6B: __destroy<stonedb::core::GroupDistinctCache*> (stl_construct.h:108)
==00:01:00:20.807 1339681==    by 0x104ED6B: _Destroy<stonedb::core::GroupDistinctCache*> (stl_construct.h:137)
==00:01:00:20.807 1339681==    by 0x104ED6B: _Destroy<stonedb::core::GroupDistinctCache*, stonedb::core::GroupDistinctCache> (stl_construct.h:206)
==00:01:00:20.807 1339681==    by 0x104ED6B: ~vector (stl_vector.h:434)
==00:01:00:20.807 1339681==    by 0x104ED6B: ~DistinctWrapper (groupby_wrapper.h:37)
==00:01:00:20.807 1339681==    by 0x104ED6B: stonedb::core::GroupByWrapper::~GroupByWrapper() (groupby_wrapper.cpp:53)
==00:01:00:20.807 1339681==    by 0xFFFACC: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:42)
==00:01:00:20.807 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:20.807 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:20.807 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:20.807 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:20.807 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:20.807 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:20.807 1339681==    by 0x9B63CB: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6428)
==00:01:00:20.807 1339681==  Address 0x11bd9022a is 0 bytes after a block of size 42 alloc'd
==00:01:00:20.807 1339681==    at 0x483E217: operator new[](unsigned long) (vg_replace_malloc.c:640)
==00:01:00:20.807 1339681==    by 0xF025CC: stonedb::system::CacheableItem::CacheableItem(char const*, char const*, int) (cacheable_item.cpp:37)
==00:01:00:20.807 1339681==    by 0x1041C7D: stonedb::core::GroupDistinctCache::GroupDistinctCache() (group_distinct_cache.cpp:25)
==00:01:00:20.807 1339681==    by 0x104FBEF: _Construct<stonedb::core::GroupDistinctCache> (stl_uninitialized.h:82)
==00:01:00:20.807 1339681==    by 0x104FBEF: __uninit_default_n<stonedb::core::GroupDistinctCache*, long unsigned int> (stl_uninitialized.h:527)
==00:01:00:20.807 1339681==    by 0x104FBEF: __uninitialized_default_n<stonedb::core::GroupDistinctCache*, long unsigned int> (stl_uninitialized.h:583)
==00:01:00:20.807 1339681==    by 0x104FBEF: __uninitialized_default_n_a<stonedb::core::GroupDistinctCache*, long unsigned int, stonedb::core::GroupDistinctCache> (stl_uninitialized.h:645)
==00:01:00:20.807 1339681==    by 0x104FBEF: std::vector<stonedb::core::GroupDistinctCache, std::allocator<stonedb::core::GroupDistinctCache> >::_M_default_append(unsigned long) (vector.tcc:579)
==00:01:00:20.807 1339681==    by 0x104EA18: stonedb::core::GroupByWrapper::Initialize(long, bool) (groupby_wrapper.cpp:258)
==00:01:00:20.807 1339681==    by 0xFFF909: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:136)
==00:01:00:20.808 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:20.808 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:20.808 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:20.808 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:20.808 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:20.808 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:20.808 1339681== 
==00:01:00:23.693 1339681== Invalid read of size 1
==00:01:00:23.693 1339681==    at 0x4842654: strlen (vg_replace_strmem.c:494)
==00:01:00:23.693 1339681==    by 0xB75027: length (char_traits.h:320)
==00:01:00:23.693 1339681==    by 0xB75027: std::basic_string<char, std::char_traits<char>, std::allocator<char> >::basic_string(char const*, std::allocator<char> const&) (basic_string.tcc:664)
==00:01:00:23.693 1339681==    by 0xF02E02: stonedb::system::CacheableItem::~CacheableItem() (cacheable_item.cpp:81)
==00:01:00:23.693 1339681==    by 0xEB093C: ~AttrBuffer (temp_table.cpp:49)
==00:01:00:23.693 1339681==    by 0xEB093C: ~AttrBuffer (temp_table.cpp:49)
==00:01:00:23.693 1339681==    by 0xEB093C: stonedb::core::TempTable::Attr::DeleteBuffer() (temp_table.cpp:252)
==00:01:00:23.693 1339681==    by 0xEBA2B0: ~Attr (temp_table.cpp:110)
==00:01:00:23.693 1339681==    by 0xEBA2B0: ~Attr (temp_table.cpp:112)
==00:01:00:23.693 1339681==    by 0xEBA2B0: stonedb::core::TempTable::~TempTable() (temp_table.cpp:921)
==00:01:00:23.693 1339681==    by 0xEBA670: stonedb::core::TempTable::~TempTable() (temp_table.cpp:923)
==00:01:00:23.693 1339681==    by 0xE4CDE9: _M_release (shared_ptr_base.h:154)
==00:01:00:23.693 1339681==    by 0xE4CDE9: ~__shared_count (shared_ptr_base.h:684)
==00:01:00:23.693 1339681==    by 0xE4CDE9: ~__shared_ptr (shared_ptr_base.h:1123)
==00:01:00:23.693 1339681==    by 0xE4CDE9: ~shared_ptr (shared_ptr.h:93)
==00:01:00:23.693 1339681==    by 0xE4CDE9: _Destroy<std::shared_ptr<stonedb::core::JustATable> > (stl_construct.h:98)
==00:01:00:23.693 1339681==    by 0xE4CDE9: __destroy<std::shared_ptr<stonedb::core::JustATable>*> (stl_construct.h:108)
==00:01:00:23.693 1339681==    by 0xE4CDE9: _Destroy<std::shared_ptr<stonedb::core::JustATable>*> (stl_construct.h:137)
==00:01:00:23.693 1339681==    by 0xE4CDE9: _Destroy<std::shared_ptr<stonedb::core::JustATable>*, std::shared_ptr<stonedb::core::JustATable> > (stl_construct.h:206)
==00:01:00:23.693 1339681==    by 0xE4CDE9: ~vector (stl_vector.h:434)
==00:01:00:23.693 1339681==    by 0xE4CDE9: stonedb::core::Query::~Query() (query.cpp:41)
==00:01:00:23.693 1339681==    by 0xE32573: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:360)
==00:01:00:23.693 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:23.693 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:23.693 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:23.693 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:23.693 1339681==  Address 0x11bdd3c1a is 0 bytes after a block of size 42 alloc'd
==00:01:00:23.693 1339681==    at 0x483E217: operator new[](unsigned long) (vg_replace_malloc.c:640)
==00:01:00:23.693 1339681==    by 0xF025CC: stonedb::system::CacheableItem::CacheableItem(char const*, char const*, int) (cacheable_item.cpp:37)
==00:01:00:23.694 1339681==    by 0x100B377: stonedb::core::CachedBuffer<long>::CachedBuffer(unsigned int, unsigned int, stonedb::core::Transaction*) (cached_buffer.cpp:26)
==00:01:00:23.694 1339681==    by 0xEB0A66: AttrBuffer (temp_table.cpp:48)
==00:01:00:23.694 1339681==    by 0xEB0A66: stonedb::core::TempTable::Attr::CreateBuffer(unsigned long, stonedb::core::Transaction*, bool) (temp_table.cpp:174)
==00:01:00:23.694 1339681==    by 0xFFFD67: stonedb::core::AggregationAlgorithm::Aggregate(bool, long&, long&, stonedb::core::ResultSender*) (aggregation_algorithm.cpp:181)
==00:01:00:23.694 1339681==    by 0xEB97FC: stonedb::core::TempTable::Materialize(bool, stonedb::core::ResultSender*, bool) (temp_table.cpp:1972)
==00:01:00:23.694 1339681==    by 0xE327D5: stonedb::core::Engine::Execute(THD*, LEX*, select_result*, st_select_lex_unit*) (engine_execute.cpp:413)
==00:01:00:23.694 1339681==    by 0xE3391E: stonedb::core::Engine::HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (engine_execute.cpp:232)
==00:01:00:23.694 1339681==    by 0xED5421: stonedb::dbhandler::SDB_HandleSelect(THD*, LEX*, select_result*&, unsigned long, int&, int&, int&, int) (ha_rcengine.cpp:82)
==00:01:00:23.694 1339681==    by 0x7E9574: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5170)
==00:01:00:23.694 1339681==    by 0x9B1F89: mysql_execute_command(THD*) (sql_parse.cc:2663)
==00:01:00:23.694 1339681==    by 0x9B63CB: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6428)

Expected behavior

No Leakage

How To Reproduce

Start valgrind

valgrind --tool=memcheck --leak-check=full --time-stamp=yes --show-reachable=yes --show-leak-kinds=all -v --trace-children=yes --track-origins=yes --read-var-info=yes --log-file=$log_dir /stonedb56/install/bin/mysqld --defaults-file=/stonedb56/install/stonedb.cnf --user=mysql

Load TPCH 2G Data TO StoneDB

#!/bin/bash
mysql -uroot -p"xxxx" -hxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/customer.tbl' into table customer fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/lineitem.tbl' into table lineitem fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/nation.tbl' into table nation fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/orders.tbl' into table orders fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/partsupp.tbl' into table partsupp fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/part.tbl' into table part fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/region.tbl' into table region fields terminated by '|';"
mysql -uroot -p"xxxx" -hxxxxxx -P3306 --local-infile -Dtpch -e "load data local infile '/root/stonedb/tpch/tpcH/data/supplier.tbl' into table supplier fields terminated by '|';"

Environment

Ubuntu : 20.04.1
Valgrind : 3.19.0
StoneDB:
build information as follow:
        Repository address: https://github.com/stoneatom/stonedb.git:main
        Branch name: main
        Last commit ID: 4ff00ea
        Last commit time: Date:   Tue Jun 21 19:06:22 2022 +0800
        Build time: Date: Tue Jun 21 12:55:08 UTC 2022

Additional context

konghaiya commented 2 years ago

The cause of the problem is the same as #110