Mycat报错

 2021-11-08 17:13:01,310 [ERROR][Thread-1] MyCATSequenceProcessor.executeSeq(SesionSQLPair) java.lang.RuntimeException: can't fetch sequnce in db,sequnce :CN_TASK_LOCKSET detail:null
        at io.mycat.route.sequence.handler.IncrSequenceMySQLHandler.getSeqValueFromDB(IncrSequenceMySQLHandler.java:125)
        at io.mycat.route.sequence.handler.IncrSequenceMySQLHandler.nextId(IncrSequenceMySQLHandler.java:94)
        at io.mycat.route.parser.druid.DruidSequenceHandler.getExecuteSql(DruidSequenceHandler.java:64)
        at io.mycat.route.MyCATSequnceProcessor.executeSeq(MyCATSequnceProcessor.java:85)
        at io.mycat.route.MyCATSequnceProcessor.access$200(MyCATSequnceProcessor.java:19)
        at io.mycat.route.MyCATSequnceProcessor$ExecuteThread.run(MyCATSequnceProcessor.java:110)
 (io.mycat.route.MyCATSequnceProcessor:MyCATSequnceProcessor.java:89)

java.lang.RuntimeException: can't fetch sequnce in db,sequnce : detail:null
 mycat sequnce err.java.lang.RuntimeException: can't fetch sequnce in db,sequnce : detail:null

2021-11-08 17:15:38,328 [ERROR][Thread-1] MyCATSequenceProcessor.executeSeq(SesionSQLPair) java.lang.RuntimeException: can't fetch sequnce in db,sequnce :CN_TASK_LOCKSET detail:null
        at io.mycat.route.sequence.handler.IncrSequenceMySQLHandler.getSeqValueFromDB(IncrSequenceMySQLHandler.java:125)

网上各种解释都有，配置文件，函数等的问题

经过测试发现，还有一种问题，就是mysql的版本也会产生上述问题，使用mysql8，可能会产生上述问题，本人使用mysql5解决问题

Mycat新增数据报错can't fetch sequnce in db,sequnce

Mycat报错

推荐阅读