** 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