OpenStack DBaaS (Trove)

Data too long for column 'task_description'

Bug #1334360 reported by Suthan Venkataramanaiah on 2014-06-25

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	OpenStack DBaaS (Trove)	Fix Released	Medium	Suthan Venkataramanaiah	OpenStack DBaaS (Trove) 2014.2 "juno"

Bug Description

db_text for trove.instance.tasks.InstanceTasks.BUILDING_ERROR_SEC_GROUP is too long. To reproduce simply hit your security group quota limit.

2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/openstack/common/rpc/dispatcher.py", line 172, in dispatch
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp result = getattr(proxyobj, method)(ctxt, **kwargs)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/taskmanager/manager.py", line 90, in create_instance
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp overrides, cluster_config)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/taskmanager/models.py", line 193, in create_instance
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp self._log_and_raise(e, msg, err)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/taskmanager/models.py", line 528, in _log_and_raise
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp self.update_db(task_status=task_status)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/instance/models.py", line 554, in update_db
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp self.db_info.save()
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/db/models.py", line 62, in save
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp return self.db_api.save(self)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/opt/stack/trove/trove/db/sqlalchemy/api.py", line 57, in save
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp db_session.flush()
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1903, in flush
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp self._flush(objects)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2021, in _flush
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp transaction.rollback(_capture_exception=True)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp compat.reraise(exc_type, exc_value, exc_tb)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1985, in _flush
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp flush_context.execute()
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 370, in execute
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp rec.execute(self)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 523, in execute
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp uow
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 59, in save_obj
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp mapper, table, update)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 510, in _emit_update_statements
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp execute(statement, params)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 720, in execute
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp return meth(self, multiparams, params)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp return connection._execute_clauseelement(self, multiparams, params)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp compiled_sql, distilled_params
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp context)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp exc_info
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp reraise(type(exception), exception, tb=exc_tb)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 940, in _execute_context
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp context)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 435, in do_execute
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp cursor.execute(statement, parameters)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp self.errorhandler(self, exc, value)
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp raise errorclass, errorvalue
2014-06-20 18:37:48.307 TRACE trove.openstack.common.rpc.amqp DataError: (DataError) (1406, "Data too long for column 'task_description' at row 1") 'UPDATE instances SET updated=%s, task_id=%s, task_description=%s WHERE instances.id = %s' (datetime.datetime(2014, 6, 20, 18, 37, 48, 302444), 83, 'Build error: Security group or rule.', u'a427eaff-d312-48f8-91e4-b5e710d08029')

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2014-06-25: Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/102601

Changed in trove:
assignee:	nobody → Suthan Venkataramanaiah (svenkataramanaia)
status:	New → In Progress

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2014-06-27: Fix merged to trove (master)

Reviewed: https://review.openstack.org/102601
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=92c1cc1d1ea9670f06a3bfd4463bffd3156b28e2
Submitter: Jenkins
Branch: master

commit 92c1cc1d1ea9670f06a3bfd4463bffd3156b28e2
Author: svenkataramanaia <email address hidden>
Date: Wed Jun 25 10:15:49 2014 -0700

Fix data too long for column 'task_description'

Change-Id: I9153cc1a8a194990b3b437fcab0ceddbd716e247
Closes-Bug: #1334360

Changed in trove:
status:	In Progress → Fix Committed

Nikhil Manchanda (slicknik) on 2014-06-27

Changed in trove:
importance:	Undecided → Medium
milestone:	none → juno-2

Russell Bryant (russellb) on 2014-07-23

Changed in trove:
status:	Fix Committed → Fix Released

Thierry Carrez (ttx) on 2014-10-16

Changed in trove:
milestone:	juno-2 → 2014.2

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

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