Database connectivity

[attahkhan016]

ERROR: Traceback (most recent call last):
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/caravel/views.py", line 1029, in testconn
engine.connect()
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
return self._connection_cls(self, **kwargs)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in init
if connection is not None else engine.raw_connection()
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
self.pool.unique_connection, _connection)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
return fn()
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
return _ConnectionFairy._checkout(self)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
rec = pool._do_get()
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
self._dec_overflow()
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
return self._create_connection()
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
return _ConnectionRecord(self)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/pool.py", line 454, in init
exec_once(self.connection, self)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 246, in exec_once
self(_args, *_kw)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in call
fn(_args, *_kw)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 1319, in go
return once_fn(_arg, *_kw)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 165, in first_connect
dialect.initialize(c)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2642, in initialize
self._detect_ansiquotes(connection)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2909, in _detect_ansiquotes
connection.execute("SHOW VARIABLES LIKE 'sql_mode'"),
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 906, in execute
return self._execute_text(object, multiparams, params)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1054, in _execute_text
statement, parameters
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'performance_schema.session_variables' doesn't exist") [SQL: "SHOW VARIABLES LIKE 'sql_mode'"]

[xrmx]

Google suggests this:
http://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist

[bkyryliuk]

Looks like it's mysql / connector bug. @attahkhan016 feel free to reopen if you feel that it's an issue in caravel.