Version7アップグレードのエラーについて

#1

redashをv7にアップグレードした所、userのページが開けなくなりました。

コマンドでユーザーの追加をしようとしても出来ません。

エラーログは下記です。

Traceback (most recent call last):
File “/opt/redash/current/manage.py”, line 9, in
manager()
File “/usr/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/lib/python2.7/site-packages/flask/cli.py”, line 345, in main
return AppGroup.main(self, *args, **kwargs)
File “/usr/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/usr/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/usr/lib/python2.7/site-packages/flask/cli.py”, line 229, in decorator
return __ctx.invoke(f, *args, **kwargs)
File “/usr/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/opt/redash/redash.7.0.0.b17535/redash/cli/users.py”, line 244, in list
for i, user in enumerate(users.order_by(models.User.name)):
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py”, line 2995, in iter
return self._execute_and_instances(context)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py”, line 3016, in _execute_and_instances
close_with_result=True)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py”, line 3025, in _get_bind_args
**kw
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py”, line 3007, in _connection_from_session
conn = self.session.connection(**kw)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 1035, in connection
execution_options=execution_options)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 1040, in _connection_for_bind
engine, execution_options)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 409, in _connection_for_bind
conn = bind.contextual_connect()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2123, in contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2162, in _wrap_pool_connect
e, dialect, self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1476, in _handle_dbapi_exception_noconnection
exc_info
File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py”, line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2158, in _wrap_pool_connect
return fn()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 400, in connect
return _ConnectionFairy._checkout(self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 788, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 529, in checkout
rec = pool._do_get()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 1193, in _do_get
self._dec_overflow()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py”, line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 1190, in _do_get
return self._create_connection()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 347, in _create_connection
return _ConnectionRecord(self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 474, in init
self.__connect(first_connect_check=True)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py”, line 671, in __connect
connection = pool._invoke_creator(self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py”, line 106, in connect
return dialect.connect(*cargs, **cparams)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py”, line 412, in connect
return self.dbapi.connect(*cargs, **cparams)
File “/usr/lib64/python2.7/site-packages/psycopg2/init.py”, line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError

0 Likes

#2

docker版とお見受けしましたがAPIコールではいかがでしょうか?

$ curl -XPOST -H 'Authorization: <API KEY>' -d '{"name":"something","email":"something@some.thing"}' http://localhost:5000/api/users
0 Likes