Error JAVA on update

Siren Federate (Elasticsearch Plugin)
1

Hi guy,

I have a problem when i update a record (Article) on ES which is joined with an other index (Company).

I have this error

{“total”:5,“successful”:4,“skipped”:0,“failed”:1,“failures”:[{“shard”:1,“index”:“app_project”,“node”:“4B2AWZghTuuyQK-Eo1C58Q”,“reason”:{“type”:“exception”,“reason”:“Unable to call method=private void org.elasticsearch.search.SearchService.loadOrExecuteQueryPhase(org.elasticsearch.search.internal.ShardSearchRequest,org.elasticsearch.search.internal.SearchContext) throws java.lang.Exception with args [io.siren.federate.core.g.a.c@23444fed, [4B2AWZghTuuyQK-Eo1C58Q][app_project][1] query=[+type.id:[1 TO 1] +statut.id:{6 7 8} +CachingWrapperQuery(LongsHashSemiJoinQuery(companies.id:[inputData=3386-603806648-27674846-125208000])) #companies.porteuse:T]] on org.elasticsearch.search.c@33f0f9a0”,“caused_by”:{“type”:“invocation_target_exception”,“reason”:null,“caused_by”:{“type”:“null_pointer_exception”,“reason”:null}}}}]}

Could you help me please ?

Thanks

Mickael

2

Can you add the request parameter error_trace and see if you get a bit more ?
If not, can you add the parameter debug ? The output can be big.

3

I try with error_trace but failure message is same.

Where I must setted debug parameter ? On ES or on siren federate ?

4

This is also a request parameter.

What are the steps you take to reproduce the issue ? Make a join, update a doc, then again a join ?

5

I have a script which update each indice (article & company). When i update a record company and make a join query, the error appear

6

I am not able to reproduce this problem locally. Is it possible that you share your script ?
For the record, I have tested the following script but didn’t get an exception:

#! /bin/bash

http PUT localhost:9200/_bulk <<< '{ "index" : { "_index" : "articles", "_type" : "article", "_id" : "1" } }
{ "title" : "The NoSQL database glut", "mentions" : [1, 2] }
{ "index" : { "_index" : "articles", "_type" : "article", "_id" : "2" } }
{ "title" : "Graph Databases Seen Connecting the Dots", "mentions" : [] }
{ "index" : { "_index" : "articles", "_type" : "article", "_id" : "3" } }
{ "title" : "How to determine which NoSQL DBMS best fits your needs", "mentions" : [2, 4] }
{ "index" : { "_index" : "articles", "_type" : "article", "_id" : "4" } }
{ "title" : "MapR ships Apache Drill", "mentions" : [4] }
{ "index" : { "_index" : "companies", "_type" : "company", "_id" : "1" } }
{ "id": 1, "name" : "Elastic" }
{ "index" : { "_index" : "companies", "_type" : "company", "_id" : "2" } }
{ "id": 2, "name" : "Orient Technologies" }
{ "index" : { "_index" : "companies", "_type" : "company", "_id" : "3" } }
{ "id": 3, "name" : "Cloudera" }
{ "index" : { "_index" : "companies", "_type" : "company", "_id" : "4" } }
{ "id": 4, "name" : "MapR" }
'

for i in $(seq 10); do
	http POST localhost:9200/companies/_doc/1/_update <<< "$(jo doc=$(jo name=toto$i))"
	http localhost:9200/siren/articles/_search error_trace==true <<< "$(jo query=$(jo join=$(jo indices=$(jo -a companies) on=$(jo -a mentions id) request=$(jo  query=$(jo term=$(jo name=orient))))))"
done

for i in $(seq 10); do
	http POST localhost:9200/articles/_doc/1/_update <<< "$(jo doc=$(jo title=toto$i))"
	http localhost:9200/siren/articles/_search error_trace==true <<< "$(jo query=$(jo join=$(jo indices=$(jo -a companies) on=$(jo -a mentions id) request=$(jo  query=$(jo term=$(jo name=orient))))))"
done

What about the Elasticsearch logs ? Do they have any exception stack trace ?
What version of Federate are you using ? This was tested on 6.8.5-10.3.4.

7

Problem solved. This is a problem with my bash script to index all document. I need to set the type with HASH_JOIN too.

Thanks

8

Do you know where can i download siren federate 6.8.5-10.3.4 ?

9

Sorry 10.3.4 is still an internal branch but I have tested this against 10.3.3 without problem.