Hi, I tried to run a migration job on kubernetes, ...
# deployment-kubernetes
j
Hi, I tried to run a migration job on kubernetes, and it yielded this error and it was unable to create asset_event_logs. Can anyone help with this?
Copy code
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2130, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1906, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for table event_logs

[SQL: 
CREATE TABLE asset_event_tags (
	id BIGSERIAL NOT NULL, 
	event_id INTEGER, 
	asset_key TEXT NOT NULL, 
	key TEXT NOT NULL, 
	value TEXT, 
	event_timestamp TIMESTAMP WITHOUT TIME ZONE, 
	PRIMARY KEY (id), 
	FOREIGN KEY(event_id) REFERENCES event_logs (id) ON DELETE CASCADE
)

]
(Background on this error at: <https://sqlalche.me/e/14/f405>)
do I even need this?
a
Copy code
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for table event_logs
Looks like a permission error?
j
yeah, I got that but I have used that user to create every other table
I was looking for the asset_event_tags table in the code and couldn't find any reference