yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #51547
[Bug 1585917] [NEW] member-create will raise 500 Internal Server error if member-id is greater that 255 characters
Public bug reported:
While adding members to image (image sharing) if member-id is specified
above 255 characters then it will raise 500 Internal server error.
Steps to reproduce:
:~$ glance member-create 3174767b-7ccc-4691-a3ca-6884d04c0330 2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
500 Internal Server Error
The server has either erred or is incapable of performing the requested operation.
(HTTP 500)
glance-api logs:
2016-05-26 12:23:43.186 DEBUG oslo_policy.policy [req-ca9b4266-b1a9-406a-9b77-6905ce3bf658 9448716ab50145dcbdb7d5653ecdc2dc 9f8383968a0a4d0bb303500cd5c49f51] Reloaded pol
icy file: /etc/glance/policy.json from (pid=26413) _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:520
2016-05-26 12:23:43.201 ERROR oslo_db.sqlalchemy.exc_filters [req-ca9b4266-b1a9-406a-9b77-6905ce3bf658 9448716ab50145dcbdb7d5653ecdc2dc 9f8383968a0a4d0bb303500cd5c49f51]
DBAPIError exception wrapped from (pymysql.err.DataError) (1406, u"Data too long for column 'member' at row 1") [SQL: u'INSERT INTO image_members (created_at, updated_at,
deleted_at, deleted, image_id, member, can_share, status) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(image_id)s, %(member)s, %(can_share)s, %
(status)s)'] [parameters: {'status': 'pending', 'deleted': 0, 'created_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201107), 'updated_at': datetime.datetime(2016, 5, 26
, 6, 53, 43, 201144), 'member': u'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', '
image_id': u'3174767b-7ccc-4691-a3ca-6884d04c0330', 'can_share': 0, 'deleted_at': None}]
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters context)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters result = self._query(query)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters conn.query(q)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters result.read()
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters packet.check_error()
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters _check_mysql_exception(errinfo)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errorvalue)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters DataError: (1406, u"Data too long for column 'member' at row 1")
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters
2016-05-26 12:23:43.234 ERROR glance.common.wsgi [req-ca9b4266-b1a9-406a-9b77-6905ce3bf658 9448716ab50145dcbdb7d5653ecdc2dc 9f8383968a0a4d0bb303500cd5c49f51] Caught error: (pymysql.err.DataError) (1406, u"Data too long for column 'member' at row 1") [SQL: u'INSERT INTO image_members (created_at, updated_at, deleted_at, deleted, image_id, member, can_share, status) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(image_id)s, %(member)s, %(can_share)s, %(status)s)'] [parameters: {'status': 'pending', 'deleted': 0, 'created_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201107), 'updated_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201144), 'member': u'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'image_id': u'3174767b-7ccc-4691-a3ca-6884d04c0330', 'can_share': 0, 'deleted_at': None}]
2016-05-26 12:23:43.234 TRACE glance.common.wsgi Traceback (most recent call last):
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/common/wsgi.py", line 918, in __call__
2016-05-26 12:23:43.234 TRACE glance.common.wsgi request, **action_args)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/common/wsgi.py", line 957, in dispatch
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return method(*args, **kwargs)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/common/utils.py", line 362, in wrapped
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return func(self, req, *args, **kwargs)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/api/v2/image_members.py", line 116, in create
2016-05-26 12:23:43.234 TRACE glance.common.wsgi member_repo.add(new_member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/api/authorization.py", line 166, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self.member_repo.add(image_member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/notifier.py", line 520, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi super(ImageMemberRepoProxy, self).add(member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/domain/proxy.py", line 121, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self.base.add(self.member_proxy_helper.unproxy(member))
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/api/policy.py", line 241, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self.member_repo.add(member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/location.py", line 494, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi super(ImageMemberRepoProxy, self).add(member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/domain/proxy.py", line 94, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi result = self.base.add(base_item)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/__init__.py", line 367, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi image_member_values)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/sqlalchemy/api.py", line 1066, in image_member_create
2016-05-26 12:23:43.234 TRACE glance.common.wsgi _image_member_update(context, memb_ref, values, session=session)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/sqlalchemy/api.py", line 1098, in _image_member_update
2016-05-26 12:23:43.234 TRACE glance.common.wsgi memb_ref.save(session=session)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/sqlalchemy/models.py", line 72, in save
2016-05-26 12:23:43.234 TRACE glance.common.wsgi super(GlanceBase, self).save(session or db_api.get_session())
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/models.py", line 48, in save
2016-05-26 12:23:43.234 TRACE glance.common.wsgi session.flush()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self._flush(objects)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
2016-05-26 12:23:43.234 TRACE glance.common.wsgi transaction.rollback(_capture_exception=True)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-05-26 12:23:43.234 TRACE glance.common.wsgi compat.reraise(exc_type, exc_value, exc_tb)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
2016-05-26 12:23:43.234 TRACE glance.common.wsgi flush_context.execute()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi rec.execute(self)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi uow
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
2016-05-26 12:23:43.234 TRACE glance.common.wsgi mapper, table, insert)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
2016-05-26 12:23:43.234 TRACE glance.common.wsgi execute(statement, params)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return meth(self, multiparams, params)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return connection._execute_clauseelement(self, multiparams, params)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2016-05-26 12:23:43.234 TRACE glance.common.wsgi compiled_sql, distilled_params
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-05-26 12:23:43.234 TRACE glance.common.wsgi context)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-05-26 12:23:43.234 TRACE glance.common.wsgi util.raise_from_cause(newraise, exc_info)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-05-26 12:23:43.234 TRACE glance.common.wsgi reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-05-26 12:23:43.234 TRACE glance.common.wsgi context)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi cursor.execute(statement, parameters)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi result = self._query(query)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-05-26 12:23:43.234 TRACE glance.common.wsgi conn.query(q)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-05-26 12:23:43.234 TRACE glance.common.wsgi result.read()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-05-26 12:23:43.234 TRACE glance.common.wsgi first_packet = self.connection._read_packet()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-05-26 12:23:43.234 TRACE glance.common.wsgi packet.check_error()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-05-26 12:23:43.234 TRACE glance.common.wsgi err.raise_mysql_exception(self._data)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-05-26 12:23:43.234 TRACE glance.common.wsgi _check_mysql_exception(errinfo)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-05-26 12:23:43.234 TRACE glance.common.wsgi raise errorclass(errno, errorvalue)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi DBError: (pymysql.err.DataError) (1406, u"Data too long for column 'member' at row 1") [SQL: u'INSERT INTO image_members (created_at, updated_at, deleted_at, deleted, image_id, member, can_share, status) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(image_id)s, %(member)s, %(can_share)s, %(status)s)'] [parameters: {'status': 'pending', 'deleted': 0, 'created_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201107), 'updated_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201144), 'member': u'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'image_id': u'3174767b-7ccc-4691-a3ca-6884d04c0330', 'can_share': 0, 'deleted_at': None}]
** Affects: glance
Importance: Undecided
Assignee: Abhishek Kekane (abhishek-kekane)
Status: New
** Changed in: glance
Assignee: (unassigned) => Abhishek Kekane (abhishek-kekane)
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1585917
Title:
member-create will raise 500 Internal Server error if member-id is
greater that 255 characters
Status in Glance:
New
Bug description:
While adding members to image (image sharing) if member-id is
specified above 255 characters then it will raise 500 Internal server
error.
Steps to reproduce:
:~$ glance member-create 3174767b-7ccc-4691-a3ca-6884d04c0330 2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
500 Internal Server Error
The server has either erred or is incapable of performing the requested operation.
(HTTP 500)
glance-api logs:
2016-05-26 12:23:43.186 DEBUG oslo_policy.policy [req-ca9b4266-b1a9-406a-9b77-6905ce3bf658 9448716ab50145dcbdb7d5653ecdc2dc 9f8383968a0a4d0bb303500cd5c49f51] Reloaded pol
icy file: /etc/glance/policy.json from (pid=26413) _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:520
2016-05-26 12:23:43.201 ERROR oslo_db.sqlalchemy.exc_filters [req-ca9b4266-b1a9-406a-9b77-6905ce3bf658 9448716ab50145dcbdb7d5653ecdc2dc 9f8383968a0a4d0bb303500cd5c49f51]
DBAPIError exception wrapped from (pymysql.err.DataError) (1406, u"Data too long for column 'member' at row 1") [SQL: u'INSERT INTO image_members (created_at, updated_at,
deleted_at, deleted, image_id, member, can_share, status) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(image_id)s, %(member)s, %(can_share)s, %
(status)s)'] [parameters: {'status': 'pending', 'deleted': 0, 'created_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201107), 'updated_at': datetime.datetime(2016, 5, 26
, 6, 53, 43, 201144), 'member': u'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', '
image_id': u'3174767b-7ccc-4691-a3ca-6884d04c0330', 'can_share': 0, 'deleted_at': None}]
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters context)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters result = self._query(query)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters conn.query(q)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters result.read()
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters packet.check_error()
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters _check_mysql_exception(errinfo)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errorvalue)
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters DataError: (1406, u"Data too long for column 'member' at row 1")
2016-05-26 12:23:43.201 TRACE oslo_db.sqlalchemy.exc_filters
2016-05-26 12:23:43.234 ERROR glance.common.wsgi [req-ca9b4266-b1a9-406a-9b77-6905ce3bf658 9448716ab50145dcbdb7d5653ecdc2dc 9f8383968a0a4d0bb303500cd5c49f51] Caught error: (pymysql.err.DataError) (1406, u"Data too long for column 'member' at row 1") [SQL: u'INSERT INTO image_members (created_at, updated_at, deleted_at, deleted, image_id, member, can_share, status) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(image_id)s, %(member)s, %(can_share)s, %(status)s)'] [parameters: {'status': 'pending', 'deleted': 0, 'created_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201107), 'updated_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201144), 'member': u'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'image_id': u'3174767b-7ccc-4691-a3ca-6884d04c0330', 'can_share': 0, 'deleted_at': None}]
2016-05-26 12:23:43.234 TRACE glance.common.wsgi Traceback (most recent call last):
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/common/wsgi.py", line 918, in __call__
2016-05-26 12:23:43.234 TRACE glance.common.wsgi request, **action_args)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/common/wsgi.py", line 957, in dispatch
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return method(*args, **kwargs)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/common/utils.py", line 362, in wrapped
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return func(self, req, *args, **kwargs)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/api/v2/image_members.py", line 116, in create
2016-05-26 12:23:43.234 TRACE glance.common.wsgi member_repo.add(new_member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/api/authorization.py", line 166, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self.member_repo.add(image_member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/notifier.py", line 520, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi super(ImageMemberRepoProxy, self).add(member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/domain/proxy.py", line 121, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self.base.add(self.member_proxy_helper.unproxy(member))
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/api/policy.py", line 241, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self.member_repo.add(member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/location.py", line 494, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi super(ImageMemberRepoProxy, self).add(member)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/domain/proxy.py", line 94, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi result = self.base.add(base_item)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/__init__.py", line 367, in add
2016-05-26 12:23:43.234 TRACE glance.common.wsgi image_member_values)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/sqlalchemy/api.py", line 1066, in image_member_create
2016-05-26 12:23:43.234 TRACE glance.common.wsgi _image_member_update(context, memb_ref, values, session=session)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/sqlalchemy/api.py", line 1098, in _image_member_update
2016-05-26 12:23:43.234 TRACE glance.common.wsgi memb_ref.save(session=session)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/opt/stack/glance/glance/db/sqlalchemy/models.py", line 72, in save
2016-05-26 12:23:43.234 TRACE glance.common.wsgi super(GlanceBase, self).save(session or db_api.get_session())
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/models.py", line 48, in save
2016-05-26 12:23:43.234 TRACE glance.common.wsgi session.flush()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self._flush(objects)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
2016-05-26 12:23:43.234 TRACE glance.common.wsgi transaction.rollback(_capture_exception=True)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-05-26 12:23:43.234 TRACE glance.common.wsgi compat.reraise(exc_type, exc_value, exc_tb)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
2016-05-26 12:23:43.234 TRACE glance.common.wsgi flush_context.execute()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi rec.execute(self)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi uow
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
2016-05-26 12:23:43.234 TRACE glance.common.wsgi mapper, table, insert)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
2016-05-26 12:23:43.234 TRACE glance.common.wsgi execute(statement, params)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return meth(self, multiparams, params)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2016-05-26 12:23:43.234 TRACE glance.common.wsgi return connection._execute_clauseelement(self, multiparams, params)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2016-05-26 12:23:43.234 TRACE glance.common.wsgi compiled_sql, distilled_params
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-05-26 12:23:43.234 TRACE glance.common.wsgi context)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-05-26 12:23:43.234 TRACE glance.common.wsgi util.raise_from_cause(newraise, exc_info)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-05-26 12:23:43.234 TRACE glance.common.wsgi reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-05-26 12:23:43.234 TRACE glance.common.wsgi context)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi cursor.execute(statement, parameters)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-05-26 12:23:43.234 TRACE glance.common.wsgi result = self._query(query)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-05-26 12:23:43.234 TRACE glance.common.wsgi conn.query(q)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-05-26 12:23:43.234 TRACE glance.common.wsgi self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-05-26 12:23:43.234 TRACE glance.common.wsgi result.read()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-05-26 12:23:43.234 TRACE glance.common.wsgi first_packet = self.connection._read_packet()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-05-26 12:23:43.234 TRACE glance.common.wsgi packet.check_error()
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-05-26 12:23:43.234 TRACE glance.common.wsgi err.raise_mysql_exception(self._data)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-05-26 12:23:43.234 TRACE glance.common.wsgi _check_mysql_exception(errinfo)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-05-26 12:23:43.234 TRACE glance.common.wsgi raise errorclass(errno, errorvalue)
2016-05-26 12:23:43.234 TRACE glance.common.wsgi DBError: (pymysql.err.DataError) (1406, u"Data too long for column 'member' at row 1") [SQL: u'INSERT INTO image_members (created_at, updated_at, deleted_at, deleted, image_id, member, can_share, status) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(image_id)s, %(member)s, %(can_share)s, %(status)s)'] [parameters: {'status': 'pending', 'deleted': 0, 'created_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201107), 'updated_at': datetime.datetime(2016, 5, 26, 6, 53, 43, 201144), 'member': u'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'image_id': u'3174767b-7ccc-4691-a3ca-6884d04c0330', 'can_share': 0, 'deleted_at': None}]
To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1585917/+subscriptions
