elasticsearch can not update active record that has a parent relation

[cebe]

#!/bin/sh

curl -XDELETE "http://localhost:9200/bugreport"
curl -XPUT "http://localhost:9200/bugreport"
echo ""
echo "create tasks:"
curl -XPUT "http://localhost:9200/bugreport/_mapping/tasks" -d '{
"tasks": {
    "_id": {"path": "id", "index": "not_analyzed"},
    "properties": {
        "id": {"type": "string", "index": "not_analyzed"}
    }
}}'
echo ""
echo "create task_comments:"
curl -XPUT "http://localhost:9200/bugreport/_mapping/task_comments" -d '{
"task_comments": {
    "_parent": {"type": "tasks"},
    "_routing": {"required": true},
    "properties": {
        "taskId": {"type": "string", "index": "not_analyzed"},
        "message": {"type": "string"}
    }
}}'
echo ""
echo "add task record:"
curl -XPUT "http://localhost:9200/bugreport/tasks/cebe%2Ftest%2F6?op_type=create" -d '{
    "title":"test",
    "description":"test",
    "id":"cebe\/test\/6"
}'
echo ""
echo "add task_comments record:"
curl -XPUT "http://localhost:9200/bugreport/task_comments/1?op_type=create&parent=cebe%2Ftest%2F6" -d '{
    "taskId":"cebe\/test\/6",
    "authorId":"cebe",
    "message":"asdasd"
}'
echo ""
echo "update it:"
curl -XPOST "http://localhost:9200/bugreport/task_comments/_bulk" -d '
{"update":{"_id":"1","_type":"task_comments","_index":"bugreport"}}
{"doc":{"message":"as asdf","updated":"2014-10-24 21:59:18"}}

'
#{"update":{"_id":"1","_routing": "cebe\/test\/6","_type":"task_comments","_index":"bugreport"}}

output:

{"acknowledged":true}{"acknowledged":true}
create tasks:
{"acknowledged":true}
create task_comments:
{"acknowledged":true}
add task record:
{"_index":"bugreport","_type":"tasks","_id":"cebe/test/6","_version":1,"created":true}
add task_comments record:
{"_index":"bugreport","_type":"task_comments","_id":"1","_version":1,"created":true}
update it:
{"error":"NullPointerException[null]","status":500}

[cebe]

simple updates should not go through bulk api.

[cebe]

same for delete, do not use bulk api.

[ghost]

I'm experiencing the same problem. Thanks for sharing!

[cebe]

related docs: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-routing-field.html

[cebe]

related to: elastic/elasticsearch#8068 could be implemented automatically this way.

[cebe]

reported this case to improve the error message: elastic/elasticsearch#8714

[cebe]

@mortenzeppelin should work now, you can pass custom options to the update() and delete() method:

$comment->update(true, null, ['routing' => $task->id]

[ghost]

Hi @cebe
I found that I could also update children with "_parent" : (same as routing).
However, initially I thought the child element as an independent entity, but after reading http://www.elasticsearch.org/blog/managing-relations-inside-elasticsearch/
I realised the necessity for the parent ID.

[cebe]

I found that I could also update children with "_parent" : (same as routing).

You mean sending _parent within the request body/among the attributes?

[ghost]

To be honest it is been a while since I worked on this. And looking at my test script I see that I did not get bulk update to work, but it should be possible like this - which is equivalent to _routing.

curl -XPOST "http://localhost:9200/bugreport/task_comments/_bulk" -d '
{"update":{"_id":"1"}}
{"doc": {"_parent": "cebe/test/6", "message":"as asdf","updated":"2014-10-24 21:59:18"}, "doc_as_upsert": True}
'

("doc_as_upsert": True) added to only update parts of document.

[cebe]

Okay, thanks. Will consider this when working on the interface for direct support of parent-child relations.