Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema/ Tables Can't be refreshed #28

Open
puneethpotu opened this issue Apr 19, 2016 · 0 comments
Open

Schema/ Tables Can't be refreshed #28

puneethpotu opened this issue Apr 19, 2016 · 0 comments

Comments

@puneethpotu
Copy link

Hi I was able to start the redshift-console and i see that the data is being refreshed in queries tab, but for some reason there is no data in the schemas and loads tab, and when the process to refresh tables started i am seeing the below error on the console

[E 160419 13:38:09 ioloop:588] Exception in callback <functools.partial object at 0x7fb94bf15e68>
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/tornado/ioloop.py", line 568, in _run_callback
ret = callback()
File "/usr/local/lib/python2.7/dist-packages/tornado/stack_context.py", line 275, in null_wrapper
return fn(_args, *_kwargs)
File "/usr/local/lib/python2.7/dist-packages/tornado/ioloop.py", line 574, in
self.add_future(ret, lambda f: f.result())
File "/usr/local/lib/python2.7/dist-packages/tornado/concurrent.py", line 209, in result
raise_exc_info(self._exc_info)
File "/usr/local/lib/python2.7/dist-packages/tornado/gen.py", line 810, in run
yielded = self.gen.throw(_sys.exc_info())
File "/usr/local/lib/python2.7/dist-packages/redshift_console/redshift.py", line 105, in _refresh
yield self.refresh()
File "/usr/local/lib/python2.7/dist-packages/tornado/gen.py", line 807, in run
value = future.result()
File "/usr/local/lib/python2.7/dist-packages/tornado/concurrent.py", line 209, in result
raise_exc_info(self._exc_info)
File "/usr/local/lib/python2.7/dist-packages/tornado/gen.py", line 810, in run
yielded = self.gen.throw(_sys.exc_info())
File "/usr/local/lib/python2.7/dist-packages/redshift_console/redshift.py", line 273, in refresh
yield self._fetch_schema()
File "/usr/local/lib/python2.7/dist-packages/tornado/gen.py", line 807, in run
value = future.result()
File "/usr/local/lib/python2.7/dist-packages/tornado/concurrent.py", line 209, in result
raise_exc_info(self._exc_info)
File "/usr/local/lib/python2.7/dist-packages/tornado/gen.py", line 810, in run
yielded = self.gen.throw(*sys.exc_info())
File "/usr/local/lib/python2.7/dist-packages/redshift_console/redshift.py", line 289, in _fetch_schema
columns = yield self.execute_query(search_path_query + "SELECT * FROM pg_table_def WHERE schemaname NOT IN ('pg_catalog', 'pg_toast', 'information_schema');", namespaces)
File "/usr/local/lib/python2.7/dist-packages/tornado/gen.py", line 807, in run
value = future.result()
File "/usr/local/lib/python2.7/dist-packages/concurrent/futures/_base.py", line 400, in result
return self.__get_result()
File "/usr/local/lib/python2.7/dist-packages/concurrent/futures/_base.py", line 359, in __get_result
reraise(self._exception, self._traceback)
File "/usr/local/lib/python2.7/dist-packages/concurrent/futures/compat.py", line 107, in reraise
exec('raise exc_type, exc_value, traceback', {}, locals
)
File "/usr/local/lib/python2.7/dist-packages/concurrent/futures/thread.py", line 61, in run
result = self.fn(_self.args, *_self.kwargs)
File "/usr/local/lib/python2.7/dist-packages/redshift_console/redshift.py", line 119, in execute_query
cursor.execute(query, *args)
File "/usr/local/lib/python2.7/dist-packages/psycopg2/extras.py", line 223, in execute
return super(RealDictCursor, self).execute(query, vars)
ProgrammingError: Operation not allowed on schema "pg_internal"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant