内江市住房和城乡建设局网站,个人网页设计的主要内容和要求,网站做专题页面,wordpress主题国内模板问题
办公室有一台二手服务器#xff0c;作为平时开发测试使用。由于机器没放在机房#xff0c;会偶发断电异常断电后#xff0c;文件系统是有出问题的可能的#xff0c;尤其是一些不断在读写合并的文件春节后#xff0c;发现clickhouse启动不了#xff0c;使用systemct…问题
办公室有一台二手服务器作为平时开发测试使用。由于机器没放在机房会偶发断电异常断电后文件系统是有出问题的可能的尤其是一些不断在读写合并的文件春节后发现clickhouse启动不了使用systemctl status clickhouse-server返回如下
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)Active: activating (auto-restart) (Result: exit-code) since 二 2023-02-21 15:46:41 CST; 10s agoProcess: 9688 ExecStart/usr/bin/clickhouse-server --config/etc/clickhouse-server/config.xml --pid-file/run/clickhouse-server/clickhouse-server.pid (codeexited, status70)Main PID: 9688 (codeexited, status70)2月 21 15:46:41 localhost.localdomain systemd[1]: clickhouse-server.service: main process exited, codeexited, status70/n/a
2月 21 15:46:41 localhost.localdomain systemd[1]: Unit clickhouse-server.service entered failed state.
2月 21 15:46:41 localhost.localdomain systemd[1]: clickhouse-server.service failed.对于具体的报错信息还是要查看clickhouse的报错日志默认位置在/var/log/clickhouse-server/错误日志如下
2023.02.21 15:47:12.351823 [ 9848 ] {} Error system.query_thread_log (95febdac-d99a-4bdb-9431-653a75f3a34b): Detaching broken part /var/lib/clickhouse/store/95f/95febdac-d99a-4bdb-9431-653a75f3a34b/202302_390451_394084_2980 (size: 0.00 B). If it happened after update, it is likely because of backward incompability. You need to resolve this manually
2023.02.21 15:47:12.365662 [ 9787 ] {} Error Application: Caught exception while loading metadata: std::exception. Code: 1001, type: std::__1::__fs::filesystem::filesystem_error, e.what() filesystem error: in directory_iterator::directory_iterator(...): Structure needs cleaning [/var/lib/clickhouse/store/95f/95febdac-d99a-4bdb-9431-653a75f3a34b/202302_390451_394023_2919/], Stack trace (when copying this message, always include the lines below):0. std::runtime_error::runtime_error(std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const) 0x1b4107cd in ?
1. std::__1::system_error::system_error(std::__1::error_code, std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const) 0x1b41a437 in ?
2. ? 0x145458c1 in /usr/bin/clickhouse
3. ? 0x1b3bf356 in /usr/bin/clickhouse
4. ? 0x1b3bd762 in /usr/bin/clickhouse
5. std::__1::__fs::filesystem::directory_iterator::directory_iterator(std::__1::__fs::filesystem::path const, std::__1::error_code*, std::__1::__fs::filesystem::directory_options) 0x1b3bd581 in /usr/bin/clickhouse
6. DB::DiskLocalDirectoryIterator::DiskLocalDirectoryIterator(std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const, std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const) 0x14552124 in /usr/bin/clickhouse
7. DB::DiskLocal::iterateDirectory(std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const) 0x145483d7 in /usr/bin/clickhouse
8. DB::MergeTreeIndexGranularityInfo::getMarksExtensionFromFilesystem(std::__1::shared_ptrDB::IDisk const, std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const) 0x1552dd06 in /usr/bin/clickhouse
9. DB::MergeTreeData::createPart(std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const, DB::MergeTreePartInfo const, std::__1::shared_ptrDB::IVolume const, std::__1::basic_stringchar, std::__1::char_traitschar, std::__1::allocatorchar const, DB::IMergeTreeDataPart const*) const 0x1547a871 in /usr/bin/clickhouse
10. ? 0x154c98ac in /usr/bin/clickhouse
11. ThreadPoolImplThreadFromGlobalPool::worker(std::__1::__list_iteratorThreadFromGlobalPool, void*) 0xaf6546a in /usr/bin/clickhouse
12. ThreadFromGlobalPool::ThreadFromGlobalPoolvoid ThreadPoolImplThreadFromGlobalPool::scheduleImplvoid(std::__1::functionvoid (), int, std::__1::optionalunsigned long)::lambda0()(void, void ThreadPoolImplThreadFromGlobalPool::scheduleImplvoid(std::__1::functionvoid (), int, std::__1::optionalunsigned long)::lambda0()...)::lambda()::operator()() 0xaf674a4 in /usr/bin/clickhouse
13. ThreadPoolImplstd::__1::thread::worker(std::__1::__list_iteratorstd::__1::thread, void*) 0xaf62837 in /usr/bin/clickhouse
14. ? 0xaf662fd in /usr/bin/clickhouse
15. start_thread 0x7ea5 in /usr/lib64/libpthread-2.17.so
16. __clone 0xfe96d in /usr/lib64/libc-2.17.soCannot print extra info for Poco::Exception (version 22.2.2.1)
2023.02.21 15:47:12.366162 [ 9787 ] {} Information Application: Shutting down storages.
2023.02.21 15:47:12.366178 [ 9787 ] {} Information Context: Shutdown disk default
2023.02.21 15:47:12.391451 [ 9787 ] {} Debug Application: Shut down storages.
2023.02.21 15:47:13.199583 [ 9787 ] {} Debug Application: Destroyed global context.
2023.02.21 15:47:13.202239 [ 9787 ] {} Error Application: filesystem error: in directory_iterator::directory_iterator(...): Structure needs cleaning [/var/lib/clickhouse/store/95f/95febdac-d99a-4bdb-9431-653a75f3a34b/202302_390451_394023_2919/]
2023.02.21 15:47:13.202291 [ 9787 ] {} Information Application: shutting down
2023.02.21 15:47:13.202308 [ 9787 ] {} Debug Application: Uninitializing subsystem: Logging Subsystem
2023.02.21 15:47:13.203474 [ 9788 ] {} Trace BaseDaemon: Received signal -2
2023.02.21 15:47:13.203546 [ 9788 ] {} Information BaseDaemon: Stop SignalListener thread
2023.02.21 15:47:13.276203 [ 9786 ] {} Information Application: Child process exited normally with code 70.关键报错日志是这一句Error Application: filesystem error: in directory_iterator::directory_iterator(...): Structure needs cleaning [/var/lib/clickhouse/store/95f/95febdac-d99a-4bdb-9431-653a75f3a34b/202302_390451_394023_2919/]这个文件夹损坏结构需要清理
解决
百度了一堆确实能搜到解决方式牵涉到磁盘挂载、修复之类的试了下没用识别不到磁盘可能是我哪里搞错了暂时舍弃还有一个办法给文件重命名试了下使用mv old_file_name new_file_name重命名直接死机了重启服务器后我使用文件传输工具查看修改文件名竟然成功了。想了下这个损坏的文件应该不能随便移动应该使用rename虽然文件命名成功了但是clickhouse还是无法启动还是类似报错应该是clickhouse还是会使用这个文件想着怎么才能让clickhouse忽略这个文件夹试着把上面层级的文件夹95f改了下改成95f1启动服务后发现可以了
