# Pastebin 4zDSsVnG 2017-03-27 15:13:49.582 105878 ERROR wsme.api [req-40e3ad68-8fce-4257-9fda-c5bddfeb4d2b - 59f6173974d54e57b92a4d4ca5523844 - default default] Server-side error: "'UnsetType' object has no attribute 'translate'". Detail: Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/wsmeext/pecan.py", line 85, in callfunction result = f(self, *args, **kwargs) File "/opt/stack/octavia/octavia/api/v2/controllers/pool.py", line 146, in post pool.loadbalancer_id) File "/opt/stack/octavia/octavia/api/v2/controllers/base.py", line 103, in _get_lb_project_id data_models.LoadBalancer, id) File "/opt/stack/octavia/octavia/api/v2/controllers/base.py", line 62, in _get_db_obj db_obj = repo.get(session, id=id) File "/opt/stack/octavia/octavia/db/repositories.py", line 102, in get model = session.query(self.model_class).filter_by(**filters).first() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2659, in first ret = list(self[0:1]) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2457, in __getitem__ return list(res) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2761, in __iter__ return self._execute_and_instances(context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2776, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception util.raise_from_cause(newraise, exc_info) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 164, in execute query = self.mogrify(query, args) File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 143, in mogrify query = query % self._escape_args(args, conn) File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 123, in _escape_args return dict((key, conn.literal(val)) for (key, val) in args.items()) File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 123, in return dict((key, conn.literal(val)) for (key, val) in args.items()) File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 817, in literal return self.escape(obj, self.encoders) File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 810, in escape return escape_item(obj, self.charset, mapping=mapping) File "/usr/local/lib/python2.7/dist-packages/pymysql/converters.py", line 27, in escape_item val = encoder(val, mapping) File "/usr/local/lib/python2.7/dist-packages/pymysql/converters.py", line 110, in escape_unicode return u"'%s'" % _escape_unicode(value) File "/usr/local/lib/python2.7/dist-packages/pymysql/converters.py", line 73, in _escape_unicode return value.translate(_escape_table) DBError: 'UnsetType' object has no attribute 'translate' 172.21.21.135 - - [27/Mar/2017 15:13:49] "POST /v2.0/lbaas/pools HTTP/1.1" 500 4031