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 84 85 86 87
	UInt64 max_part_id = 0;
	for (DataParts::iterator it = data_parts.begin(); it != data_parts.end(); ++it)
	{
		max_part_id = std::max(max_part_id, (*it)->right);
	}
M
Merge  
Michael Kolupaev 已提交
88
	return max_part_id;
M
Merge  
Michael Kolupaev 已提交
89 90
}

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

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


M
Merge  
Michael Kolupaev 已提交
106
void MergeTreeData::loadDataParts(bool skip_sanity_checks)
M
Merge  
Michael Kolupaev 已提交
107 108 109 110 111 112 113 114
{
	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 已提交
115
	Strings all_file_names;
M
Merge  
Michael Kolupaev 已提交
116 117
	Poco::DirectoryIterator end;
	for (Poco::DirectoryIterator it(full_path); it != end; ++it)
M
Merge  
Michael Kolupaev 已提交
118
		all_file_names.push_back(it.name());
M
Merge  
Michael Kolupaev 已提交
119

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

M
Merge  
Michael Kolupaev 已提交
127
		/// TODO: Это можно удалить, если нигде больше не осталось директорий old_* (их давно никто не пишет).
M
Merge  
Michael Kolupaev 已提交
128
		if (0 == file_name.compare(0, strlen("old_"), "old_"))
M
Merge  
Michael Kolupaev 已提交
129 130 131 132 133 134
		{
			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 已提交
135
		else
M
Merge  
Michael Kolupaev 已提交
136
		{
M
Merge  
Michael Kolupaev 已提交
137
			part_file_names.push_back(file_name);
M
Merge  
Michael Kolupaev 已提交
138
		}
M
Merge  
Michael Kolupaev 已提交
139 140
	}

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

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

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

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

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

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

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

				for (const String & contained_name : part_file_names)
				{
					if (contained_name == file_name)
						continue;
M
Merge  
Michael Kolupaev 已提交
192
					if (!ActiveDataPartSet::isPartDirectory(contained_name, &matches))
M
Merge  
Michael Kolupaev 已提交
193 194
						continue;
					DataPart contained_part(*this);
195
					ActiveDataPartSet::parsePartName(contained_name, contained_part, &matches);
M
Merge  
Michael Kolupaev 已提交
196 197 198 199 200 201 202 203 204 205
					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 已提交
206
					broken_parts_to_remove.push_back(part);
M
Merge  
Michael Kolupaev 已提交
207 208 209
				}
				else
				{
M
Merge  
Michael Kolupaev 已提交
210
					LOG_ERROR(log, "Detaching broken part " << full_path + file_name
M
Merge  
Michael Kolupaev 已提交
211
						<< " because it covers less than 2 parts. You need to resolve this manually");
M
Merge  
Michael Kolupaev 已提交
212
					broken_parts_to_detach.push_back(part);
M
Merge  
Michael Kolupaev 已提交
213
				}
M
Merge  
Michael Kolupaev 已提交
214 215 216 217 218 219 220 221 222 223
			}

			continue;
		}

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

		data_parts.insert(part);
	}

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

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

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

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

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


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

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

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

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

M
Merge  
Michael Kolupaev 已提交
311 312 313 314 315 316 317 318 319 320 321 322 323 324 325
	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 已提交
326
	return res;
M
Merge  
Michael Kolupaev 已提交
327 328
}

M
Merge  
Michael Kolupaev 已提交
329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345
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();

	for (DataPartPtr part : parts_to_remove)
	{
		LOG_DEBUG(log, "Removing part " << part->name);
		part->remove();
	}
}

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

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

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

364
	context.resetCaches();
365

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


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

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

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

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

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

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

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

M
Merge  
Michael Kolupaev 已提交
414
	for (const NameAndTypePair & column : old_columns)
M
Merge  
Michael Kolupaev 已提交
415
	{
M
Merge  
Michael Kolupaev 已提交
416
		if (!new_types.count(column.name))
417
		{
M
Merge  
Michael Kolupaev 已提交
418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438
			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"] = "";
					}
				}
			}
439
		}
M
Merge  
Michael Kolupaev 已提交
440 441 442 443 444 445 446 447 448 449 450
		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 已提交
451

M
Merge  
Michael Kolupaev 已提交
452 453 454 455 456 457 458 459 460 461 462 463 464
				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 已提交
465 466
	}
}
M
Merge  
Michael Kolupaev 已提交
467

M
Merge  
Michael Kolupaev 已提交
468
MergeTreeData::AlterDataPartTransactionPtr MergeTreeData::alterDataPart(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
}


M
Merge  
Michael Kolupaev 已提交
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 639
MergeTreeData::DataPartsVector MergeTreeData::renameTempPartAndReplace(
	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
	}
}

M
Merge  
Michael Kolupaev 已提交
753 754 755 756 757 758 759 760 761 762 763
void MergeTreeData::attachPart(DataPartPtr part)
{
	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);
}

void MergeTreeData::renameAndDetachPart(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
}

M
Merge  
Michael Kolupaev 已提交
830 831 832 833 834
void MergeTreeData::detachPartInPlace(DataPartPtr part)
{
	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 846 847 848
MergeTreeData::DataPartsVector MergeTreeData::getDataPartsVector()
{
	Poco::ScopedLock<Poco::FastMutex> lock(data_parts_mutex);

	return {std::begin(data_parts), std::end(data_parts)};
}

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
}