** Changed in: nova
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1322599

Title:
  nova baremetal-node-create fails with HTTP 500

Status in OpenStack Compute (Nova):
  Invalid
Status in tripleo - openstack on openstack:
  Fix Released

Bug description:
  baremetal-node-create fails with HTTP 500 as pm_password we pass is
  bigger than allowed; DB schema reports VARCHAR255

  trace is as follows:

  nova.openstack.common.db.sqlalchemy.session   File 
"/opt/stack/venvs/nova/lib/python2.7/site-packages/nova/openstack/common/db/sqlalchemy/session.py",
 line 439, in _wrap
  nova.openstack.common.db.sqlalchemy.session     return f(self, *args, 
**kwargs)
  nova.openstack.common.db.sqlalchemy.session   File 
"/opt/stack/venvs/nova/lib/python2.7/site-packages/nova/openstack/common/db/sqlalchemy/session.py",
 line 705, in flush
  nova.openstack.common.db.sqlalchemy.session     return super(Session, 
self).flush(*args, **kwargs)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1824, in 
flush
  nova.openstack.common.db.sqlalchemy.session     self._flush(objects)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1942, in 
_flush
  nova.openstack.common.db.sqlalchemy.session     
transaction.rollback(_capture_exception=True)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 58, 
in __exit__
  nova.openstack.common.db.sqlalchemy.session     compat.reraise(exc_type, 
exc_value, exc_tb)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1906, in 
_flush
  nova.openstack.common.db.sqlalchemy.session     flush_context.execute()
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in 
execute
  nova.openstack.common.db.sqlalchemy.session     rec.execute(self)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 525, in 
execute
  nova.openstack.common.db.sqlalchemy.session     uow
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 64, in 
save_obj
  nova.openstack.common.db.sqlalchemy.session     table, insert)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 569, 
in _emit_insert_statements
  nova.openstack.common.db.sqlalchemy.session     execute(statement, params)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in 
execute
  nova.openstack.common.db.sqlalchemy.session     params)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 761, in 
_execute_clauseelement
  nova.openstack.common.db.sqlalchemy.session     compiled_sql, distilled_params
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 874, in 
_execute_context
  nova.openstack.common.db.sqlalchemy.session     context)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1024, in 
_handle_dbapi_exception
  nova.openstack.common.db.sqlalchemy.session     exc_info
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 196, in 
raise_from_cause
  nova.openstack.common.db.sqlalchemy.session     reraise(type(exception), 
exception, tb=exc_tb)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 867, in 
_execute_context
  nova.openstack.common.db.sqlalchemy.session     context)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 324, in 
do_execute
  nova.openstack.common.db.sqlalchemy.session     cursor.execute(statement, 
parameters)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute
  nova.openstack.common.db.sqlalchemy.session     self.errorhandler(self, exc, 
value)
  nova.openstack.common.db.sqlalchemy.session   File 
"/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in 
defaulterrorhandler
  nova.openstack.common.db.sqlalchemy.session     raise errorclass, errorvalue
  nova.openstack.common.db.sqlalchemy.session DataError: (DataError) (1406, 
"Data too long for column 'pm_password' at row 1") 'INSERT INTO bm_nodes 
(created_at, updated_at, deleted_at, deleted, uuid, service_host, 
instance_uuid, instance_na
  me, cpus, memory_mb, local_gb, preserve_ephemeral, pm_address, pm_user, 
pm_password, task_state, terminal_port, image_path, pxe_config_path, 
deploy_key, root_mb, swap_mb, ephemeral_mb)

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1322599/+subscriptions

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to