Exception: ERROR: permission denied for table show
Tian Isaac
I installed cuebot and postgres in container, When I try to execute those commands: >>> import opencue >>> import outline >>> [show.name() for show in opencue.api.getShows()] I got those error: Traceback (most recent call last):File "<stdin>", line 1, in <module> File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/pycue-0.2.31-py2.7.egg/opencue/util.py", line 59, in _decorator "Server caught an internal exception. {}".format(details))) File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/pycue-0.2.31-py2.7.egg/opencue/util.py", line 44, in _decorator return grpcFunc(*args, **kwargs) File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/pycue-0.2.31-py2.7.egg/opencue/api.py", line 191, in getShows show_pb2.ShowGetShowsRequest(), timeout=Cuebot.Timeout).shows File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/grpc/_channel.py", line 533, in __call__ return _end_unary_response_blocking(state, call, False, None) File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/grpc/_channel.py", line 467, in _end_unary_response_blocking raise _Rendezvous(state, None, None, deadline) opencue.exception.CueInternalErrorException: Server caught an internal exception. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT show.*,COALESCE(vs_show_stat.int_pending_count,0) AS int_pending_count,COALESCE(vs_show_stat.int_running_count,0) AS int_running_count,COALESCE(vs_show_stat.int_dead_count,0) AS int_dead_count,COALESCE(vs_show_resource.int_cores,0) AS int_cores, COALESCE(vs_show_stat.int_job_count,0) AS int_job_count FROM show LEFT JOIN vs_show_stat ON (vs_show_stat.pk_show = show.pk_show) LEFT JOIN vs_show_resource ON (vs_show_resource.pk_show=show.pk_show) WHERE 1 = 1 ]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for table show StatementCallback; bad SQL grammar [SELECT show.*,COALESCE(vs_show_stat.int_pending_count,0) AS int_pending_count,COALESCE(vs_show_stat.int_running_count,0) AS int_running_count,COALESCE(vs_show_stat.int_dead_count,0) AS int_dead_count,COALESCE(vs_show_resource.int_cores,0) AS int_cores, COALESCE(vs_show_stat.int_job_count,0) AS int_job_count FROM show LEFT JOIN vs_show_stat ON (vs_show_stat.pk_show = show.pk_show) LEFT JOIN vs_show_resource ON (vs_show_resource.pk_show=show.pk_show) WHERE 1 = 1 ]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for table show But when l try to run those SQL commands at the host machine directly, that works fine. Does anybody have any clues? |
|