Logstash always fail to connect jdbc connection with sql server

Dear All.

I am trying to fetch auto data from sql server to elastic search but i am getting below failure error.

[2019-10-07T12:12:25,194][INFO ][logstash.outputs.elasticsearch] retrying failed action with response code: 429 ({"type"=>"es_rejected_execution_exception", "reason"=>"rejected execution of processing of [19483440][indices:data/write/bulk[s][p]]: request: BulkShardRequest [[dbdataindex_join_04_10_2019_labs_medications_union][0]] containing [125] requests, target allocation id: nae3lQr2S1m8lU8x_Xd9EQ, primary term: 1 on EsThreadPoolExecutor[name = slave1/write, queue capacity = 200, org.elasticsearch.common.util.concurrent.EsThreadPoolExecutor@c477fff[Running, pool size = 4, active threads = 4, queued tasks = 200, completed tasks = 3406195]]"})

from database admin side error:-

SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [this ip].

Please help for this issue.

Thanks
HadoopHelp

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.