docker启动报mysql字段缺失

# 使用环境

> ↓↓ 请填写您的使用环境 ↓↓

- Torna版本：1.33.0
- Java版本：1.8
- MySQL版本：5.7
- 浏览器：Chrome/Edge

# 描述

> 提需求请写明需求的使用场景

启动命令：

```
docker run --name torna --restart=always \
  -p 7700:7700 \
  -e JAVA_OPTS="-server -Xms512m -Xmx512m" \
  -v /etc/torna/application.properties:/torna/config/application.properties \
  -d registry.cn-hangzhou.aliyuncs.com/tanghc/torna:1.33.0
```

`mysql初始化脚本：https://gitee.com/durcframework/torna/blob/v1.33.0/mysql.sql`

报错信息：

```
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column 't.mfa_sk' in 'field list'
### The error may exist in InputStream resource [UserInfoMapper.xml]
### The error may involve cn.torna.dao.mapper.UserInfoMapper.list-Inline
### The error occurred while setting parameters
### SQL: SELECT                              t.`id` , t.`username` , t.`password` , t.`nickname` , t.`is_super_admin` , t.`source` , t.`email` , t.`status` , t.`is_deleted` , t.`gmt_create` , t.`gmt_modified` , t.`mfa_sk`                             FROM `user_info` t                                    WHERE                  username                 =                 ?                                                                                                                     AND t.`is_deleted` = 0                                                            LIMIT ?,?
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't.mfa_sk' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't.mfa_sk' in 'field list'
�       at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.22.jar!/:5.3.22]
�       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.22.jar!/:5.3.22]
�       at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.7.jar!/:2.0.7]
�       at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.7.jar!/:2.0.7]
        at com.sun.proxy.$Proxy82.selectList(Unknown Source) ~[na:na]
        at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.7.jar!/:2.0.7]
        at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.16.jar!/:3.5.16]
        at com.sun.proxy.$Proxy89.list(Unknown Source) ~[na:na]
        at com.gitee.fastmybatis.core.mapper.SearchMapper.get(SearchMapper.java:94) ~[fastmybatis-core-3.0.10.jar!/:na]
        at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) ~[na:1.8.0_212]
        at org.apache.ibatis.binding.MapperProxy$DefaultMethodInvoker.invoke(MapperProxy.java:154) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.16.jar!/:3.5.16]
        at com.sun.proxy.$Proxy89.get(Unknown Source) ~[na:na]
        at com.gitee.fastmybatis.core.mapper.SearchMapper.get(SearchMapper.java:316) ~[fastmybatis-core-3.0.10.jar!/:na]
        at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) ~[na:1.8.0_212]
        at org.apache.ibatis.binding.MapperProxy$DefaultMethodInvoker.invoke(MapperProxy.java:154) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.16.jar!/:3.5.16]
        at com.sun.proxy.$Proxy89.get(Unknown Source) ~[na:na]
        at com.gitee.fastmybatis.core.mapper.LambdaSearchMapper.get(LambdaSearchMapper.java:48) ~[fastmybatis-core-3.0.10.jar!/:na]
        at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) ~[na:1.8.0_212]
        at org.apache.ibatis.binding.MapperProxy$DefaultMethodInvoker.invoke(MapperProxy.java:154) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.16.jar!/:3.5.16]
        at com.sun.proxy.$Proxy89.get(Unknown Source) ~[na:na]
        at com.gitee.fastmybatis.core.support.LambdaService.lambda$get$43(LambdaService.java:973) ~[fastmybatis-core-3.0.10.jar!/:na]
        at com.gitee.fastmybatis.core.ext.MapperRunner.run(MapperRunner.java:33) ~[fastmybatis-core-3.0.10.jar!/:na]
        ... 21 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 't.mfa_sk' in 'field list'
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
�       at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
�       at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
�       at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-4.0.3.jar!/:na]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar!/:na]
�       at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.16.jar!/:3.5.16]
�       at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.16.jar!/:3.5.16]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.16.jar!/:3.5.16]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_212]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_212]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_212]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212]
�       at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7]
        ... 45 common frames omitted

```

我也发现这个问题了，用1.30.0的数据库的情况下启动1.33.0的镜像就报这个错。
然后我将镜像版本降级切到1.32.1可以成功启动，然后再切回1.33.0居然成功启动了，然后打开`user_info`表查看字段增加了`mfa_sk`字段，神奇。
目前解决办法是将`user_info`的ddl增加mfa_sk字段即可。整个user_info的ddl如下：

```
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
                             `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                             `username` varchar(128) NOT NULL DEFAULT '' COMMENT '登录账号/邮箱',
                             `password` varchar(128) NOT NULL DEFAULT '' COMMENT '登录密码',
                             `nickname` varchar(64) NOT NULL DEFAULT '' COMMENT '昵称',
                             `is_super_admin` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否是超级管理员',
                             `source` varchar(64) NOT NULL DEFAULT 'register',
                             `email` varchar(128) NOT NULL DEFAULT '',
                             `mfa_sk` varchar(128) NOT NULL DEFAULT '' COMMENT '多因素认证密钥',
                             `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0：禁用，1：启用，2：重设密码',
                             `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
                             `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
                             `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                             PRIMARY KEY (`id`) USING BTREE,
                             UNIQUE KEY `uk_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户表';
```

tanghc/torna

内容风险标识

评论 (2)

tanghc/torna .gitee-modal { width: 500px !important; }

内容风险标识