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?

Join {main@lists.aswf.io to automatically receive all group messages.