【 使用环境 】测试环境
【 OB or 其他组件 】OMS
【 使用版本 】 feature_4.2.4_ce
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):
ERROR 1054 (42S22) at line 50: Unknown column ‘oms.g1.small’ in ‘field list’
ERROR 1054 (42S22) at line 56: Unknown column ‘u00001’ in ‘field list’
ERROR 1054 (42S22) at line 58: Unknown column ‘u00002’ in ‘field list’
ERROR 1054 (42S22) at line 64: Unknown column ‘u00000’ in ‘field list’
ERROR 1054 (42S22) at line 322: Unknown column ‘u00002’ in ‘field list’
2024-07-08 14:53:01,563-Oms-DEBUG oms_init_manager.init_rm.724 :REPLACE INTO user
(id
, name
, password
, type
, linkman
, linkman_cn
, reason
, product
, gmt_modify
) VALUES(1, ‘RM_oms’, ‘MjAyNC0wNy0wOA==’, 3, ‘oms’, ‘oms’, ‘oms’, ‘oms’, now());
query {‘charset’: ‘utf8’} {‘username’: ‘root’, ‘database’: ‘oms_cm’, ‘host’: ‘192.168.3.155’, ‘password_original’: ‘XXXXXX’, ‘drivername’: ‘mysql+pymysql’, ‘query’: {‘charset’: ‘utf8’}, ‘port’: 3306}
2024-07-08 14:53:01,925-Oms-DEBUG units.create_engine_wrapper.70 :create a new sqlalchemy engine wrapped Engine(mysql+pymysql://root:***@192.168.3.155:3306/oms_cm?charset=utf8)
drc_cm_schema
2024-07-08 14:53:01,936-Oms-DEBUG oms_init_manager._import_sql_file_by_engine.98 :Engine(mysql+pymysql://root:***@192.168.3.155:3306/oms_cm?charset=utf8)
import /root/omsflow/meta_init/drc_cm_schema.sql
mysql -h’192.168.3.155’ -P3306 -u ‘root’ --password=‘XXXXXX’ -f -D ‘oms_cm’ < /root/omsflow/meta_init/drc_cm_schema.sql
ERROR 1071 (42000) at line 1595: Specified key was too long; max key length is 3072 bytes
ERROR 1071 (42000) at line 1662: Specified key was too long; max key length is 3072 bytes
drc_cm_data
2024-07-08 14:55:16,620-Oms-DEBUG oms_init_manager._import_sql_file_by_engine.98 :Engine(mysql+pymysql://root:***@192.168.3.155:3306/oms_cm?charset=utf8)
import /root/omsflow/meta_init/drc_cm_data.sql
mysql -h’192.168.3.155’ -P3306 -u ‘root’ --password=‘XXXXXX’ -f -D ‘oms_cm’ < /root/omsflow/meta_init/drc_cm_data.sql
ERROR 1054 (42S22) at line 269: Unknown column ‘cluster_user’ in ‘where clause’
ERROR 1054 (42S22) at line 270: Unknown column ‘cluster_password’ in ‘where clause’