使用 psql 的 \o 命令重定向输出
如果你只是想查看查询结果或者快速导出到一个文件中,可以使用 \o 命令重定向输出。
\o '/tmp/systemd-private-40xxxxx/tmp/output.txt'
SELECT role,env FROM cluster_role WHERE cluster_id = 'cl-h...
# ceph health detail
HEALTH_WARN 1 daemons have recently crashed
RECENT_CRASH 1 daemons have recently crashed
mgr.controller crashed on host controller at 2023-06-19...
问题原因是是因为pg数大导致的:修复方法1:调整三个pool的pg数,2:按照下面的操作做。
# ceph -s
cluster:
id: 8ad5bacc-b1d6-4954-adb4-8fd0bb9eab35
health: HEALTH_WARN
3 pools have too ...
ceph -s查看集群状态提示错误 Errors while parsing config file!
# ceph -s
2023-06-25 22:51:08.141 2b2d436b3700 -1 Errors while parsing config file!
2023-06-25 22:51:08.141 2b2d436b37...
磁盘有问题导致好多pg需要修复,结果pg数据不一致修复完了,提示下面的错误。
告诉osd清除共享请求
ceph tell osd.38 clear_shards_repaired
参考:
https://ceph.com/geen-categorie/ceph-manually-repair-object/
查看ceph状态
# ceph health detail
HEALTH_ERR 1 scrub errors; Possible data damage: 1 pg inconsistent
OSD_SCRU...
# ceph -s
cluster:
id: aa2c40ad-53bc-40a7-b7ea-74ae648c70e9
health: HEALTH_WARN
4 slow ops, oldest one blocked for 60002 sec, mon.node-1 has slo...
查看报错信息
# ceph health detail
HEALTH_WARN 3 daemons have recently crashed
RECENT_CRASH 3 daemons have recently crashed
osd.2 crashed on host compute02 at 2021-10-01 05...
ceph版本
# ceph -v
ceph version 14.2.22 (ca74598065096e6fcbd8433c8779a2be0c889351) nautilus (stable)
ceph状态
# ceph -s
cluster:
id: 0a5412e0-073d-4245-92ea-8401c0b...