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

failed to register first user after fresh install #1467

Open
Talhashahar opened this issue Jun 24, 2024 · 0 comments
Open

failed to register first user after fresh install #1467

Talhashahar opened this issue Jun 24, 2024 · 0 comments

Comments

@Talhashahar
Copy link

use helm chart to install on our eks cluster.
when i tried to register the first user i got this error:
(pymysql.err.OperationalError) (1054, "Unknown column 'is_group' in 'field list'") [SQL: INSERT INTO user (username, fullname, password, email, profile_img, deleted, is_group, properties) VALUES (%(username)s, %(fullname)s, %(password)s, %(email)s, %(profile_img)s, %(deleted)s, %(is_group)s, %(properties)s)] [parameters: {'username': 'asdasd', 'fullname': None, 'password': 'pbkdf2:sha256:260000$3ax2CgjzsiSThKSy$000ec3efef1eed67cc8605fd153e8c221da4bc0bd252dc66a1765e339382a32b', 'email': '[email protected]', 'profile_img': None, 'deleted': 0, 'is_group': 0, 'properties': '{}'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)

tried to apply the db migration with follow command
cd querybook PYTHONPATH=server alembic upgrade head

and got this error:
`root@worker-ccd96cd4f-bng7g:/opt/querybook/querybook# PYTHONPATH=server alembic upgrade head
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade 17f7c039ab6e -> f449a73c5838, add boardEditor and board as board item
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/usr/local/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1553, "Cannot drop index 'board_item_ibfk_1': needed in a foreign key constraint")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/local/bin/alembic", line 8, in
sys.exit(main())
File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 590, in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 584, in main
self.run_cmd(cfg, options)
File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 561, in run_cmd
fn(
File "/usr/local/lib/python3.9/site-packages/alembic/command.py", line 322, in upgrade
script.run_env()
File "/usr/local/lib/python3.9/site-packages/alembic/script/base.py", line 569, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "", line 850, in exec_module
File "", line 228, in _call_with_frames_removed
File "migrations/env.py", line 76, in
run_migrations_online()
File "migrations/env.py", line 70, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "/usr/local/lib/python3.9/site-packages/alembic/runtime/environment.py", line 853, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/lib/python3.9/site-packages/alembic/runtime/migration.py", line 623, in run_migrations
step.migration_fn(**kw)
File "/opt/querybook/querybook/migrations/versions/f449a73c5838_add_boardeditors_board_as_board_item.py", line 21, in upgrade
op.alter_column(
File "", line 8, in alter_column
File "", line 3, in alter_column
File "/usr/local/lib/python3.9/site-packages/alembic/operations/ops.py", line 1880, in alter_column
return operations.invoke(alt)
File "/usr/local/lib/python3.9/site-packages/alembic/operations/base.py", line 399, in invoke
return fn(self, operation)
File "/usr/local/lib/python3.9/site-packages/alembic/operations/toimpl.py", line 50, in alter_column
operations.impl.alter_column(
File "/usr/local/lib/python3.9/site-packages/alembic/ddl/mysql.py", line 89, in alter_column
self._exec(
File "/usr/local/lib/python3.9/site-packages/alembic/ddl/impl.py", line 195, in _exec
return conn.execute(construct, multiparams)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1306, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
return connection._execute_ddl(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1398, in _execute_ddl
ret = self._execute_context(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self.handle_dbapi_exception(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in handle_dbapi_exception
util.raise
(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise

raise exception
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/usr/local/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1553, "Cannot drop index 'board_item_ibfk_1': needed in a foreign key constraint")
[SQL: ALTER TABLE board_item CHANGE board_id parent_board_id INTEGER NOT NULL]
(Background on this error at: https://sqlalche.me/e/14/e3q8)`

i ran the db migration on a fresh install.

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