barnard 回滚区块浏览器数据清理步骤

1.先切换到老集群

kubectl config use-context arn:aws:eks:ap-northeast-1:576184071779:cluster/starcoin2

2. 暂停barnard starcoin-indexer服务
   先获取pod

kubectl get pods -n starcoin-barnard
NAME                                           READY   STATUS    RESTARTS   AGE
starcoin-indexer-deployment-544fcc458b-ncmws   1/1     Running   0          4d3h

获取pod对应的deployment

kubectl get deployment -n starcoin-barnard
NAME                          READY   UP-TO-DATE   AVAILABLE   AGE
starcoin-indexer-deployment   1/1     1            1           116d

获取对应deployment配置文件

kubectl get deploy starcoin-indexer-deployment -n starcoin-barnard -o yaml > barnard.yaml

删除对应pod

kubectl delete -f barnard.yaml

3. es内更新脚本
   

   GET barnard.0727.blocks/_search
   {
     "query": {
       "term": {
         "header.number": {
           "value": "16056000"
         }
       }
     }
   }
   
   POST barnard.0727.block_ids/_delete_by_query
   {
     "query": {
       "range": {
         "header.number": {
           "gt": 16056000
         }
       }
     }
   }
   
   POST barnard.0727.blocks/_delete_by_query
   {
     "query": {
       "range": {
         "header.number": {
           "gt": 16056000
         }
       }
     }
   }
   POST barnard.0727.uncle_blocks/_delete_by_query
   {
     "query": {
       "range": {
         "header.number": {
           "gt": 16056000
         }
       }
     }
   }
   
   //查处time
   POST barnard.0727.transfer/_delete_by_query
   {
     "query": {
       "range": {
         "timestamp": {
           "gt": 1693377323811
         }
       }
     }
   }
   POST barnard.0727.transfer_journal/_delete_by_query
   {
     "query": {
       "range": {
         "timestamp": {
           "gt": 1693377323811
         }
       }
     }
   }
   POST barnard.0727.txn_events/_delete_by_query
   {
     "query": {
       "range": {
         "timestamp": {
           "gt": 1693377323811
         }
       }
     }
   }
   POST barnard.0727.txn_infos/_delete_by_query
   {
     "query": {
       "range": {
         "timestamp": {
           "gt": 1693377323811
         }
       }
     }
   }
   
   //offset
   PUT barnard.0727.blocks/_mapping
   {
       "_meta" : {
         "tip" : {
             "block_hash" : "0x1067291d5f74c1332de6e9109b1b4c382be1c482a052ad4bb0e2b66f220bb22e",
             "block_number" : 16056000
           }
       }
   }
   
   //查找块内交易的global index
   PUT barnard.0727.transfer/_mapping
   {
       "_meta" : {
           "offset" : 11836358,
           "timestamp" : "1668236833504"
       }
   }
   PUT barnard.0727.txn_payloads/_mapping
   {
       "_meta" : {
           "offset" : 11836358,
           "timestamp" : "1668236833504"
       }
   }
   

4. 恢复pod
   

   kubectl apply -f barnard.yaml