2023-08-21 18:07:55.024 ERRORINFO - 1756679130478306304 : traceId:8d4cfb4f310497a7, sql执行错误，错误信息：deploy script error--traceId:8d4cfb4f310497a7 --isAll:false--DBRouteKey:iscb -- error:such column list already indexed

RequestContext: tenantId=dev-zxk, accountId=970282446551518208

TX: TXContext.7124:tag=noname, level=1, propagation=REQUIRES_NEW, rollback=false, halt=false, ended=false

SQL: IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ISC_MSG_NUM') CREATE INDEX IDX_ISC_MSG_NUM ON T_ISC_MSG_NOTIFICATION ( FNUMBER );

Parameters: [], 错误sql: IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ISC_MSG_NUM') CREATE INDEX IDX_ISC_MSG_NUM ON T_ISC_MSG_NOTIFICATION ( FNUMBER ); ，-- Stack:kd.bos.exception.KDException: such column list already indexed

RequestContext: tenantId=dev-zxk, accountId=970282446551518208

TX: TXContext.7124:tag=noname, level=1, propagation=REQUIRES_NEW, rollback=false, halt=false, ended=false

SQL: IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ISC_MSG_NUM') CREATE INDEX IDX_ISC_MSG_NUM ON T_ISC_MSG_NOTIFICATION ( FNUMBER );

Parameters: []

at kd.bos.exception.SecureExceptionUtil.wrapSQLException(SecureExceptionUtil.java:29)

at kd.bos.db.ExceptionWrapper.wrapSQLException(ExceptionWrapper.java:248)

at kd.bos.db.ExceptionWrapper.wrapperRethrowCause(ExceptionWrapper.java:131)

at kd.bos.db.ExceptionWrapper.wrapper(ExceptionWrapper.java:58)

at kd.bos.db.ExceptionWrapper.getLogCause(ExceptionWrapper.java:99)

at kd.bos.db.BaseDB.rethrow(BaseDB.java:600)

at kd.bos.db.DBImpl.executeBatch(DBImpl.java:495)

at kd.bos.db.DBImpl.executeBatch(DBImpl.java:101)

at kd.bos.db.DBImpl.execute(DBImpl.java:90)

at kd.bos.db.DB.execute(DB.java:294)

at kd.bos.service.upgrade.deploy.DeplayDataModelBase.deploySingleSql(DeplayDataModelBase.java:359)

at kd.bos.service.upgrade.deploy.DeplayDataModelBase.deployScript(DeplayDataModelBase.java:237)

at kd.bos.service.upgrade.deploy.DeplayDataModelBase.deployScript

产品问题达梦数据库升级时，集成云IDX_ISC_MSG_NUM，报such column list already indexe

产品问题 达梦数据库升级时，集成云IDX_ISC_MSG_NUM，报such column list already indexe

恭喜您！

产品问题
达梦数据库升级时，集成云IDX_ISC_MSG_NUM，报such column list already indexe

产品问题达梦数据库升级时，集成云IDX_ISC_MSG_NUM，报such column list already indexe