nailgun fails to update task status in receiver

[Anastasia Palkina]

"build_id": "2014-06-27_00-31-14",
"mirantis": "yes",
"build_number": "274",
"ostf_sha": "a4978638de3951dbc229276608a839a19ece2b70",
"nailgun_sha": "5f2944a8d5077a1c96acb076ba9194f670b818e8",
"production": "docker",
"api": "1.0",
"fuelmain_sha": "bf8660309601cee2f8f3e1bb881d272e638dcffa",
"astute_sha": "694b5a55695e01e1c42185bfac9cc7a641a9bd48",
"release": "5.1",
"fuellib_sha": "acc99fcd0ba9eeef0a504dc26507eb91ce757220"

There are many tracebacks in RPC Consumer log on UI:

2014-06-27 15:36:52 ERROR

[7f040da29700] (receiverd) Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/nailgun/rpc/receiverd.py", line 47, in consume_msg
    callback(**body["args"])
  File "/usr/lib/python2.6/site-packages/nailgun/rpc/receiver.py", line 766, in verify_networks_resp
    objects.Task.update(task, data)
  File "/usr/lib/python2.6/site-packages/nailgun/objects/task.py", line 250, in update
    super(Task, cls).update(instance, data)
  File "/usr/lib/python2.6/site-packages/nailgun/objects/base.py", line 121, in update
    db().flush()
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 1718, in flush
    self._flush(objects)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 1789, in _flush
    flush_context.execute()
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 331, in execute
    rec.execute(self)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 475, in execute
    uow
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 59, in save_obj
    mapper, table, update)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 485, in _emit_update_statements
    execute(statement, params)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
IntegrityError: (IntegrityError) null value in column "status" violates not-null constraint
DETAIL: Failing row contains (50, 6, 366f055b-e146-42df-8595-f799584bdd0e, verify_networks, null, null, 60, {"args": {"task_uuid": "366f055b-e146-42df-8595-f799584bdd0e", "..., [], null, 1).
 'UPDATE tasks SET status=%(status)s, progress=%(progress)s, result=%(result)s WHERE tasks.id = %(tasks_id)s' {'status': None, 'progress': 60, 'result': '[]', 'tasks_id': 50}

[Nastya Urlapova (aurlapova)]

Issue reproduced on smoke test for iso #275

[Dima Shulyak (dshulyak)]

sorry, the problem is not only with provision

[Dima Shulyak (dshulyak)]

https://bugs.launchpad.net/fuel/+bug/1335059

[Dima Shulyak (dshulyak)]

see comment on Base 136 line

https://review.openstack.org/#/c/96532/15/nailgun/nailgun/task/helpers.py

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/103496

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/103496
Committed: https://git.openstack.org/cgit/stackforge/fuel-web/commit/?id=384ecef4dcadef7cb622ade15824b9fa24507310
Submitter: Jenkins
Branch: master

commit 384ecef4dcadef7cb622ade15824b9fa24507310
Author: Alexander Kislitsky <email address hidden>
Date: Mon Jun 30 13:14:35 2014 +0400

    Filtering of wrong Task statuses added into update

    Wrong statuses of Task filtered in objects.Task.update
    Closes-Bug: #1335170

    Change-Id: Id12d628dd67126ffd97afc468f590db7dc8ea6f8