??????????????????427??G??????346G??????
------------------ ???????? ------------------
??????:
"dev"
<kai....@huifu.com>;
????????: 2022??11??11??(??????) ????10:16
??????: "dev@doris.apache.org"<dev@doris.apache.org>;
????: ????: ??????????: be????????????????
I1110 17:11:43.881491&amp;nbsp; 4854 data_dir.cpp:739] path:
/home/cv/apache-doris-be-1.1.2/be/storage total capacity: 458232905728,
available capacity: 380353990656
?????????????????????????????????? ????be????????compaction????
-----????????-----
??????: ?????? <1879467...@qq.com.INVALID>
????????: 2022??11??11?? 9:59
??????: dev <dev@doris.apache.org>
????: ??????????: be????????????????
&nbsp; &nbsp; &nbsp;
&nbsp;????????????????????????????demo??Java??mybatis????????????insert int
??????????????????????????????????????????????????be??????????????????????ddl??????????????????????????????????????????be.conf????path??network????????????????????????????????
SimpleDateFormat&nbsp;format&nbsp;=&nbsp;new&nbsp;SimpleDateFormat("yyyy-MM-dd&nbsp;HH:mm:ss");
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(int&nbsp;i&nbsp;=&nbsp;0;&nbsp;i&nbsp;<&nbsp;59999;&nbsp;i++)&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(i&nbsp;%&nbsp;1000&nbsp;==&nbsp;0)&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thread.sleep(2000);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;catch&nbsp;(InterruptedException&nbsp;e)&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EngineGs&nbsp;engineGs&nbsp;=&nbsp;new&nbsp;EngineGs();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setId(i&nbsp;+&nbsp;1L);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setVehicleId(i&nbsp;+&nbsp;10000L);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setEngineState(i&nbsp;%&nbsp;2&nbsp;==&nbsp;0&nbsp;?&nbsp;0&nbsp;:&nbsp;1);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setSpeed(500);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setConsumptionRate(0.75);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setDateTimeStr(format.format(new&nbsp;Date()));
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineGs.setEnterpriseId(123L);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;engineBrandMapper.insertTest(engineGs);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
<insert&nbsp;id="insertTest"&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;insert&nbsp;into&nbsp;t_day(F_ID,&nbsp;F_VEHICLE_ID,&nbsp;F_ENGINE_STATE,&nbsp;F_SPEED,&nbsp;F_CONSUMPTION_RATE,&nbsp;F_DATE_TIME,&nbsp;F_ENTERPRISE_ID)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;values(#{dto.id},&nbsp;#{dto.vehicleId},&nbsp;#{dto.engineState},&nbsp;#{dto.speed},&nbsp;#{dto.consumptionRate},&nbsp;#{dto.dateTimeStr},&nbsp;#{dto.enterpriseId})
&nbsp;&nbsp;&nbsp;&nbsp;</insert&gt;?6?9
------------------&nbsp;????????&nbsp;------------------
??????:
"dev"
<kai....@huifu.com&gt;;
????????:&nbsp;2022??11??11??(??????) ????9:45
??????:&nbsp;"dev@doris.apache.org"<dev@doris.apache.org&gt;;
????:&nbsp;????: be????????????????
????????ddl??insert into????????????????????
-----????????-----
??????: ?????? <1879467...@qq.com.INVALID&gt;
????????: 2022??11??10?? 17:29
??????: dev <dev@doris.apache.org&gt;
????: be????????????????
&amp;nbsp; hi??
&amp;nbsp; &amp;nbsp; &amp;nbsp;
??????????apache-doris-be-1.1.2??????????demo??????6??????????insert
into??????????????3??????????????????????????????????disable_auto_compaction=true????????????????????????????????be.out??????????
start time: Thu Nov 10 17:11:43 CST 2022
WARNING: Logging before InitGoogleLogging() is written to STDERR
I1110 17:11:43.721869&amp;nbsp; 4706 env.cpp:46] Env init successfully.
*** Aborted at 1668071504 (unix time) try "date -d @1668071504" if you are
using GNU date ***
*** SIGSEGV unkown detail explain (@0x0) received by PID 4706 (TID
0x7f0bf7546700) from PID 0; stack trace: *** &amp;nbsp;0#
doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*,
void*) at /mnt/disk2/apache-doris/be/src/common/signal_handler.h:420
&amp;nbsp;1# 0x00007F0C5595C400 in /lib64/libc.so.6 &amp;nbsp;2#
doris::BaseFieldtypeTraits<(doris::FieldType)9&amp;gt;::equal(void const*,
void const*) at /mnt/disk2/apache-doris/be/src/olap/types.h:491
&amp;nbsp;3# doris::TupleReader::_unique_key_next_row(doris::RowCursor*,
doris::MemPool*, doris::ObjectPool*, bool*) at
/mnt/disk2/apache-doris/be/src/olap/tuple_reader.cpp:197
&amp;nbsp;4#
doris::Merger::merge_rowsets(std::shared_ptr<doris::Tablet&amp;gt;,
doris::ReaderType, std::vector<std::shared_ptr<doris::RowsetReader&amp;gt;,
std::allocator<std::shared_ptr<doris::RowsetReader&amp;gt; &amp;gt;
&amp;gt; const&amp;amp;, doris::RowsetWriter*,
doris::Merger::Statistics*) in /home/cv/apache-doris-be-1.1.2/be/lib/doris_be
&amp;nbsp;5# doris::Compaction::do_compaction_impl(long) in
/home/cv/apache-doris-be-1.1.2/be/lib/doris_be
&amp;nbsp;6# doris::Compaction::do_compaction(long) at
/mnt/disk2/apache-doris/be/src/olap/compaction.cpp:112
&amp;nbsp;7# doris::CumulativeCompaction::execute_compact_impl() in
/home/cv/apache-doris-be-1.1.2/be/lib/doris_be
&amp;nbsp;8# doris::Compaction::execute_compact() at
/mnt/disk2/apache-doris/be/src/olap/compaction.cpp:50
&amp;nbsp;9# doris::Tablet::execute_compaction(doris::CompactionType) in
/home/cv/apache-doris-be-1.1.2/be/lib/doris_be
10# std::_Function_handler<void (),
doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet&amp;gt;,
doris::CompactionType)::$_12&amp;gt;::_M_invoke(std::_Any_data
const&amp;amp;) at
/mnt/disk2/ygl/installs/ldbtools/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/std_function.h:291
11# doris::ThreadPool::dispatch_thread() at
/mnt/disk2/apache-doris/be/src/util/threadpool.cpp:578
12# doris::Thread::supervise_thread(void*) at
/mnt/disk2/apache-doris/be/src/util/thread.cpp:407
13# start_thread in /lib64/libpthread.so.0 14# clone in /lib64/libc.so.6
be.INFO??????????
I1110 17:11:43.801707&amp;nbsp; 4706 daemon.cpp:240]&amp;nbsp; version
1.1.2-rc05 RELEASE (build
git://hk-dev01/mnt/disk2/apache-doris@a8323dae4f93cc4653b9b071607090449208fd7c)
Built on Fri, 09 Sep 2022 18:12:12 CST by ygl@hk-dev01
I1110 17:11:43.806525&amp;nbsp; 4706 mem_info.cpp:89] Physical Memory:
31.26 GB
I1110 17:11:43.810570&amp;nbsp; 4706 daemon.cpp:272] Cpu Info:
&amp;nbsp; Model: Intel(R) Xeon(R) Silver 4208 CPU @ 2.10GHz &amp;nbsp;
Cores: 32 &amp;nbsp; Max Possible Cores: 32 &amp;nbsp; L1 Cache: 32.00
KB (Line: 64.00 B) &amp;nbsp; L2 Cache: 1.00 MB (Line: 64.00 B)
&amp;nbsp; L3 Cache: 11.00 MB (Line: 64.00 B) &amp;nbsp; Hardware
Supports:
&amp;nbsp; &amp;nbsp; ssse3
&amp;nbsp; &amp;nbsp; sse4_1
&amp;nbsp; &amp;nbsp; sse4_2
&amp;nbsp; &amp;nbsp; popcnt
&amp;nbsp; &amp;nbsp; avx
&amp;nbsp; &amp;nbsp; avx2
&amp;nbsp; Numa Nodes: 2
&amp;nbsp; Numa Nodes of Cores: 0-&amp;gt;0 | 1-&amp;gt;0 |
2-&amp;gt;0 | 3-&amp;gt;0 | 4-&amp;gt;0 | 5-&amp;gt;0 |
6-&amp;gt;0 | 7-&amp;gt;0 | 8-&amp;gt;0 | 9-&amp;gt;0 |
10-&amp;gt;0 | 11-&amp;gt;0 | 12-&amp;gt;0 | 13-&amp;gt;0 |
14-&amp;gt;0 | 15-&amp;gt;0 | 16-&amp;gt;1 | 17-&amp;gt;1 |
18-&amp;gt;1 | 19-&amp;gt;1 | 20-&amp;gt;1 | 21-&amp;gt;1 |
22-&amp;gt;1 | 23-&amp;gt;1 | 24-&amp;gt;1 | 25-&amp;gt;1 |
26-&amp;gt;1 | 27-&amp;gt;1 | 28-&amp;gt;1 | 29-&amp;gt;1 |
30-&amp;gt;1 | 31-&amp;gt;1 |
I1110 17:11:43.810644&amp;nbsp; 4706 daemon.cpp:273] Disk
Info:&amp;nbsp; &amp;nbsp; Num disks 3: sda, sr, dm-
I1110 17:11:43.810652&amp;nbsp; 4706 daemon.cpp:274] Physical Memory: 31.26
GB Memory Limt: 25.01 GB Current Usage: 0 CGroup Info: Process CGroup Info:
memory.limit_in_bytes=9223372036854771712, cpu cfs limits: unlimited
I1110 17:11:43.811475&amp;nbsp; 4706 backend_options.cpp:88] priority cidrs
in conf: 10.10.11.0/24
I1110 17:11:43.811609&amp;nbsp; 4706 backend_options.cpp:76] local host
ip=10.10.11.151
I1110 17:11:43.815408&amp;nbsp; 4706 exec_env_init.cpp:118] scan thread
pool use PriorityWorkStealingThreadPool
I1110 17:11:43.816560&amp;nbsp; 4771 fragment_mgr.cpp:699] FragmentMgr
cancel worker start working.
I1110 17:11:43.873380&amp;nbsp; 4706 load_path_mgr.cpp:58] Load path
configured to [/home/cv/apache-doris-be-1.1.2/be/storage/mini_download]
I1110 17:11:43.873428&amp;nbsp; 4848 result_buffer_mgr.cpp:142] result
buffer manager cancel thread begin.
I1110 17:11:43.873529&amp;nbsp; 4706 exec_env_init.cpp:223] Using global
memory limit: 25.01 GB, origin config value: 80%
I1110 17:11:43.873634&amp;nbsp; 4706 exec_env_init.cpp:264] Buffer pool
memory limit: 5.00 GB, origin config value: 20%. clean pages limit: 2.50 GB,
origin config value: 50%
I1110 17:11:43.876905&amp;nbsp; 4706 exec_env_init.cpp:280] Storage page
cache memory limit: 5.00 GB, origin config value: 20%
I1110 17:11:43.878834&amp;nbsp; 4706 tmp_file_mgr.cc:113] Using scratch
directory /home/cv/apache-doris-be-1.1.2/be/storage/doris-scratch on disk 2
I1110 17:11:43.878902&amp;nbsp; 4706 exec_env_init.cpp:309] Chunk allocator
memory limit: 2.00 GB, origin config value: 2147483648
I1110 17:11:43.881217&amp;nbsp; 4706 storage_engine.cpp:100] starting
backend using uid:bf427e76d6265c55-0ff40281990f2189
I1110 17:11:43.881491&amp;nbsp; 4854 data_dir.cpp:739] path:
/home/cv/apache-doris-be-1.1.2/be/storage total capacity: 458232905728,
available capacity: 380353990656
I1110 17:11:43.881717&amp;nbsp; 4854 data_dir.cpp:204] path:
/home/cv/apache-doris-be-1.1.2/be/storage, hash: 5426859093020019257
I1110 17:11:43.976120&amp;nbsp; 4706 storage_engine.cpp:256] stream load
record path: /home/cv/apache-doris-be-1.1.2/be/storage
I1110 17:11:44.043159&amp;nbsp; 4940 data_dir.cpp:386] start to load
tablets from /home/cv/apache-doris-be-1.1.2/be/storage
I1110 17:11:44.043560&amp;nbsp; 4940 data_dir.cpp:379] successfully check
incompatible old format meta /home/cv/apache-doris-be-1.1.2/be/storage
I1110 17:11:44.043581&amp;nbsp; 4940 data_dir.cpp:396] begin loading rowset
from meta
I1110 17:11:44.043814&amp;nbsp; 4940 data_dir.cpp:416] load rowset from
meta finished, data dir: /home/cv/apache-doris-be-1.1.2/be/storage
I1110 17:11:44.043828&amp;nbsp; 4940 data_dir.cpp:421] begin loading tablet
from meta
I1110 17:11:44.242991&amp;nbsp; 4940 data_dir.cpp:470] load tablet from
meta finished, loaded tablet: 4539, error tablet: 0, path:
/home/cv/apache-doris-be-1.1.2/be/storage
I1110 17:11:44.243028&amp;nbsp; 4940 data_dir.cpp:543] finish to load
tablets from /home/cv/apache-doris-be-1.1.2/be/storage, total rowset meta: 3,
invalid rowset num: 0
I1110 17:11:44.244043&amp;nbsp; 4706 storage_engine.cpp:104] success to
init storage engine.
I1110 17:11:44.244122&amp;nbsp; 4706 olap_server.cpp:50] unused rowset
monitor thread started
I1110 17:11:44.244285&amp;nbsp; 4706 olap_server.cpp:56] garbage sweeper
thread started
I1110 17:11:44.244421&amp;nbsp; 4706 olap_server.cpp:62] disk stat monitor
thread started
I1110 17:11:44.248678&amp;nbsp; 4706 olap_server.cpp:114] compaction tasks
producer thread started
I1110 17:11:44.248697&amp;nbsp; 4985 olap_server.cpp:426] try to start
compaction producer process!
I1110 17:11:44.248818&amp;nbsp; 4706 olap_server.cpp:128] tablet checkpoint
tasks producer thread started
I1110 17:11:44.248914&amp;nbsp; 4986 olap_server.cpp:331] begin to produce
tablet meta checkpoint tasks.
I1110 17:11:44.248952&amp;nbsp; 4706 olap_server.cpp:134] fd cache clean
thread started
I1110 17:11:44.250069&amp;nbsp; 4988 olap_server.cpp:312] try to perform
path scan!
I1110 17:11:44.250088&amp;nbsp; 4988 data_dir.cpp:660] start to scan data
dir path:/home/cv/apache-doris-be-1.1.2/be/storage
I1110 17:11:44.250088&amp;nbsp; 4706 olap_server.cpp:156] path scan/gc
threads started. number:1
I1110 17:11:44.250108&amp;nbsp; 4706 olap_server.cpp:159] all storage
engine's background threads are started.
I1110 17:11:44.250173&amp;nbsp; 4990 olap_server.cpp:287] try to start path
gc thread!
I1110 17:11:44.250198&amp;nbsp; 4990 olap_server.cpp:290] try to perform
path gc by tablet!
I1110 17:11:44.254791&amp;nbsp; 4974 compaction.cpp:138] start cumulative
compaction. tablet=223773.1946636312.9142e80eeff35fb3-beb419325a9c37b4,
output_version=[2-60], permits: 59
I1110 17:11:44.260146&amp;nbsp; 4989 tablet_manager.cpp:1202] finish to do
meta checkpoint on dir: /home/cv/apache-doris-be-1.1.2/be/storage, number: 0,
cost(ms): 1
I1110 17:11:44.262894&amp;nbsp; 4706 agent_server.cpp:99] Register user
resource listener
I1110 17:11:44.262941&amp;nbsp; 4706 backend_service.cpp:82]
DorisInternalService listening on 9060
I1110 17:11:44.263602&amp;nbsp; 4706 thrift_server.cpp:355] ThriftServer
'backend' started on port: 9060
I1110 17:11:44.270102&amp;nbsp; 4973 compaction.cpp:138] start cumulative
compaction. tablet=223777.1946636312.2449a4f3990d0cf0-5192af096b13689b,
output_version=[2-60], permits: 59
I1110 17:11:44.285086&amp;nbsp; 4706 server.cpp:1066]
Server[doris::PInternalServiceImpl<doris::PBackendService&amp;gt;] is
serving on port=8060.
I1110 17:11:44.285102&amp;nbsp; 4706 server.cpp:1069] Check out
http://localhost.localdomain:8060 in web browser.
I1110 17:11:44.309863&amp;nbsp; 4706 thrift_server.cpp:355] ThriftServer
'heartbeat' started on port: 9050
I1110 17:11:44.350798&amp;nbsp; 4988 data_dir.cpp:709] scan data dir path:
/home/cv/apache-doris-be-1.1.2/be/storage finished. path size: 5914
I1110 17:11:44.351671&amp;nbsp; 4990 data_dir.cpp:567] start to path gc by
tablet schemahash.
I1110 17:11:44.410344&amp;nbsp; 4990 data_dir.cpp:606] finished one time
path gc by tablet.
I1110 17:11:44.410378&amp;nbsp; 4990 olap_server.cpp:293] try to perform
path gc by rowsetid!
I1110 17:11:44.410387&amp;nbsp; 4990 data_dir.cpp:617] start to path gc by
rowsetid.
I1110 17:11:44.431969&amp;nbsp; 4990 data_dir.cpp:650] finished one time
path gc by rowsetid.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org For additional
commands, e-mail: dev-h...@doris.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org
For additional commands, e-mail: dev-h...@doris.apache.org
