DC
помогите пожалуйста
на одном шарде, в двух из трех реплик отставание репликации
таблицы одни и те же
этому предшевстовало too many parts
Size: a a a
DC
DC
RT
database: stats
table: advertisers_selective_bidding_1573558672
replica_name: clickhouse-replica2
position: 1
node_name: queue-0000879340
type: GET_PART
create_time: 2021-03-19 18:45:28
required_quorum: 0
source_replica: clickhouse-replica
new_part_name: 202103_50747_50747_0
parts_to_merge: []
is_detach: 0
is_currently_executing: 0
num_tries: 0
last_exception:
last_attempt_time: 0000-00-00 00:00:00
num_postponed: 270
postpone_reason: Not executing log entry for part 202103_50747_50747_0 because it is covered by part 202103_48771_51643_87 that is currently executing
last_postpone_time: 2021-03-21 08:50:54
RT
RT
database: stats
table: advertisers_selective_bidding_1573558672
replica_name: clickhouse-replica2
position: 0
node_name: queue-0000879323
type: GET_PART
create_time: 2021-03-19 18:35:29
required_quorum: 0
source_replica: clickhouse-replica
new_part_name: 202103_50730_50730_0
parts_to_merge: []
is_detach: 0
is_currently_executing: 0
num_tries: 1
last_exception: Code: 226, e.displayText() = DB::Exception: Marks file '/var/lib/clickhouse/data/stats/advertisers_selective_bidding_1573558672/tmp_fetch_202103_48771_51643_87/hour_timestamp.mrk' doesn't exist (version 20.3.19.4 (official build))
last_attempt_time: 2021-03-21 08:22:26
num_postponed: 270
postpone_reason: Not executing log entry for part 202103_50730_50730_0 because it is covered by part 202103_48771_51643_87 that is currently executing
last_postpone_time: 2021-03-21 08:50:54
RT
DC
database: stats
table: advertisers_selective_bidding_1573558672
replica_name: clickhouse-replica2
position: 1
node_name: queue-0000879340
type: GET_PART
create_time: 2021-03-19 18:45:28
required_quorum: 0
source_replica: clickhouse-replica
new_part_name: 202103_50747_50747_0
parts_to_merge: []
is_detach: 0
is_currently_executing: 0
num_tries: 0
last_exception:
last_attempt_time: 0000-00-00 00:00:00
num_postponed: 270
postpone_reason: Not executing log entry for part 202103_50747_50747_0 because it is covered by part 202103_48771_51643_87 that is currently executing
last_postpone_time: 2021-03-21 08:50:54
DC
database: stats
table: advertisers_selective_bidding_1573558672
replica_name: clickhouse-replica2
position: 0
node_name: queue-0000879323
type: GET_PART
create_time: 2021-03-19 18:35:29
required_quorum: 0
source_replica: clickhouse-replica
new_part_name: 202103_50730_50730_0
parts_to_merge: []
is_detach: 0
is_currently_executing: 0
num_tries: 1
last_exception: Code: 226, e.displayText() = DB::Exception: Marks file '/var/lib/clickhouse/data/stats/advertisers_selective_bidding_1573558672/tmp_fetch_202103_48771_51643_87/hour_timestamp.mrk' doesn't exist (version 20.3.19.4 (official build))
last_attempt_time: 2021-03-21 08:22:26
num_postponed: 270
postpone_reason: Not executing log entry for part 202103_50730_50730_0 because it is covered by part 202103_48771_51643_87 that is currently executing
last_postpone_time: 2021-03-21 08:50:54
RT
2021.03.21 08:59:20.638873 [ 7861 ] {} <Trace> stats.advertisers_selective_bidding_1573558672 (Replicated PartsService): Sending part 202103_48771_51643_87
2021.03.21 08:59:20.771248 [ 7882 ] {} <Trace> stats.advertisers_selective_bidding_1573558672 (Replicated PartsService): Sending part 202103_51644_51671_6
RT
DC
RT
RT
/var/lib/clickhouse/data/stats/advertisers_selective_bidding_1573558672/
RT
D
RT
RT
DC
RT
RT