Internal Server Error for url: http://10.20.0.2:8000/api/v1/clusters/

Bug #1638452 reported by Sergey K
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Invalid
Medium
Fuel Sustaining
Nominated for Ocata by Oleksiy Molchanov
Mitaka
Invalid
Medium
Fuel Sustaining
Newton
Invalid
Medium
Fuel Sustaining

Bug Description

# fuel --debug env
GET http://10.20.0.2:8000/api/v1/clusters/
500 Server Error: Internal Server Error for url: http://10.20.0.2:8000/api/v1/clusters/ (Unexpected exception, please check logs)

# fuel --debug snapshot
PUT http://10.20.0.2:8000/api/v1/logs/package data={}
400 Client Error: Bad Request for url: http://10.20.0.2:8000/api/v1/logs/package ((psycopg2.ProgrammingError) column tasks.dry_run does not exist
LINE 1: ...sks_weight, tasks.deleted_at AS tasks_deleted_at, tasks.dry_...
                                                             ^
 [SQL: 'SELECT tasks.id AS tasks_id, tasks.cluster_id AS tasks_cluster_id, tasks.uuid AS tasks_uuid, tasks.name AS tasks_name, tasks.message AS tasks_message, tasks.status AS tasks_status, tasks.progress AS tasks_progress, tasks.result AS tasks_result, tasks.parent_id AS tasks_parent_id, tasks.weight AS tasks_weight, tasks.deleted_at AS tasks_deleted_at, tasks.dry_run AS tasks_dry_run, tasks.graph_type AS tasks_graph_type, tasks.time_start AS tasks_time_start, tasks.time_end AS tasks_time_end \nFROM tasks \nWHERE tasks.deleted_at IS NULL AND tasks.name IN (%(name_1)s) ORDER BY tasks.id ASC'] [parameters: {'name_1': 'dump'}])

fuel --debug fuel-version
GET http://10.20.0.2:8000/api/v1/version/
api: '1'
auth_required: true
feature_groups:
- experimental
- advanced
openstack_version: mitaka-9.0
release: '9.0'

What logs I should see? What`s wrong?

Tags: area-python
Sergey K (silver-lynx)
description: updated
Changed in fuel:
milestone: none → 9.2
milestone: 9.2 → 11.0
assignee: nobody → Fuel Sustaining (fuel-sustaining-team)
importance: Undecided → Medium
status: New → Confirmed
tags: added: area-python
Revision history for this message
Sergey K (silver-lynx) wrote :

Is there any progress in this issue?
Is there some sort of a temporary solution?

Revision history for this message
Vitalii Kulanov (vitaliy-t) wrote :

@Sergey, can you, please specify ISO, because I can't reproduce this on one of the latest (4910) community builds

[root@fuel ~]# shotgun2 short-report
cat /etc/fuel_build_id:
 4910
cat /etc/fuel_build_number:
 4910
cat /etc/fuel_release:
 9.0
cat /etc/fuel_openstack_version:
 mitaka-9.0

[root@fuel ~]# fuel env
id | status | name | release_id
---+--------+--------+-----------
1 | new | iCloud | 2

[root@fuel ~]# fuel2 env list
+----+--------+--------+------------+
| id | status | name | release_id |
+----+--------+--------+------------+
| 1 | new | iCloud | 2 |
+----+--------+--------+------------+
[root@fuel ~]#

Revision history for this message
Sergey K (silver-lynx) wrote :

@Vitalii, Just the image of the official website of Mirantis.

[root@fuel ~]# shotgun2 short-report
cat /etc/fuel_build_id:
 495
cat /etc/fuel_build_number:
 495
cat /etc/fuel_release:
 9.0
cat /etc/fuel_openstack_version:
 mitaka-9.0
rpm -qa | egrep 'fuel|astute|network-checker|nailgun|packetary|shotgun':
 fuel-openstack-metadata-9.0.0-1.mos8861.noarch
 rubygem-astute-9.0.0-1.mos774.noarch
 fuel-utils-9.0.0-1.mos8607.noarch
 network-checker-9.0.0-1.mos77.x86_64
 fuel-misc-9.0.0-1.mos8607.noarch
 fuel-setup-9.0.0-1.mos6357.noarch
 shotgun-9.0.0-1.mos90.noarch
 fuel-nailgun-extension-cluster-upgrade-9.1-1.mos81.noarch
 fuelmenu-9.0.0-1.mos275.noarch
 fuel-library9.0-9.0.0-1.mos8606.noarch
 fuel-bootstrap-cli-9.0.0-1.mos291.noarch
 nailgun-mcagents-9.0.0-1.mos774.noarch
 fuel-octane-9.0.0-1.mos1349.noarch
 fuel-release-9.0.0-1.mos6357.noarch
 python-packetary-9.0.0-1.mos154.noarch
 fuel-provisioning-scripts-9.0.0-1.mos8861.noarch
 fuel-agent-9.0.0-1.mos291.noarch
 fuel-ostf-9.0.0-1.mos946.noarch
 fuel-notify-9.0.0-1.mos8607.noarch
 fuel-migrate-9.0.0-1.mos8607.noarch
 python-fuelclient-9.0.0-1.mos356.noarch
 fuel-mirror-9.0.0-1.mos154.noarch
 fuel-9.0.0-1.mos6357.noarch
 fuel-ui-9.0.0-1.mos2814.noarch
 fuel-nailgun-9.0.0-1.mos8861.noarch
[root@fuel ~]#

Revision history for this message
Sergey K (silver-lynx) wrote :
Download full text (4.8 KiB)

More info:

==> /var/log/nailgun/app.log <==
2016-12-02 03:28:47.470 ERROR [7fef8f107880] (base) Unexpected exception occured
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/nailgun/api/v1/handlers/base.py", line 297, in handle_errors
    return func(cls, *args, **kwargs)
  File "<string>", line 2, in GET
  File "/usr/lib/python2.7/site-packages/nailgun/api/v1/handlers/base.py", line 355, in validate
    return func(cls, *args, **kwargs)
  File "<string>", line 2, in GET
  File "/usr/lib/python2.7/site-packages/nailgun/api/v1/handlers/base.py", line 381, in serialize
    resp = func(cls, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/nailgun/api/v1/handlers/node.py", line 102, in GET
    return self.collection.to_list(nodes)
  File "/usr/lib/python2.7/site-packages/nailgun/objects/base.py", line 424, in to_list
    use_iterable
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/loading.py", line 86, in instances
    util.raise_from_cause(err)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/loading.py", line 71, in instances
    rows = [proc(row) for row in fetch]
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/loading.py", line 428, in _instance
    loaded_instance, populate_existing, populators)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/loading.py", line 497, in _populate_full
    populator(state, dict_, row)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 1048, in load_collection_from_subq
    ()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 985, in get
    self._load()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 993, in _load
    lambda x: x[1:]
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    co...

Read more...

Revision history for this message
Sergey K (silver-lynx) wrote :

Problem was solved by run `nailgun_syncdb`

Dmitry Pyzhov (dpyzhov)
Changed in fuel:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.