Error: Failed to perform requested operation on instance "istance-name", the instance has an error status: Please try again later [Error: Remote error: DBError (_mysql_exceptions.DataError)

[mkalir]

Hi

When I try to resize the instance

Error: Failed to perform requested operation on instance "istance-name", the instance has an error status: Please try again later [Error: Remote error: DBError (_mysql_exceptions.DataError) (1406, "Data too long for column 'dest_host' at row 1") [SQL: u'INSERT INTO migrations (created_at, updated_at, deleted_at, deleted, source_compute, dest_compute, source_node, dest_node, dest_host, old_i].

How can I solve this problem?

File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 383, in decorated_function return function(self, context, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 3838, in prep_resize filter_properties) File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 3889, in _reschedule_resize_or_reraise six.reraise(*exc_info) File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 3827, in prep_resize node, clean_shutdown) File "/usr/lib/python2.7/dist-packages/nova/compute/manager.py", line 3783, in _prep_resize image_meta=image, limits=limits) as claim: File "/usr/lib/python2.7/dist-packages/oslo_concurrency/lockutils.py", line 274, in inner return f(*args, **kwargs) File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 240, in resize_claim image_meta=image_meta, limits=limits) File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 268, in _move_claim new_instance_type, move_type) File "/usr/lib/python2.7/dist-packages/nova/compute/resource_tracker.py", line 318, in _create_migration migration.create() File "/usr/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 207, in wrapper ctxt, self, fn.__name__, args, kwargs) File "/usr/lib/python2.7/dist-packages/osprofiler/profiler.py", line 147, in wrapper return f(*args, **kwargs) File "/usr/lib/python2.7/dist-packages/nova/conductor/rpcapi.py", line 247, in object_action objmethod=objmethod, args=args, kwargs=kwargs) File "/usr/lib/python2.7/dist-packages/oslo_messaging/rpc/client.py", line 158, in call retry=self.retry) File "/usr/lib/python2.7/dist-packages/oslo_messaging/transport.py", line 90, in _send timeout=timeout, retry=retry) File "/usr/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 470, in send retry=retry) File "/usr/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 461, in _send raise result

[Stephane_Grandg]

Hi Mkalir,

this covered by bthis kb :

"Remote error: DBError (DataError)" during the resize operation in VIO (2146421)

https://kb.vmware.com/kb/2146421

if you connect to oms, and run as root:

#viocli show -p

it should return your deployment configuration file :

/var/lib/vio/jarvis/6e59e501-c029-49ac-baf1-9f689659dbc2/post-deployment-req-5a123b15-594c-45dd-aa1c-0e1fa3823d20-hosts.ini

#grep -A 3 compute /var/lib/vio/jarvis/6e59e501-c029-49ac-baf1-9f689659dbc2/post-deployment-req-5a123b15-594c-45dd-aa1c-0e1fa3823d20-hosts.ini

[compute]

192.168.20.57 datastore_regex="vsanDatastoreCompute" vcenter_ip=192.168.20.20 hostname=compute01 cluster_name=Compute01 vcenter_user=administrator@vsphere.local cluster_moid=domain-c82 vcenter_insecure=True vcenter_uuid=0acb24cc-45c2-4695-83e5-a0695ecd49e

this is taken from a 3.1 deployment it will be different in 2.5 and 3.0.

what version do you have . it should be fixed in VIO 3.1.

regards

stephane