Wanglw6
commented
1 year ago - rm -rf /home/myapp/myapp/static/assets
- ln -s /home/myapp/myapp/assets /home/myapp/myapp/static/
- rm -rf /home/myapp/myapp/static/mnt
- ln -s /data/k8s/kubeflow/pipeline/workspace /home/myapp/myapp/static/mnt
- export FLASK_APP=myapp:app
- FLASK_APP=myapp:app
- python myapp/create_db.py
- myapp fab create-admin --username admin --firstname admin --lastname admin --email admin@tencent.com --password admin mysql+pymysql://root:admin@mysql-service.infra:3306/kubeflow?charset=utf8 Recognized Database Authentications. 2023-06-07 13:03:23,467:ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database. (pymysql.err.IntegrityError) (1062, "Duplicate entry 'admin' for key 'username'") [SQL: INSERT INTO ab_user (first_name, last_name, username, password, active, email, last_login, login_count, fail_login_count, created_on, changed_on, created_by_fk, changed_by_fk, org) VALUES (%(first_name)s, %(last_name)s, %(username)s, %(password)s, %(active)s, %(email)s, %(last_login)s, %(login_count)s, %(fail_login_count)s, %(created_on)s, %(changed_on)s, %(created_by_fk)s, %(changed_by_fk)s, %(org)s)] [parameters: {'first_name': 'admin', 'last_name': 'admin', 'username': 'admin', 'password': 'pbkdf2:sha256:150000$QSudoiE5$223ac777bcb552d3dd33f69030902d137bb1ea039bf1546dff1d7295229a199e', 'active': 1, 'email': 'admin@tencent.com', 'last_login': None, 'login_count': None, 'fail_login_count': None, 'created_on': datetime.datetime(2023, 6, 7, 13, 3, 22, 447272), 'changed_on': datetime.datetime(2023, 6, 7, 13, 3, 22, 447287), 'created_by_fk': None, 'changed_by_fk': None, 'org': None}] (Background on this error at: http://sqlalche.me/e/gkpj) No user created an error occured
- myapp db upgrade
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade 16f0ba32110a -> 444d4749dfa1, empty message
mysql+pymysql://root:admin@mysql-service.infra:3306/kubeflow?charset=utf8
Traceback (most recent call last):
File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1243, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/default.py", line 552, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.9/dist-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/usr/local/lib/python3.9/dist-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.9/dist-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.9/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1060, "Duplicate column name 'expand'")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/myapp/myapp/bin/myapp", line 14, in
cli() File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 829, in call return self.main(*args, kwargs) File "/usr/local/lib/python3.9/dist-packages/flask/cli.py", line 586, in main return super(FlaskGroup, self).main(args, kwargs) File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 782, in main rv = self.invoke(ctx) File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 1259, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 1066, in invoke return ctx.invoke(self.callback, ctx.params) File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 610, in invoke return callback(args, kwargs) File "/usr/local/lib/python3.9/dist-packages/click/decorators.py", line 21, in new_func return f(get_current_context(), *args, kwargs) File "/usr/local/lib/python3.9/dist-packages/flask/cli.py", line 426, in decorator return __ctx.invoke(f, *args, *kwargs) File "/usr/local/lib/python3.9/dist-packages/click/core.py", line 610, in invoke return callback(args, kwargs) File "/usr/local/lib/python3.9/dist-packages/flask_migrate/cli.py", line 134, in upgrade _upgrade(directory, revision, sql, tag, x_arg) File "/usr/local/lib/python3.9/dist-packages/flask_migrate/init.py", line 95, in wrapped f(*args, kwargs) File "/usr/local/lib/python3.9/dist-packages/flask_migrate/init.py", line 280, in upgrade command.upgrade(config, revision, sql=sql, tag=tag) File "/usr/local/lib/python3.9/dist-packages/alembic/command.py", line 276, in upgrade script.run_env() File "/usr/local/lib/python3.9/dist-packages/alembic/script/base.py", line 475, in run_env util.load_python_file(self.dir, "env.py") File "/usr/local/lib/python3.9/dist-packages/alembic/util/pyfiles.py", line 90, in load_python_file module = load_module_py(module_id, path) File "/usr/local/lib/python3.9/dist-packages/alembic/util/compat.py", line 177, in load_module_py spec.loader.exec_module(module) File " ", line 850, in exec_module File " kw) File "/usr/local/lib/python3.9/dist-packages/alembic/runtime/migration.py", line 362, in run_migrations step.migrationfn(**kw) File "/home/myapp/myapp/migrations/versions/444d4749dfa1.py", line 21, in upgrade op.add_column('docker', sa.Column('expand', sa.Text(length=65536), nullable=True)) File "", line 228, in _call_with_frames_removed File "/home/myapp/myapp/migrations/env.py", line 96, in run_migrations_online() File "/home/myapp/myapp/migrations/env.py", line 90, in run_migrations_online context.run_migrations() File " ", line 8, in run_migrations File "/usr/local/lib/python3.9/dist-packages/alembic/runtime/environment.py", line 839, in run_migrations self.get_context().run_migrations( ", line 8, in add_column File " ", line 3, in add_column File "/usr/local/lib/python3.9/dist-packages/alembic/operations/ops.py", line 1904, in add_column return operations.invoke(op) File "/usr/local/lib/python3.9/dist-packages/alembic/operations/base.py", line 345, in invoke return fn(self, operation) File "/usr/local/lib/python3.9/dist-packages/alembic/operations/toimpl.py", line 131, in add_column operations.impl.add_column(table_name, column, schema=schema) File "/usr/local/lib/python3.9/dist-packages/alembic/ddl/impl.py", line 231, in add_column self._exec(base.AddColumn(table_name, column, schema=schema)) File "/usr/local/lib/python3.9/dist-packages/alembic/ddl/impl.py", line 134, in _exec return conn.execute(construct, *multiparams, **params) File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection return connection._execute_ddl(self, multiparams, params) File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1045, in _execute_ddl ret = self._execute_context( File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise raise value.with_traceback(tb) File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/base.py", line 1243, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/dist-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.9/dist-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/usr/local/lib/python3.9/dist-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/usr/local/lib/python3.9/dist-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/usr/local/lib/python3.9/dist-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.9/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1060, "Duplicate column name 'expand'") [SQL: ALTER TABLE docker ADD COLUMN expand TEXT(65536)] (Background on this error at: http://sqlalche.me/e/e3q8)
gxin0426