API tools faq
paste
Advertisement
Sergey_Gorshkov

Untitled

Sergey_Gorshkov
Jul 10th, 2019
328
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.34 KB | None | 0 0
raw download clone embed print report
  1. [root@glaber ~]# tail -200 /var/log/clickhouse-server/clickhouse-server.log
  2. 2019.07.10 10:00:36.271394 [ 23 ] {} <Debug> zabbix.history (MergerMutator): Merge sorted 69443 rows, containing 7 columns (7 merged, 0 gathered) in 0.02 sec., 4558805.29 rows/sec., 196.11 MB/sec.
  3. 2019.07.10 10:00:36.272782 [ 23 ] {} <Trace> zabbix.history: Renaming temporary part tmp_merge_20190709_20190710_1_28508_23589 to 20190709_20190710_1_28508_23589.
  4. 2019.07.10 10:00:36.272997 [ 23 ] {} <Trace> zabbix.history (MergerMutator): Merged 2 parts: from 20190709_20190710_1_28503_23588 to 20190710_20190710_28504_28508_1
  5. 2019.07.10 10:00:37.255504 [ 42 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 127.0.0.1:56132, User-Agent: none, Length: 149, Content Type: application/x-www-form-urlencoded, Transfer Encoding: identity
  6. 2019.07.10 10:00:37.255604 [ 42 ] {} <Trace> HTTPHandler: Request URI: /
  7. 2019.07.10 10:00:37.255764 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Debug> executeQuery: (from 127.0.0.1:56132) INSERT INTO zabbix.history (day,itemid,clock,value,value_dbl,value_str,ns) VALUES
  8. 2019.07.10 10:00:37.256007 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Debug> executeQuery: Query pipeline:
  9. NullAndDoCopy
  10. InputStreamFromASTInsertQuery
  11.  
  12. 2019.07.10 10:00:37.257381 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> zabbix.history: Renaming temporary part tmp_insert_20190710_20190710_4504_4504_0 to 20190710_20190710_28513_28513_0.
  13. 2019.07.10 10:00:37.257771 [ 18 ] {} <Trace> zabbix.history: Found 7 old parts to remove.
  14. 2019.07.10 10:00:37.257792 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190709_20190710_1_28011_23160
  15. 2019.07.10 10:00:37.257975 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  16. 2019.07.10 10:00:37.258040 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Aggregating
  17. 2019.07.10 10:00:37.258067 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Aggregation method: keys128
  18. 2019.07.10 10:00:37.258100 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (29298.878 rows/sec., 1.201 MiB/sec.)
  19. 2019.07.10 10:00:37.258112 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Merging aggregated data
  20. 2019.07.10 10:00:37.258690 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190710_20190710_28012_28016_1
  21. 2019.07.10 10:00:37.259118 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> zabbix..inner.trends: Renaming temporary part tmp_insert_201907_4504_4504_0 to 201907_28513_28513_0.
  22. 2019.07.10 10:00:37.259257 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  23. 2019.07.10 10:00:37.259298 [ 9 ] {} <Debug> zabbix.history (MergerMutator): Selected 2 parts from 20190709_20190710_1_28508_23589 to 20190710_20190710_28509_28509_0
  24. 2019.07.10 10:00:37.259341 [ 9 ] {} <Debug> zabbix.history (MergerMutator): Merging 2 parts: from 20190709_20190710_1_28508_23589 to 20190710_20190710_28509_28509_0 into tmp_merge_20190709_20190710_1_28509_23590
  25. 2019.07.10 10:00:37.259455 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190710_20190710_28017_28017_0
  26. 2019.07.10 10:00:37.259462 [ 9 ] {} <Debug> zabbix.history (MergerMutator): Selected MergeAlgorithm: Horizontal
  27. 2019.07.10 10:00:37.259509 [ 9 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 9 marks from part 20190709_20190710_1_28508_23589, total 69443 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  28. 2019.07.10 10:00:37.259682 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  29. 2019.07.10 10:00:37.259739 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Aggregating
  30. 2019.07.10 10:00:37.259765 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Aggregation method: keys128
  31. 2019.07.10 10:00:37.259802 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (26336.582 rows/sec., 1.080 MiB/sec.)
  32. 2019.07.10 10:00:37.259814 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> Aggregator: Merging aggregated data
  33. 2019.07.10 10:00:37.259848 [ 9 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 20190710_20190710_28509_28509_0, total 1 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  34. 2019.07.10 10:00:37.260710 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190710_20190710_28018_28018_0
  35. 2019.07.10 10:00:37.260957 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> zabbix..inner.trends_uint: Renaming temporary part tmp_insert_201907_4504_4504_0 to 201907_28513_28513_0.
  36. 2019.07.10 10:00:37.261075 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  37. 2019.07.10 10:00:37.261151 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Information> executeQuery: Read 1 rows, 43.00 B in 0.005 sec., 186 rows/sec., 7.85 KiB/sec.
  38. 2019.07.10 10:00:37.261216 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Debug> MemoryTracker: Peak memory usage (total): 15.07 MiB.
  39. 2019.07.10 10:00:37.261316 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Debug> MemoryTracker: Peak memory usage (for query): 17.07 MiB.
  40. 2019.07.10 10:00:37.261334 [ 42 ] {f8736341-1519-4b37-b181-4fbd97351109} <Information> HTTPHandler: Done processing query
  41. 2019.07.10 10:00:37.261442 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190710_20190710_28019_28019_0
  42. 2019.07.10 10:00:37.261608 [ 17 ] {} <Trace> zabbix..inner.trends_uint: Found 6 old parts to remove.
  43. 2019.07.10 10:00:37.261625 [ 17 ] {} <Debug> zabbix..inner.trends_uint: Removing part from filesystem 201907_1_28015_5600
  44. 2019.07.10 10:00:37.262187 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190710_20190710_28020_28020_0
  45. 2019.07.10 10:00:37.262529 [ 17 ] {} <Debug> zabbix..inner.trends_uint: Removing part from filesystem 201907_28016_28016_0
  46. 2019.07.10 10:00:37.262879 [ 18 ] {} <Debug> zabbix.history: Removing part from filesystem 20190710_20190710_28021_28021_0
  47. 2019.07.10 10:00:37.263329 [ 17 ] {} <Debug> zabbix..inner.trends_uint: Removing part from filesystem 201907_28017_28017_0
  48. 2019.07.10 10:00:37.263927 [ 45 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 127.0.0.1:56134, User-Agent: none, Length: 152, Content Type: application/x-www-form-urlencoded, Transfer Encoding: identity
  49. 2019.07.10 10:00:37.263984 [ 45 ] {} <Trace> HTTPHandler: Request URI: /
  50. 2019.07.10 10:00:37.264111 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Debug> executeQuery: (from 127.0.0.1:56134) INSERT INTO zabbix.history (day,itemid,clock,value,value_dbl,value_str,ns) VALUES
  51. 2019.07.10 10:00:37.264287 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Debug> executeQuery: Query pipeline:
  52. NullAndDoCopy
  53. InputStreamFromASTInsertQuery
  54.  
  55. 2019.07.10 10:00:37.265293 [ 17 ] {} <Debug> zabbix..inner.trends_uint: Removing part from filesystem 201907_28018_28018_0
  56. 2019.07.10 10:00:37.265436 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> zabbix.history: Renaming temporary part tmp_insert_20190710_20190710_4505_4505_0 to 20190710_20190710_28514_28514_0.
  57. 2019.07.10 10:00:37.266060 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  58. 2019.07.10 10:00:37.266074 [ 17 ] {} <Debug> zabbix..inner.trends_uint: Removing part from filesystem 201907_28019_28019_0
  59. 2019.07.10 10:00:37.266122 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Aggregating
  60. 2019.07.10 10:00:37.266149 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Aggregation method: keys128
  61. 2019.07.10 10:00:37.266178 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (31635.558 rows/sec., 1.297 MiB/sec.)
  62. 2019.07.10 10:00:37.266195 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Merging aggregated data
  63. 2019.07.10 10:00:37.266434 [ 12 ] {} <Debug> zabbix.history (MergerMutator): Selected 5 parts from 20190710_20190710_28510_28510_0 to 20190710_20190710_28514_28514_0
  64. 2019.07.10 10:00:37.266471 [ 12 ] {} <Debug> zabbix.history (MergerMutator): Merging 5 parts: from 20190710_20190710_28510_28510_0 to 20190710_20190710_28514_28514_0 into tmp_merge_20190710_20190710_28510_28514_1
  65. 2019.07.10 10:00:37.266654 [ 12 ] {} <Debug> zabbix.history (MergerMutator): Selected MergeAlgorithm: Horizontal
  66. 2019.07.10 10:00:37.266678 [ 12 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 20190710_20190710_28510_28510_0, total 1 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  67. 2019.07.10 10:00:37.266952 [ 12 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 20190710_20190710_28511_28511_0, total 1 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  68. 2019.07.10 10:00:37.267475 [ 12 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 20190710_20190710_28512_28512_0, total 1 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  69. 2019.07.10 10:00:37.267826 [ 12 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 20190710_20190710_28513_28513_0, total 1 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  70. 2019.07.10 10:00:37.268070 [ 12 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 20190710_20190710_28514_28514_0, total 1 rows starting from the beginning of the part, columns: day, itemid, clock, ns, value, value_dbl, value_str
  71. 2019.07.10 10:00:37.268502 [ 9 ] {} <Debug> zabbix.history (MergerMutator): Merge sorted 69444 rows, containing 7 columns (7 merged, 0 gathered) in 0.01 sec., 7588939.23 rows/sec., 326.45 MB/sec.
  72. 2019.07.10 10:00:37.269534 [ 12 ] {} <Debug> zabbix.history (MergerMutator): Merge sorted 5 rows, containing 7 columns (7 merged, 0 gathered) in 0.00 sec., 1637.72 rows/sec., 0.07 MB/sec.
  73. 2019.07.10 10:00:37.269588 [ 9 ] {} <Trace> zabbix.history: Renaming temporary part tmp_merge_20190709_20190710_1_28509_23590 to 20190709_20190710_1_28509_23590.
  74. 2019.07.10 10:00:37.270216 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> zabbix..inner.trends: Renaming temporary part tmp_insert_201907_4505_4505_0 to 201907_28514_28514_0.
  75. 2019.07.10 10:00:37.270274 [ 9 ] {} <Trace> zabbix.history (MergerMutator): Merged 2 parts: from 20190709_20190710_1_28508_23589 to 20190710_20190710_28509_28509_0
  76. 2019.07.10 10:00:37.270473 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  77. 2019.07.10 10:00:37.270841 [ 17 ] {} <Debug> zabbix..inner.trends_uint: Removing part from filesystem 201907_28020_28020_0
  78. 2019.07.10 10:00:37.271240 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  79. 2019.07.10 10:00:37.271342 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Aggregating
  80. 2019.07.10 10:00:37.271378 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Aggregation method: keys128
  81. 2019.07.10 10:00:37.271404 [ 12 ] {} <Trace> zabbix.history: Renaming temporary part tmp_merge_20190710_20190710_28510_28514_1 to 20190710_20190710_28510_28514_1.
  82. 2019.07.10 10:00:37.271410 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (28349.493 rows/sec., 1.163 MiB/sec.)
  83. 2019.07.10 10:00:37.271456 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> Aggregator: Merging aggregated data
  84. 2019.07.10 10:00:37.271548 [ 12 ] {} <Trace> zabbix.history (MergerMutator): Merged 5 parts: from 20190710_20190710_28510_28510_0 to 20190710_20190710_28514_28514_0
  85. 2019.07.10 10:00:37.272362 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> zabbix..inner.trends_uint: Renaming temporary part tmp_insert_201907_4505_4505_0 to 201907_28514_28514_0.
  86. 2019.07.10 10:00:37.272543 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  87. 2019.07.10 10:00:37.272622 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Information> executeQuery: Read 1 rows, 43.00 B in 0.008 sec., 117 rows/sec., 4.95 KiB/sec.
  88. 2019.07.10 10:00:37.272689 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Debug> MemoryTracker: Peak memory usage (total): 15.07 MiB.
  89. 2019.07.10 10:00:37.272817 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Debug> MemoryTracker: Peak memory usage (for query): 17.07 MiB.
  90. 2019.07.10 10:00:37.272836 [ 45 ] {3b958786-ec2b-4573-b9ea-652e617dc904} <Information> HTTPHandler: Done processing query
  91. 2019.07.10 10:00:38.263044 [ 55 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 127.0.0.1:56136, User-Agent: none, Length: 149, Content Type: application/x-www-form-urlencoded, Transfer Encoding: identity
  92. 2019.07.10 10:00:38.263142 [ 55 ] {} <Trace> HTTPHandler: Request URI: /
  93. 2019.07.10 10:00:38.263302 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Debug> executeQuery: (from 127.0.0.1:56136) INSERT INTO zabbix.history (day,itemid,clock,value,value_dbl,value_str,ns) VALUES
  94. 2019.07.10 10:00:38.263583 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Debug> executeQuery: Query pipeline:
  95. NullAndDoCopy
  96. InputStreamFromASTInsertQuery
  97.  
  98. 2019.07.10 10:00:38.264924 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> zabbix.history: Renaming temporary part tmp_insert_20190710_20190710_4506_4506_0 to 20190710_20190710_28515_28515_0.
  99. 2019.07.10 10:00:38.265663 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  100. 2019.07.10 10:00:38.265735 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Aggregating
  101. 2019.07.10 10:00:38.265762 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Aggregation method: keys128
  102. 2019.07.10 10:00:38.265795 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (29751.279 rows/sec., 1.220 MiB/sec.)
  103. 2019.07.10 10:00:38.265807 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Merging aggregated data
  104. 2019.07.10 10:00:38.266713 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> zabbix..inner.trends: Renaming temporary part tmp_insert_201907_4506_4506_0 to 201907_28515_28515_0.
  105. 2019.07.10 10:00:38.266848 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  106. 2019.07.10 10:00:38.267319 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  107. 2019.07.10 10:00:38.267606 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Aggregating
  108. 2019.07.10 10:00:38.267683 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Aggregation method: keys128
  109. 2019.07.10 10:00:38.267764 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (10220.978 rows/sec., 0.419 MiB/sec.)
  110. 2019.07.10 10:00:38.267796 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> Aggregator: Merging aggregated data
  111. 2019.07.10 10:00:38.269217 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> zabbix..inner.trends_uint: Renaming temporary part tmp_insert_201907_4506_4506_0 to 201907_28515_28515_0.
  112. 2019.07.10 10:00:38.269365 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  113. 2019.07.10 10:00:38.269469 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Information> executeQuery: Read 1 rows, 43.00 B in 0.006 sec., 163 rows/sec., 6.88 KiB/sec.
  114. 2019.07.10 10:00:38.269479 [ 10 ] {} <Debug> zabbix..inner.trends_uint (MergerMutator): Selected 6 parts from 201907_1_28510_5699 to 201907_28515_28515_0
  115. 2019.07.10 10:00:38.269559 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Debug> MemoryTracker: Peak memory usage (total): 15.07 MiB.
  116. 2019.07.10 10:00:38.269579 [ 10 ] {} <Debug> zabbix..inner.trends_uint (MergerMutator): Merging 6 parts: from 201907_1_28510_5699 to 201907_28515_28515_0 into tmp_merge_201907_1_28515_5700
  117. 2019.07.10 10:00:38.269664 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Debug> MemoryTracker: Peak memory usage (for query): 17.07 MiB.
  118. 2019.07.10 10:00:38.269683 [ 55 ] {ead01adc-6070-483d-9b1d-f8e73d2b2602} <Information> HTTPHandler: Done processing query
  119. 2019.07.10 10:00:38.270063 [ 10 ] {} <Debug> zabbix..inner.trends_uint (MergerMutator): Selected MergeAlgorithm: Horizontal
  120. 2019.07.10 10:00:38.270096 [ 10 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_1_28510_5699, total 4173 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  121. 2019.07.10 10:00:38.270323 [ 10 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28511_28511_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  122. 2019.07.10 10:00:38.270571 [ 10 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28512_28512_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  123. 2019.07.10 10:00:38.270782 [ 10 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28513_28513_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  124. 2019.07.10 10:00:38.270976 [ 10 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28514_28514_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  125. 2019.07.10 10:00:38.271179 [ 10 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28515_28515_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  126. 2019.07.10 10:00:38.273972 [ 10 ] {} <Debug> MergingSortedBlockInputStream: Merge sorted 1 blocks, 4178 rows in 0.00 sec., 2088949.87 rows/sec., 91.91 MB/sec.
  127. 2019.07.10 10:00:38.274017 [ 10 ] {} <Debug> zabbix..inner.trends_uint (MergerMutator): Merge sorted 4178 rows, containing 6 columns (6 merged, 0 gathered) in 0.00 sec., 940529.41 rows/sec., 41.38 MB/sec.
  128. 2019.07.10 10:00:38.274807 [ 10 ] {} <Trace> zabbix..inner.trends_uint: Renaming temporary part tmp_merge_201907_1_28515_5700 to 201907_1_28515_5700.
  129. 2019.07.10 10:00:38.274950 [ 10 ] {} <Trace> zabbix..inner.trends_uint (MergerMutator): Merged 6 parts: from 201907_1_28510_5699 to 201907_28515_28515_0
  130. 2019.07.10 10:00:39.267534 [ 48 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 127.0.0.1:56138, User-Agent: none, Length: 149, Content Type: application/x-www-form-urlencoded, Transfer Encoding: identity
  131. 2019.07.10 10:00:39.267633 [ 48 ] {} <Trace> HTTPHandler: Request URI: /
  132. 2019.07.10 10:00:39.267790 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Debug> executeQuery: (from 127.0.0.1:56138) INSERT INTO zabbix.history (day,itemid,clock,value,value_dbl,value_str,ns) VALUES
  133. 2019.07.10 10:00:39.268031 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Debug> executeQuery: Query pipeline:
  134. NullAndDoCopy
  135. InputStreamFromASTInsertQuery
  136.  
  137. 2019.07.10 10:00:39.269474 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> zabbix.history: Renaming temporary part tmp_insert_20190710_20190710_4507_4507_0 to 20190710_20190710_28516_28516_0.
  138. 2019.07.10 10:00:39.269798 [ 14 ] {} <Trace> zabbix..inner.trends: Found 6 old parts to remove.
  139. 2019.07.10 10:00:39.269827 [ 14 ] {} <Debug> zabbix..inner.trends: Removing part from filesystem 201907_1_28017_5528
  140. 2019.07.10 10:00:39.270090 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  141. 2019.07.10 10:00:39.270190 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Aggregating
  142. 2019.07.10 10:00:39.270217 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Aggregation method: keys128
  143. 2019.07.10 10:00:39.270249 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (29456.816 rows/sec., 1.208 MiB/sec.)
  144. 2019.07.10 10:00:39.270260 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Merging aggregated data
  145. 2019.07.10 10:00:39.270674 [ 14 ] {} <Debug> zabbix..inner.trends: Removing part from filesystem 201907_28018_28018_0
  146. 2019.07.10 10:00:39.273521 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> zabbix..inner.trends: Renaming temporary part tmp_insert_201907_4507_4507_0 to 201907_28516_28516_0.
  147. 2019.07.10 10:00:39.273658 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  148. 2019.07.10 10:00:39.273897 [ 14 ] {} <Debug> zabbix..inner.trends: Removing part from filesystem 201907_28019_28019_0
  149. 2019.07.10 10:00:39.274085 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  150. 2019.07.10 10:00:39.274145 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Aggregating
  151. 2019.07.10 10:00:39.274170 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Aggregation method: keys128
  152. 2019.07.10 10:00:39.274197 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Aggregated. 1 to 1 rows (from 0.000 MiB) in 0.000 sec. (34869.935 rows/sec., 1.430 MiB/sec.)
  153. 2019.07.10 10:00:39.274208 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> Aggregator: Merging aggregated data
  154. 2019.07.10 10:00:39.274673 [ 14 ] {} <Debug> zabbix..inner.trends: Removing part from filesystem 201907_28020_28020_0
  155. 2019.07.10 10:00:39.275125 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> zabbix..inner.trends_uint: Renaming temporary part tmp_insert_201907_4507_4507_0 to 201907_28516_28516_0.
  156. 2019.07.10 10:00:39.275258 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  157. 2019.07.10 10:00:39.275329 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Information> executeQuery: Read 1 rows, 43.00 B in 0.008 sec., 133 rows/sec., 5.60 KiB/sec.
  158. 2019.07.10 10:00:39.275384 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Debug> MemoryTracker: Peak memory usage (total): 15.07 MiB.
  159. 2019.07.10 10:00:39.275447 [ 14 ] {} <Debug> zabbix..inner.trends: Removing part from filesystem 201907_28021_28021_0
  160. 2019.07.10 10:00:39.275505 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Debug> MemoryTracker: Peak memory usage (for query): 17.07 MiB.
  161. 2019.07.10 10:00:39.275523 [ 48 ] {79112642-c8d9-4722-bcc8-52b2b55de5e7} <Information> HTTPHandler: Done processing query
  162. 2019.07.10 10:00:39.276215 [ 14 ] {} <Debug> zabbix..inner.trends: Removing part from filesystem 201907_28022_28022_0
  163. 2019.07.10 10:00:40.271124 [ 42 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 127.0.0.1:56140, User-Agent: none, Length: 217, Content Type: application/x-www-form-urlencoded, Transfer Encoding: identity
  164. 2019.07.10 10:00:40.271224 [ 42 ] {} <Trace> HTTPHandler: Request URI: /
  165. 2019.07.10 10:00:40.271379 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Debug> executeQuery: (from 127.0.0.1:56140) INSERT INTO zabbix.history (day,itemid,clock,value,value_dbl,value_str,ns) VALUES
  166. 2019.07.10 10:00:40.271664 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Debug> executeQuery: Query pipeline:
  167. NullAndDoCopy
  168. InputStreamFromASTInsertQuery
  169.  
  170. 2019.07.10 10:00:40.273048 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> zabbix.history: Renaming temporary part tmp_insert_20190710_20190710_4508_4508_0 to 20190710_20190710_28517_28517_0.
  171. 2019.07.10 10:00:40.273653 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  172. 2019.07.10 10:00:40.273721 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Aggregating
  173. 2019.07.10 10:00:40.273748 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Aggregation method: keys128
  174. 2019.07.10 10:00:40.273780 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Aggregated. 2 to 2 rows (from 0.000 MiB) in 0.000 sec. (59516.724 rows/sec., 2.441 MiB/sec.)
  175. 2019.07.10 10:00:40.273792 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Merging aggregated data
  176. 2019.07.10 10:00:40.275119 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> zabbix..inner.trends: Renaming temporary part tmp_insert_201907_4508_4508_0 to 201907_28517_28517_0.
  177. 2019.07.10 10:00:40.275254 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  178. 2019.07.10 10:00:40.275416 [ 19 ] {} <Debug> zabbix..inner.trends (MergerMutator): Selected 6 parts from 201907_1_28512_5627 to 201907_28517_28517_0
  179. 2019.07.10 10:00:40.275525 [ 19 ] {} <Debug> zabbix..inner.trends (MergerMutator): Merging 6 parts: from 201907_1_28512_5627 to 201907_28517_28517_0 into tmp_merge_201907_1_28517_5628
  180. 2019.07.10 10:00:40.275844 [ 19 ] {} <Debug> zabbix..inner.trends (MergerMutator): Selected MergeAlgorithm: Horizontal
  181. 2019.07.10 10:00:40.275874 [ 19 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_1_28512_5627, total 4175 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  182. 2019.07.10 10:00:40.276065 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
  183. 2019.07.10 10:00:40.276081 [ 19 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28513_28513_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  184. 2019.07.10 10:00:40.276122 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Aggregating
  185. 2019.07.10 10:00:40.276150 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Aggregation method: keys128
  186. 2019.07.10 10:00:40.276177 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Aggregated. 2 to 2 rows (from 0.000 MiB) in 0.000 sec. (61268.878 rows/sec., 2.513 MiB/sec.)
  187. 2019.07.10 10:00:40.276189 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> Aggregator: Merging aggregated data
  188. 2019.07.10 10:00:40.276269 [ 19 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28514_28514_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  189. 2019.07.10 10:00:40.276466 [ 19 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28515_28515_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  190. 2019.07.10 10:00:40.276696 [ 19 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28516_28516_0, total 1 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  191. 2019.07.10 10:00:40.276908 [ 19 ] {} <Trace> MergeTreeSequentialBlockInputStream: Reading 1 marks from part 201907_28517_28517_0, total 2 rows starting from the beginning of the part, columns: clock, itemid, num, value_min, value_avg, value_max
  192. 2019.07.10 10:00:40.277120 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> zabbix..inner.trends_uint: Renaming temporary part tmp_insert_201907_4508_4508_0 to 201907_28517_28517_0.
  193. 2019.07.10 10:00:40.277255 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Trace> virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish
  194. 2019.07.10 10:00:40.277328 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Information> executeQuery: Read 2 rows, 86.00 B in 0.006 sec., 338 rows/sec., 14.20 KiB/sec.
  195. 2019.07.10 10:00:40.277388 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Debug> MemoryTracker: Peak memory usage (total): 15.07 MiB.
  196. 2019.07.10 10:00:40.277500 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Debug> MemoryTracker: Peak memory usage (for query): 17.07 MiB.
  197. 2019.07.10 10:00:40.277541 [ 42 ] {592cd50b-aa67-4971-a5f8-d73de524fc50} <Information> HTTPHandler: Done processing query
  198. 2019.07.10 10:00:40.279194 [ 19 ] {} <Debug> MergingSortedBlockInputStream: Merge sorted 1 blocks, 4181 rows in 0.00 sec., 2090449.83 rows/sec., 91.98 MB/sec.
  199. 2019.07.10 10:00:40.279235 [ 19 ] {} <Debug> zabbix..inner.trends (MergerMutator): Merge sorted 4181 rows, containing 6 columns (6 merged, 0 gathered) in 0.00 sec., 1115668.78 rows/sec., 49.09 MB/sec.
  200. 2019.07.10 10:00:40.279882 [ 19 ] {} <Trace> zabbix..inner.trends: Renaming temporary part tmp_merge_201907_1_28517_5628 to 201907_1_28517_5628.
  201. 2019.07.10 10:00:40.280008 [ 19 ] {} <Trace> zabbix..inner.trends (MergerMutator): Merged 6 parts: from 201907_1_28512_5627 to 201907_28517_28517_0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!