{"body":"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:\nTraceback (most recent call last):\n\n  File \"/usr/local/lib/python2.7/dist-packages/wsmeext/pecan.py\", line 85, in callfunction\n    result = f(self, *args, **kwargs)\n\n  File \"/opt/stack/octavia/octavia/api/v2/controllers/pool.py\", line 146, in post\n    pool.loadbalancer_id)\n\n  File \"/opt/stack/octavia/octavia/api/v2/controllers/base.py\", line 103, in _get_lb_project_id\n    data_models.LoadBalancer, id)\n\n  File \"/opt/stack/octavia/octavia/api/v2/controllers/base.py\", line 62, in _get_db_obj\n    db_obj = repo.get(session, id=id)\n\n  File \"/opt/stack/octavia/octavia/db/repositories.py\", line 102, in get\n    model = session.query(self.model_class).filter_by(**filters).first()\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2659, in first\n    ret = list(self[0:1])\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2457, in __getitem__\n    return list(res)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2761, in __iter__\n    return self._execute_and_instances(context)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2776, in _execute_and_instances\n    result = conn.execute(querycontext.statement, self._params)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 914, in execute\n    return meth(self, multiparams, params)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py\", line 323, in _execute_on_connection\n    return connection._execute_clauseelement(self, multiparams, params)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1010, in _execute_clauseelement\n    compiled_sql, distilled_params\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1146, in _execute_context\n    context)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1337, in _handle_dbapi_exception\n    util.raise_from_cause(newraise, exc_info)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py\", line 203, in raise_from_cause\n    reraise(type(exception), exception, tb=exc_tb, cause=cause)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1139, in _execute_context\n    context)\n\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\", line 450, in do_execute\n    cursor.execute(statement, parameters)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py\", line 164, in execute\n    query = self.mogrify(query, args)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py\", line 143, in mogrify\n    query = query % self._escape_args(args, conn)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py\", line 123, in _escape_args\n    return dict((key, conn.literal(val)) for (key, val) in args.items())\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py\", line 123, in <genexpr>\n    return dict((key, conn.literal(val)) for (key, val) in args.items())\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/connections.py\", line 817, in literal\n    return self.escape(obj, self.encoders)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/connections.py\", line 810, in escape\n    return escape_item(obj, self.charset, mapping=mapping)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/converters.py\", line 27, in escape_item\n    val = encoder(val, mapping)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/converters.py\", line 110, in escape_unicode\n    return u\"'%s'\" % _escape_unicode(value)\n\n  File \"/usr/local/lib/python2.7/dist-packages/pymysql/converters.py\", line 73, in _escape_unicode\n    return value.translate(_escape_table)\n\nDBError: 'UnsetType' object has no attribute 'translate'\n\n172.21.21.135 - - [27/Mar/2017 15:13:49] \"POST /v2.0/lbaas/pools HTTP/1.1\" 500 4031\n","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/4zDSsVnG","modified":1490652860,"id":"4zDSsVnG","size":4095,"lines":84,"own_paste":false,"theme":"","date":1490652860}