MergeTreeData.cpp 36.1 KB
Newer Older
M
Merge  
Michael Kolupaev 已提交
1
#include <DB/Storages/MergeTree/MergeTreeData.h>
M
Merge  
Michael Kolupaev 已提交
2
#include <Yandex/time2str.h>
M
Merge  
Michael Kolupaev 已提交
3
#include <Poco/Ext/ScopedTry.h>
M
Merge  
Michael Kolupaev 已提交
4
#include <DB/Interpreters/ExpressionAnalyzer.h>
M
Merge  
Michael Kolupaev 已提交
5
#include <DB/Storages/MergeTree/MergeTreeReader.h>
M
Merge  
Michael Kolupaev 已提交
6 7
#include <DB/Storages/MergeTree/MergeTreeBlockInputStream.h>
#include <DB/Storages/MergeTree/MergedBlockOutputStream.h>
M
Merge  
Michael Kolupaev 已提交
8
#include <DB/Storages/MergeTree/MergeTreePartChecker.h>
M
Merge  
Michael Kolupaev 已提交
9 10 11
#include <DB/Parsers/ASTIdentifier.h>
#include <DB/Parsers/ASTNameTypePair.h>
#include <DB/DataStreams/ExpressionBlockInputStream.h>
M
Merge  
Michael Kolupaev 已提交
12
#include <DB/DataStreams/copyData.h>
M
Merge  
Michael Kolupaev 已提交
13
#include <DB/IO/WriteBufferFromFile.h>
A
Merge  
Alexey Milovidov 已提交
14
#include <DB/DataTypes/DataTypeDate.h>
P
Merge  
Pavel Kartavyy 已提交
15
#include <algorithm>
M
Merge  
Michael Kolupaev 已提交
16 17 18 19 20 21 22



namespace DB
{

MergeTreeData::MergeTreeData(
M
Merge  
Michael Kolupaev 已提交
23
	const String & full_path_, NamesAndTypesListPtr columns_,
M
Merge  
Michael Kolupaev 已提交
24 25 26 27 28 29
	const Context & context_,
	ASTPtr & primary_expr_ast_,
	const String & date_column_name_, const ASTPtr & sampling_expression_,
	size_t index_granularity_,
	Mode mode_,
	const String & sign_column_,
M
Merge  
Michael Kolupaev 已提交
30
	const MergeTreeSettings & settings_,
M
Merge  
Michael Kolupaev 已提交
31
	const String & log_name_,
M
Merge  
Michael Kolupaev 已提交
32 33
	bool require_part_metadata_,
	BrokenPartCallback broken_part_callback_)
M
Merge  
Michael Kolupaev 已提交
34
	: context(context_),
M
Merge  
Michael Kolupaev 已提交
35 36 37
	date_column_name(date_column_name_), sampling_expression(sampling_expression_),
	index_granularity(index_granularity_),
	mode(mode_), sign_column(sign_column_),
M
Merge  
Michael Kolupaev 已提交
38
	settings(settings_), primary_expr_ast(primary_expr_ast_->clone()),
M
Merge  
Michael Kolupaev 已提交
39
	require_part_metadata(require_part_metadata_),
M
Merge  
Michael Kolupaev 已提交
40 41 42
	full_path(full_path_), columns(columns_),
	broken_part_callback(broken_part_callback_),
	log_name(log_name_), log(&Logger::get(log_name + " (Data)"))
M
Merge  
Michael Kolupaev 已提交
43
{
A
Merge  
Alexey Milovidov 已提交
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
	/// Проверяем, что столбец с датой существует и имеет тип Date.
	{
		auto it = columns->begin();
		for (; it != columns->end(); ++it)
		{
			if (it->name == date_column_name)
			{
				if (!typeid_cast<const DataTypeDate *>(&*it->type))
					throw Exception("Date column (" + date_column_name + ") for storage of MergeTree family must have type Date."
						" Provided column of type " + it->type->getName() + "."
						" You may have separate column with type " + it->type->getName() + ".", ErrorCodes::BAD_TYPE_OF_FIELD);
				break;
			}
		}

		if (it == columns->end())
			throw Exception("Date column (" + date_column_name + ") does not exist in table declaration.", ErrorCodes::NO_SUCH_COLUMN_IN_TABLE);
	}

M
Merge  
Michael Kolupaev 已提交
63 64
	/// создаём директорию, если её нет
	Poco::File(full_path).createDirectories();
M
Merge  
Michael Kolupaev 已提交
65
	Poco::File(full_path + "detached").createDirectory();
M
Merge  
Michael Kolupaev 已提交
66 67 68

	/// инициализируем описание сортировки
	sort_descr.reserve(primary_expr_ast->children.size());
M
Merge  
Michael Kolupaev 已提交
69
	for (const ASTPtr & ast : primary_expr_ast->children)
M
Merge  
Michael Kolupaev 已提交
70
	{
M
Merge  
Michael Kolupaev 已提交
71
		String name = ast->getColumnName();
M
Merge  
Michael Kolupaev 已提交
72 73 74 75 76 77 78
		sort_descr.push_back(SortColumnDescription(name, 1));
	}

	primary_expr = ExpressionAnalyzer(primary_expr_ast, context, *columns).getActions(false);

	ExpressionActionsPtr projected_expr = ExpressionAnalyzer(primary_expr_ast, context, *columns).getActions(true);
	primary_key_sample = projected_expr->getSampleBlock();
M
Merge  
Michael Kolupaev 已提交
79
}
M
Merge  
Michael Kolupaev 已提交
80

M
Merge  
Michael Kolupaev 已提交
81 82
UInt64 MergeTreeData::getMaxDataPartIndex()
{
M
Merge  
Michael Kolupaev 已提交
83
	UInt64 max_part_id = 0;
84 85 86
	for (const auto & part : data_parts)
		max_part_id = std::max(max_part_id, part->right);

M
Merge  
Michael Kolupaev 已提交
87
	return max_part_id;
M
Merge  
Michael Kolupaev 已提交
88 89
}

M
Merge  
Michael Kolupaev 已提交
90
std::string MergeTreeData::getModePrefix() const
M
Merge  
Michael Kolupaev 已提交
91
{
M
Merge  
Michael Kolupaev 已提交
92
	switch (mode)
M
Merge  
Michael Kolupaev 已提交
93
	{
M
Merge  
Michael Kolupaev 已提交
94 95 96
		case Ordinary: 		return "";
		case Collapsing: 	return "Collapsing";
		case Summing: 		return "Summing";
S
Merge  
Sergey Fedorov 已提交
97
		case Aggregating: 	return "Aggregating";
M
Merge  
Michael Kolupaev 已提交
98

M
Merge  
Michael Kolupaev 已提交
99 100
		default:
			throw Exception("Unknown mode of operation for MergeTreeData: " + toString(mode), ErrorCodes::LOGICAL_ERROR);
M
Merge  
Michael Kolupaev 已提交
101 102 103 104
	}
}


M
Merge  
Michael Kolupaev 已提交
105
void MergeTreeData::loadDataParts(bool skip_sanity_checks)
M
Merge  
Michael Kolupaev 已提交
106 107 108 109 110 111 112 113
{
	LOG_DEBUG(log, "Loading data parts");

	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);
	Poco::ScopedLock<Poco::FastMutex> lock_all(all_data_parts_mutex);

	data_parts.clear();

M
Merge  
Michael Kolupaev 已提交
114
	Strings all_file_names;
M
Merge  
Michael Kolupaev 已提交
115 116
	Poco::DirectoryIterator end;
	for (Poco::DirectoryIterator it(full_path); it != end; ++it)
M
Merge  
Michael Kolupaev 已提交
117
		all_file_names.push_back(it.name());
M
Merge  
Michael Kolupaev 已提交
118

M
Merge  
Michael Kolupaev 已提交
119 120 121
	Strings part_file_names;
	for (const String & file_name : all_file_names)
	{
M
Merge  
Michael Kolupaev 已提交
122 123 124 125
		/// Удаляем временные директории старше суток.
		if (0 == file_name.compare(0, strlen("tmp_"), "tmp_"))
			continue;

M
Merge  
Michael Kolupaev 已提交
126
		/// TODO: Это можно удалить, если нигде больше не осталось директорий old_* (их давно никто не пишет).
M
Merge  
Michael Kolupaev 已提交
127
		if (0 == file_name.compare(0, strlen("old_"), "old_"))
M
Merge  
Michael Kolupaev 已提交
128 129 130 131 132 133
		{
			String new_file_name = file_name.substr(strlen("old_"));
			LOG_WARNING(log, "Renaming " << file_name << " to " << new_file_name << " for compatibility reasons");
			Poco::File(full_path + file_name).renameTo(full_path + new_file_name);
			part_file_names.push_back(new_file_name);
		}
M
Merge  
Michael Kolupaev 已提交
134
		else
M
Merge  
Michael Kolupaev 已提交
135
		{
M
Merge  
Michael Kolupaev 已提交
136
			part_file_names.push_back(file_name);
M
Merge  
Michael Kolupaev 已提交
137
		}
M
Merge  
Michael Kolupaev 已提交
138 139
	}

M
Merge  
Michael Kolupaev 已提交
140
	DataPartsVector broken_parts_to_remove;
M
Merge  
Michael Kolupaev 已提交
141 142
	DataPartsVector broken_parts_to_detach;
	size_t suspicious_broken_parts = 0;
M
Merge  
Michael Kolupaev 已提交
143

M
Merge  
Michael Kolupaev 已提交
144
	Poco::RegularExpression::MatchVec matches;
M
Merge  
Michael Kolupaev 已提交
145
	for (const String & file_name : part_file_names)
M
Merge  
Michael Kolupaev 已提交
146
	{
M
Merge  
Michael Kolupaev 已提交
147
		if (!ActiveDataPartSet::isPartDirectory(file_name, &matches))
M
Merge  
Michael Kolupaev 已提交
148 149
			continue;

M
Merge  
Michael Kolupaev 已提交
150
		MutableDataPartPtr part = std::make_shared<DataPart>(*this);
151
		ActiveDataPartSet::parsePartName(file_name, *part, &matches);
M
Merge  
Michael Kolupaev 已提交
152 153
		part->name = file_name;

M
Merge  
Michael Kolupaev 已提交
154 155 156 157
		bool broken = false;

		try
		{
M
Merge  
Michael Kolupaev 已提交
158 159
			part->loadColumns(require_part_metadata);
			part->loadChecksums(require_part_metadata);
M
Merge  
Michael Kolupaev 已提交
160
			part->loadIndex();
M
Merge  
Michael Kolupaev 已提交
161
			part->checkNotBroken(require_part_metadata);
M
Merge  
Michael Kolupaev 已提交
162 163 164 165 166 167 168
		}
		catch (...)
		{
			broken = true;
			tryLogCurrentException(__PRETTY_FUNCTION__);
		}

M
Merge  
Michael Kolupaev 已提交
169
		/// Игнорируем и, возможно, удаляем битые куски, которые могут образовываться после грубого перезапуска сервера.
M
Merge  
Michael Kolupaev 已提交
170
		if (broken)
M
Merge  
Michael Kolupaev 已提交
171 172 173 174
		{
			if (part->level == 0)
			{
				/// Восстановить куски нулевого уровня невозможно.
175
				LOG_ERROR(log, "Removing broken part " << full_path + file_name << " because it's impossible to repair.");
M
Merge  
Michael Kolupaev 已提交
176
				broken_parts_to_remove.push_back(part);
M
Merge  
Michael Kolupaev 已提交
177 178 179
			}
			else
			{
M
Merge  
Michael Kolupaev 已提交
180 181 182 183 184
				/// Посмотрим, сколько кусков покрыты битым. Если хотя бы два, предполагаем, что битый кусок образован их
				///  слиянием, и мы ничего не потеряем, если его удалим.
				int contained_parts = 0;

				LOG_ERROR(log, "Part " << full_path + file_name << " is broken. Looking for parts to replace it.");
M
Merge  
Michael Kolupaev 已提交
185
				++suspicious_broken_parts;
M
Merge  
Michael Kolupaev 已提交
186 187 188 189 190

				for (const String & contained_name : part_file_names)
				{
					if (contained_name == file_name)
						continue;
M
Merge  
Michael Kolupaev 已提交
191
					if (!ActiveDataPartSet::isPartDirectory(contained_name, &matches))
M
Merge  
Michael Kolupaev 已提交
192 193
						continue;
					DataPart contained_part(*this);
194
					ActiveDataPartSet::parsePartName(contained_name, contained_part, &matches);
M
Merge  
Michael Kolupaev 已提交
195 196 197 198 199 200 201 202 203 204
					if (part->contains(contained_part))
					{
						LOG_ERROR(log, "Found part " << full_path + contained_name);
						++contained_parts;
					}
				}

				if (contained_parts >= 2)
				{
					LOG_ERROR(log, "Removing broken part " << full_path + file_name << " because it covers at least 2 other parts");
M
Merge  
Michael Kolupaev 已提交
205
					broken_parts_to_remove.push_back(part);
M
Merge  
Michael Kolupaev 已提交
206 207 208
				}
				else
				{
M
Merge  
Michael Kolupaev 已提交
209
					LOG_ERROR(log, "Detaching broken part " << full_path + file_name
M
Merge  
Michael Kolupaev 已提交
210
						<< " because it covers less than 2 parts. You need to resolve this manually");
M
Merge  
Michael Kolupaev 已提交
211
					broken_parts_to_detach.push_back(part);
M
Merge  
Michael Kolupaev 已提交
212
				}
M
Merge  
Michael Kolupaev 已提交
213 214 215 216 217 218 219 220 221 222
			}

			continue;
		}

		part->modification_time = Poco::File(full_path + file_name).getLastModified().epochTime();

		data_parts.insert(part);
	}

M
Merge  
Michael Kolupaev 已提交
223 224
	if (suspicious_broken_parts > 5 && !skip_sanity_checks)
		throw Exception("Suspiciously many (" + toString(suspicious_broken_parts) + ") broken parts to remove.",
M
Merge  
Michael Kolupaev 已提交
225 226 227 228
			ErrorCodes::TOO_MANY_UNEXPECTED_DATA_PARTS);

	for (const auto & part : broken_parts_to_remove)
		part->remove();
M
Merge  
Michael Kolupaev 已提交
229 230
	for (const auto & part : broken_parts_to_detach)
		part->renameAddPrefix("detached/");
M
Merge  
Michael Kolupaev 已提交
231

M
Merge  
Michael Kolupaev 已提交
232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257
	all_data_parts = data_parts;

	/** Удаляем из набора актуальных кусков куски, которые содержатся в другом куске (которые были склеены),
	  *  но по каким-то причинам остались лежать в файловой системе.
	  * Удаление файлов будет произведено потом в методе clearOldParts.
	  */

	if (data_parts.size() >= 2)
	{
		DataParts::iterator prev_jt = data_parts.begin();
		DataParts::iterator curr_jt = prev_jt;
		++curr_jt;
		while (curr_jt != data_parts.end())
		{
			/// Куски данных за разные месяцы рассматривать не будем
			if ((*curr_jt)->left_month != (*curr_jt)->right_month
				|| (*curr_jt)->right_month != (*prev_jt)->left_month
				|| (*prev_jt)->left_month != (*prev_jt)->right_month)
			{
				++prev_jt;
				++curr_jt;
				continue;
			}

			if ((*curr_jt)->contains(**prev_jt))
			{
M
Merge  
Michael Kolupaev 已提交
258
				(*prev_jt)->remove_time = time(0);
M
Merge  
Michael Kolupaev 已提交
259 260 261 262 263 264
				data_parts.erase(prev_jt);
				prev_jt = curr_jt;
				++curr_jt;
			}
			else if ((*prev_jt)->contains(**curr_jt))
			{
M
Merge  
Michael Kolupaev 已提交
265
				(*curr_jt)->remove_time = time(0);
M
Merge  
Michael Kolupaev 已提交
266 267 268 269 270 271 272 273 274 275
				data_parts.erase(curr_jt++);
			}
			else
			{
				++prev_jt;
				++curr_jt;
			}
		}
	}

A
Merge  
Andrey Mironov 已提交
276 277
	calculateColumnSizes();

M
Merge  
Michael Kolupaev 已提交
278 279 280 281
	LOG_DEBUG(log, "Loaded data parts (" << data_parts.size() << " items)");
}


M
Merge  
Michael Kolupaev 已提交
282
MergeTreeData::DataPartsVector MergeTreeData::grabOldParts()
M
Merge  
Michael Kolupaev 已提交
283 284
{
	Poco::ScopedTry<Poco::FastMutex> lock;
M
Merge  
Michael Kolupaev 已提交
285
	DataPartsVector res;
M
Merge  
Michael Kolupaev 已提交
286 287 288

	/// Если метод уже вызван из другого потока (или если all_data_parts прямо сейчас меняют), то можно ничего не делать.
	if (!lock.lock(&all_data_parts_mutex))
289 290
	{
		LOG_TRACE(log, "grabOldParts: all_data_parts is locked");
M
Merge  
Michael Kolupaev 已提交
291
		return res;
292
	}
M
Merge  
Michael Kolupaev 已提交
293

M
Merge  
Michael Kolupaev 已提交
294 295
	/// Удаляем временные директории старше суток.
	Poco::DirectoryIterator end;
296
	for (Poco::DirectoryIterator it{full_path}; it != end; ++it)
M
Merge  
Michael Kolupaev 已提交
297
	{
298
		if (0 == it.name().compare(0, strlen("tmp_"), "tmp_"))
M
Merge  
Michael Kolupaev 已提交
299
		{
300
			Poco::File tmp_dir(full_path + it.name());
M
Merge  
Michael Kolupaev 已提交
301 302 303

			if (tmp_dir.isDirectory() && tmp_dir.getLastModified().epochTime() + 86400 < time(0))
			{
304 305
				LOG_WARNING(log, "Removing temporary directory " << full_path << it.name());
				Poco::File(full_path + it.name()).remove(true);
M
Merge  
Michael Kolupaev 已提交
306 307 308 309
			}
		}
	}

M
Merge  
Michael Kolupaev 已提交
310 311 312 313 314 315 316 317 318 319 320 321 322 323 324
	time_t now = time(0);
	for (DataParts::iterator it = all_data_parts.begin(); it != all_data_parts.end();)
	{
		int ref_count = it->use_count();
		if (ref_count == 1 && /// После этого ref_count не может увеличиться.
			(*it)->remove_time < now &&
			now - (*it)->remove_time > settings.old_parts_lifetime)
		{
			res.push_back(*it);
			all_data_parts.erase(it++);
		}
		else
			++it;
	}

M
Merge  
Michael Kolupaev 已提交
325
	return res;
M
Merge  
Michael Kolupaev 已提交
326 327
}

M
Merge  
Michael Kolupaev 已提交
328 329 330 331 332 333 334 335 336 337
void MergeTreeData::addOldParts(const MergeTreeData::DataPartsVector & parts)
{
	Poco::ScopedLock<Poco::FastMutex> lock(all_data_parts_mutex);
	all_data_parts.insert(parts.begin(), parts.end());
}

void MergeTreeData::clearOldParts()
{
	auto parts_to_remove = grabOldParts();

338
	for (const DataPartPtr & part : parts_to_remove)
M
Merge  
Michael Kolupaev 已提交
339 340 341 342 343 344
	{
		LOG_DEBUG(log, "Removing part " << part->name);
		part->remove();
	}
}

M
Merge  
Michael Kolupaev 已提交
345
void MergeTreeData::setPath(const String & new_full_path, bool move_data)
M
Merge  
Michael Kolupaev 已提交
346
{
M
Merge  
Michael Kolupaev 已提交
347 348 349 350 351 352
	if (move_data)
	{
		Poco::File(full_path).renameTo(new_full_path);
		/// Если данные перемещать не нужно, значит их переместил кто-то другой. Расчитываем, что он еще и сбросил кеши.
		context.resetCaches();
	}
353

M
Merge  
Michael Kolupaev 已提交
354
	full_path = new_full_path;
M
Merge  
Michael Kolupaev 已提交
355 356
}

M
Merge  
Michael Kolupaev 已提交
357
void MergeTreeData::dropAllData()
M
Merge  
Michael Kolupaev 已提交
358 359 360
{
	data_parts.clear();
	all_data_parts.clear();
A
Merge  
Andrey Mironov 已提交
361
	column_sizes.clear();
M
Merge  
Michael Kolupaev 已提交
362

363
	context.resetCaches();
364

M
Merge  
Michael Kolupaev 已提交
365 366 367 368
	Poco::File(full_path).remove(true);
}


M
Merge  
Michael Kolupaev 已提交
369
void MergeTreeData::checkAlter(const AlterCommands & params)
M
Merge  
Michael Kolupaev 已提交
370
{
M
Merge  
Michael Kolupaev 已提交
371 372 373
	/// Проверим, что указанные преобразования можно совершить над списком столбцов без учета типов.
	NamesAndTypesList new_columns = *columns;
	params.apply(new_columns);
M
Merge  
Michael Kolupaev 已提交
374

M
Merge  
Michael Kolupaev 已提交
375 376 377 378 379
	/// Список столбцов, которые нельзя трогать.
	/// sampling_expression можно не учитывать, потому что он обязан содержаться в первичном ключе.
	Names keys = primary_expr->getRequiredColumns();
	keys.push_back(sign_column);
	std::sort(keys.begin(), keys.end());
M
Merge  
Michael Kolupaev 已提交
380

M
Merge  
Michael Kolupaev 已提交
381
	for (const AlterCommand & command : params)
382
	{
M
Merge  
Michael Kolupaev 已提交
383 384
		if (std::binary_search(keys.begin(), keys.end(), command.column_name))
			throw Exception("trying to ALTER key column " + command.column_name, ErrorCodes::ILLEGAL_COLUMN);
385 386
	}

M
Merge  
Michael Kolupaev 已提交
387 388 389 390
	/// Проверим, что преобразования типов возможны.
	ExpressionActionsPtr unused_expression;
	NameToNameMap unused_map;
	createConvertExpression(nullptr, *columns, new_columns, unused_expression, unused_map);
M
Merge  
Michael Kolupaev 已提交
391 392
}

393
void MergeTreeData::createConvertExpression(const DataPartPtr & part, const NamesAndTypesList & old_columns, const NamesAndTypesList & new_columns,
M
Merge  
Michael Kolupaev 已提交
394
	ExpressionActionsPtr & out_expression, NameToNameMap & out_rename_map)
M
Merge  
Michael Kolupaev 已提交
395
{
M
Merge  
Michael Kolupaev 已提交
396 397
	out_expression = nullptr;
	out_rename_map.clear();
M
Merge  
Michael Kolupaev 已提交
398

M
Merge  
Michael Kolupaev 已提交
399 400 401
	typedef std::map<String, DataTypePtr> NameToType;
	NameToType new_types;
	for (const NameAndTypePair & column : new_columns)
M
Merge  
Michael Kolupaev 已提交
402
	{
M
Merge  
Michael Kolupaev 已提交
403
		new_types[column.name] = column.type;
M
Merge  
Michael Kolupaev 已提交
404
	}
M
Merge  
Michael Kolupaev 已提交
405

M
Merge  
Michael Kolupaev 已提交
406 407 408
	/// Сколько столбцов сейчас в каждой вложенной структуре. Столбцы не из вложенных структур сюда тоже попадут и не помешают.
	std::map<String, int> nested_table_counts;
	for (const NameAndTypePair & column : old_columns)
M
Merge  
Michael Kolupaev 已提交
409
	{
M
Merge  
Michael Kolupaev 已提交
410
		++nested_table_counts[DataTypeNested::extractNestedTableName(column.name)];
M
Merge  
Michael Kolupaev 已提交
411
	}
412

M
Merge  
Michael Kolupaev 已提交
413
	for (const NameAndTypePair & column : old_columns)
M
Merge  
Michael Kolupaev 已提交
414
	{
M
Merge  
Michael Kolupaev 已提交
415
		if (!new_types.count(column.name))
416
		{
M
Merge  
Michael Kolupaev 已提交
417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437
			if (!part || part->hasColumnFiles(column.name))
			{
				/// Столбец нужно удалить.

				String escaped_column = escapeForFileName(column.name);
				out_rename_map[escaped_column + ".bin"] = "";
				out_rename_map[escaped_column + ".mrk"] = "";

				/// Если это массив или последний столбец вложенной структуры, нужно удалить файлы с размерами.
				if (typeid_cast<const DataTypeArray *>(&*column.type))
				{
					String nested_table = DataTypeNested::extractNestedTableName(column.name);
					/// Если это был последний столбец, относящийся к этим файлам .size0, удалим файлы.
					if (!--nested_table_counts[nested_table])
					{
						String escaped_nested_table = escapeForFileName(nested_table);
						out_rename_map[escaped_nested_table + ".size0.bin"] = "";
						out_rename_map[escaped_nested_table + ".size0.mrk"] = "";
					}
				}
			}
438
		}
M
Merge  
Michael Kolupaev 已提交
439 440 441 442 443 444 445 446 447 448 449
		else
		{
			String new_type_name = new_types[column.name]->getName();

			if (new_type_name != column.type->getName() &&
				(!part || part->hasColumnFiles(column.name)))
			{
				/// Нужно изменить тип столбца.

				if (!out_expression)
					out_expression = new ExpressionActions(NamesAndTypesList(), context.getSettingsRef());
M
Merge  
Michael Kolupaev 已提交
450

M
Merge  
Michael Kolupaev 已提交
451 452 453 454 455 456 457 458 459 460 461 462 463
				out_expression->addInput(ColumnWithNameAndType(nullptr, column.type, column.name));

				FunctionPtr function = context.getFunctionFactory().get("to" + new_type_name, context);
				Names out_names;
				out_expression->add(ExpressionAction::applyFunction(function, Names(1, column.name)), out_names);
				out_expression->add(ExpressionAction::removeColumn(column.name));

				String escaped_expr = escapeForFileName(out_names[0]);
				String escaped_column = escapeForFileName(column.name);
				out_rename_map[escaped_expr + ".bin"] = escaped_column + ".bin";
				out_rename_map[escaped_expr + ".mrk"] = escaped_column + ".mrk";
			}
		}
M
Merge  
Michael Kolupaev 已提交
464 465
	}
}
M
Merge  
Michael Kolupaev 已提交
466

467 468
MergeTreeData::AlterDataPartTransactionPtr MergeTreeData::alterDataPart(
	const DataPartPtr & part, const NamesAndTypesList & new_columns, bool skip_sanity_checks)
M
Merge  
Michael Kolupaev 已提交
469
{
M
Merge  
Michael Kolupaev 已提交
470
	ExpressionActionsPtr expression;
M
Merge  
Michael Kolupaev 已提交
471
	AlterDataPartTransactionPtr transaction(new AlterDataPartTransaction(part)); /// Блокирует изменение куска.
M
Merge  
Michael Kolupaev 已提交
472
	createConvertExpression(part, part->columns, new_columns, expression, transaction->rename_map);
M
Merge  
Michael Kolupaev 已提交
473

M
Merge  
Michael Kolupaev 已提交
474 475 476 477 478 479 480 481
	if (!skip_sanity_checks && transaction->rename_map.size() > 5)
	{
		transaction->clear();

		throw Exception("Suspiciously many (" + toString(transaction->rename_map.size()) + ") files need to be modified in part " + part->name
						+ ". Aborting just in case");
	}

M
Merge  
Michael Kolupaev 已提交
482
	if (transaction->rename_map.empty())
M
Merge  
Michael Kolupaev 已提交
483
	{
M
Merge  
Michael Kolupaev 已提交
484
		transaction->clear();
M
Merge  
Michael Kolupaev 已提交
485
		return nullptr;
M
Merge  
Michael Kolupaev 已提交
486
	}
M
Merge  
Michael Kolupaev 已提交
487

M
Merge  
Michael Kolupaev 已提交
488 489 490 491
	DataPart::Checksums add_checksums;

	/// Применим выражение и запишем результат во временные файлы.
	if (expression)
M
Merge  
Michael Kolupaev 已提交
492 493
	{
		MarkRanges ranges(1, MarkRange(0, part->size));
M
Merge  
Michael Kolupaev 已提交
494
		BlockInputStreamPtr part_in = new MergeTreeBlockInputStream(full_path + part->name + '/',
M
Merge  
Michael Kolupaev 已提交
495
			DEFAULT_MERGE_BLOCK_SIZE, expression->getRequiredColumns(), *this, part, ranges, false, nullptr, "", false);
M
Merge  
Michael Kolupaev 已提交
496
		ExpressionBlockInputStream in(part_in, expression);
M
Merge  
Michael Kolupaev 已提交
497
		MergedColumnOnlyOutputStream out(*this, full_path + part->name + '/', true);
M
Merge  
Michael Kolupaev 已提交
498
		in.readPrefix();
M
Merge  
Michael Kolupaev 已提交
499
		out.writePrefix();
M
Merge  
Michael Kolupaev 已提交
500

M
Merge  
Michael Kolupaev 已提交
501 502
		while (Block b = in.read())
			out.write(b);
M
Merge  
Michael Kolupaev 已提交
503

M
Merge  
Michael Kolupaev 已提交
504 505 506
		in.readSuffix();
		add_checksums = out.writeSuffixAndGetChecksums();
	}
M
Merge  
Michael Kolupaev 已提交
507

M
Merge  
Michael Kolupaev 已提交
508
	/// Обновим контрольные суммы.
M
Merge  
Michael Kolupaev 已提交
509 510 511 512 513 514
	DataPart::Checksums new_checksums = part->checksums;
	for (auto it : transaction->rename_map)
	{
		if (it.second == "")
		{
			new_checksums.files.erase(it.first);
M
Merge  
Michael Kolupaev 已提交
515
		}
M
Merge  
Michael Kolupaev 已提交
516
		else
M
Merge  
Michael Kolupaev 已提交
517
		{
M
Merge  
Michael Kolupaev 已提交
518
			new_checksums.files[it.second] = add_checksums.files[it.first];
M
Merge  
Michael Kolupaev 已提交
519 520
		}
	}
M
Merge  
Michael Kolupaev 已提交
521

M
Merge  
Michael Kolupaev 已提交
522 523
	/// Запишем обновленные контрольные суммы во временный файл
	if (!part->checksums.empty())
M
Merge  
Michael Kolupaev 已提交
524
	{
M
Merge  
Michael Kolupaev 已提交
525
		transaction->new_checksums = new_checksums;
M
Merge  
Michael Kolupaev 已提交
526 527 528
		WriteBufferFromFile checksums_file(full_path + part->name + "/checksums.txt.tmp", 4096);
		new_checksums.writeText(checksums_file);
		transaction->rename_map["checksums.txt.tmp"] = "checksums.txt";
M
Merge  
Michael Kolupaev 已提交
529
	}
M
Merge  
Michael Kolupaev 已提交
530

M
Merge  
Michael Kolupaev 已提交
531 532
	/// Запишем обновленный список столбцов во временный файл.
	{
M
Merge  
Michael Kolupaev 已提交
533
		transaction->new_columns = new_columns.filter(part->columns.getNames());
M
Merge  
Michael Kolupaev 已提交
534 535 536 537 538
		WriteBufferFromFile columns_file(full_path + part->name + "/columns.txt.tmp", 4096);
		transaction->new_columns.writeText(columns_file);
		transaction->rename_map["columns.txt.tmp"] = "columns.txt";
	}

M
Merge  
Michael Kolupaev 已提交
539 540
	return transaction;
}
M
Merge  
Michael Kolupaev 已提交
541

M
Merge  
Michael Kolupaev 已提交
542 543 544 545 546
void MergeTreeData::AlterDataPartTransaction::commit()
{
	if (!data_part)
		return;
	try
M
Merge  
Michael Kolupaev 已提交
547
	{
M
Merge  
Michael Kolupaev 已提交
548 549
		Poco::ScopedWriteRWLock lock(data_part->columns_lock);

M
Merge  
Michael Kolupaev 已提交
550
		String path = data_part->storage.full_path + data_part->name + "/";
M
Merge  
Michael Kolupaev 已提交
551 552

		/// 1) Переименуем старые файлы.
M
Merge  
Michael Kolupaev 已提交
553
		for (auto it : rename_map)
M
Merge  
Michael Kolupaev 已提交
554
		{
M
Merge  
Michael Kolupaev 已提交
555 556 557 558
			String name = it.second.empty() ? it.first : it.second;
			Poco::File(path + name).renameTo(path + name + ".tmp2");
		}

559
		/// 2) Переместим на их место новые и обновим метаданные в оперативке.
M
Merge  
Michael Kolupaev 已提交
560 561 562
		for (auto it : rename_map)
		{
			if (!it.second.empty())
M
Merge  
Michael Kolupaev 已提交
563
			{
M
Merge  
Michael Kolupaev 已提交
564
				Poco::File(path + it.first).renameTo(path + it.second);
M
Merge  
Michael Kolupaev 已提交
565
			}
M
Merge  
Michael Kolupaev 已提交
566
		}
567 568 569 570

		DataPart & mutable_part = const_cast<DataPart &>(*data_part);
		mutable_part.checksums = new_checksums;
		mutable_part.columns = new_columns;
M
Merge  
Michael Kolupaev 已提交
571 572 573 574 575 576 577 578

		/// 3) Удалим старые файлы.
		for (auto it : rename_map)
		{
			String name = it.second.empty() ? it.first : it.second;
			Poco::File(path + name + ".tmp2").remove();
		}

M
Merge  
Michael Kolupaev 已提交
579 580
		mutable_part.size_in_bytes = MergeTreeData::DataPart::calcTotalSize(path);

M
Merge  
Michael Kolupaev 已提交
581 582 583
		/// TODO: можно не сбрасывать кеши при добавлении столбца.
		data_part->storage.context.resetCaches();

M
Merge  
Michael Kolupaev 已提交
584
		clear();
M
Merge  
Michael Kolupaev 已提交
585 586 587 588
	}
	catch (...)
	{
		/// Если что-то пошло не так, не будем удалять временные файлы в деструкторе.
M
Merge  
Michael Kolupaev 已提交
589
		clear();
M
Merge  
Michael Kolupaev 已提交
590
		throw;
M
Merge  
Michael Kolupaev 已提交
591
	}
M
Merge  
Michael Kolupaev 已提交
592
}
M
Merge  
Michael Kolupaev 已提交
593

M
Merge  
Michael Kolupaev 已提交
594
MergeTreeData::AlterDataPartTransaction::~AlterDataPartTransaction()
M
Merge  
Michael Kolupaev 已提交
595
{
M
Merge  
Michael Kolupaev 已提交
596
	try
M
Merge  
Michael Kolupaev 已提交
597
	{
M
Merge  
Michael Kolupaev 已提交
598 599 600 601
		if (!data_part)
			return;

		LOG_WARNING(data_part->storage.log, "Aborting ALTER of part " << data_part->name);
M
Merge  
Michael Kolupaev 已提交
602

M
Merge  
Michael Kolupaev 已提交
603 604 605 606
		String path = data_part->storage.full_path + data_part->name + "/";
		for (auto it : rename_map)
		{
			if (!it.second.empty())
M
Merge  
Michael Kolupaev 已提交
607
			{
M
Merge  
Michael Kolupaev 已提交
608 609
				try
				{
M
Merge  
Michael Kolupaev 已提交
610 611 612
					Poco::File file(path + it.first);
					if (file.exists())
						file.remove();
M
Merge  
Michael Kolupaev 已提交
613 614 615 616 617
				}
				catch (Poco::Exception & e)
				{
					LOG_WARNING(data_part->storage.log, "Can't remove " << path + it.first << ": " << e.displayText());
				}
M
Merge  
Michael Kolupaev 已提交
618
			}
M
Merge  
Michael Kolupaev 已提交
619 620
		}
	}
M
Merge  
Michael Kolupaev 已提交
621
	catch (...)
M
Merge  
Michael Kolupaev 已提交
622
	{
M
Merge  
Michael Kolupaev 已提交
623
		tryLogCurrentException(__PRETTY_FUNCTION__);
M
Merge  
Michael Kolupaev 已提交
624
	}
M
Merge  
Michael Kolupaev 已提交
625 626 627
}


628
void MergeTreeData::renameTempPartAndAdd(MutableDataPartPtr & part, Increment * increment, Transaction * out_transaction)
M
Merge  
Michael Kolupaev 已提交
629
{
M
Merge  
Michael Kolupaev 已提交
630
	auto removed = renameTempPartAndReplace(part, increment, out_transaction);
M
Merge  
Michael Kolupaev 已提交
631 632 633 634 635
	if (!removed.empty())
	{
		LOG_ERROR(log, "Added part " << part->name << + " covers " << toString(removed.size())
			<< " existing part(s) (including " << removed[0]->name << ")");
	}
M
Merge  
Michael Kolupaev 已提交
636 637
}

M
Merge  
Michael Kolupaev 已提交
638
MergeTreeData::DataPartsVector MergeTreeData::renameTempPartAndReplace(
639
	MutableDataPartPtr & part, Increment * increment, Transaction * out_transaction)
M
Merge  
Michael Kolupaev 已提交
640
{
M
Merge  
Michael Kolupaev 已提交
641 642 643
	if (out_transaction && out_transaction->data)
		throw Exception("Using the same MergeTreeData::Transaction for overlapping transactions is invalid");

644
	LOG_TRACE(log, "Renaming " << part->name << ".");
M
Merge  
Michael Kolupaev 已提交
645 646 647 648

	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);
	Poco::ScopedLock<Poco::FastMutex> lock_all(all_data_parts_mutex);

M
Merge  
Michael Kolupaev 已提交
649 650
	String old_name = part->name;
	String old_path = getFullPath() + old_name + "/";
M
Merge  
Michael Kolupaev 已提交
651

M
Merge  
Michael Kolupaev 已提交
652
	/** Для StorageMergeTree важно, что получение номера куска происходит атомарно с добавлением этого куска в набор.
M
Merge  
Michael Kolupaev 已提交
653 654 655 656
	  * Иначе есть race condition - может произойти слияние пары кусков, диапазоны номеров которых
	  *  содержат ещё не добавленный кусок.
	  */
	if (increment)
M
Merge  
Michael Kolupaev 已提交
657
		part->left = part->right = increment->get(false);
M
Merge  
Michael Kolupaev 已提交
658

M
Merge  
Michael Kolupaev 已提交
659
	String new_name = ActiveDataPartSet::getPartName(part->left_date, part->right_date, part->left, part->right, part->level);
M
Merge  
Michael Kolupaev 已提交
660

M
Merge  
Michael Kolupaev 已提交
661 662 663 664 665
	part->is_temp = false;
	part->name = new_name;
	bool duplicate = data_parts.count(part);
	part->name = old_name;
	part->is_temp = true;
M
Merge  
Michael Kolupaev 已提交
666

M
Merge  
Michael Kolupaev 已提交
667 668 669 670
	if (duplicate)
		throw Exception("Part " + new_name + " already exists", ErrorCodes::DUPLICATE_DATA_PART);

	String new_path = getFullPath() + new_name + "/";
M
Merge  
Michael Kolupaev 已提交
671 672 673 674

	/// Переименовываем кусок.
	Poco::File(old_path).renameTo(new_path);

M
Merge  
Michael Kolupaev 已提交
675 676 677
	part->is_temp = false;
	part->name = new_name;

M
Merge  
Michael Kolupaev 已提交
678
	bool obsolete = false; /// Покрыт ли part каким-нибудь куском.
M
Merge  
Michael Kolupaev 已提交
679 680 681 682 683 684 685 686
	DataPartsVector res;
	/// Куски, содержащиеся в part, идут в data_parts подряд, задевая место, куда вставился бы сам part.
	DataParts::iterator it = data_parts.lower_bound(part);
	/// Пойдем влево.
	while (it != data_parts.begin())
	{
		--it;
		if (!part->contains(**it))
M
Michael Kolupaev 已提交
687
		{
M
Merge  
Michael Kolupaev 已提交
688 689
			if ((*it)->contains(*part))
				obsolete = true;
M
Michael Kolupaev 已提交
690
			++it;
M
Merge  
Michael Kolupaev 已提交
691
			break;
M
Michael Kolupaev 已提交
692
		}
M
Merge  
Michael Kolupaev 已提交
693
		res.push_back(*it);
M
Merge  
Michael Kolupaev 已提交
694
		(*it)->remove_time = time(0);
A
Merge  
Andrey Mironov 已提交
695
		removePartContributionToColumnSizes(*it);
M
Merge  
Michael Kolupaev 已提交
696 697 698 699
		data_parts.erase(it++); /// Да, ++, а не --.
	}
	std::reverse(res.begin(), res.end()); /// Нужно получить куски в порядке возрастания.
	/// Пойдем вправо.
M
Merge  
Michael Kolupaev 已提交
700
	while (it != data_parts.end())
M
Merge  
Michael Kolupaev 已提交
701
	{
M
Merge  
Michael Kolupaev 已提交
702 703 704 705 706 707
		if (!part->contains(**it))
		{
			if ((*it)->name == part->name || (*it)->contains(*part))
				obsolete = true;
			break;
		}
M
Merge  
Michael Kolupaev 已提交
708
		res.push_back(*it);
M
Merge  
Michael Kolupaev 已提交
709
		(*it)->remove_time = time(0);
A
Merge  
Andrey Mironov 已提交
710
		removePartContributionToColumnSizes(*it);
M
Merge  
Michael Kolupaev 已提交
711 712 713
		data_parts.erase(it++);
	}

M
Merge  
Michael Kolupaev 已提交
714 715 716 717 718 719 720
	if (obsolete)
	{
		LOG_WARNING(log, "Obsolete part " + part->name + " added");
	}
	else
	{
		data_parts.insert(part);
A
Merge  
Andrey Mironov 已提交
721
		addPartContributionToColumnSizes(part);
M
Merge  
Michael Kolupaev 已提交
722
	}
723

M
Merge  
Michael Kolupaev 已提交
724
	all_data_parts.insert(part);
M
Merge  
Michael Kolupaev 已提交
725

M
Merge  
Michael Kolupaev 已提交
726 727 728 729 730 731 732
	if (out_transaction)
	{
		out_transaction->data = this;
		out_transaction->added_parts = res;
		out_transaction->removed_parts = DataPartsVector(1, part);
	}

M
Merge  
Michael Kolupaev 已提交
733
	return res;
M
Merge  
Michael Kolupaev 已提交
734 735
}

M
Merge  
Michael Kolupaev 已提交
736
void MergeTreeData::replaceParts(const DataPartsVector & remove, const DataPartsVector & add, bool clear_without_timeout)
M
Merge  
Michael Kolupaev 已提交
737 738 739 740 741
{
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);

	for (const DataPartPtr & part : remove)
	{
M
Merge  
Michael Kolupaev 已提交
742
		part->remove_time = clear_without_timeout ? 0 : time(0);
A
Merge  
Andrey Mironov 已提交
743
		removePartContributionToColumnSizes(part);
M
Merge  
Michael Kolupaev 已提交
744 745 746 747 748
		data_parts.erase(part);
	}
	for (const DataPartPtr & part : add)
	{
		data_parts.insert(part);
A
Merge  
Andrey Mironov 已提交
749
		addPartContributionToColumnSizes(part);
M
Merge  
Michael Kolupaev 已提交
750 751 752
	}
}

753
void MergeTreeData::attachPart(const DataPartPtr & part)
M
Merge  
Michael Kolupaev 已提交
754 755 756 757 758 759 760 761 762
{
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);
	Poco::ScopedLock<Poco::FastMutex> lock_all(all_data_parts_mutex);

	if (!all_data_parts.insert(part).second)
		throw Exception("Part " + part->name + " is already attached", ErrorCodes::DUPLICATE_DATA_PART);
	data_parts.insert(part);
}

763
void MergeTreeData::renameAndDetachPart(const DataPartPtr & part, const String & prefix, bool restore_covered, bool move_to_detached)
M
Merge  
Michael Kolupaev 已提交
764
{
M
Merge  
Michael Kolupaev 已提交
765 766
	LOG_INFO(log, "Renaming " << part->name << " to " << prefix << part->name << " and detaching it.");

M
Merge  
Michael Kolupaev 已提交
767
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);
M
Merge  
Michael Kolupaev 已提交
768
	Poco::ScopedLock<Poco::FastMutex> lock_all(all_data_parts_mutex);
M
Merge  
Michael Kolupaev 已提交
769

M
Merge  
Michael Kolupaev 已提交
770
	if (!all_data_parts.erase(part))
M
Merge  
Michael Kolupaev 已提交
771
		throw Exception("No such data part", ErrorCodes::NO_SUCH_DATA_PART);
M
Merge  
Michael Kolupaev 已提交
772

A
Merge  
Andrey Mironov 已提交
773
	removePartContributionToColumnSizes(part);
M
Merge  
Michael Kolupaev 已提交
774
	data_parts.erase(part);
M
Merge  
Michael Kolupaev 已提交
775 776
	if (move_to_detached || !prefix.empty())
		part->renameAddPrefix((move_to_detached ? "detached/" : "") + prefix);
M
Merge  
Michael Kolupaev 已提交
777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793

	if (restore_covered)
	{
		auto it = all_data_parts.lower_bound(part);
		Strings restored;
		bool error = false;

		UInt64 pos = part->left;

		if (it != all_data_parts.begin())
		{
			--it;
			if (part->contains(**it))
			{
				if ((*it)->left != part->left)
					error = true;
				data_parts.insert(*it);
A
Merge  
Andrey Mironov 已提交
794
				addPartContributionToColumnSizes(*it);
M
Merge  
Michael Kolupaev 已提交
795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811
				pos = (*it)->right + 1;
				restored.push_back((*it)->name);
			}
			else
				error = true;
			++it;
		}
		else
			error = true;

		for (; it != all_data_parts.end() && part->contains(**it); ++it)
		{
			if ((*it)->left < pos)
				continue;
			if ((*it)->left > pos)
				error = true;
			data_parts.insert(*it);
A
Merge  
Andrey Mironov 已提交
812
			addPartContributionToColumnSizes(*it);
M
Merge  
Michael Kolupaev 已提交
813 814 815 816 817 818 819 820 821 822 823 824 825 826 827
			pos = (*it)->right + 1;
			restored.push_back((*it)->name);
		}

		if (pos != part->right + 1)
			error = true;

		for (const String & name : restored)
		{
			LOG_INFO(log, "Activated part " << name);
		}

		if (error)
			LOG_ERROR(log, "The set of parts restored in place of " << part->name << " looks incomplete. There might or might not be a data loss.");
	}
M
Merge  
Michael Kolupaev 已提交
828 829
}

830
void MergeTreeData::detachPartInPlace(const DataPartPtr & part)
M
Merge  
Michael Kolupaev 已提交
831 832 833 834
{
	renameAndDetachPart(part, "", false, false);
}

M
Merge  
Michael Kolupaev 已提交
835 836 837 838 839 840 841
MergeTreeData::DataParts MergeTreeData::getDataParts()
{
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);

	return data_parts;
}

A
Merge  
Andrey Mironov 已提交
842 843 844 845
MergeTreeData::DataPartsVector MergeTreeData::getDataPartsVector()
{
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);

846
	return DataPartsVector(std::begin(data_parts), std::end(data_parts));
A
Merge  
Andrey Mironov 已提交
847 848
}

M
Merge  
Michael Kolupaev 已提交
849 850 851 852 853 854 855
MergeTreeData::DataParts MergeTreeData::getAllDataParts()
{
	Poco::ScopedLock<Poco::FastMutex> lock(all_data_parts_mutex);

	return all_data_parts;
}

M
Merge  
Michael Kolupaev 已提交
856
size_t MergeTreeData::getMaxPartsCountForMonth()
M
Merge  
Michael Kolupaev 已提交
857 858 859
{
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);

M
Merge  
Michael Kolupaev 已提交
860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879
	size_t res = 0;
	size_t cur_count = 0;
	DayNum_t cur_month = DayNum_t(0);

	for (const auto & part : data_parts)
	{
		if (part->left_month == cur_month)
		{
			++cur_count;
		}
		else
		{
			cur_month = part->left_month;
			cur_count = 1;
		}

		res = std::max(res, cur_count);
	}

	return res;
M
Merge  
Michael Kolupaev 已提交
880 881
}

882
void MergeTreeData::delayInsertIfNeeded(Poco::Event * until)
M
Merge  
Michael Kolupaev 已提交
883 884 885 886 887 888
{
	size_t parts_count = getMaxPartsCountForMonth();
	if (parts_count > settings.parts_to_delay_insert)
	{
		double delay = std::pow(settings.insert_delay_step, parts_count - settings.parts_to_delay_insert);
		delay /= 1000;
889 890

		if (delay > DBMS_MAX_DELAY_OF_INSERT)
891 892 893 894
		{
			ProfileEvents::increment(ProfileEvents::RejectedInserts);
			throw Exception("Too much parts. Merges are processing significantly slower than inserts.", ErrorCodes::TOO_MUCH_PARTS);
		}
895 896 897

		ProfileEvents::increment(ProfileEvents::DelayedInserts);
		ProfileEvents::increment(ProfileEvents::DelayedInsertsMilliseconds, delay * 1000);
898

M
Merge  
Michael Kolupaev 已提交
899
		LOG_INFO(log, "Delaying inserting block by "
900 901 902 903 904 905
			<< std::fixed << std::setprecision(4) << delay << " sec. because there are " << parts_count << " parts");

		if (until)
			until->tryWait(delay * 1000);
		else
			std::this_thread::sleep_for(std::chrono::duration<double>(delay));
M
Merge  
Michael Kolupaev 已提交
906 907 908
	}
}

M
Merge  
Michael Kolupaev 已提交
909
MergeTreeData::DataPartPtr MergeTreeData::getActiveContainingPart(const String & part_name)
M
Merge  
Michael Kolupaev 已提交
910 911
{
	MutableDataPartPtr tmp_part(new DataPart(*this));
912
	ActiveDataPartSet::parsePartName(part_name, *tmp_part);
M
Merge  
Michael Kolupaev 已提交
913

M
Merge  
Michael Kolupaev 已提交
914
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);
M
Merge  
Michael Kolupaev 已提交
915

M
Merge  
Michael Kolupaev 已提交
916
	/// Кусок может покрываться только предыдущим или следующим в data_parts.
M
Merge  
Michael Kolupaev 已提交
917
	DataParts::iterator it = data_parts.lower_bound(tmp_part);
M
Merge  
Michael Kolupaev 已提交
918

M
Merge  
Michael Kolupaev 已提交
919
	if (it != data_parts.end())
M
Merge  
Michael Kolupaev 已提交
920 921 922 923 924 925 926
	{
		if ((*it)->name == part_name)
			return *it;
		if ((*it)->contains(*tmp_part))
			return *it;
	}

M
Merge  
Michael Kolupaev 已提交
927
	if (it != data_parts.begin())
M
Merge  
Michael Kolupaev 已提交
928 929 930 931 932 933 934 935 936
	{
		--it;
		if ((*it)->contains(*tmp_part))
			return *it;
	}

	return nullptr;
}

M
Merge  
Michael Kolupaev 已提交
937 938 939 940 941 942 943 944 945 946 947 948 949
MergeTreeData::DataPartPtr MergeTreeData::getPartIfExists(const String & part_name)
{
	MutableDataPartPtr tmp_part(new DataPart(*this));
	ActiveDataPartSet::parsePartName(part_name, *tmp_part);

	Poco::ScopedLock<Poco::FastMutex> lock(all_data_parts_mutex);
	DataParts::iterator it = all_data_parts.lower_bound(tmp_part);
	if (it != all_data_parts.end() && (*it)->name == part_name)
		return *it;

	return nullptr;
}

M
Merge  
Michael Kolupaev 已提交
950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984
MergeTreeData::MutableDataPartPtr MergeTreeData::loadPartAndFixMetadata(const String & relative_path)
{
	MutableDataPartPtr part = std::make_shared<DataPart>(*this);
	part->name = relative_path;

	/// Раньше список столбцов записывался неправильно. Удалим его и создадим заново.
	if (Poco::File(full_path + relative_path + "/columns.txt").exists())
		Poco::File(full_path + relative_path + "/columns.txt").remove();

	part->loadColumns(false);
	part->loadChecksums(false);
	part->loadIndex();
	part->checkNotBroken(false);

	part->modification_time = Poco::File(full_path + relative_path).getLastModified().epochTime();

	/// Если нет файла с чексуммами, посчитаем чексуммы и запишем. Заодно проверим данные.
	if (part->checksums.empty())
	{
		MergeTreePartChecker::Settings settings;
		settings.setIndexGranularity(index_granularity);
		settings.setRequireColumnFiles(true);
		MergeTreePartChecker::checkDataPart(full_path + relative_path, settings, context.getDataTypeFactory(), &part->checksums);

		{
			WriteBufferFromFile out(full_path + relative_path + "/checksums.txt.tmp", 4096);
			part->checksums.writeText(out);
		}

		Poco::File(full_path + relative_path + "/checksums.txt.tmp").renameTo(full_path + relative_path + "/checksums.txt");
	}

	return part;
}

985

M
Merge  
Michael Kolupaev 已提交
986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015
void MergeTreeData::DataPart::Checksums::Checksum::checkEqual(const Checksum & rhs, bool have_uncompressed, const String & name) const
{
	if (is_compressed && have_uncompressed)
	{
		if (!rhs.is_compressed)
			throw Exception("No uncompressed checksum for file " + name, ErrorCodes::CHECKSUM_DOESNT_MATCH);
		if (rhs.uncompressed_size != uncompressed_size)
			throw Exception("Unexpected size of file " + name + " in data part", ErrorCodes::BAD_SIZE_OF_FILE_IN_DATA_PART);
		if (rhs.uncompressed_hash != uncompressed_hash)
			throw Exception("Checksum mismatch for file " + name + " in data part", ErrorCodes::CHECKSUM_DOESNT_MATCH);
		return;
	}
	if (rhs.file_size != file_size)
		throw Exception("Unexpected size of file " + name + " in data part", ErrorCodes::BAD_SIZE_OF_FILE_IN_DATA_PART);
	if (rhs.file_hash != file_hash)
		throw Exception("Checksum mismatch for file " + name + " in data part", ErrorCodes::CHECKSUM_DOESNT_MATCH);
}

void MergeTreeData::DataPart::Checksums::Checksum::checkSize(const String & path) const
{
	Poco::File file(path);
	if (!file.exists())
		throw Exception(path + " doesn't exist", ErrorCodes::FILE_DOESNT_EXIST);
	size_t size = file.getSize();
	if (size != file_size)
		throw Exception(path + " has unexpected size: " + DB::toString(size) + " instead of " + DB::toString(file_size),
			ErrorCodes::BAD_SIZE_OF_FILE_IN_DATA_PART);
}

void MergeTreeData::DataPart::Checksums::checkEqual(const Checksums & rhs, bool have_uncompressed) const
1016
{
M
Merge  
Michael Kolupaev 已提交
1017
	for (const auto & it : rhs.files)
1018 1019 1020
	{
		const String & name = it.first;

M
Merge  
Michael Kolupaev 已提交
1021
		if (!files.count(name))
1022 1023 1024
			throw Exception("Unexpected file " + name + " in data part", ErrorCodes::UNEXPECTED_FILE_IN_DATA_PART);
	}

M
Merge  
Michael Kolupaev 已提交
1025
	for (const auto & it : files)
1026 1027 1028
	{
		const String & name = it.first;

M
Merge  
Michael Kolupaev 已提交
1029 1030
		auto jt = rhs.files.find(name);
		if (jt == rhs.files.end())
1031 1032
			throw Exception("No file " + name + " in data part", ErrorCodes::NO_FILE_IN_DATA_PART);

M
Merge  
Michael Kolupaev 已提交
1033 1034 1035
		it.second.checkEqual(jt->second, have_uncompressed, name);
	}
}
M
Merge  
Michael Kolupaev 已提交
1036

M
Merge  
Michael Kolupaev 已提交
1037 1038 1039 1040 1041 1042
void MergeTreeData::DataPart::Checksums::checkSizes(const String & path) const
{
	for (const auto & it : files)
	{
		const String & name = it.first;
		it.second.checkSize(path + name);
1043 1044 1045
	}
}

1046
bool MergeTreeData::DataPart::Checksums::readText(ReadBuffer & in)
1047
{
M
Merge  
Michael Kolupaev 已提交
1048
	files.clear();
1049 1050
	size_t count;

M
Merge  
Michael Kolupaev 已提交
1051 1052 1053 1054 1055
	DB::assertString("checksums format version: ", in);
	int format_version;
	DB::readText(format_version, in);
	if (format_version < 1 || format_version > 2)
		throw Exception("Bad checksums format version: " + DB::toString(format_version), ErrorCodes::UNKNOWN_FORMAT);
1056 1057
	if (format_version == 1)
		return false;
M
Merge  
Michael Kolupaev 已提交
1058
	DB::assertString("\n", in);
1059 1060 1061 1062 1063 1064 1065 1066 1067 1068
	DB::readText(count, in);
	DB::assertString(" files:\n", in);

	for (size_t i = 0; i < count; ++i)
	{
		String name;
		Checksum sum;

		DB::readString(name, in);
		DB::assertString("\n\tsize: ", in);
M
Merge  
Michael Kolupaev 已提交
1069
		DB::readText(sum.file_size, in);
1070
		DB::assertString("\n\thash: ", in);
M
Merge  
Michael Kolupaev 已提交
1071
		DB::readText(sum.file_hash.first, in);
1072
		DB::assertString(" ", in);
M
Merge  
Michael Kolupaev 已提交
1073
		DB::readText(sum.file_hash.second, in);
1074 1075 1076
		DB::assertString("\n\tcompressed: ", in);
		DB::readText(sum.is_compressed, in);
		if (sum.is_compressed)
M
Merge  
Michael Kolupaev 已提交
1077
		{
1078 1079 1080 1081 1082 1083
			DB::assertString("\n\tuncompressed size: ", in);
			DB::readText(sum.uncompressed_size, in);
			DB::assertString("\n\tuncompressed hash: ", in);
			DB::readText(sum.uncompressed_hash.first, in);
			DB::assertString(" ", in);
			DB::readText(sum.uncompressed_hash.second, in);
M
Merge  
Michael Kolupaev 已提交
1084
		}
1085
		DB::assertString("\n", in);
1086

M
Merge  
Michael Kolupaev 已提交
1087
		files.insert(std::make_pair(name, sum));
1088
	}
1089 1090

	return true;
1091 1092 1093 1094
}

void MergeTreeData::DataPart::Checksums::writeText(WriteBuffer & out) const
{
M
Merge  
Michael Kolupaev 已提交
1095
	DB::writeString("checksums format version: 2\n", out);
M
Merge  
Michael Kolupaev 已提交
1096
	DB::writeText(files.size(), out);
1097 1098
	DB::writeString(" files:\n", out);

M
Merge  
Michael Kolupaev 已提交
1099
	for (const auto & it : files)
1100
	{
M
Merge  
Michael Kolupaev 已提交
1101 1102 1103
		const String & name = it.first;
		const Checksum & sum = it.second;
		DB::writeString(name, out);
1104
		DB::writeString("\n\tsize: ", out);
M
Merge  
Michael Kolupaev 已提交
1105
		DB::writeText(sum.file_size, out);
1106
		DB::writeString("\n\thash: ", out);
M
Merge  
Michael Kolupaev 已提交
1107
		DB::writeText(sum.file_hash.first, out);
1108
		DB::writeString(" ", out);
M
Merge  
Michael Kolupaev 已提交
1109 1110 1111
		DB::writeText(sum.file_hash.second, out);
		DB::writeString("\n\tcompressed: ", out);
		DB::writeText(sum.is_compressed, out);
1112
		DB::writeString("\n", out);
M
Merge  
Michael Kolupaev 已提交
1113 1114 1115 1116 1117 1118 1119 1120 1121 1122
		if (sum.is_compressed)
		{
			DB::writeString("\tuncompressed size: ", out);
			DB::writeText(sum.uncompressed_size, out);
			DB::writeString("\n\tuncompressed hash: ", out);
			DB::writeText(sum.uncompressed_hash.first, out);
			DB::writeString(" ", out);
			DB::writeText(sum.uncompressed_hash.second, out);
			DB::writeString("\n", out);
		}
1123 1124 1125
	}
}

A
Merge  
Andrey Mironov 已提交
1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167
void MergeTreeData::calculateColumnSizes()
{
	column_sizes.clear();

	for (const auto & part : data_parts)
		addPartContributionToColumnSizes(part);
}

void MergeTreeData::addPartContributionToColumnSizes(const DataPartPtr & part)
{
	const auto & files = part->checksums.files;

	for (const auto & column : *columns)
	{
		const auto escaped_name = escapeForFileName(column.name);
		const auto bin_file_name = escaped_name + ".bin";
		const auto mrk_file_name = escaped_name + ".mrk";

		auto & column_size = column_sizes[column.name];

		if (files.count(bin_file_name)) column_size += files.find(bin_file_name)->second.file_size;
		if (files.count(mrk_file_name)) column_size += files.find(mrk_file_name)->second.file_size;
	}
}

void MergeTreeData::removePartContributionToColumnSizes(const DataPartPtr & part)
{
	const auto & files = part->checksums.files;

	for (const auto & column : *columns)
	{
		const auto escaped_name = escapeForFileName(column.name);
		const auto bin_file_name = escaped_name + ".bin";
		const auto mrk_file_name = escaped_name + ".mrk";

		auto & column_size = column_sizes[column.name];

		if (files.count(bin_file_name)) column_size -= files.find(bin_file_name)->second.file_size;
		if (files.count(mrk_file_name)) column_size -= files.find(mrk_file_name)->second.file_size;
	}
}

M
Merge  
Michael Kolupaev 已提交
1168
}