tooptoop4 opened a new issue #9878:
URL: https://github.com/apache/incubator-superset/issues/9878


   brand new mysql db
   
   ```
   /usr/local/bin/superset db upgrade
   logging was configured successfully
   INFO:superset.utils.logging_configurator:logging was configured successfully
   /usr/local/lib64/python3.6/site-packages/flask_caching/__init__.py:189: 
UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively 
disabled.
     "Flask-Caching: CACHE_TYPE is set to null, "
   INFO  [alembic.runtime.migration] Context impl MySQLImpl.
   INFO  [alembic.runtime.migration] Will assume transactional DDL.
   INFO  [alembic.runtime.migration] Running upgrade  -> 4e6a06bad7a8, Init
   INFO  [alembic.runtime.migration] Running upgrade 4e6a06bad7a8 -> 
5a7bad26f2a7, empty message
   INFO  [alembic.runtime.migration] Running upgrade 5a7bad26f2a7 -> 
1e2841a4128, empty message
   INFO  [alembic.runtime.migration] Running upgrade 1e2841a4128 -> 
2929af7925ed, TZ offsets in data sources
   INFO  [alembic.runtime.migration] Running upgrade 2929af7925ed -> 
289ce07647b, Add encrypted password field
   Traceback (most recent call last):
     File "/usr/local/bin/superset", line 21, in <module>
       superset()
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 829, in 
__call__
       return self.main(*args, **kwargs)
     File "/usr/local/lib64/python3.6/site-packages/flask/cli.py", line 586, in 
main
       return super(FlaskGroup, self).main(*args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 782, in 
main
       rv = self.invoke(ctx)
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1259, in 
invoke
       return _process_result(sub_ctx.command.invoke(sub_ctx))
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1259, in 
invoke
       return _process_result(sub_ctx.command.invoke(sub_ctx))
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1066, in 
invoke
       return ctx.invoke(self.callback, **ctx.params)
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 610, in 
invoke
       return callback(*args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/click/decorators.py", line 
21, in new_func
       return f(get_current_context(), *args, **kwargs)
     File "/usr/local/lib64/python3.6/site-packages/flask/cli.py", line 426, in 
decorator
       return __ctx.invoke(f, *args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/click/core.py", line 610, in 
invoke
       return callback(*args, **kwargs)
     File "/usr/local/lib64/python3.6/site-packages/flask_migrate/cli.py", line 
134, in upgrade
       _upgrade(directory, revision, sql, tag, x_arg)
     File "/usr/local/lib64/python3.6/site-packages/flask_migrate/__init__.py", 
line 96, in wrapped
       f(*args, **kwargs)
     File "/usr/local/lib64/python3.6/site-packages/flask_migrate/__init__.py", 
line 271, in upgrade
       command.upgrade(config, revision, sql=sql, tag=tag)
     File "/usr/local/lib/python3.6/site-packages/alembic/command.py", line 
298, in upgrade
       script.run_env()
     File "/usr/local/lib/python3.6/site-packages/alembic/script/base.py", line 
489, in run_env
       util.load_python_file(self.dir, "env.py")
     File "/usr/local/lib/python3.6/site-packages/alembic/util/pyfiles.py", 
line 98, in load_python_file
       module = load_module_py(module_id, path)
     File "/usr/local/lib/python3.6/site-packages/alembic/util/compat.py", line 
184, in load_module_py
       spec.loader.exec_module(module)
     File "<frozen importlib._bootstrap_external>", line 678, in exec_module
     File "<frozen importlib._bootstrap>", line 219, in 
_call_with_frames_removed
     File "/usr/local/lib/python3.6/site-packages/superset/migrations/env.py", 
line 115, in <module>
       run_migrations_online()
     File "/usr/local/lib/python3.6/site-packages/superset/migrations/env.py", 
line 107, in run_migrations_online
       context.run_migrations()
     File "<string>", line 8, in run_migrations
     File 
"/usr/local/lib/python3.6/site-packages/alembic/runtime/environment.py", line 
846, in run_migrations
       self.get_context().run_migrations(**kw)
     File 
"/usr/local/lib/python3.6/site-packages/alembic/runtime/migration.py", line 
520, in run_migrations
       step.migration_fn(**kw)
     File 
"/usr/local/lib/python3.6/site-packages/superset/migrations/versions/289ce07647b_add_encrypted_password_field.py",
 line 36, in upgrade
       "dbs", sa.Column("password", EncryptedType(sa.String(1024)), 
nullable=True)
     File "<string>", line 8, in add_column
     File "<string>", line 3, in add_column
     File "/usr/local/lib/python3.6/site-packages/alembic/operations/ops.py", 
line 1929, in add_column
       return operations.invoke(op)
     File "/usr/local/lib/python3.6/site-packages/alembic/operations/base.py", 
line 374, in invoke
       return fn(self, operation)
     File 
"/usr/local/lib/python3.6/site-packages/alembic/operations/toimpl.py", line 
132, in add_column
       operations.impl.add_column(table_name, column, schema=schema, **kw)
     File "/usr/local/lib/python3.6/site-packages/alembic/ddl/impl.py", line 
237, in add_column
       self._exec(base.AddColumn(table_name, column, schema=schema))
     File "/usr/local/lib/python3.6/site-packages/alembic/ddl/impl.py", line 
140, in _exec
       return conn.execute(construct, *multiparams, **params)
     File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", 
line 1020, in execute
       return meth(self, multiparams, params)
     File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/ddl.py", 
line 72, in _execute_on_connection
       return connection._execute_ddl(self, multiparams, params)
     File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", 
line 1075, in _execute_ddl
       else None,
     File "<string>", line 1, in <lambda>
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py", line 
476, in compile
       return self._compiler(dialect, bind=bind, **kw)
     File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/ddl.py", 
line 29, in _compiler
       return dialect.ddl_compiler(dialect, self, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/compiler.py", line 
319, in __init__
       self.string = self.process(self.statement, **compile_kwargs)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/compiler.py", line 
350, in process
       return obj._compiler_dispatch(self, **kwargs)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/ext/compiler.py", line 
441, in <lambda>
       lambda *arg, **kw: existing(*arg, **kw),
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/ext/compiler.py", line 
486, in __call__
       return fn(element, compiler, **kw)
     File "/usr/local/lib/python3.6/site-packages/alembic/ddl/base.py", line 
116, in visit_add_column
       add_column(compiler, element.column, **kw),
     File "/usr/local/lib/python3.6/site-packages/alembic/ddl/base.py", line 
219, in add_column
       text = "ADD COLUMN %s" % compiler.get_column_specification(column, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py", 
line 1588, in get_column_specification
       column.type, type_expression=column
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/compiler.py", line 
400, in process
       return type_._compiler_dispatch(self, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/visitors.py", line 95, 
in _compiler_dispatch
       return meth(self, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/compiler.py", line 
3440, in visit_type_decorator
       return self.process(type_.type_engine(self.dialect), **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/compiler.py", line 
400, in process
       return type_._compiler_dispatch(self, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/visitors.py", line 95, 
in _compiler_dispatch
       return meth(self, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/sql/compiler.py", line 
3418, in visit_string
       return self.visit_VARCHAR(type_, **kw)
     File 
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py", 
line 2061, in visit_VARCHAR
       "VARCHAR requires a length on dialect %s" % self.dialect.name
   sqlalchemy.exc.CompileError: VARCHAR requires a length on dialect mysql
   
   
   
   
   mysql> SHOW TABLE STATUS WHERE Name = 'dbs'
       -> ;
   
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+
   | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length 
| Max_data_length | Index_length | Data_free | Auto_increment | Create_time     
    | Update_time | Check_time | Collation         | Checksum | Create_options 
| Comment |
   
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+
   | dbs  | InnoDB |      10 | Dynamic    |    0 |              0 |       16384 
|               0 |        65536 |         0 |              1 | 2020-05-21 
19:12:29 | NULL        | NULL       | latin1_swedish_ci |     NULL |            
    |         |
   
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+
   1 row in set (0.00 sec)
   
   
   mysql 5.7.26
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org

Reply via email to