1.先切换到集群
kubectl config use-context do-sgp1-k8s-starcoin
2. 暂停barnard starcoin-indexer
先获取pod
kubectl get pods -n starcoin-barnard NAME READY STATUS RESTARTS AGE starcoin-indexer-stcscan-deployment-59f7fbccfc-s5kbj 1/1 Running 0 3h59m
获取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
5.执行如下命令时候报错，似乎不影响
POST barnard.0727.blocks/_delete_by_query
{
"query": {
"range": {
"header.number": {
"gt": 16056000
}
}
}
}