在JDBC River中如何停止内部管理不删除记录？ [英] In JDBC River how to stop housekeeping not to delete records?

问题描述

当JDBC River进行轮询时，内务管理作业将删除大部分记录。

When JDBC River does the polling, housekeeping jobs removes chunk of records.

有人知道解决方案。我想停止记录删除。

Somebody know solutions for it. I want to stop records deletion.

有关更多参考： - https://github.com/jprante/elasticsearch-river-jdbc/issues/61

For more reference :- https://github.com/jprante/elasticsearch-river-jdbc/issues/61

推荐答案

如果在版本控制：false JDBC-River-parametersrel =nofollow> JDBC river参数，这是默认值。

The housekeeping job is stop if versioning is disabled by versioning: false in the JDBC river parameters, which is the default.

{
    "jdbc" :{
    "strategy" : "oneshot",
    "driver" : null,
    "url" : null,
    "user" : null,
    "password" : null,
    "sql" : null,
    "sqlparams" : null,
    "poll" : "1h",
    "rounding" : null,
    "scale" : 0,
    "autocommit" : false,
    "fetchsize" : 10,
    "max_rows" : 0,
    "max_retries" : 3,
    "max_retries_wait" : "10s",
    "locale" : Locale.getDefault().toLanguageTag(),
    "digesting" : true,
    "acksql" : null,
    "acksqlparams" : null          
    },
    "index" : {
    "index" : "jdbc",
    "type" : "jdbc",
    "bulk_size" : 100,
    "max_bulk_requests" : 30,
    "index_settings" : null,
    "type_mapping" : null,
    "versioning" : false,  
    "acknowledge" : false,
    }
}

versioning：true 如果版本控制应该用于Elasticsearch索引文档

"versioning": true if versioning should be used in the Elasticsearch indexed documents

作者参考： - https://github.com/jprante/elasticsearch-river-jdbc/issues/133#issuecomment-30148180

这篇关于在JDBC River中如何停止内部管理不删除记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！