Skip to content

Instantly share code, notes, and snippets.

@kolobaev
Created April 1, 2020 12:54
Show Gist options
  • Save kolobaev/a89ff1e3933f4caa20dc0bf83d9caf18 to your computer and use it in GitHub Desktop.
Save kolobaev/a89ff1e3933f4caa20dc0bf83d9caf18 to your computer and use it in GitHub Desktop.
SELECT *
FROM system.mutations
WHERE is_done = 0
Row 1:
──────
database: graphite
table: series
mutation_id: 0000000067
command: DELETE WHERE Path LIKE 'complex.delete_me._avi-http01.%'
create_time: 2020-04-01 15:37:41
block_numbers.partition_id: ['197001','197003','197006','197007','197107','197110','197206','197301','197304','197305','197306','197307','197309','197310','197401','197409','197411','197412','197501','197606','197611','197711','197905','198001','198111','198602','198604','198607','198705','199012','199208','199303','199308','199309','199312','199407','199502','199508','199701','199708','199712','199903','199904','199908','199909','200004','200104','200105','200112','200205','200208','200209','200210','200302','200306','200307','200308','200310','200401','200410','200412','200501','200502','200503','200504','200505','200506','200508','200510','200601','200606','200607','200609','200807','200810','200907','201006','201008','201012','201110','201111','201112','201201','201202','201203','201204','201205','201206','201207','201208','201209','201210','201211','201212','201301','201302','201303','201304','201305','201306','201307','201308','201309','201310','201311','201312','201401','201402','201403','201404','201405','201406','201407','201408','201409','201410','201411','201412','201501','201502','201503','201504','201505','201506','201507','201508','201509','201510','201511','201512','201601','201602','201603','201604','201605','201606','201607','201608','201609','201610','201611','201612','201701','201702','201703','201704','201705','201706','201707','201708','201709','201710','201711','201712','201801','201802','201803','201804','201805','201806','201807','201808','201809','201810','201811','201812','201901','201902','201903','201904','201905','201906','201907','201908','201909','201910','201911','201912','202001','202002','202003','202004','202012','202108','202205','202308','202503','202507','202906','203108','203409','203412','203504','203510','203608','203612','203811','204004','204203','204308','204404','204405','204406','204412','204504','204506','204511','204604','204607','204703','204706','204707','204709','204710','204712','204802','204806','204807','204902','204909','205001','205004','205102','205103','205104','205105','205106','205107','205108','205112','205201','205202','205204','205401','205402','205405','205407','205410','205502','205504','205511','205812','205905','205911','206103','206303','206309','206502','206503','206505','206506','206608','206609','206612','206706','206711','206807','206901','207011','207012','207303','207310','207311','207402','207411','207502','207603','207702','207708','207709','207711','207807','207901','208110','208112','208209','208304','208309','208507','208608','208808','208909','208910','209001','209003','209005','209006','209007','209008','209009','209103','209109','209201','209207','209312','209403','209405','209408','209410','209411','209412','209502','209503','209505','209509','209512','209602','209701','209704','209805','209808','209912','210005','210008','210107','210208','210301','210302','210303','210304','210306','210311','210405','210406','210407','210409','210412','210501','210503','210504','210505','210507','210509']
block_numbers.number: [446,72,161,77,81,71,60,62,60,60,69,111,60,66,72,74,161,80,21,60,60,60,60,61,60,60,65,60,74,61,60,60,60,60,60,60,60,62,60,61,62,61,66,62,60,64,61,60,61,60,60,61,60,61,66,61,61,60,72,60,72,64,60,61,61,84,70,62,60,60,28,77,78,63,70,60,61,63,60,41,66,84,80,86,97,91,94,88,91,140,86,104,102,102,159,95,102,100,102,97,108,116,106,108,104,111,159,146,155,166,154,160,164,163,157,166,155,157,156,148,149,156,705,701,170,744,164,744,162,167,747,734,749,166,749,756,767,871,846,876,911,978,991,984,1063,1100,1201,2159,2625,2959,2955,3016,3064,3127,2960,3230,3344,1437312,1415131,1501251,2095605,2532167,2576289,2689891,2535725,2657265,2765860,2985565,2407014,1519309,1651719,1786759,1901436,2050538,2109924,2237652,1924338,1909196,1752175,1699693,2022396,44223,60,61,60,61,60,60,1401,60,60,60,60,67,60,60,62,60,60,60,68,68,60,60,60,60,60,70,60,96,60,61,61,63,61,61,65,60,59,60,61,60,61,69,60,66,61,67,72,72,135,74,61,62,60,75,68,60,60,60,60,60,61,60,60,60,70,60,64,60,60,64,60,64,69,60,61,60,60,61,60,60,60,61,61,60,63,64,60,61,62,60,60,64,61,60,21,60,62,60,60,62,55,60,60,58,55,55,60,62,60,60,61,60,61,60,65,61,60,64,60,74,60,60,61,60,60,60,60,60,60,60,60,60,60,60,60,61,60,62,61,77,60,60,62,64,61,60,61,60,61,60,62]
parts_to_do_names: ['20191201_20191228_962857_1623700_316_1909195']
parts_to_do: 1
is_done: 0
latest_failed_part: 20191201_20191228_962857_1623700_316_1909195
latest_fail_time: 2020-04-01 15:47:23
latest_fail_reason: Code: 246, e.displayText() = DB::Exception: Bad size of marks file '/var/lib/clickhouse/data/graphite/series/20191201_20191228_962857_1623700_316_1909195/Path.mrk': 504048, must be: 336032 (version 20.3.4.10 (official build))
1 rows in set. Elapsed: 0.377 sec.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment