巨杉数据库—错误码40006，Failed to begin transaction, RR is isolation is only supported when mvccon is true.

 

巨杉数据库，新建一个数据库，往一个新建的表里插入数据，提示上述错误：错误码40006，Failed to begin transaction, RR is isolation is only supported when mvccon is true.

解决办法：

修改配置文件auto.conf，往配置文件中添加transaction_isolation=read-committed

具体操作：

找到auto.conf文件所在目录/opt/sequoiasql/mysql/database/3306

 

修改auto.conf

vim auto.cnf

在文件末尾添加transaction_isolation=read-committed

之后重启mysql实例

进入bin目录/opt/sequoiasql/mysql/bin

sdb_sql_ctl restart 实例名

此时已修改完成，可以进行查询，插入，删除操作了。