Comment 5 for bug 1638452

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

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
    context)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (psycopg2.ProgrammingError) column node_nic_interfaces.attributes does not exist
LINE 1: ...ng_modes AS node_nic_interfaces_offloading_modes, node_nic_i...
                                                             ^
 [SQL: 'SELECT node_nic_interfaces.id AS node_nic_interfaces_id, node_nic_interfaces.node_id AS node_nic_interfaces_node_id, node_nic_interfaces.name AS node_nic_interfaces_name, node_nic_interfaces.mac AS node_nic_interfaces_mac, node_nic_interfaces.max_speed AS node_nic_interfaces_max_speed, node_nic_interfaces.current_speed AS node_nic_interfaces_current_speed, node_nic_interfaces.ip_addr AS node_nic_interfaces_ip_addr, node_nic_interfaces.netmask AS node_nic_interfaces_netmask, node_nic_interfaces.state AS node_nic_interfaces_state, node_nic_interfaces.interface_properties AS node_nic_interfaces_interface_properties, node_nic_interfaces.parent_id AS node_nic_interfaces_parent_id, node_nic_interfaces.driver AS node_nic_interfaces_driver, node_nic_interfaces.bus_info AS node_nic_interfaces_bus_info, node_nic_interfaces.pxe AS node_nic_interfaces_pxe, node_nic_interfaces.offloading_modes AS node_nic_interfaces_offloading_modes, node_nic_interfaces.attributes AS node_nic_interfaces_attributes, node_nic_interfaces.meta AS node_nic_interfaces_meta, anon_1.nodes_id AS anon_1_nodes_id \nFROM (SELECT nodes.id AS nodes_id \nFROM nodes) AS anon_1 JOIN node_nic_interfaces ON anon_1.nodes_id = node_nic_interfaces.node_id ORDER BY anon_1.nodes_id, node_nic_interfaces.name']

How to fix it?