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
fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
fffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd',
'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'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd',
'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
fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
fffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd',
'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'2222222222222222222234244444444424444444444gdegddddddddddfgdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd',
'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
--
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
